need solution w the excel sheet

Computational - Create an NPV model in excel for 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 rate of 10 lots per year - Costs of marketing - 5% of gross revenues IRR of 15% What is the justified acquisition cost of the land? What would be the justified acquisition cost of the land if the absorption changed from 3 to 5 years