disregard last post.
they are offering seller finance. 20-25 down, 5 yr =balloon.
if i understanding the formula correctly, i dont like the numbers.
i am trying to attach the sheet but can do it. can you read what i posted?
GENERAL INFORMATION:
REVENUE:
Gross Scheduled Revenues: 32 Pads@avgrentof:
Additional Income
Total Gross Scheduled Revenues:
- Vacancy & Credit Loss -- PERCENT - Vacancy & Credit Loss -- NUMBER - Vacancy & Credit Loss -- DOLLAR AMOUNT
NET MOBILE HOME RENTAL INCOME:
SELLER FINANCING:
YR 1 FINANCIAL RESULTS:
CASH INVESTMENT : $40,000
Inflation for Yrs 1-5 per pad: $5.00
PARK HAS A CITY SEWER/METERED PARK HAS CITY WATER/METERED
TOTAL SALES PRICE Debt 80.00% Interest Rate - Fixed Amortization (Months) Monthly Payment Balloon EO 5th Yr:
$200,000 $160,000
6.50%
300 $1,080 $144,899
GROSS RENT MULTIPLIER 4.52 CAP RATE 11.07% CASH ON CASH RETURN 22.93% DEBT COVERAGE RA TIO 1.71 PER P AD SALES PRICE $6,250
OPERATING EXPENSES:
Average Expense Per
Annual Debt Service
CASH INVESTMENT :
Year @
$205.00 $0.00
50.00%
Year 1
205 78,720 0 78,720
43.76% 14.00 34,448
44,272 22,136
22,136 12,964 9,172 40,000
22.93% 11.07%
1.71
4.52 4,104
33.19%
Year 2
210 80,640 0 80,640
37.50% 12.00 30,240
50,400 25,200
25,200 12,964 12,236 40,000 30.59% 12.60%
1.94
3.97 4,400
41.59%
Year 3
215 82,560 0 82,560
31.24% 10.00 25,792
56,768 28,384
28,384 12,964 15,420 40,000 38.55% 14.19%
2.19
3.52 4,718
50.35%
Year 4
220 84,480 0 84,480
25.00% 8.00 21,120
63,360 31,680
31,680 12,964 18,716 40,000 46.79% 15.84%
2.44
3.16 5,060
59.44%
Year 5
225 86,400 0 86,400
18.76% 6.00 16,209
70,191 35,096
35,096 12,964 22,132 40,000 55.33% 17.55%
2.71
2.85 5,425
68.89%
Total
412,800
412,800
31.25% 10.00 129,008
284,992 142,496
142,496 64,820 77,676 40,000 38.84% avg 14.25% avg
2.20 avg
3.60 avg 23,707 total 50.69% avg
NET OPERATING INCOME:
CASH FLOW BEFORE T AX:
CASH ON CASH RETURN: OVERALL CAPITALIZATION: DEBT COVERAGE RATIO : GROSS RENT MUL TIPLIER: PRINCIP AL REDUCTION PRINCIPAL REDUCTION & CASH / CASH RETURN
