Scribd
Upload
60 views5 pages

Five-Year Rental Cash Flow Analysis

1. The document provides cash flow information for a real estate investment over 5 years, including monthly rent amounts, operating expenses, and annual cash positions. 2. It outlines the purchase information for the property including the purchase price and extra cash reserves. 3. Shareholder contribution amounts and ownership percentages are specified. 4. Annual returns and cash flows are broken out for each shareholder over the 5 year period.

Uploaded by

mdd100
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
60 views5 pages

Five-Year Rental Cash Flow Analysis

1. The document provides cash flow information for a real estate investment over 5 years, including monthly rent amounts, operating expenses, and annual cash positions. 2. It outlines the purchase information for the property including the purchase price and extra cash reserves. 3. Shareholder contribution amounts and ownership percentages are specified. 4. Annual returns and cash flows are broken out for each shareholder over the 5 year period.

Uploaded by

mdd100
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Cash Flow Information

Cash on Hand (beginning of month)

Enter Monthly Rent


Gross Scheduled Rents
Vacancy Allowance
Total Cash Available (before cash
out)

Purchase Info
Year 1
Purchase Price:
1,200.00 Extra Cash Reserves
14,400.00 Starting Cash
(1,800.00)

Management
Outside services
Supplies (office & oper.)
Repairs & maintenance
Advertising
Accounting & legal
Insurance
Taxes (real estate, etc.)
TOTAL CASH PAID OUT
Cash Position (end of year)
Inflation Rate

45,000.00
2,000.00
47,000.00

1,440.00
500.00
50.00
500.00
100.00
500.00
550.00
1,500.00
5,140.00
7,460.00
3%

2. Enter Cash Flow Information


3. Enter Purchase Information
4. Enter Shareholder Amounts

Ownership Makeup

12,600.00

CASH PAID OUT

1. Enter Monthly rent of property

Shareholder 1 Shareholder 2 Shareholder 3


Contribution
Ownership Percentage
Earnings:
Year 1
ROI
Year 2
ROI
Year 3
ROI
Year 4
ROI
Year 5
ROI

47,000.00
121.28%

5,000.00
10.64%

4,000.00
8.51%

6,000.00
12.77%

7,460.00
15.87%
7,646.50
16.27%
7,837.66
16.68%
8,033.60
17.09%
8,234.44
17.52%

793.62
15.87%
813.46
16.27%
833.79
16.68%
854.64
17.09%
876.00
17.52%

634.89
15.87%
650.77
16.27%
667.04
16.68%
683.71
17.09%
700.80
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

y rent of property

low Information

Ownership Makeup
Shareholder 4 Shareholder 5 Shareholder 6 Shareholder 7 Shareholder 8 Shareholder 9 Shareholder 10

6,000.00

6,000.00

6,000.00

6,000.00

6,000.00

6,000.00

6,000.00

12.77%

12.77%

12.77%

12.77%

12.77%

12.77%

12.77%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

952.34
15.87%
976.15
16.27%
1,000.55
16.68%
1,025.57
17.09%
1,051.21
17.52%

57,000.00

57,000.00

Five Year Cash Flow


Enter Monthly Rent
Gross Scheduled Rents
Vacancy Allowance
Total Cash Available (before cash out)

Year 1

Year 2

Year 3

Year 4

Year 5

1,200.00
14,400.00
(1,800.00)
12,600.00

1,230.00
14,760.00
(1,845.00)
12,915.00

1,260.75
15,129.00
(1,891.13)
13,237.88

1,292.27
15,507.23
(1,938.40)
13,568.82

1,324.58
15,894.91
(1,986.86)
13,908.04

1,440.00
500.00
50.00
500.00
100.00
500.00
550.00
1,500.00
5,140.00
7,460.00
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%

1,476.00
512.50
51.25
512.50
102.50
512.50
563.75
1,537.50
5,268.50
7,646.50
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%

1,512.90
525.31
52.53
525.31
105.06
525.31
577.84
1,575.94
5,400.21
7,837.66
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%

1,550.72
538.45
53.84
538.45
107.69
538.45
592.29
1,615.34
5,535.22
8,033.60
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%

1,589.49
551.91
55.19
551.91
110.38
551.91
607.10
1,655.72
5,673.60
8,234.44
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%

CASH PAID OUT


Management
Outside services
Supplies (office & oper.)
Repairs & maintenance
Advertising
Accounting & legal
Insurance
Taxes (real estate, etc.)
TOTAL CASH PAID OUT
Cash Position (end of year)
Infaltion rate

Five Year Breakout Cash Flow


Year 1
Enter Monthly Rent
Gross Scheduled Rents
Vacancy Allowance
Total Cash Available (before cash out)

Year 2

Year 3

Year 4

Year 5

1,200.00
14,400.00
(1,800.00)

1,230.00
14,760.00
(1,845.00)

1,260.75
15,129.00
(1,891.13)

1,292.27
15,507.23
(1,938.40)

1,292.27
15,507.23
(1,938.40)

12,600.00

12,915.00

13,237.88

13,568.82

13,568.82

1,440.00
500.00
50.00
500.00
100.00
500.00
550.00
1,500.00
5,140.00
7,460.00

1,476.00
512.50
51.25
512.50
102.50
512.50
563.75
1,537.50
5,268.50
7,646.50

1,512.90
525.31
52.53
525.31
105.06
525.31
577.84
1,575.94
5,400.21
7,837.66

1,550.72
538.45
53.84
538.45
107.69
538.45
592.29
1,615.34
5,535.22
8,033.60

1,550.72
538.45
53.84
538.45
107.69
538.45
592.29
1,615.34
5,535.22
8,033.60

CASH PAID OUT


Management
Outside services
Supplies (office & oper.)
Repairs & maintenance
Advertising
Accounting & legal
Insurance
Taxes (real estate, etc.)
TOTAL CASH PAID OUT
Cash Position (end of year)

You might also like