1. Build a financial model that has the ability to calculate the cash on cash return for the results of each scenario (see blank tabs) Financial Models should include the following: *Inputs Sheet *Detailed schedule for accurate cashflow tracking *Use Loan to Value Lookup at the beginning of year 1 to determine the loans interest rate and PMI for the entire Loan HINT: Build one scenario and leverage for other 4 scenarios 2. Summary Write a summary which analyzes each investment scenario? *Include which scenario has the best Cash On Cash Return after 5 years *Include which scenario has the worste cash on cash return after 5 years *Make a recommendation on how to help improve the cash on cash return of this investment