jagomart
digital resources
picture1_Construction Template Excel 40240 | Proforma And Budget Template


 249x       Filetype XLSX       File size 0.04 MB       Source: www.detroithousingforthefuturefund.org


File: Construction Template Excel 40240 | Proforma And Budget Template
sheet 1 1 project financing summary ref construction financing sources sources amount lien priority specify 1st 2nd 3rd etc or quot na quot for a grant or unsecured source commitment ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: 1.  Project Financing Summary



#REF!








Construction Financing Sources



Sources Amount Lien Priority
(Specify 1st, 2nd, 3rd, etc., or "NA" for a grant or unsecured source)
Commitment Status
(Specify committed, applied for, to-be-applied for, or possible)




























Total Sources $0





Permanent Financing Sources


Sources Amount Lien Priority
(Specify 1st, 2nd, 3rd, etc., or "NA" for a grant or unsecured source)
Commitment Status
(Specify committed, applied for, to-be-applied for, or possible)




























Total Sources $0





If loans are revolving, provide footnote estimating total amount to be drawn during life of LISC loan.

Total Construction Financing Sources must equal Total Permanent Financing Sources. If necessary, list deferred payment of construction expenses (e.g., developer fees) during the construction phase as a source to ensure that construction and permanent financing source totals equal each other.

Sheet 2: 2. Development Cost and Budget
REQUEST FOR PROGRAM ACTION - DATA SHEETS




#REF!






















TOTAL DEVELOPMENT COST








INPUT ALL YELLOW SHADED CELLS; GRAY SHADED CELLS ARE FORMULAS


NOTE: IF ROWS ARE ADDED, ENSURE THAT IT DOES NOT IMPACT THE FORMULAS













Residential

Non-Residential





Residential Square feet:

Commercial Square feet:





Residential As a % of Total SF NA
Commercial As a % of Total SF NA




No. of units:

















Category Residential Amount Cost per Unit
Non-Residential Amount Cost per SF Total Amount


Acquisition NA NA
NA NA NA


Hard Costs NA NA
NA NA NA


Soft Costs NA NA
NA NA NA


Developer fees NA NA
NA NA NA


Total $0 NA
$0 NA $0












TOTAL DEVELOPMENT BUDGET



Item Total
Per Unit (Residential) Per Gross SF (Non-Residential) Use of LISC Loan Funds (Y/N)


Acquisition Land

NA NA N



Building

NA NA


Y

Pre-closing costs

NA NA


N

Total Acquisition $0
NA NA













Hard Costs Public Infrastructure

NA NA




Demolition

NA NA




Environmental Mitigation

NA NA




Construction Hard Costs

NA NA Y



Parking

NA NA




General Requirements/ Overhead/Profits

NA NA Y



Permits/ Tap Fees/ Bond/ Cost Certification

NA NA




Hard Cost Contingency (as % of total hard costs)
NA NA NA Y



Total Hard Costs $0
NA NA













Soft Costs Accounting and Financial Consulting

NA NA




Appraisal

NA NA




Architect

NA NA




Engineering

NA NA




Supervision

NA NA




Builder's Risk Insurance

NA NA




Building Permits

NA NA




Construction Period Operating Expenses $0
NA NA




Property Taxes

NA NA




Security and Utilities

NA NA




Other Operating Expenses

NA NA




Consultant Fees

NA NA




Engineering

NA NA




Environmental Study/ Soil Testing

NA NA




Escrow for Operating Deficits

NA NA




Financing Costs $0
NA NA




Construction Interest

NA NA




Loan/Financing Fees

NA NA




Predevelopment Loan - Interest Payments

NA NA




Other Financing Costs

NA NA




HTC Asset Management Fee

NA NA




HTC Fees

NA NA




Insurance During Construction

NA NA




Legal $0
NA NA




Transaction

NA NA




Organization

NA NA




Syndication

NA NA




Lender Inspections

NA NA




Market Study

NA NA




Marketing and Leasing Commissions

NA NA




Organization Costs (except legal)

NA NA




Other Construction Deficits/Revenues

NA NA




Professional Fees

NA NA




Project Management Fees

NA NA




Rent Up Reserves



N



Soft Cost Contingency (as % of total soft costs)
NA NA NA




Survey/Site Tests

NA NA




Syndication Fees

NA NA




Tax Credit Application

NA NA




Tenant Relocation

NA NA




Title, Mortgage Recording, Transfer Taxes

NA NA




Total Soft Costs $0
NA NA














Developer Fees

NA NA













TOTAL COSTS
$0
NA NA




The words contained in this file might help you see if this file matches what you are looking for:

...Sheet project financing summary ref construction sources amount lien priority specify st nd rd etc or quot na for a grant unsecured source commitment status committed applied tobeapplied possible total permanent if loans are revolving provide footnote estimating to be drawn during life of lisc loantotal must equal necessary list deferred payment expenses eg developer fees the phase as ensure that and totals each other development cost budget request program action data sheets input all yellow shaded cells gray formulas note rows added it does not impact residential nonresidential square feet commercial sf no units category per unit acquisition hard costs soft item gross use loan funds yn land n building y preclosing public infrastructure demolition environmental mitigation parking general requirements overheadprofits permits tap bond certification contingency accounting financial consulting appraisal architect engineering supervision builder s risk insurance period operating property t...

no reviews yet
Please Login to review.