KEMBAR78
Basic MF Development Model v1.1 | PDF | Internal Rate Of Return | Net Present Value
0% found this document useful (0 votes)
325 views4 pages

Basic MF Development Model v1.1

This document summarizes the details of a proposed 50-unit transit oriented development with condominiums in Salt Lake City, Utah. It includes development costs of over $5.4 million, annual operating revenues of $586,200, and operating expenses of $95,875 for the first year. The projected after-tax cash flow for the first year is $65,157.

Uploaded by

Alex
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
325 views4 pages

Basic MF Development Model v1.1

This document summarizes the details of a proposed 50-unit transit oriented development with condominiums in Salt Lake City, Utah. It includes development costs of over $5.4 million, annual operating revenues of $586,200, and operating expenses of $95,875 for the first year. The projected after-tax cash flow for the first year is $65,157.

Uploaded by

Alex
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

TRANSIT ORIENTED DEVELOPMENT Square Footage Summary # of Apartments Avg.

Rent/Unit/Month
SLC UT GSF NSF 50 $970
50 Condos 60,000 49,500 Avg. Unit Size (SF)
Development Costs 990.00

Type of Multi-Family Project New Development RESIDENTIAL REVENUE PARAMETERS


Acquisition Price $5,402,667 Unit Type % # Units SF Rent/Unit/Month
Purchase Price (Stabilized Only) $0 3 Bed 40% 20 1,150 $1,100
2 Bed 40% 20 950 $950
RESIDENTIAL TIMING 1 Bed 20% 10 750 $750
Pre-development period 3 months Commencement date 12/31/2013 0%
Construction period 12 months End of pre-development 3/31/2014 0%
Leasing Period 6 months End of construction 3/31/2015 0%
Total development period 21 months End of leasing/sale date 9/30/2015 Annual Potential Gross Income $582,000
Vacancy/Credit Loss Factor 5.00%
RESIDENTIAL CONSTRUCTION PARAMETERS Annual Rent Growth 3.00%
Residential GSF 60,000
Residential NSF 49,500 OTHER REVENUE # spaces $ Rent/Month
Residential parking spaces 60 $0
RESIDENTIAL PARKING PARAMETERS
Surface parking spaces 60 spaces Misc. revenue (vending, etc) $350 per month

RESIDENTIAL OPERATING EXPENSE PARAMETERS SALE PARAMETERS


Fixed expenses $65,000 total first year Terminal capitalization rate 7.50%
Variable expenses $650 per occupied unit first year Apartment selling costs 6.50%
Capital reserves $350 per unit per year
Real estate taxes 1.50% of assessed value PERMANENT FINANCING PARAMETERS
Annual fixed/variable expense growth 2.00% Permanent loan closes 9/30/2015
Annual RE taxes growth 3.00% Stabilized Appraised Value $5,845,769
Income Tax Rate 20.00% Permanent Loan LTV 75%
Discount Rate 15.00% Term in years 30
Contract Interest Rate 5.50%
Permanent loan financing fees 1.5%
Frequency of Payments Monthly
Mortgage Constant 0.57%

DEVELOPMENT/REHABILITATION COST PARAMETERS


ACQUISITION
TRANSIT ORIENTED DEVELOPMENT Square Footage Summary Number of Apartments
50 Condos GSF NSF 50
Development Costs 60,000 49,500

COST CATEGORY Cost $/NSF $/Unit

SITE ACQUISITION
Land purchase $600,000 $12.12 $12,000
Closing Costs $9,000 $0.18 $180
Total Site Acquisition Costs $609,000 $12.30 $12,180

HARD COSTS
Site Development $30,000 $0.61 $600.00
Parking Construction $150,000 $3.03 $3,000.00
Base Building Construction $3,300,000 $66.67 $66,000.00
General Conditions $104,400 $2.11 $2,088.00
Hard Cost Contingency $179,220 $3.62 $3,584.40
Total Hard Costs $3,763,620 $76.03 $75,272

