Ground up Columbus Triplex Wholesale Build - Full return of capital on refinance

[Robert Ellis]

SOFT COSTS NOT INCLUDED IN BASE BID
Trade	Subcontractor Cost	20% Builder Profit	Total	Construction Period Duration in Days
Permit Set Drawings With Our Architect and Building Fees	$4,000	-	$4,000	7
Sewer / Water Taps	$18,900	-	$18,900	1
Stainless Steel Appliances (Not Included)	$8,100	-	$8,100	2
Landscaping	$1,500	-	$1,500	1
Base Bid Hard Construction Cost Guaranteed Maximum Price
Trade	Subcontractor Cost	20% Builder Profit	Total	Construction Period Duration in Days
Site Clearing / Excavation Work / Trees	$5,000	$1,000	$6,000	3
Underground Utility Stubs, Plumbing, Plumbing Fixtures, Tubs, Snap in Kits Material and Labor and Permits	$27,000	$5,400	$32,400	7
Concrete Foundation and Flat Work And Asphalt Parking Pad	$28,000	$5,600	$33,600	10
Framing, Sheeting, Dimensional Lumber, Trusses, and Labor (no decks, railings, staircase)	$49,800	$9,960	$59,760	10
Atlas Shingles, Hid Ridge, Eave, Ice Guard, Underlayment, Rails, Staples, Caulk, Roof Spray Paint, Flashing Gutters, and Downspouts Materials and Labor	$4,800	$960	$5,760	2
Gutters and Downspouts and Storm Drainage Tie In	$3,000	$600	$3,600	3
Decks, Landings, Stairwells Material and Labor	$9,500	$1,900	$11,400	10
Exterior 3 Doors Materials and Labor	$2,400	$480	$2,880	2
Exterior Double Hung New Construction Windows Materials and Labor	$8,800	$1,760	$10,560	4
Siding Labor and Materials	$25,000	$5,000	$30,000	2
Insulation Materials and Labor	$15,000	$3,000	$18,000	3
HVAC with Labor & Permit	$28,000	$5,600	$33,600	5
Temp Electric, Elelctric Permit, All Can Lights, Service, Wiring, GFI, Outlet Covers, Boxes, Wires, Arc Fault	$22,000	$4,400	$26,400	5
Drywall Materials and Labor	$19,829	$3,966	$23,795	10
Paint Materials and Labor	$6,024	$1,205	$7,229	4
Interior Baseboards Trim Materials and Labor	$4,025	$805	$4,830	4
Interior Doors Materials and Labor	$5,600	$1,120	$6,720	3
Kitchen Cabinets and Bathroom Vanities with Labor Install	$7,900	$1,580	$9,480	2
Door Hardware and Kitchen Hardware	$800	$160	$960	1
Granite or Quartz Solid Surface Materials and Labor	$6,000	$1,200	$7,200	1
LVT Flooring and Carpet Mix Labor and Materials and Protector	$6,024	$1,205	$7,229	3
Tile Backsplash in Kitchen	$2,550	$510	$3,060	5
Closets Materials, Grab Bars, Mirrors, Bath Accessories, Pantry Materials and Labor	$3,000	$600	$3,600	3
Photos for Marketing	-	-	-	2
Seed and Straw / Grading	$1,500	$300	$1,800	1
Landscaping	-	-		0
Totals	$291,552	$58,310	$349,862	105
Hard Cost Price Per Square Foot - Guaranteed Maxmimum Price	$174
Price Per Unit With Hard Costs	$116,621
Price Per Bed	$58,310
15% LTC Down Payment On All In Cost For Bank Financing	$52,479
Equity And Financial Analysis (Informational only, not meant to be guaranteed)
Estimated Appraised Value On Completion	$504,000
Estimated Appraised Value Per Unit	$168,000
Appraised Value Per Square Foot	$251
Debt At Refinance 80% of Value	$403,200
Equity At Refinance	$100,800
Basis of Land and Soft Costs	$424,862
Land and Soft Costs Equity Contribution	$75,000
Hard Costs	$349,862
Cash Out Refinance Value	$79,138
Equity Value Not Returned Due to 5% Gap In Construction Loan Versus Long Term Debt Thresholds	$21,662
Estimated Cash on Cash Return in 8 Months	105.52%
Estimated Annualized Cash on Cash Return or IRR	158.28%
Historical New Construction Appreciation Percentage	8.00%
Estimated Appreciation Dollar Value Per Year	$40,320
Estimated Appreciation Dollar Value Per Month	$3,360