HomeMy WebLinkAboutFinancial Review Basic Info requiredPurchase of Land and Buildings
Acquisition - Land
Acquisition - Building
Site Work
On site work
Off site work - streets, curbs, etc.
Rehab and/or New Construction
New Construction Costs
Rehabiliation Costs
Construction Contingency ____ %
Other Contingency
Other Depreciable Costs
Furniture, Fixtures, Equipment
Professional Fees
Architect Fee - Design / Supervision
Fees
Engineering
Accounting / Real Estate Attorney
Appraisal, Market Study, Environmental Reports
Consulting, Cost Certification, etc.
Other contingency (____%)
Developer's Fees
Developer's Fees
General Partner Fees
Interim Costs
Construction Interest
Construction Loan Fee
Insurance, Title, etc.
Taxes, Performance Premium, etc.
Permanent Financing Fees and Expenses
Permanent Loan Fees
Tax Credit Fees
Start-up Expenses
Organizational Expense
Marketing
Syndication Costs
Syndication Legal Fee
Tax Opinions, other fees
Project Reserves
Operating, Vacanacy, Lease Up Reserves
Maintenance, Replacement Reserves
TOTAL
Project Costs
0
Uses of Funds
Uses of Funds
Land acquisition
Building construction, renovation
Machinery and Equipment
Furniture and Fixtures
Leasehold Improvements
Contingencies
Other
Other
Other
Other
Total Uses of Funds
Amount
0
=
Sources of Funds
List
Lender, Investor or other Source
Term
Estimated Rate
Collateral
Total Sources of Funds
Amount
0
Annual Debt Service
PRE TAX CASH FLOW ANALYSIS
REVENUES
Gross Residential Rent
Gross Commercial Rent
Commercial Tenant Contributions
Other Income
= GROSS INCOME
Vacancy Residential
Vacancy Commercial
= EFFECTIVE GROSS RENT (EGR)
OPERATING EXPENSES
Insurance
Maintenance
Prop Taxes
Misc.
Management Fees
Reserve Deposits (escrows)
= NET OPERATING INCOME
- DEBT SERVICE (annual princ + int)
Loan #1
Loan #2
- TOTAL DEBT SERVICE
= CASH FLOW (avail for distribution)
Cash on Cash ROI
Cash Flow Available for Distribution
Original Equity Investment
YR1
0
0
0
0
0
YR2
0
0
0
0
0
YR3
0
0
0
0
0
YR4
0
0
0
0
0
YR5
0
0
0
0
0
YR6
0
0
0
0
0
YR7
0
0
0
0
0
YR8
0
0
0
0
0
YR9
0
0
0
0
0
YR10
0
0
0
0
0
stabilized NOI
AFTER TAX CASH FLOW ANALYSIS
DETERMINING TAXES
Cash Flow (from Pretax Analysis)
+ Loan Principal Payments
+ Reserve Deposits
- Depreciation Expense
- Amortization of Fees
- Accrued Interest
= Taxable Income or (Loss)
x Tax Rate ___%
= Taxes Incurred (saved)
Cash Flow After Tax =
Cash Flow from above
- Tax Incurred (or + Tax Saved)
= Cash Flow After Tax (CFATx)
TOTAL BENEFIT ANALYSIS
Cash Flow After Tax (CFATx)
+ Rehabilitation Tax Credit (RTC)
+ LIHTC
+ Net Sales Proceeds (NSP)
= TOTAL BENEFITS AFTER TAX
Net Cash Flow After Tax
IRR (From PV table)
Present Value
YR1
AFTER TAX BENEFIT ANALYSIS
YR2
YR3
YR4
YR5
YR6
YR7
YR8
YR9
YR10
SUM of PVs