SOFT COSTS
Architectural and engineering fees $150,545 $3.04 $3,011
Surveys, testing, and inspections $20,000 $0.40 $400
Permits, licenses, fees $50,000 $1.01 $1,000
Appraisals and inspections $12,000 $0.24 $240
Insurance and title $6,000 $0.12 $120
Property taxes during development $27,000 $0.55 $540
Legal and accounting $15,000 $0.30 $300
Marketing costs $12,500 $0.25 $250
Commercial brokerage fees $0 $0.00 $0
Construction management $75,000 $1.52 $1,500
Development fee $225,000 $4.55 $4,500
Soft cost contingency $36,804.48 $0.74 $736
Total Soft Costs $629,849 $12.72 $12,597

TOTAL DEVELOPMENT COSTS BEFORE FINANCING $5,002,469 $101.06 $100,049

FINANCING COSTS
Acquisition/Construction loan financing fees $0 $0.00 $0
Acquisition/Construction loan interest $400,198 $8.08 $8,004
Total Financing Costs $400,198 $8.08 $8,004

TOTAL DEVELOPMENT COSTS $5,402,667 $109.14 $108,053


TRANSIT ORIENTED DEVELOPMENT Square Footage Summary # of Apartments
50 Condos GSF NSF 50
Development Costs 60,000 49,500

FIRST YEAR SETUP DEVELOPMENT COSTS $ Amount $/NSF $/Unit


Rental Revenue 582,000.00 Site Acquisition Costs $609,000 $12.30 $12,180
Parking Revenue 0.00 Hard Costs $3,763,620 $76.03 $75,272
Misc. Revenue 4,200.00 Soft Costs $629,849 $12.72 $12,597
POTENTIAL GROSS INCOME 586,200.00 Financing Costs $400,198 $8.08 $8,004
Vacancy/Credit Loss (29,310.00) Total Costs $5,402,667 $109.14 $108,053
EFFECTIVE GROSS INCOME 556,890.00
CAPITALIZATION
Operating expenses (95,875.00) Permanent Loan $4,384,326.90
Real estate taxes (81,040.00) Required Equity $1,018,340
NET OPERATING INCOME 379,975.00 Total Capitalization $5,402,667

Capital Reserve (17,500.00) RISK METRICS


Debt Service (298,724.71) Anticipated Occupancy 95.00%
BEFORE TAX CASH FLOW 63,750.29 Net Margin (BTCF ÷ PGI) 10.95%
Break-even Occupancy 84.05%
Amortization Principal 59,060.81 Loan to Value 75%
Reserve 17,500.00 Debt Coverage Ratio 1.27
Depreciation (147,345.46)
TAXABLE INCOME (7,034.37) BREAKDOWN OF FUTURES
Income Taxes 1,406.87 Net Cash Flows $3,770,457 Non-discounted
AFTER TAX CASH FLOW 65,157.16 Principal Recapture $765.46
Anticipated Appreciation $1,347,957
FINANCIAL ANALYSIS Tax on Depreciation $294,691
Free and Clear Return 7.03% Tax on Capital Gains $175,944
Cash-on-Cash Return (Year 1) 6.26% Net Cash from Sale $2,669,430
Increase in Capital Value 24.95%
Levered Internal Rate of Return 17.84% % OF TOTAL BENEFITS @ IRR
Levered NPV at 15.00% 175,524 Before Tax Cash Flow 50.33%
NPV ÷ Equity (Profit. Index) 17.24% Tax Benefits -4.51%
Appreciation (Cap Gain) 54.18%
TRANSIT ORIENTED DEVELOPMENT
Projected Cash Flow ($000) Assumptions 0 1 2 3 4 5 6 7 8 9 10
Potential Gross Income 586.2 603.79 621.90 640.56 659.77 679.57 699.95 720.95 742.58 764.86
- Vacancy/Credit Loss (29.31) (30.19) (31.09) (32.03) (32.99) (33.98) (35.00) (36.05) (37.13) (38.24)
Effective Gross Income 556.89 573.60 590.80 608.53 626.78 645.59 664.96 684.90 705.45 726.62
- Operating Expenses (95.88) (97.79) (99.75) (101.74) (103.78) (105.85) (107.97) (110.13) (112.33) (114.58)
- Real Estate Taxes (81.04) (83.47) (85.98) (88.55) (91.21) (93.95) (96.77) (99.67) (102.66) (105.74)
Net Operating Income 379.97 392.33 405.08 418.23 431.80 445.79 460.22 475.11 490.46 506.30
- Capital Reserve (17.50) (17.50) (17.50) (17.50) (17.50) (17.50) (17.50) (17.50) (17.50) (17.50)
- Debt Service (298.72) (298.72) (298.72) (298.72) (298.72) (298.72) (298.72) (298.72) (298.72) (298.72)
Before Tax Cash Flow 63.75 76.11 88.86 102.01 115.57 129.56 143.99 158.88 174.23 190.07

