Assignment: Use the data below to create the formulas to fill in the light blue highlighted cells including computing the IRR and NPV (using a 12% discount rate). Required input information is highlighted in light orange. There are no points on the loan. Also Compute DCR by Year, the Debt Yield by Year and Cash-on-Cash by Year. Plot the Cash on Cash by year. After completing the Cash-on-Cash graph compute and plot the effect of Leverage on BTIRR (use LTV's of 0%,25%,50%,75% and 90% for this graph). When you are done, save your completed spreadsheet and submit to Blackboard before the exam period is complete nI_.. 11 TII. nTInn 1I11