Expenses Format In Excel Free Download 31578 | Sampleleasepurchaseproforma

Partial file snippet.

Sheet 1: Introduction

	
	
	
		
 
		
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		



Sheet 2: vertical version

	
	
	
	
	
	
	
	
	
	
	
		 LEASE-PURCHASE DEVELOPMENT PRO FORMA
		

		

		

		

		

		LEASE-PURCHASE OPERATING PRO FORMA
		

		

		

		

	
	
		No. of units:
		2
		

		 Lease Period: 
		 36 
		UNITS:
		2
		

		

		 Lease Period: 
		 36 
	
	
		SOURCES OF FUNDS
		

		

		

		  (in months) 
		INCOME
		

		

		

		

		 LEASE 
	
	
		

		

		

		 Projections 
		

		

		

		

		 MONTHLY 
		 PERIOD 
	
	
		

		

		

		 Per unit 
		 All units 
		Gross Rents
		

		

		

		 INCOME 
		 INCOME 
	
	
		Acquisition/Construction
		

		 Int rate: 
		

		

		Bdrm size
		# of units
		Lease payment
		

		

		

	
	
		Lender
		

		7%
		 38,000 
		 76,000 
		3
		2
		710
		

		 1,420 
		 51,120 
	
	
		NSP
		

		

		 75,000 
		 150,000 
		

		

		

		

		 -   
		 -   
	
	
		Non profit equity
		

		

		 4,118 
		 8,237 
		Total units:
		2
		

		

		

		 -   
	
	
		

		

		Total:
		 117,118 
		 234,237 
		

		

		

		 Gross rents: 
		 1,420 
		 51,120 
	
	
		Interim (Lease Period)
		

		

		

		

		

		

		 Less Vacancy 
		3%
		 43 
		 1,534 
	
	
		Lender
		

		7.0%
		 38,000 
		 76,000 
		

		

		

		 EFFECTIVE GROSS INCOME 
		 1,377 
		 49,586 
	
	
		NSP
		

		

		 75,000 
		 150,000 
		EXPENSES
		

		

		

		

		

	
	
		Nonprofit equity
		

		

		
		assumes half of developer fee is retained until sale.

		 4,118 
		 8,237 
		

		

		

		

		

		 LEASE 
	
	
		

		

		Total:
		 117,118 
		 234,236 
		

		

		

		 Per U mo. 
		 MONTHLY 
		 PERIOD 
	
	
		USES OF FUNDS
		

		

		

		

		Residential
		

		

		 Expenses 
		 EXPENSES 
		 EXPENSES 
	
	
		

		

		

		 Per unit 
		 All units 
		Housing counseling
		

		

		 25 
		 50 
		 1,800 
	
	
		Predevelopment
		

		

		

		

		Property taxes
		

		

		 79 
		 158 
		 5,688 
	
	
		Inspections
		

		

		 350 
		 700 
		Insurance
		

		

		 60 
		 120 
		 4,320 
	
	
		Options
		

		

		 500 
		 1,000 
		Management fee
		

		12%
		 85 
		 170 
		 6,134 
	
	
		

		

		Total Predevelopment costs:
		 850 
		 1,700 
		Maintenance
		

		

		 42 
		 84 
		 3,024 
	
	
		

		

		

		

		

		Operating Reserves
		

		

		 30 
		 60 
		 2,160 
	
	
		Acquisition
		

		

		

		

		Reserves (closing rebate )
		

		

		 100 
		 200 
		 7,200 
	
	
		Property
		

		

		 52,500 
		 105,000 
		

		

		 Total expenses: 
		 421 
		 842 
		 30,326 
	
	
		Site preparation (demolition)
		

		

		 -   
		 -   
		

		

		

		 NET OPERATING INCOME 
		 535 
		 19,260 
	
	
		Closing
		

		

		 1,000 
		 2,000 
		DEBT SERVICE
		

		

		

		

		

	
	
		

		

		Total Acquisition costs:
		 53,500 
		 107,000 
		Source
		Amount
		Rate/term
		

		

	
	
		Construction
		

		

		

		

		Lender
		 $76,000 
		7.0%
		 (int. only) 
		 443 
		 15,960 
	
	
		Construction bid
		

		

		 30,000 
		 60,000 
		

		

		

		 Total debt service: 
		 443 
		 15,960 
	
	
		Construction contingency
		15%
		

		 5,000 
		 10,000 
		

		

		

		 NET CASH FLOW 
		 92 
		 3,300 
	
	
		Other
		

		

		 3,500 
		 7,000 
		

		

		

		Debt Coverage Ratio (DCR):
		1.21
		1.21
	
	
		

		

		Total Construction costs:
		 38,500 
		 77,000 
		

		PURCHASE ANALYSIS FOR INDIVIDUAL BUYER
		

		

	
	
		Soft Costs
		

		

		

		

		SOURCES OF FUNDS
		

		

		

		

		

	
	
		Fees:
		

		

		

		

		Type/Source
		

		Rate/Term
		

		 Amount 
	
	
		Financing
		

		

		 1,500 
		 3,000 
		Purchaser's Cash
		

		

		

		3.5%
		 2,135 
	
	
		Developer fee
		12.0%
		

		 11,142 
		 22,284 
		First Mortgage
		

		5.0%
		 30 
		

		 50,165 
	
	
		Construction mgt fee
		10.0%
		

		 3,850 
		 7,700 
		Second 
		

		0%
		 5 
		20%
		 12,200 
	
	
		Counseling
		

		

		 -   
		 -   
		Third 
		

		

		

		

		 -   
	
	
		Marketing
		6%
		

		 3,660 
		 7,320 
		

		

		

		

		 TOTAL 
		 64,500 
	
	
		

		

		Sub total:
		 20,152 
		 40,304 
		USES OF FUNDS AT SALE
		

		

		

		

		

	
	
		Holding costs:
		Monthly costs
		No. of months
		

		

		Sale Price
		

		

		

		

		 61,000 
	
	
		Real estate taxes
		79
		6
		 474 
		 948 
		Closing costs
		

		

		

		

		 3,000 
	
	
		Utilities
		150
		6
		 900 
		 1,800 
		Prepaids
		

		

		

		

		 500 
	
	
		Builders risk insurance
		0
		6
		 -   
		 -   
		

		

		

		

		 TOTAL 
		 64,500 
	
	
		Liability insurance
		60
		6
		 360 
		 720 
		SUMMARY OF INDIVIDUAL HOUSING COSTS
		

		

		

		

		

	
	
		Security
		20
		6
		 120 
		 240 
		

		

		

		

		 MONTHLY 
		 ANNUAL 
	
	
		Construction loan interest
		 222 
		
		assumes loan is drawn after subsidy
		4
		 887 
		 1,773 
		Property taxes
		

		

		

		 79 
		 948 
	
	
		

		

		Sub total:
		 2,741 
		 5,481 
		Insurance
		

		

		

		 60 
		 720 
	
	
		
		assumes most closing costs are split with buyer
		Closing costs at sale:
		

		% Paid by Seller
		

		

		Debt Service
		

		

		

		

		

	
	
		Title insurance
		200
		50%
		100
		 200 
		First mortgage
		

		

		

		 269 
		 3,232 
	
	
		Survey
		550
		50%
		275
		 550 
		

		

		

		 PITI 
		 408 
		 4,900 
	
	
		Appraisal
		400
		100%
		400
		 800 
		

		

		AFFORDABILITY TABLE
		

		

		

	
	
		Legal
		600
		50%
		300
		 600 
		

		Affordable annual income at 30% of PITI
		

		

		

		 16,332 
	
	
		Transfer taxes
		600
		50%
		300
		 600 
		

		Percent of median income @30% (PITI)
		

		

		

		30%
	
	
		

		

		Sub total:
		 1,375 
		 2,750 
		

		Median income:
		

		

		

		 54,000 
	
	
		

		

		Total Soft costs:
		 24,268 
		 48,535 
		

		

		80%
		 of median:
		

		 43,200 
	
	
		

		

		Total Development costs:
		 117,118 
		 234,236 
		Subsidy summary:
		

		

		

		

		

	
	
		

		

		Development subsidy:
		 56,118 
		 112,236 
		

		

		Per Unit
		All Units
		

		

	
	
		

		

		

		

		

		

		Development subsidy:
		 56,118 
		 112,236 
		

		

	
	
		

		

		

		

		

		

		Buyer's Assistance
		 12,200 
		 24,400 
		

		

	
	
		

		

		

		

		

		

		Total subsidy
		 68,318 
		 136,636 
		

		

	
	
		

		

		

		

		

		Program income or  proceeds:
		

		 6,682 
		 13,364

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

