Key Variables Page
This
output page is a tabular
summary of key input variables and model
calculations. This is not the page for profit and cash
flow results -
we leave that to other parts of the model. Here is
where
you find land cost allocations, average lot sale price by
phase,
development cost per phase, cost of goods sold by phase, length of the
construction and holding period, interest rate trend, maximum loan
amounts based on lender requirement, developer's cash requirement,
beginning bank loan balance, project density, etc.
| 1 | # of Phases | 2 | |
| 2 | Total # of Lots | 83 | |
| 3 | Phase 1 | 38 | |
| 4 | Phase 2 | 45 | |
| 5 | Phase 3 | ||
| 6 | Project Type | 2 Phase - No Option | |
| 7 | Land Cost | $1,500,000 | |
| 8 | Land Cost Allocation Phase 1 | $686,747 | |
| 9 | Land Cost Allocation Phase 2 | $813,253 | |
| 10 | Land Cost Allocation Phase 3 | ||
| 11 | Average Sale Price - Phase 1 Lots | $72,500 | Back to LDM |
| 12 | Average Sale Price - Phase 2 Lots | $74,000 | |
| 13 | Average Sale Price - Phase 3 Lots | Profit, Cash Flow, etc. | |
| 14 | Average Sale Price - All Phases | $73,313 | |
| Profit By Phase | |||
| 15 | Development Cost - Phase 1 | $1,155,000 | |
| 16 | Development Cost - Phase 2 | $1,440,000 | Key Variables |
| 17 | Development Cost - Phase 3 | ||
| 18 | Development Cost - All Phases | $2,595,000 | Cash Inflow & Loan Reduction |
| 19 | Cost of Goods Sold - Phase 1 | $1,841,747 | Interest Calculation |
| 20 | Cost of Goods Sold - Phase 2 | $2,253,253 | |
| 21 | Cost of Goods Sold - Phase 3 | Owner Tax | |
| 22 | Cost of Goods Sold - All Phases | $4,095,000 | |
| 23 | Length of Construction Period (Months) | 3 | |
| 24 | Absorption Rate Per Month | 2 | |
| 25 | A&D Interest Rate - (Months 1-12) | 8.00% | |
| 26 | A&D Interest Rate - (Months 13-24) | 7.00% | |
| 27 | A&D Interest Rate - (Months 25-36) | 6.00% | |
| 28 | A&D Interest Rate - (Months 37-48) | 5.00% | |
| 29 | A&D Interest Rate - (Months 49-60) | ||
| 30 | Maximum A&D % on Phase 1 COGS | 75% | |
| 31 | Maximum A&D Loan Amount - Phase 1 | $1,381,310 | |
| 32 | Maximum A&D Loan Amount - Residual Land | $528,614 | |
| 33 | Maximum Initial A&D Loan Amount | $1,909,925 | |
| 34 | Minimum Cash and/or Seller Financing Amount | $745,075 | |
| 35 | Seller Financing Amount | $500,000 | |
| 36 | Cash Contribution By Developer/Investor | $245,075 | |
| 37 | Beginning A&D Loan Balance | $754,925 | |
| 38 | Initial Land Purchase | $1,500,000 | |
| 39 | Cash + Beginning Loan Balance + Seller Financing | $1,500,000 | |
| 40 | Project Duration in Years | 3.71 | |
| 41 | Total Amount of Loans (Bank, Seller, Equity Rollover) | $3,849,925 | |
| 42 | Bank & Equity Rollover Portion | $3,349,925 | |
| 43 | Total Lots in Project | 83 | |
| 44 | Total Acres in Project | 54 | |
| 45 | Project Density (Lots Per Acre) | 1.54 |
As
is the case with any output page, the key variables
page can
be printed. Click
on
the links below to see any of the model
output pages.
If you wish to ask us a question about the model, 'Contact
Us' and we will get back to you
as soon as possible.
Land Development Model, LLC
302 West Lafayette Road
Medina, OH 44256
330.441.1690
302 West Lafayette Road
Medina, OH 44256
330.441.1690