Build Pro Formula analysis in Excel to compute Net Income for the following project:

a$)$ You plan to build a quadplex in and you plan to sell this quadplex after the project is complete. After doing all the due diligence and consulting with experts. You came up with the following costs:

Projected sale price is $$1\mathrm{.}5$ million

Land acquisition $($including all the legal fees and associated expenses$)$ is $$200,000.$

Total construction cost $($including all the expenses associated with construction such as land development, actual building construction, legal fees, etc.$)$ is $$1$ million.

Total sale cost $($marketing$,$ agent, and legal fees, etc.$)$ is $$100,000.$

Assume you received $$1$ million worth of a loan for the total construction cost which you will be paying off right after the sale is completed. However, the lender will not give you the loan until you acquire the land. You are also expected to pay a one$-$time $$80,000$ interest with the loan payment to the lender for the amount you borrowed. Assume the interest payment is fully tax deductible.

Tax rate is $25\%.$

Assume there are not any additional expenses.