...Sheet introduction vertical version leasepurchase development pro forma operating no of units lease period sources funds in months income projections monthly per unit all gross rents acquisitionconstruction int rate bdrm size payment lender nsp non profit equity total interim less vacancy effective expenses nonprofit assumes half developer fee is retained until sale u mo uses residential housing counseling predevelopment property taxes inspections insurance options management costs maintenance reserves acquisition closing rebate site preparation demolition net debt service source amount rateterm construction only bid contingency cash flow other coverage ratio dcr purchase analysis for individual buyer soft fees typesource financing purchaser s first mortgage mgt second third marketing sub at holding price real estate utilities prepaids builders risk liability summary security annual loan interest drawn after subsidy most are split with paid by seller title survey piti appraisal afforda...

Related files

Share

Help

LEASE-PURCHASE DEVELOPMENT PRO FORMA						LEASE-PURCHASE OPERATING PRO FORMA
No. of units:	2		Lease Period:	36	UNITS:	2			Lease Period:	36
SOURCES OF FUNDS				(in months)	INCOME					LEASE
			Projections						MONTHLY	PERIOD
			Per unit	All units	Gross Rents				INCOME	INCOME
Acquisition/Construction		Int rate:			Bdrm size	# of units	Lease payment
Lender		7%	38,000	76,000	3	2	710		1,420	51,120
NSP			75,000	150,000					-	-
Non profit equity			4,118	8,237	Total units:	2				-
		Total:	117,118	234,237				Gross rents:	1,420	51,120
