Base Assumptions Purchase Price Sale Price Sale Year $ 3,617,815 $ 4,256,463 5 Debt Assumptions (Please use loan amort tab #3 to create an amortization table) LTV 75.00% I/O Period O months Debt Interesti 4.20% Loan Commen 7/1/2014 Amortization 30 year Closing 1/1/2018 Cash Flow Analysis Date Company Net Operating Income Forecast Purchase/Sale Price Year 1 1/1/2018 235,158 Year 2 1/1/2019 238, 239 Year 3 1/1/2020 246,969 Year 4 1/1/2021 212,723 Year 5 1/1/2022 319,235 Unlevered Cash Flow Interest Payments Principal Payments Total Debt Service Debt Proceeds/Repayment Levered Cash Flow Return on Equity Levered IRR - Sensitivity Table: Year of Sale and Sale Price Answers 5 Year Unlevered IRR 5 Year Levered IRR Year 1 Year 2 5 Year Total Proceeds 5 Year Profit 5 Year Equity Multiple Year 3 Year 4 Year 5 Base Assumptions Purchase Price Sale Price Sale Year $ 3,617,815 $ 4,256,463 5 Debt Assumptions (Please use loan amort tab #3 to create an amortization table) LTV 75.00% I/O Period O months Debt Interesti 4.20% Loan Commen 7/1/2014 Amortization 30 year Closing 1/1/2018 Cash Flow Analysis Date Company Net Operating Income Forecast Purchase/Sale Price Year 1 1/1/2018 235,158 Year 2 1/1/2019 238, 239 Year 3 1/1/2020 246,969 Year 4 1/1/2021 212,723 Year 5 1/1/2022 319,235 Unlevered Cash Flow Interest Payments Principal Payments Total Debt Service Debt Proceeds/Repayment Levered Cash Flow Return on Equity Levered IRR - Sensitivity Table: Year of Sale and Sale Price Answers 5 Year Unlevered IRR 5 Year Levered IRR Year 1 Year 2 5 Year Total Proceeds 5 Year Profit 5 Year Equity Multiple Year 3 Year 4 Year 5