I need some help starting this assignment! I am confused how to set this up.

Assignment 7 (75 pts): Using excel, assess the following. For a total investment of $12 million, the proposed subdivision will have 250 buildable lots. Development costs of $6 million are evenly spread over the rst eight months. The lots will start selling in month 9 at a pace of 25 per month. The lots will sell for $100,000 per lot. $9 million of the capital investment will be financed at 7% annual interest with principal paid back in proportion to the number of lots sold. Sales expenses will run 10% of the lot price. The rm allocates xed operating expenses of $30,000 per month to the project. 1) In the month of sellout, what is the total cumulative net investment? 2) What is the payback month on the equity invested? Set up a simple =IF statement to indicate that the subdivision has sold out. Also, answer questions 1) and 2) above for the following scenarios, as well. A) Absorption (velocity) is 25 per month, but the selling price is increased to $120,000. B) Absorption (velocity) increases to 20 per month at the proposed $100,000 selling price. C) Absorption (velocity) increases to 25 per month, at an $85,000 selling price. D) Absorption (velocity) decreases to 50 per month, at the $85,000 selling price. E) Absorption (velocity) increases to 9 per month, at the $120,000 selling price