Interim (Lease Period)							Less Vacancy	3%	43	1,534
Lender		7.0%	38,000	76,000				EFFECTIVE GROSS INCOME	1,377	49,586
NSP			75,000	150,000	EXPENSES
Nonprofit equity			assumes half of developer fee is retained until sale. 4,118	8,237						LEASE
		Total:	117,118	234,236				Per U mo.	MONTHLY	PERIOD
USES OF FUNDS					Residential			Expenses	EXPENSES	EXPENSES
			Per unit	All units	Housing counseling			25	50	1,800
Predevelopment					Property taxes			79	158	5,688
Inspections			350	700	Insurance			60	120	4,320
Options			500	1,000	Management fee		12%	85	170	6,134
		Total Predevelopment costs:	850	1,700	Maintenance			42	84	3,024
					Operating Reserves			30	60	2,160
Acquisition					Reserves (closing rebate )			100	200	7,200
Property			52,500	105,000			Total expenses:	421	842	30,326
Site preparation (demolition)			-	-				NET OPERATING INCOME	535	19,260
Closing			1,000	2,000	DEBT SERVICE
		Total Acquisition costs:	53,500	107,000	Source	Amount	Rate/term
Construction					Lender	$76,000	7.0%	(int. only)	443	15,960
Construction bid			30,000	60,000				Total debt service:	443	15,960
Construction contingency	15%		5,000	10,000				NET CASH FLOW	92	3,300
Other			3,500	7,000				Debt Coverage Ratio (DCR):	1.21	1.21
		Total Construction costs:	38,500	77,000		PURCHASE ANALYSIS FOR INDIVIDUAL BUYER
Soft Costs					SOURCES OF FUNDS
Fees:					Type/Source		Rate/Term			Amount
Financing			1,500	3,000	Purchaser's Cash				3.5%	2,135
Developer fee	12.0%		11,142	22,284	First Mortgage		5.0%	30		50,165
Construction mgt fee	10.0%		3,850	7,700	Second		0%	5	20%	12,200
Counseling			-	-	Third					-
Marketing	6%		3,660	7,320					TOTAL	64,500
		Sub total:	20,152	40,304	USES OF FUNDS AT SALE
Holding costs:	Monthly costs	No. of months			Sale Price					61,000
Real estate taxes	79	6	474	948	Closing costs					3,000
Utilities	150	6	900	1,800	Prepaids					500
Builders risk insurance	0	6	-	-					TOTAL	64,500
Liability insurance	60	6	360	720	SUMMARY OF INDIVIDUAL HOUSING COSTS
Security	20	6	120	240					MONTHLY	ANNUAL
Construction loan interest	222	assumes loan is drawn after subsidy 4	887	1,773	Property taxes				79	948
		Sub total:	2,741	5,481	Insurance				60	720
assumes most closing costs are split with buyer Closing costs at sale:		% Paid by Seller			Debt Service
Title insurance	200	50%	100	200	First mortgage				269	3,232
Survey	550	50%	275	550				PITI	408	4,900
Appraisal	400	100%	400	800			AFFORDABILITY TABLE
Legal	600	50%	300	600		Affordable annual income at 30% of PITI				16,332
Transfer taxes	600	50%	300	600		Percent of median income @30% (PITI)				30%
		Sub total:	1,375	2,750		Median income:				54,000
		Total Soft costs:	24,268	48,535			80%	of median:		43,200
		Total Development costs:	117,118	234,236	Subsidy summary:
		Development subsidy:	56,118	112,236			Per Unit	All Units
						Development subsidy:	56,118	112,236
						Buyer's Assistance	12,200	24,400
						Total subsidy	68,318	136,636
					Program income or proceeds:		6,682	13,364

Related files

Share

Share to social media

Help

Login Area