help asap please

a. list 5 errors in the cash flow and explain explain why you dont agree

b. recalculate the cash flow based on your finds in as

c. based on your findings in b what NPV and RR would this property achieve if the first analyst purchase is used?

d. make a recomm to your boss based on results in a and b

e. calculate what returns equity investors might expect

Input data and additional information for multi-year operating statement \begin{tabular}{|c|c|c|c|c|c|} \hline Required rate of return & 10,00% & per annum & & & \\ \hline \multicolumn{6}{|l|}{ Assume a five-year holding period } \\ \hline \multicolumn{6}{|l|}{ Other Income (OI)= zero } \\ \hline \begin{tabular}{l} Year 1VA=6 months vacancy in tenancy 6 , and 4 months \\ vacancy in tenancy 9 , plus a provision for collection losses @ 7% of \end{tabular} & Given & & & & \\ \hline \multicolumn{6}{|l|}{\begin{tabular}{l} VA for the remainder of the holding period will be a provision for \\ collection losses @ 5% of PGI. \end{tabular}} \\ \hline \begin{tabular}{l} Rent is at market level and annual CPI rent reviews are in place \\ for all tenancies. The applicable rent escalation rate across the \\ holdina period is estimated @ \end{tabular} & 4,25% & per annum & & & \\ \hline \begin{tabular}{l} Replacement Reserves (RR) of $50,000 in year 5 are projected to \\ partially replace the oldest portion of the roof. \end{tabular} & $50,000 & Year 5 & & & \\ \hline \begin{tabular}{l} The applicable OPEX escalation rate across the holding period is \\ forecast @ \end{tabular} & 4,00% & per annum & & & \\ \hline The terminal capitalisation rate is estimated @ & 8,50% & & & & \\ \hline Risk Free Rate (based on 5-year Government Bond yield) & 4,75% & & & & \\ \hline Risk Premium & 4,25% & & & & \\ \hline Acquisition costs & 3,00% & & & & \\ \hline Sales costs & 4,00% & & & & \\ \hline \multicolumn{6}{|l|}{ QUESTION 2 (a) } \\ \hline Year & 1 & 2 & 3 & 4 & 5 \\ \hline Potential Gross Income & $1.345.825 & $1.403.023 & $1.462.651 & $1.524.814 & $1.589.618 \\ \hline Other income & $0 & $0 & $0 & $0 & $0 \\ \hline Vacancy allowance & $111.896 & $70.151 & $73.133 & $76.241 & $79.481 \\ \hline Subtotal & $1.233.929 & $1.332.871 & $1.389.518 & $1.448.573 & $1.510.137 \\ \hline \multicolumn{6}{|l|}{ Expenses } \\ \hline OPEX & $369.600 & $384.384 & $399.759 & $415.750 & $432.380 \\ \hline Replacement reserves & $0 & $0 & $0 & $0 & $0 \\ \hline Total Expenses & $369.600 & $384.384 & $399.759 & $415.750 & $432.380 \\ \hline Net Operating Income & $864.329 & $948.487 & $989.759 & $1.032.823 & $1.077.758 \\ \hline Net Sale Price & & & & & $12.679.502 \\ \hline Total Net Income & $864.329 & $948.487 & $989.759 & $1.032.823 & $13.757.259 \\ \hline \multicolumn{2}{|l|}{PV of Cash Flow = } & 12.028.513,51 & & & \\ \hline \multicolumn{2}{|l|}{ Maximum recommended purchase price is approximately = } & $12,000,000 & & & \\ \hline \end{tabular}