show steps to calculation to put in excel!!!$--$ Using the discounted cash flow $($DCF$)$ valuation method, what is the maximum loan that can be made on a property with the following annual net before$-$tax cash flow, assuming a $10\mathrm{.}5\%$ discount rate and underwriting criteria which specify a maximum loan$/$value ratio of $75\%?$ Cash flows: $$1$ Million in year $1,1\mathrm{.}1$ Million in year $2$ through $4,1\mathrm{.}5$ Million in year $5$ through $9,$ and $$12$ Million in year $10$ including reversion?