Palm Bay Deal Analysis

Let's look at deal analysis for Palm Bay, FL and for 15 Buy 10 Nomads™ with 10% Higher Rents.

The analysis is based on The World's Greatest Real Estate Deal Analysis Spreadsheet™ (shown above)... a free spreadsheet download you can use to analyze your own deals.

Typical Palm Bay, Florida Nomad™ Property with 10% Higher Rents

Typical Palm Bay, Florida Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$257,355
Purchase Price		$257,355
Seller Concessions	—	$0
Down Payment	5.000%	$12,868
Closing Costs	1.000%	$2,574
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$114
Total Invested		$15,556
Mortgage
Mortgage Amount		$244,487.25
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$173.18
Drop PMI LTV	80.000%
Income
Monthly Rent		$2,562 $2561.79
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$922
Property Taxes	0.794%	$2,043
Property Insurance	1.674%	$4,308
HOA Dues		$0
Utilities		$0
Other Expenses 1		$0
Other Expenses 2		$0
Maintenance	10.000%
CapEx		$0
Management	0.000%
Depreciation Details
Land Value	15.000%	$38,603
Property Type (C or R)	R	27.5
Effective Income Tax Rate	15.000%

Property Value	1	2	3	4	5
ARV at End of Year	$265,076	$273,028	$281,219	$289,655	$298,345
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$7,721	$7,952	$8,191	$8,437	$8,690
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$2,562	$2,639	$2,718	$2,799	$2,883
Monthly Other Income Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Other Income	$0	$0	$0	$0	$0
Monthly Gross Potential Income	$2,562	$2,639	$2,718	$2,799	$2,883
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$77	$79	$82	$84	$86
Monthly Gross Operating Income	$2,485	$2,559	$2,636	$2,715	$2,797
Annual Income	1	2	3	4	5
Annual Rent	$30,741	$31,664	$32,614	$33,592	$34,600
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$30,741	$31,664	$32,614	$33,592	$34,600
Annual Vacancy Dollar	$922	$950	$978	$1,008	$1,038
Annual Gross Operating Income	$29,819	$30,714	$31,635	$32,584	$33,562
Annual Expenses	1	2	3	4	5
Property Taxes Percent	0.794%	0.794%	0.794%	0.794%	0.794%
Property Taxes Dollar	$2,043	$2,105	$2,168	$2,233	$2,300
Insurance Percent	1.674%	1.674%	1.674%	1.674%	1.674%
Insurance Dollar	$4,308	$4,437	$4,570	$4,708	$4,849
HOA Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
HOA Dues Dollar	$0	$0	$0	$0	$0
Utilities Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Utilities Dollar	$0	$0	$0	$0	$0
Other Expense 1 Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Other Expense 1 Dollar	$0	$0	$0	$0	$0
Other Expense 2 Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Other Expense 2 Dollar	$0	$0	$0	$0	$0
Maintenance Percent	10.000%	10.000%	10.000%	10.000%	10.000%
Maintenance Dollar	$2,982	$3,071	$3,164	$3,258	$3,356
CapEx Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
CapEx Dollar	$0	$0	$0	$0	$0
Property Management Percent	0.000%	0.000%	0.000%	0.000%	0.000%
Property Management Dollar	$0	$0	$0	$0	$0
Annual Operating Expenses	$9,333	$9,613	$9,902	$10,199	$10,505
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$20,486	$21,100	$21,733	$22,385	$23,057
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$18,544	$18,544	$18,544	$18,544	$18,544
Principal	$2,733	$2,916	$3,111	$3,319	$3,542
Interest	$15,811	$15,628	$15,433	$15,225	$15,002
Loan Balance at End of Year	$241,755	$238,839	$235,728	$232,408	$228,867
Loan-To-Value	91.202%	87.478%	83.824%	80.236%	76.712%
Private Mortgage Insurance (PMI) Rate	0.850%	0.850%	0.850%	0.850%
Private Mortgage Insurance Dollar	$2,078	$2,078	$2,078	$2,078	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$23,321	$34,189	$45,491	$57,247	$69,478
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$136	$478	$1,111	$1,763	$4,513
Monhtly Cash Flow	-$11	$40	$93	$147	$376
Cash on Cash Return on Investment	-0.009%	0.031%	0.071%	0.113%	0.290%
Cap Rate
DSCR	0.00	0.00	0.00	0.00	0.00
Negative Cash Flow	$0	$0	$0	$0	$0
Cumulative Negative Cash Flow	$0	$0	$0	$0	$0