Enter the “Square footage of house”, Build Cost per sf”, “Interest Rate 1”,  and (optional) “Interest Rate 2”.  The worksheet will break out the phases based on the variables.

As presented, the variables are based on national averages. The “Time in Days”, and “% of Cost” variables can be customized for your business model. If you do customize the variables, just be sure that the totals still aggregate to 100%. If you customize this tool for your business model, save it as a template so you can call it up to use for future analyses.

Use this tool to create a quick estimate of building costs and loan costs for a project on which you are responsible for providing the financing.  These could include spec homes or model homes.