Cash Flow Calculator by ocak

VIEWS: 548 PAGES: 3

									Investment Summary Property Address 40XX Shenandoah Property Value (Appraisal) Cummulative Equity Increase Asking Price Accepted Price Down Payment (out of pocket) Closing Costs Balance to Be Financed Total Financing Req'd (incl closing costs) MONTHLY EXPENSES: Taxes (actual) Monthly Maintenance Costs Advertising Expense Insurance Expense P&I Expense Vacancy Rate Expense Management Expense Total Expenses: INCOME: Monthly Income from Rents CASH FLOW: Monthly Cash Flow Annual Cash Flow Cummulative Cash Flow % Return On Down Payment Cummulative ROI (Cash + Equity) as % Cummulative ROI (Cash + Equity) as $

Year 1 $ 142,000 $ 30,000 $ 140,000 $ 140,000 $ 28,000 $ 2,240 $ 112,000 $ 114,240 $ $ $ $ $ $ $ $ $ $ $ 71 58 20 50 800 238 1,237 1,585 348 4,181 14.93%

Year 2 $ 144,840 $ 32,840 100%

Year 3 $ 147,737 $ 35,737

Year 4 $ 150,692 $ 38,692

Year 5 $ 153,705 $ 41,705

Year 6 $ 156,779 $ 44,779

Year 7 $ 159,915 $ 47,915

Year 8 $ 163,113 $ 51,113

Year 9 $ 166,376 $ 54,376

Year 10 $ 169,703 $ 57,703

$ $ $ $ $ $ $ $ $ $ $ $

72 60 20 51 800 243 1,245 1,617 371 4,456 8,637

$ $ $ $ $ $ $ $ $ $

74 61 21 52 800 247 1,254 1,649 395

$ $ $ $ $ $ $ $ $ $

75 62 21 53 800 252 1,263 1,682 419

$ $ $ $ $ $ $ $ $ $

77 63 22 54 800 257 1,273 1,716 443

$ $ $ $ $ $ $ $ $ $

78 64 22 55 800 262 1,282 1,750 468

$ $ $ $ $ $ $ $ $ $

80 66 23 56 800 268 1,292 1,785 493

$ $ $ $ $ $ $ $ $ $

81 67 23 57 800 273 1,302 1,821 519

$ $ $ $ $ $ $ $ $ $

83 68 23 59 800 279 1,312 1,857 545

$ $ $ $ $ $ $ $ $ $

85 70 24 60 800 284 1,322 1,894 572

$ 4,737 $ 13,375

$ 5,024 $ 18,399

$ 5,317 $ 23,715

$ 5,615 $ 29,330

$ 5,919 $ 35,249

$ 6,229 $ 41,478

$ 6,546 $ 48,024

$ 6,869 $ 54,893

40.99% 68.26% 96.75% 126.50% 143.85% 161.60% 179.76% 198.34% 217.35% $ 41,477 $ 49,111 $ 57,090 $ 65,421 $ 74,109 $ 83,164 $ 92,592 $ 102,400 $ 112,596 1.020 0.200 0.005 7.000 0.150 0.000 850 4 Rents Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 Unit 7 Unit 8 Unit 9 Unit 10 Unit 11 Unit 12 Unit 13 Unit 14 Unit 15 Unit 16 Unit 17 Unit 18 Unit 19 Unit 20

Assumptions Inflation Rate Down Payment Maintenance Rate P&I Rate Vacancy Rate Management Rate Taxes Number of Units

415 400 385 385

Property Value Based on Rental Income 228,240 190,200

Cost/Unit $ 35,000

Cash Flow Calculator Instructions
Note: The "Calculator" spreadsheet is filled out as an example. Before making changes to this, you may wish to click around and change the assumptions and rents to get an idea of how the adjustments affect the cash flows, etc. The only rule: Only change the values in the highlighted cells, because all other cells showing values contain formulas driven by the highlighted cells. The exception to the only rule: Cell C10 assumes closing costs are 2% of the Balance to Be Financed. This cell may be changed if you know more accurately how much your closing costs are, or if you're not planning to finance the closing costs, in which case it would be changed to $0. So first, fill in the Address, Property Value, Asking Price, and Accepted Price cells. Below that, fill in the approximate monthly Advertising Expense and Insurance Expense cells. If you’re using a property management company, you’ll likely set the Advertising Expense at $0, as there is a cell for Management Rate under Assumptions. Then, under Assumptions, add the Down Payment percentage, P&I Rate, Taxes, and the Number of Units. If you have values for the other Assumptions, add those, too. A little research will produce more accurate numbers for the Vacancy Rate for a given zip code, etc., as well as Inflation Rate. The numbers shown have not been researched and are given for informational purposes only. Lastly, add the appropriate values under Rents. Also, notice the cells with comments, which may clarify what's happening in those cells.


								
To top