Class Project 1 Demo -- Projection of 2011
回答:
教了几天书,商学院案例分析。
由
sweetptt
于
2015-11-03 21:52:48
|
|
Class Project 1 Demo -- Projection of 2011 |
|
|
|
|
|
|
|
|
|
1. Rent Roll |
|
|
2. Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
2 |
450 |
|
|
Rent Income |
7575 |
|
3 |
325 |
|
less |
Vacancy |
8% |
-606 |
|
4 |
450 |
|
Before Management Fee |
6969 |
|
5 |
450 |
|
|
|
|
|
|
6A |
450 |
|
less |
Management Fee |
-557.52 |
|
6B |
350 |
|
less |
property tax |
-131 |
|
7 |
450 |
|
less |
Insurance |
|
-215 |
|
8 |
425 |
|
less |
utilities |
|
-1000 |
|
9 |
550 |
|
less |
Repairs |
90 |
-1620 |
|
10 |
450 |
|
less |
Lawn/Snow |
-100 |
|
11 |
325 |
|
Before Interest |
|
3345.48 |
|
12A |
450 |
|
|
|
|
|
|
12B |
350 |
|
Payment of Assumed Loan |
($2,169.10) |
|
13 |
650 |
|
Payment of Wrap-around Loan |
($530.94) |
|
14 |
450 |
|
Before income tax |
|
645.442215 |
|
15 |
325 |
|
|
|
|
|
|
16 |
325 |
|
3. Cash on Cash ROI |
|
|
|
17 |
350 |
|
|
|
|
|
|
|
|
|
|
Asking Price |
375000 |
|
total |
7575 |
|
less |
Assumed Loan |
-200000 |
|
|
|
|
less |
Wrap-around Loan |
-84000 |
|
|
|
|
= |
Downpayment |
91000 |
|
|
|
|
Plus |
Renovation Cost |
39000 |
|
|
|
|
= |
Total |
|
130000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash on Cash |
5.96% |
您的位置:
文学城 »
论坛 »
投资理财 »
Class Project 1 Demo -- Projection of 2011