please solve the promblem and have clear steps please

Sube Styles Pone betare Computational - Create an NPV model in excel for a land subdivision with the following assumptions (include the Excel model in your submission) - - 30 lots at $75,000 per lot, increasing at 3% per year -Absorption rute of to lots per year - Costs of marketing - 5% of gross revenues - IRR of 15% What is the justified acquisition cost of the lund? What would be the justified acquisition cost of the land if the absorption changed from 3 to years