Category Description $ Totals 179900 $ 30000 $ 209900 $ 18000 ...
315 W Burbank Fredericskburg TX 78624 Financial Model Investor Proforma Description
Category $ LIST PRICE $ ESTIMATED RENOVATION BUDGET $ INVESTMENT (LIST PRICE + ESTIMATED IMPROVEMENTS) $ ANNUAL RENTAL REVENUES $ Home Monthly Estimate $ 1,500 ANNUAL OPERATING EXPENSES $ Taxes 2016 Actual $ 2,291 Insurance 2017 Estimated $ 900 Repairs Included in Reserve Maintenanace Included in Reserve HOA None $ Utilities None - Tenant expense $ Property Management None- Owner Managed $ Reserve 1% of Investment $ 2,099 PERFORMANCE INDICATORS Net Operating Income Annual Rental Revenues - Annual Operating Expenses $ Estimated Annual Debt Service *Estimated montly P&I * 12 $ Net Cash Flow Net Operating Income - *Annual Debt Service $ Cap Rate Net Operating Income / Sale Price 1st year Cash on Cash 1st Year Net Cash Flow / (Down Payment + 1% Closing Cost) * $850.83 estimated monthly P&I. 4.5% APR. Arm 5 year fixed. 30-year amortization. 1% closing cost. Calculator: http://www.calculator.net/
Totals 179,900 30,000 209,900 18,000 5,290
12,710 10,210 2,500 7.06% 5.41%
$36,000 Instant Equity AFTER $30,000 Investor Renovation Investment
Category
Calculation
$
List Price
$ 179,900
Investor Rehab Budget
$ 30,000
Investment 2016 Home Value: Avg. Sale Price per SF in Fredericksburg for Homes Under 1,000 SF * 926 SF
Instant Equity
List Price + Rehab Cost $266 SF * 926 SF
$ 209,900 $ 246,316
2016 Home Value - Investment $ 36,416
List Price / SF Compared to 2016 Fredericksburg Sale Price / SF Homes Sold Under 1,000 SF $450 $400 $350 $300
$250 $200
$418
Flip or investor opportunity for major renovations and still be way under market $266
$268
$194
$150 $100
$50 $-
List Price
Average
Median
Maximum
List Price Compared to 2016 Fredericksburg Sale Price Homes Sold Under 1,000 SF $450,000 $400,000 $350,000 $300,000
$250,000 $200,000
$387,411
Flip or investor opportunity for major renovations and still be way under market $246,492
$247,781
Average
Median
$179,900
$150,000 $100,000
$50,000 $-
List Price
Maximum
Gillespie CAD Satellite with Property Lines
Not in flood plain
Who lives in Fredericksburg ESRI Tapestry Segmentation Profile 9% Retirement Communities 1.9 Avg. Household Size 52 Median Age Fiscally responsible eye on finances Paid their dues, prefer eating out
14% Old & Newcomers 2.1 Avg. Household Size 39 Median Age Single’s lifestyles on a budget Age not obvious from choices
16% Comfortable Empty Nesters 2.5 Avg. Household Size 47 Median Age Many live where they grew up Value health and financial well-being
7% The Great Outdoors 2.4 Avg. Household Size 46 Median Age Invest in real estate vs. stocks Most still work
54% Midlife Constants 2.3 Avg. Household Size 46 Median Age Live in smaller communities Generous, not spendthrifts
Fredericksburg Annual Visitors Historic & Projected Lower
2,000,000
Timeline
1,800,000
2008 2012 2016 2020
1,600,000 1,400,000
Values
Forecast
1,000,000 1,200,000 1,500,000
1,500,000 1,737,080
1,200,000
Values
1,000,000
Forecast
Upper
Confidence Confidence Bound Bound
1,500,000 1,679,391
1,500,000 1,794,769
800,000
Lower Confidence Bound
600,000
Upper Confidence Bound
400,000 200,000 -
2008
2012
2016
2020
Historic data from Fredericksburg Visitor & Convention Bureau Projections from Southwest Partners
Visitor demographics
From Fredericksburg Visitor & Convention Bureau 2013 Annual Report
Visitor home locations
From Fredericksburg Visitor & Convention Bureau 2013 Annual Report
% $500K Household Net Worth 20%
19.0%
18%
16.4%
16%
14.5%
14%
13.5% 12.3%
12.7%
12.6%
Houston
San Antonio
12% 9.6%
10% 8% 6% 4%
2% 0% Fredericksburg
Arlington
Austin
Dallas
Fort Worth
Galveston
Average Household Net Worth San Antonio
$367,250
Houston
$389,088
Galveston
$348,779
Fort Worth
$383,250
Dallas
$422,814
Austin
$412,546
Arlington
$477,002
Fredericksburg
$761,089 $-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
Average Home Values $350,000 $300,000
$323,852
$271,628
$263,137
$250,000
$215,664 $181,722
$179,519
$200,000
$234,952 $169,569
$150,000 $100,000
$50,000 $Fredericksburg
Arlington
Austin
Dallas
Fort Worth
Galveston
Houston
San Antonio
0.9 miles to W Main ST
0.4 miles to N Llano ST
1-3-5 mile radii map
30-60-90 mile radii map
Category $ LIST PRICE $ ESTIMATED RENOVATION BUDGET $ INVESTMENT (LIST PRICE + ESTIMATED IMPROVEMENTS) $ ANNUAL RENTAL REVENUES $ Home Monthly Estimate $ 1,500 ANNUAL OPERATING EXPENSES $ Taxes 2016 Actual $ 2,291 Insurance 2017 Estimated $ 900 Repairs Included in Reserve Maintenanace Included in Reserve HOA None $ Utilities None - Tenant expense $ Property Management None- Owner Managed $ Reserve 1% of Investment $ 2,099 PERFORMANCE INDICATORS Net Operating Income Annual Rental Revenues - Annual Operating Expenses $ Estimated Annual Debt Service *Estimated montly P&I * 12 $ Net Cash Flow Net Operating Income - *Annual Debt Service $ Cap Rate Net Operating Income / Sale Price 1st year Cash on Cash 1st Year Net Cash Flow / (Down Payment + 1% Closing Cost) * $850.83 estimated monthly P&I. 4.5% APR. Arm 5 year fixed. 30-year amortization. 1% closing cost. Calculator: http://www.calculator.net/
Totals 179,900 30,000 209,900 18,000 5,290
12,710 10,210 2,500 7.06% 5.41%
$36,000 Instant Equity AFTER $30,000 Investor Renovation Investment
Category
Calculation
$
List Price
$ 179,900
Investor Rehab Budget
$ 30,000
Investment 2016 Home Value: Avg. Sale Price per SF in Fredericksburg for Homes Under 1,000 SF * 926 SF
Instant Equity
List Price + Rehab Cost $266 SF * 926 SF
$ 209,900 $ 246,316
2016 Home Value - Investment $ 36,416
List Price / SF Compared to 2016 Fredericksburg Sale Price / SF Homes Sold Under 1,000 SF $450 $400 $350 $300
$250 $200
$418
Flip or investor opportunity for major renovations and still be way under market $266
$268
$194
$150 $100
$50 $-
List Price
Average
Median
Maximum
List Price Compared to 2016 Fredericksburg Sale Price Homes Sold Under 1,000 SF $450,000 $400,000 $350,000 $300,000
$250,000 $200,000
$387,411
Flip or investor opportunity for major renovations and still be way under market $246,492
$247,781
Average
Median
$179,900
$150,000 $100,000
$50,000 $-
List Price
Maximum
Gillespie CAD Satellite with Property Lines
Not in flood plain
Who lives in Fredericksburg ESRI Tapestry Segmentation Profile 9% Retirement Communities 1.9 Avg. Household Size 52 Median Age Fiscally responsible eye on finances Paid their dues, prefer eating out
14% Old & Newcomers 2.1 Avg. Household Size 39 Median Age Single’s lifestyles on a budget Age not obvious from choices
16% Comfortable Empty Nesters 2.5 Avg. Household Size 47 Median Age Many live where they grew up Value health and financial well-being
7% The Great Outdoors 2.4 Avg. Household Size 46 Median Age Invest in real estate vs. stocks Most still work
54% Midlife Constants 2.3 Avg. Household Size 46 Median Age Live in smaller communities Generous, not spendthrifts
Fredericksburg Annual Visitors Historic & Projected Lower
2,000,000
Timeline
1,800,000
2008 2012 2016 2020
1,600,000 1,400,000
Values
Forecast
1,000,000 1,200,000 1,500,000
1,500,000 1,737,080
1,200,000
Values
1,000,000
Forecast
Upper
Confidence Confidence Bound Bound
1,500,000 1,679,391
1,500,000 1,794,769
800,000
Lower Confidence Bound
600,000
Upper Confidence Bound
400,000 200,000 -
2008
2012
2016
2020
Historic data from Fredericksburg Visitor & Convention Bureau Projections from Southwest Partners
Visitor demographics
From Fredericksburg Visitor & Convention Bureau 2013 Annual Report
Visitor home locations
From Fredericksburg Visitor & Convention Bureau 2013 Annual Report
% $500K Household Net Worth 20%
19.0%
18%
16.4%
16%
14.5%
14%
13.5% 12.3%
12.7%
12.6%
Houston
San Antonio
12% 9.6%
10% 8% 6% 4%
2% 0% Fredericksburg
Arlington
Austin
Dallas
Fort Worth
Galveston
Average Household Net Worth San Antonio
$367,250
Houston
$389,088
Galveston
$348,779
Fort Worth
$383,250
Dallas
$422,814
Austin
$412,546
Arlington
$477,002
Fredericksburg
$761,089 $-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
Average Home Values $350,000 $300,000
$323,852
$271,628
$263,137
$250,000
$215,664 $181,722
$179,519
$200,000
$234,952 $169,569
$150,000 $100,000
$50,000 $Fredericksburg
Arlington
Austin
Dallas
Fort Worth
Galveston
Houston
San Antonio
0.9 miles to W Main ST
0.4 miles to N Llano ST
1-3-5 mile radii map
30-60-90 mile radii map
