|
|
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 |
|
|
|