Use the following information to solve for both the levered and unleved NPV & IRR. Please note: mortgage and income numbers are to be annual numbers, not monthly Levered CF-0 CF-1 CF-2 NPV = IRR = Potential Investment Purchase Price Years LTV Rate: Origination Expenses: NOI Required Return Levered Required Return Un-Levered: Expected Price Appreciation: Selling expenses Expected holding period: $700,000.00 30 80.0% 7.0% 3.0% $75,000.00 13.0% 10.0% 4.0% 5.0% 2 PAID ANNUALLY of the loan amount Per Year Un-Levered CF-O CF-1 CF-2 Years of the sale price Years NPV = IRR = Workspace: 0 1 Use the following information to solve for both the levered and unleved NPV & IRR. Please note: mortgage and income numbers are to be annual numbers, not monthly Levered CF-0 CF-1 CF-2 NPV = IRR = Potential Investment Purchase Price Years LTV Rate: Origination Expenses: NOI Required Return Levered Required Return Un-Levered: Expected Price Appreciation: Selling expenses Expected holding period: $700,000.00 30 80.0% 7.0% 3.0% $75,000.00 13.0% 10.0% 4.0% 5.0% 2 PAID ANNUALLY of the loan amount Per Year Un-Levered CF-O CF-1 CF-2 Years of the sale price Years NPV = IRR = Workspace: 0 1