Docstoc

Single Family Housing Development Budget Template - Excel

Document Sample
Single Family Housing Development Budget Template - Excel Powered By Docstoc
					Dev. Budget

SINGLE FAMILY HOUSING DEVELOPMENT Development Budget Project: DEVELOPMENT BUDGET ITEM ACQUISITION Building Acquisition Land Acquisition CONSTRUCTION Construction/Rehab (see schedule) Landscaping Permits Clearance and Demoliton Utility Connections & Tap Fees Contingency INFRASTRUCTURE Streets and Sidewalks Water and Sewer Stormwater & Drainage PROFESSIONAL FEES Site Planning Architect & Engineer RE Attorney Consultant Survey Market Study Environmental Organization Expense FINANCE COSTS Const. Loan Interest Const. Origination Appraisal Const. Insurance Property Taxes SOFT COSTS Marketing Other DEVELOPER FEE TOTAL DEV COST

COST 0

% Total

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Constr./Rehab Costs Model Number 1 2 3 4 5 6 7 Total

Size 0 0

Cost/Sq Ft Unit Cost # Units 0 0 0 0 0 0 0 0 0 0

Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Sales Price -

0

Page 1

Profit & Loss

PROFIT AND LOSS STATEMENT Project: 0

REVENUE Sale of Housing Units Sale of Housing Units Sale of Housing Units Sale of Housing Units Sale of Housing Units Sale of Housing Units Sale of Housing Units Total Less Selling Costs TOTAL REVENUE CONSTRUCTION INTEREST Annual Interest Number of Months Costs x Monthly Interest Rate x Number of Months = Total Interest

# Units 0 0 0 0 0 0 0 0 4.00%

Price $ $ $ $ $ $ $ $ Percent

-

Total $ $ $ $ $ $ $ $ $ $

-

1.00% 1 $ 0.08% 1 -

$

COSTS Property Acquisition Unit Construction Other Construction Infrastructure Professional Fees Finance Costs Soft Costs Other Costs Developer Fee TOTAL $ $ $ $ $ $ $ $ $ $ -

TOTAL REVENUE - TOTAL COSTS = PROFIT (LOSS)

$ $ $

-

PROJECTED PROFIT - ACTUAL PROFIT = DEVELOPERS SUBSIDY

0% Percent

$ $ $

-

Page 2

SINGLE FAMILY HOUSING DEVELOPMENT Cash Flow Analysis Project #s Construction cost Sales price Sales expense Construction interest rate Months to construct Months to sell $0 $0 4.0% 1.0% 1 0 Acquisition Unit Construction Other Construction Infrastructure Professional Fees Cnstruction Interest Other Finance Costs Soft Costs Other Costs 1 0 Budget $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Cumulative Expenditure $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 2 2 2

% Debt 100% 100% 100% 100% 100% 100% 100% 100% 100% 3 3

% City Grant 0% 0% 0% 0% 0% 0% 0% 0% 0% 4 3 5 1 6 0 7 0 8 0 9 0 10 0 11 0 12 0

Month 1 # Housing Starts 2 Project Expenses Property Acquisition Unit Construction Other Construction Infrastructure Professional Fees Construction Interest Other Finance Costs Soft Costs Other Costs Total Monthly Expenses 2a Cumulative Project Expenses

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 3

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 3

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 1

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 0

3 Number of New Constr. Sales 4 Project Revenue Sales -Cost of Sale Net Monthly Revenue 5 Cash Flow Net Monthly Revenue (4) -Total Monthly Expenses (2) Monthly Cash Flow (+ go to 6, - go to 7) 6 Uses of Cash Flow (CF) Debt Repayment +Equity Repayment Total Uses of Monthly CF 7 Sources of Investment Debt +Owner Equity +City Grant Total Sources of Monthly Investment

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

6a 6b

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

7a 7b 7c

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

INVESTMENT SUMMARY Outstanding Debt Previous Month's Outstanding Debt -CF for Debt Repayment (#6a) +This Month's Debt Invested (#7a) OUTSTANDING DEBT Equity Invested Previous Month's Outstanding Equity -CF for Equity Repayment (#6b) +This Month's Equity Invested (#7b) EQUITY INVESTED Project Cash Balance Cumulative Project Revenue ( #4) - Cumulative Expenses = Cash Balance

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

Permanent Mortgage

PERMANENT MORTGAGE ANALYSIS Project: Leftville Buyer: Smith House Information Purchase Price Appraised Value

Bank Requirements Bank Ratio Front End Back End Annual Interest Rate Loan Term (Years) Constant Annual Percent Loan to Value Closing Costs Debt Capacity Monthly Income x Front Ratio - Taxes - Insurance - Other Monthly = Max. Monthly Debt Service-Front Monthly Income x Back Ratio - Taxes - Insurance - Other - Loan Payments - Credit Card Payments - Other Monthly = Max. Monthly Debt Service-Back Maximum Monthly Debt Service Maximun Loan Using Front/Back Maximum Loan Using LVR Maximum Loan Permanent Mortgage Purchase Price Loan Amount Equity Needed Closing Costs Cash Available from Buyer Homebuyer Subsidy

29% 38% 7.50% 30 0.0839 95% $2,000

Family Information Annual Income Annual Taxes Annual Insurance Total Credit Card Debt

$51,000 ####### Monthly Income $900 $75.00 Monthly Taxes $700 $58.33 Monthly Insurance $2,000

$ 1,232.50 $ 75.00 $ 58.33 $ $ 1,099.17 $ 1,615.00 $ 75.00 $ 58.33 $ $ 250.00 $ 100.00 $ 100.00 $ 1,031.67 $ 1,031.67 $ 147,547 $ $ -

Debt Service for Loan Using LVR + Monthly Taxes + Monthly Insurance = Monthly Mortgage Payment

$0.00 $75.00 $58.33 $133.33

$ $ $ $ $ $

2,000 1,000 1,000

Page 4


				
DOCUMENT INFO
Shared By:
Stats:
views:2842
posted:2/9/2008
language:English
pages:4