+ Amortization Principal 59.06 62.39 65.91 69.63 73.56 77.71 82.09 86.72 91.61 96.78
+ Capital Reserve 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50
- Depreciation (147.35) (147.35) (147.35) (147.35) (147.35) (147.35) (147.35) (147.35) (147.35) (147.35)
Taxable Income (7.03) 8.66 24.92 41.79 59.28 77.42 96.24 115.76 136.00 157.01

- Tax Payable @ 20.00% 1.41 (1.73) (4.98) (8.36) (11.86) (15.48) (19.25) (23.15) (27.20) (31.40)
After Tax Cash Flow 65.16 74.38 83.87 93.65 103.71 114.08 124.75 135.73 147.03 158.67
- Equity In (1,018.34)
+ Net Cash from Constr. & Sale 75.43 2,669.43
Total Return (1,018.34) 140.59 74.38 83.87 93.65 103.71 114.08 124.75 135.73 147.03 2,828.10

Purchase Price 5,402.67 Sales Price 6,750.62 Sales Price 6,750.62


+ Capital Expense 175.00 - Net Book Value (4,104.21) - Income Tax (470.63)
- Depreciation (1,473.45) Gain on Sale 2,646.41 - Mortgage Balance (3,610.56)
Net Book Value 4,104.21 Net Cash from Sale 2,669.43
Depreciation Taken 1,473.45
Land Value 1,350.67 Taxes @ 20.00% 294.69
Depreciable Base 4,052.00 Remaining Gain 1,172.96
Taxes @ 15.00% 175.94 NPV at 12% 175.52
Total Taxes 470.63 IRR 17.84%

Breakdown of 17.84% Internal Rate of Return $000s (Exhibit 8)


BTCF Income Tax Futures Total
Year Actual Discount Actual Discount Actual Discount Actual Discount
1 63.75 54.10 1.41 1.19 0.00 0.00 65.16 55.29
2 76.11 54.81 (1.73) (1.25) 0.00 0.00 74.38 53.56
3 88.86 54.30 (4.98) (3.05) 0.00 0.00 83.87 51.26
4 102.01 52.90 (8.36) (4.33) 0.00 0.00 93.65 48.57
5 115.57 50.86 (11.86) (5.22) 0.00 0.00 103.71 45.65
6 129.56 48.39 (15.48) (5.78) 0.00 0.00 114.08 42.61
7 143.99 45.64 (19.25) (6.10) 0.00 0.00 124.75 39.54
8 158.88 42.73 (23.15) (6.23) 0.00 0.00 135.73 36.51
9 174.23 39.77 (27.20) (6.21) 0.00 0.00 147.03 33.56
10 190.07 36.82 (31.40) (6.08) 2,669.43 517.06 2,828.10 547.79
Total 1,243.04 480.32 (142.01) (43.05) 2,669.43 517.06 3,770.46 954.33
Percent 50.33% -4.51% 54.18% 100.00%

You might also like