D$.$ A new seced cleaning facility requires an initial cash expenditare of $5685,000$ and is expected to yield annal net cash flows of $$92,170$ from services rendered to local cliembs over the investment's $12-$ycar planning horizon with no salvape value at the end of that period. The calloulations for this question will he done in an Excel specadsheet to be submitned with the assignment Clearly identify your answers in the workbook and provide ary explanatioe asing trat boves. Be sure to format your Excel workbock clearly $s0$ it is obviers how you came lo your anowerk. You will ese the IRRO, and NPVO functions in Evoct.

a$.$ Given a $6\%$ discount rate that the investor facs, calsulate the net present value $($NPY$)$ and $-$ ieternal rate of return $($IRR$)$ before any income tax implications are coesidened. $(10$ points$)$

b$.$ Now coesider the cave where the investor finathees the purchase of the facilify with a $30\%,$ cquity down payment and wapayment of the loan in $8$ equal monall payments $($oqual botal payment amortiration$)$ tha include interest that is charged at $4\mathrm{.}5\%$ manually on the outstanding loan balance. Calculate the same mearors at it et wad cemparelcontrast your findings. $(10$ points$)$

c$.$ Now suppose that the investoe finds herself in the $24\%$ tas hracket. Recalculate bothof the. mesoures under the socnario outlined in part b$.$ In your analysis, aswame that the orginal across ten years $($no partial year conaideration$).$ Hew does the tas obligation infleence the investment analysis results for each measure? $(10$ points$)$