|
Here is the formula we use. Hope it helps:
Pro Forma: Tony King |
|
No Vacancy |
|
Vacancy |
|
|
|
|
|
|
Gross
Rental Revenues |
|
$ 15,600 |
|
$ 15,600 |
Less: Vacancy |
0% |
|
8% |
$ (1,300) |
Net
Rental Revenues |
|
$ 15,600 |
|
$ 14,300 |
|
|
|
|
|
|
Less
Property Taxes |
|
$ 2,350 |
|
$ 2,350 |
Less
Insurance |
|
$ 595 |
|
$ 595 |
Less
R&M |
|
$ 1,560 |
|
$ 1,560 |
Less
Utilities |
|
$ - |
|
$ - |
Less
Legal & Professional |
|
$ - |
|
$ - |
Less
Janitorial |
|
$ - |
|
$ - |
Less
Landscaping & Extermination |
$ - |
|
$ - |
Total
Expenses |
29% |
$ 4,505 |
32% |
$ 4,505 |
|
|
|
|
|
|
Net
Operating Income |
71% |
$ 11,095 |
68% |
$ 9,795 |
|
|
|
|
|
|
Addbacks: |
|
$ - |
|
$ - |
Available
for Debt Service |
|
$ 11,095 |
|
$ 9,795 |
|
|
|
|
|
|
Debt
Service: |
$ 70,000 |
15 |
Year Amortization |
|
|
|
|
|
|
Proposed Debt Service @ |
5.25% |
$ 6,753 |
|
$ 6,753 |
DSC |
|
|
1.64 |
|
1.45 |
Net Income |
|
$ 4,342 |
|
$ 3,042 |
|
|
|
|
|
|
Proposed Debt Service @ |
7.250% |
$ 7,668 |
|
$ 7,668 |
DSC |
|
|
1.45 |
|
1.28 |
Net Income |
|
$ 3,427 |
|
$ 2,127 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Home Sales Price (Incl.
Repairs) |
$ 100,000 |
|
|
|
Loan Amount |
|
$ 70,000 |
70% |
|
|
Cash Down |
|
$ 30,000 |
30% |
|
|
Square Footage |
|
1,300 |
$ 76.92 |
|
|
Rent / Sq. Ft. / Month |
|
$
1 |
|
|
|