you are planning to buy an undeveloped land in vancouver to build four townhouses. The price of the land is $$3,100,00.$ Use a project Pro$-$Forma based on the following information:

The expenses are provided in the table below. The revenue from sales of the townhouses will take place at month $4,$ $$7,600,000.$ The project duration is four months, the interest rate for the bank loan, if any, is $6\%$ compounded monthly. The equity $($cash$)$ that the developer has to start this project is $$2,000,000.$ The brokers fee is $$30,000$ and is due at the beginning of the project $($month $0).$ The commission for any unit sold is $3\mathrm{.}5\%.$ Use an empty project pro$-$forma to enter the data and answer this question.

a$)$ Determine the Profit without time value of money.

b$)$ Determine the Return on Cost $($ROC$)$ and Return on Equity $($ROE$).$

c$)$ Determine the Net Present Value $($NPV$)$ using a Minimum Attractive Rate of Return $($MARR$)$ of $18\%$ compounded monthly. Create a cash flow diagram for the calculation of NPV$.$

d$)$ should we proceed with this project? and why?

NOTE: the answer provided in the back of our textbook is $"$We should not proceed with this project. The NPV NPV$=-19,653.$ Although the profit is $$276,000$ for a project with a duration of $4$ months, ROC$=3\mathrm{.}8\%,$ and ROE$=13\mathrm{.}8\%,$ it does not meet the MInimum Attractive Rate of Return of $18\%$ compounded monthly"

I need help with the steps on how to get to this answer.

I have attached below a picture of the expenses table, our formula sheet, and an example of a project pro$-$forma that we use $($has different informaton in it from a different question$).$