Lot Mix and Prices: Size Bands, Price per m², Rounded List Prices and Total Sales Value
This lesson is part of the course
In this lesson
You price five fictional lot types from a banded price-per-m² list with XLOOKUP, round the list prices with MROUND, add up the total sales value and find the average price per lot.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- From Gross to Net: Roads, Open Space, Easements and Saleable Area Locked
- Lot Layout: Street Frontage, Lot Widths, Lots per Block and Leftover Metres Locked
- Lot Mix and Prices: Size Bands, Price per m², Rounded List Prices and Total Sales Value Locked
- Infrastructure Costs: Roads, Utility Connections, Fees, Contingency and Cost per Lot Locked
- Phasing: Lots per Phase, Start Dates with EDATE and Capex per Phase Locked
- Sales Absorption: Lots per Month, Months to Sell Out and Price Growth Locked
- Cash Flow: Quarterly Costs and Receipts, Peak Funding Need and Interest Locked
- Capstone: Residual Land Value, Price and Absorption Sensitivity with a Chart Locked