Florida Real Estate - Income/Expense Spreadsheet

*ESTIMATED INCOME / EXPENSE SPREADSHEET**
NUMBER OF BEDROOMS	3 BED	4 BED	5 BED	6 BED	7 BED
DEPOSIT	35%	30%	30%	30%	30%
HOME WITH POOL	171,000	190,000	215,000	240,000	270,000
CASH OUTLAYS:
- Reservation Deposit	5,000	5,000	5,000	5,000	5,000
- After Mortgage Approval	12,100	14,000	16,500	19,000	22,000
- Due on or before Closing	42,750	38,000	43,000	48,000	54,000
SUB-TOTAL	59,850	57,000	64,500	72,000	81,000
OTHER CHARGES
- Closing Costs	9,000	10,000	11,000	12,000	13,000
- Setting-up Charges and Escrow	1,500	1,500	1,500	1,500	1,500
TOTAL CASH OUTLAY *	70,350	68,500	77,000	85,500	95,500
EXPENSES:
- Electricity & Water	185	205	215	225	250
- Management Fees	100	100	100	100	100
- Pool Maintenance	85	85	85	85	85
- Lawn Maintenance	80	80	80	80	80
- Pest Control	30	30	30	30	30
- Cable TV	35	35	35	35	35
- Telephone	25	25	25	25	25
- Housekeeping* (2 Cleans)	110	150	160	180	210
MONTHLY EXPENSES*	650	710	730	760	815
ANNUAL EXPENSES:
MONTHLY EXPENSES x 12	7,800	8,520	8,760	9,120	9,780
Insurance & Taxes	3,300	3,600	4,200	5,100	5,700
ANNUAL MORTGAGE	9,800	11,800	13,300	14,800	16,700
TOTAL ANNUAL EXPENSES	20,900	23,920	26,260	29,020	32,180
TARGET RENTAL INCOME	21,000	23,250	26,250	29,250	32,250
Appreciation @ 2.5%	4,275	4,750	5,375	6,000	6,750
Yield	6.00%	6.93%	6.98%	7.02%	7.07%
* Please note that Builders generally either provide Furniture or contribute towards closing costs/legal fees. It is best to add another $5000 to all units in case you wish to add upgrades or other options
THIS SPREADSHEET SERVES AS A GUIDE ONLY AND DOES NOT OFFER THE SALE OF SECURITIES. THESE ARE EXTRAPOLATIONS AND SHOULD NOT BE ASSUMED TO BE ANY PART OF ANY CONTRACT OR IMPLICIT AGREEMENT Buyers should thoroughly familiarise themselves with any property contemplated for purchase

The following table gives examples of income/expense

All figures are given in US$

THIS SPREADSHEET SERVES AS A GUIDE ONLY AND DOES NOT OFFER THE SALE OF SECURITIES. THESE ARE EXTRAPOLATIONS AND SHOULD NOT BE ASSUMED TO BE ANY PART OF ANY CONTRACT OR IMPLICIT AGREEMENT

CONTENTS