← 85-104 Alawa Pl, Waianae, HI 96792 · All properties

Pro Forma - 85-104 Alawa Pl, Waianae, HI 96792.xlsx

This page is a searchable text preview. Use the Dropbox link for the full original file.

Open full file in Dropbox

What This File Appears To Be

sheet1: 0 · Source Code for Web App · 1 · 2 · Years · 4 · 4.5378467783681931E-2 · -3.1266155609901126E-13 · 5 · Video and PDF · 0.35979029365741111 · 7.2999999999999995E-2 · 2 · 0.3 · 6 · 7 · 8 · 9 · 10 · 11 · 12 · 13 · 14 · MLS # · Underlying Asset Value · Down Payment / Equity % · Mortgage Interest Rate · Member Equity / Investment · Monthly Cash Flow (Yield) · Cash on Cash Return · Capitalization Rate · Square Footage Above Ground · Style, Type, Bed/Bath · Number of Units · Notes · Rental (Un

Text Preview

sheet1: 0 | Source Code for Web App | 1 | 2 | Years | 4 | 4.5378467783681931E-2 | -3.1266155609901126E-13 | 5 | Video and PDF | 0.35979029365741111 | 7.2999999999999995E-2 | 2 | 0.3 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | MLS # | Underlying Asset Value | Down Payment / Equity % | Mortgage Interest Rate | Member Equity / Investment | Monthly Cash Flow (Yield) | Cash on Cash Return | Capitalization Rate | Square Footage Above Ground | Style, Type, Bed/Bath | Number of Units | Notes | Rental (Unit 1) | Rental (Unit 2) | Rental (Unit 3) | Storage & Misc Income | % Vacancy and Credit Losses | Total Monthly Income | Property Taxes | General Excise Tax | Insurance | Cleaning | Water & Sewer | Garbage | Electric & Gas | Advertising & Software | HOA Fees | Internet | Pest | Accounting & Legal | Repairs | Capital Expenditures | Property Management | Mortgage | Total Monthly Expenses | Total Monthly Income | Total Monthly Expenses | Net Operating Income | Monthly Cash Flow | Annual Cash Flow | Down Payment | Closing Costs | Furnishings | Reserve/ Prepaid | Private Money Lender | Total Investment | Cash on Cash Return | Debt Service Coverage Ratio | Principal Paydown (No VB) | Projected Appreciation Over Holding Period | Equity Growth Over Holding Period | Annual Return Due to Equity | Land Value | Depreciation Basis | Annual Depreciation | Annual Tax Savings at Marginal Tax Rate | Annual Return Due to Tax Savings | Total Annualized Return | Return on Investment | Return On Equity | Internal Rate of Return | Net Present Value | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.11985899103292486 | 2.8750000000000001E-2 | 34080.829465420968 | 1574.67 | 0.19948492707491708 | 2.6160930361345702E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 1 | LTR single family unfurnished Co-owner pays mortgage | 2950 | 0 | 0 | 0 | 0 | 2950 | 147.70000000000002 | 132.75 | 187.88 | 0 | 0 | 0 | 107 | 0 | 0 | 0 | 0 | 62.5 | 0 | 0 | 737.5 | 0 | 1375.33 | 2950 | 1375.33 | 1574.67 | 1574.67 | 18896.04 | 86574.149223081622 | 8150 | 0 | 0 | 0 | 94724.149223081622 | 0.19948492707491708 | None | 0 | 39326.855273497669 | 70475.393845610728 | 39326.855273497669 | 425000 | 109897.94519765623 | 3995.8892873867808 | 1198.7667862160342 | 1.2655344978531919E-2 | 42617.753260124868 | 0.44991434190406132 | 0.60471819928366588 | 0.97197878900000001 | 0 | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.12785864478057385 | 2.8750000000000001E-2 | 38570.346682936433 | 2322.4299999999998 | 0.25996793191442469 | 3.8583912501730579E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 3 | Mid-Term/Coliving furnished Co-owner pays mortgage | 1500 | 1500 | 1500 | 0 | 0 | 4500 | 147.70000000000002 | 202.5 | 187.88 | 240 | 60 | 0 | 107 | 15 | 0 | 29.99 | 0 | 62.5 | 0 | 0 | 1125 | 0 | 2177.5700000000002 | 4500 | 2177.5700000000002 | 2322.4299999999998 | 2322.4299999999998 | 27869.159999999996 | 92352.299125008489 | 8150 | 6700 | 0 | 0 | 107202.29912500849 | 0.25996793191442469 | None | 0 | 39326.855273497669 | 72554.316095621543 | 39326.855273497669 | 425000 | 112308.54016516088 | 4083.53852040525 | 1225.061556121575 | 1.1427567935768169E-2 | 52975.061306510404 | 0.49415974973387689 | 0.73014348638739779 | 1.661911707 | 8.0547213339999996E-10 | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.11985899103292486 | 2.8750000000000001E-2 | 34080.829465420968 | 713.3127364363645 | 9.0365053763402939E-2 | 3.5472850616087501E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 1 | LTR single family unfurnished DAO pays half the mortgage, burns half the escrow tokens | 2950 | 0 | 0 | 0 | 0 | 2950 | 147.70000000000002 | 132.75 | 187.88 | 0 | 0 | 0 | 107 | 0 | 0 | 0 | 0 | 62.5 | 0 | 0 | 177 | 1421.8572635636506 | 2236.6872635636355 | 2950 | 2236.6872635636355 | 2135.17 | 713.3127364363645 | 8559.752837236374 | 86574.149223081622 | 8150 | 0 | 0 | 0 | 94724.149223081622 | 9.0365053763402939E-2 | 1.5016767538596467 | 0 | 39326.855273497669 | 70475.393845610728 | 39326.855273497669 | 425000 | 109897.94519765623 | 3995.8892873867808 | 1198.7667862160342 | 1.2655344978531919E-2 | 30717.286097307384 | 0.32428146728418905 | 0.43585831055586904 | 0.97197878900000001 | 0 | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.12785864478057385 | 2.8750000000000001E-2 | 38570.346682936433 | 1350.5727364363647 | 0.15118027290009478 | 4.6060030458258343E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 3 | Mid-Term/Coliving furnished DAO pays half the mortgage, burns half the escrow tokens | 1500 | 1500 | 1500 | 0 | 0 | 4500 | 147.70000000000002 | 202.5 | 187.88 | 240 | 60 | 0 | 107
sheet2: 0 | Source Code for Web App | 56 | 57 | 2 | Years | 4 | 4.5378467783681931E-2 | -3.1266155609901126E-13 | 5 | Video and PDF | 0 | 0.64020970634258889 | 7.2999999999999995E-2 | 10 | 0.3 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | MLS # | Underlying Asset Value | Down Payment / Equity % | Mortgage Interest Rate | Seller Retained Equity | Monthly Cash Flow | Cash on Cash Return | Capitalization Rate | Square Footage Above Ground | Style, Type, Bed/Bath | Number of Units | Notes | Rental (Unit 1) | Rental (Unit 2) | Rental (Unit 3) | Storage & Misc Income | % Vacancy and Credit Losses | Total Monthly Income | Property Taxes | General Excise Tax | Insurance | Cleaning | Water & Sewer | Garbage | Electric & Gas | Advertising & Software | HOA Fees | Internet | Pest | Accounting & Legal | Repairs | Capital Expenditures | Property Management | Mortgage | Total Monthly Expenses | Total Monthly Income | Total Monthly Expenses | Net Operating Income | Monthly Cash Flow | Annual Cash Flow | Down Payment / Equity | Closing Costs | Furnishings | Reserve/ Prepaid | Private Money Lender | Total Seller Investment | Cash on Cash Return | Debt Service Coverage Ratio | Principal Paydown (No VB) | Projected Appreciation Over Holding Period | Equity Growth Over Holding Period | Annual Return Due to Equity | Land Value | Depreciation Basis | Annual Depreciation | Annual Tax Savings at Marginal Tax Rate | Annual Return Due to Tax Savings | Total Annualized Return | Return on Investment | Return On Equity | Internal Rate of Return | Net Present Value | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.11919578024386901 | 2.8750000000000001E-2 | 38402.672052205053 | -852.46773069423159 | -0.17053754430182683 | 3.3081768734869815E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 1 | LTR single family unfurnished Co-owner pays mortgage | 2950 | 0 | 0 | 0 | 0 | 2950 | 147.70000000000002 | 132.75 | 187.88 | 0 | 0 | 0 | 107 | 0 | 0 | 0 | 0 | 62.5 | 62.5 | 0 | 737.5 | 2843.7145271273012 | 4281.5445271272711 | 2950 | 4281.5445271272711 | 1512.1699999999996 | -852.46773069423159 | -10229.612768330779 | 86095.112070146584 | 7600 | 0 | 0 | 0 | 59984.520184164503 | -0.17053754430182683 | 0.87268605070108451 | 154849.34276725305 | 473062.09042252693 | 683030.35960574076 | 62791.143318978 | 184800 | 545100 | 19819.836000000003 | 5945.9508000000005 | 9.9124753882247271E-2 | 48042.52378464691 | 0.80091536344954883 | 7.0337318259730136E-2 | 3.4182496229999999 | 0 | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.12720743958729297 | 2.8750000000000001E-2 | 43520.626469722905 | -373.74452067949721 | -6.5975576890512339E-2 | 4.1035082482864853E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 3 | Mid-Term/Coliving furnished Co-owner pays mortgage | 1500 | 1500 | 1500 | 0 | 0 | 4500 | 147.70000000000002 | 202.5 | 187.88 | 240 | 60 | 0 | 107 | 15 | 0 | 29.99 | 0 | 62.5 | 62.5 | 0 | 1125 | 2843.7145271273012 | 5083.7845271272708 | 4500 | 5083.7845271272708 | 2259.9299999999998 | -373.74452067949721 | -4484.9342481539661 | 91881.93361390171 | 7600 | 6700 | 0 | 0 | 67978.704537844285 | -6.5975576890512339E-2 | 1.3932200163573887 | 153440.8570266332 | 473062.09042252693 | 685326.65318630543 | 62650.294744916013 | 184800 | 551800 | 20063.448 | 6019.0343999999996 | 8.8542940630019731E-2 | 59596.279231373926 | 0.87669042292790689 | 8.6960399036417946E-2 | 3.579030162 | 0 | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.11919578024386901 | 2.8750000000000001E-2 | 38402.672052205053 | 416.65663087794161 | 8.3352830950129575E-2 | 3.0544326087912119E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 1 | LTR single family unfurnished DAO pays half the mortgage, burns half the escrow tokens | 2950 | 0 | 0 | 0 | 0 | 2950 | 147.70000000000002 | 132.75 | 187.88 | 0 | 0 | 0 | 107 | 0 | 0 | 0 | 0 | 62.5 | 62.5 | 0 | 177 | 1421.8572635636506 | 2299.1872635636355 | 2950 | 2299.1872635636355 | 2072.67 | 416.65663087794161 | 4999.8795705352995 | 86095.112070146584 | 7600 | 0 | 0 | 0 | 59984.520184164503 | 8.3352830950129575E-2 | 1.745372101402169 | 154849.34276725305 | 473062.09042252693 | 683030.35960574076 | 62791.143318978 | 184800 | 545100 | 19819.836000000003 | 5945.9508000000005 | 9.9124753882247271E-2 | 78851.881626473434 | 1.3145371736638445 | 0.1154441827036625 | 3.9880187450000002 | 0 | 85-104 Alawa Pl
Waianae, HI 96792 | 202427201 | 722300 | 0.12720743958729297 | 2.8750000000000001E-2 | 43520.626469722905 | 824.63666834181993 | 0.14556970579798056 | 3.7322341385664488E-2 | 1088 | 3BD/2BA Lot: 5000 sqft (0.1148 acres) Built 1969 | 3 | Mid-Term/Coliving furnished DAO pays half the mortgage, burns half the escrow tokens | 1500 | 1500 | 1500 | 0 | 0 | 4500 | 147.70000000000002 | 202.5 | 187.88 | 240 | 60
sheet3: 58 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | 66 | 109341.34364413531 | 111965.53589159455 | 67 | 109567.78413130358 | 112197.41095045487 | 68 | 136150.10630730359 | 139417.70885867887 | 69 | 32330.66995810339 | 33106.606037097874 | 33901.164581988225 | 34714.792531955944 | 35547.947552722886 | 36401.098293988238 | 37274.724653043959 | 38169.318044717016 | 70 | 49179.291406995173 | 50359.594400763061 | 51568.224666381378 | 52805.862058374536 | 54073.202747775525 | 55370.959613722138 | 56699.862644451474 | 58060.659347918314 | 71 | 63187.415384663298 | 64703.913353895216 | 66256.807274388702 | 67846.970648974035 | 69475.297944549413 | 71142.705095218596 | 72850.130017503849 | 74598.533137923936
sheet4: 85-104 Alawa Pl Cash Flow Analysis | 73 | 74 | 75 | Scenario A | 21 | 1 | 77 | 2950 | 78 | 2950 | 27 | 0 | 79 | 0 | 80 | 81 | 2950 | 82 | 83 | 737.5 | 0.25 | 84 | 0 | 85 | 280.45000000000005 | 86 | 187.88 | 87 | 0 | 88 | 0 | 89 | 0 | 90 | 0 | 91 | 107 | 92 | 0 | 93 | 0 | 94 | 0 | 95 | 0 | 96 | 62.5 | 35 | 0 | 82 | 1375.33 | 97 | 98 | 35400 | 99 | 16503.96 | 100 | 18896.04 | 101 | 102 | 5.0999999999999997E-2 | 103 | 670000 | 104 | 730450 | 9.0223880597015027E-2 | 105 | 2.5869039633102883E-2 | 106 | 107 | 1574.67 | Annual Net Operating Income | 18896.04 | 108 | 0.2158289454146726 | 109 | 110 | 685410 | 0.93833937983434867 | LTV | 112 | 642899 | 113 | 0.87268605070107519 | 114 | 8150 | 115 | 30 | 116 | 2.8750000000000001E-2 | 117 | 87551 | 118 | 2843.7145271273012 | 0.96397102614484786 | PI/GMR (Target <50%) | 120 | 19514.011071261491 | 121 | 14610.563254266126 | 122 | 34124.574325527617 | 123 | 124 | 8850 | 125 | -34124.574325527617 | 126 | 25274.574325527617 | 127 | 1.3375593153659506 | 128 | -29553.655619604342 | 129 | 60243.671564082419 | 130 | 131 | 124 | 8850 | 124 | 8850 | 125 | -34124.574325527617 | 125 | -34124.574325527617 | 132 | 37500 | 132 | 78795.900000000009 | 133 | 0.57167822183641537 | 133 | 9.9999999999999895E-2 | 134 | 50051 | 134 | 8755.0999999999913 | 135 | 10802.454546949779 | 135 | 1889.603999999998 | 136 | -14472.119778577839 | 136 | -23384.970325527618 | 137 | -0.28914746515709655 | 137 | -2.6710112192353761 | 138 | 139 | Rental Cash Flow Analysis © 2015-2019 by Vertex42.com | 140 | 37500 | 141 | 0.42832177816358463 | 142 | 8093.585453050222 | 143 | 0.2158289454146726