tenuing to the og in the bluetooth Property main Property Name Purchase price Bayview $450.00 M UwM Lype TIT 2015 BRA Total Bels 105 Opening wat My Other Income Per Other income Anna Benincan Vacancy and Collow BPEX X sorrera Tarote Holding Period Terminal 3925 Son li target uiteid (Decorate Louity investimet Rate crimary ta tute Capital and Deprecation feature Financing LTV Loan Amount Amortid Cordigerar DOR Misiones of Phase Price Requin Cot Letration Cont Lean Costs And Loan Costa Perved Payment Are Service Lowity Required and whese Purchase Acqui La Cost LessMore in Caherd As information Land A LA Total Depreciation Deprecate Life Action Rate Font Depreciation Rate SO SO S000 $ 3.000 1 | 8 ... Cash Flow Analysis Unlevered Before Tax Cash Flow Year 6 7 Potential Gross Income (PGI) Less: Vacancy and Collection Loss Other Income Effective Gross Income (EGI) Operating Expenses (OPEX) Net Operating income (NOI) Purchase Price Net Proceeds from Sale Total 9 10 12 14 15 Property Metrics Unlevered NPV Unlevered IRR DAR at Acquisition 17 Levered Before Tax Cash Flow 19 20 21 Year 5 1 so 50 50 23 24 25 26 27 28 Net Operating income (NO) Less: Debt Service Before Tax Cash Flow Initial Cash Required Equity at Reversion Total 31 32 33 34 35 Investment Metrics Leveraged NPV Leveraged IRR Leveraged MIER Equity Dividend Rate at Acquisition After Tax Cash Flow Year SO 50 SO 5 50 Net Operating income (NOI) Less. Annual Mortgage Interest Less: Depreciation Less: Amortized Loan Costs Taxable income Ordinary Income Tax Rate Tax Liability 40 81 42 35% 355 47 Net Operating income (NOI) Less: Debt Service Before Tax Cash Flow Less: Tax Liability Alter Tax Cash Flow Initial Cash Required After Tax Equity Reversion Total After Tax Investment Metrics Laveraged After Tax NPV Leveraged After TAR IRR Leveraged Alter.Tax MIRR Leveraged After Tax Countywidend ate at Acouston Reversion Unlevered Before Tax Reversion NOI Terminal OAR Anticipated Sale Price Less: Cost of Sale (4%) Net Proceeds from Sale 9.25 NOWN SO 75% Mortgage Balance LTV Loan Amount (PV) i Amortization Period Compiunding Periods Per Year DCR Loan Origination Cost% Loan Costs Amortized Loan Costs Periodic Payment Annual Debt Service Holding Period Remaining Mortgage Balance $0 5.00% 25 12 1.15 2.00% SO $0 $0 5 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 $0 Before tax Equity Reversion Net Proceeds from Sale Less: Remaining Mortgage Balance Before Tax Equity Reversion 8188 $0 $6,450,000 Adjusted Basis Purchase Price Acquisition Costs Original Cost Basis Additional Capital Expenditures Less: Depreciation (Cost Recovery Allowance) Adjusted Basis $6.450,000 $5,450,000 $0 Capital Gain/Loss Net Proceeds from Sale Less: Adjusted Basis Total Gain/Loss -S6,450,000 42 43 Taxes Due on Sale Taxable Gain/Loss Less: Depreciation (Cost Recovery Allowance) Capital Gain/Loss on Sale SO SO 45 46 47. 48 Capital Gain/Loss Tax at 20% Depreciation Recapture Tax at 25% Taxes Due on Sale 50 51 S2 53 54 55 56 57 58 59 After Tax Equity Reversion Before Tax Equity Reversion Less: Taxes Due on Sale After Tax Equity Reversion 188 D E Please link your answer to the appropriate cell in your Cash Flow Projections and Reversion sheets where applicable. What is the EG in Year 4? What is the NOI in Year 1? What is the unlevered NPV? What is the unlevered IRR? What is the annual debt service payment? What is the before-tax cash flow for Year 5? What is the equity dividend rate at acquisition? What is the remaining mortgage balance at the end of the holding period? What is the leveraged NPV? What is the leveraged IRR? How much will be paid in mortgage interest in Year 4? How much will be paid in debt service over the holding period? 13 How much depreciation will be taken in in Year 2? How much income tax will be paid in Year 3? 15 What is the total expected depreciation over the holding period? What is the adjusted basis at reversion? How much tax will be due upon sale of the property? 18 What is the leveraged after-tax NPV? What is the leveraged after-tax IRR? What is the leveraged after-tax MIRR? Bonus What is the annual compound rate of growth for the NOI over the holding period? 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20. 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 14 16 17 8 = 0 = 5 19 20 tenuing to the og in the bluetooth Property main Property Name Purchase price Bayview $450.00 M UwM Lype TIT 2015 BRA Total Bels 105 Opening wat My Other Income Per Other income Anna Benincan Vacancy and Collow BPEX X sorrera Tarote Holding Period Terminal 3925 Son li target uiteid (Decorate Louity investimet Rate crimary ta tute Capital and Deprecation feature Financing LTV Loan Amount Amortid Cordigerar DOR Misiones of Phase Price Requin Cot Letration Cont Lean Costs And Loan Costa Perved Payment Are Service Lowity Required and whese Purchase Acqui La Cost LessMore in Caherd As information Land A LA Total Depreciation Deprecate Life Action Rate Font Depreciation Rate SO SO S000 $ 3.000 1 | 8 ... Cash Flow Analysis Unlevered Before Tax Cash Flow Year 6 7 Potential Gross Income (PGI) Less: Vacancy and Collection Loss Other Income Effective Gross Income (EGI) Operating Expenses (OPEX) Net Operating income (NOI) Purchase Price Net Proceeds from Sale Total 9 10 12 14 15 Property Metrics Unlevered NPV Unlevered IRR DAR at Acquisition 17 Levered Before Tax Cash Flow 19 20 21 Year 5 1 so 50 50 23 24 25 26 27 28 Net Operating income (NO) Less: Debt Service Before Tax Cash Flow Initial Cash Required Equity at Reversion Total 31 32 33 34 35 Investment Metrics Leveraged NPV Leveraged IRR Leveraged MIER Equity Dividend Rate at Acquisition After Tax Cash Flow Year SO 50 SO 5 50 Net Operating income (NOI) Less. Annual Mortgage Interest Less: Depreciation Less: Amortized Loan Costs Taxable income Ordinary Income Tax Rate Tax Liability 40 81 42 35% 355 47 Net Operating income (NOI) Less: Debt Service Before Tax Cash Flow Less: Tax Liability Alter Tax Cash Flow Initial Cash Required After Tax Equity Reversion Total After Tax Investment Metrics Laveraged After Tax NPV Leveraged After TAR IRR Leveraged Alter.Tax MIRR Leveraged After Tax Countywidend ate at Acouston Reversion Unlevered Before Tax Reversion NOI Terminal OAR Anticipated Sale Price Less: Cost of Sale (4%) Net Proceeds from Sale 9.25 NOWN SO 75% Mortgage Balance LTV Loan Amount (PV) i Amortization Period Compiunding Periods Per Year DCR Loan Origination Cost% Loan Costs Amortized Loan Costs Periodic Payment Annual Debt Service Holding Period Remaining Mortgage Balance $0 5.00% 25 12 1.15 2.00% SO $0 $0 5 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 $0 Before tax Equity Reversion Net Proceeds from Sale Less: Remaining Mortgage Balance Before Tax Equity Reversion 8188 $0 $6,450,000 Adjusted Basis Purchase Price Acquisition Costs Original Cost Basis Additional Capital Expenditures Less: Depreciation (Cost Recovery Allowance) Adjusted Basis $6.450,000 $5,450,000 $0 Capital Gain/Loss Net Proceeds from Sale Less: Adjusted Basis Total Gain/Loss -S6,450,000 42 43 Taxes Due on Sale Taxable Gain/Loss Less: Depreciation (Cost Recovery Allowance) Capital Gain/Loss on Sale SO SO 45 46 47. 48 Capital Gain/Loss Tax at 20% Depreciation Recapture Tax at 25% Taxes Due on Sale 50 51 S2 53 54 55 56 57 58 59 After Tax Equity Reversion Before Tax Equity Reversion Less: Taxes Due on Sale After Tax Equity Reversion 188 D E Please link your answer to the appropriate cell in your Cash Flow Projections and Reversion sheets where applicable. What is the EG in Year 4? What is the NOI in Year 1? What is the unlevered NPV? What is the unlevered IRR? What is the annual debt service payment? What is the before-tax cash flow for Year 5? What is the equity dividend rate at acquisition? What is the remaining mortgage balance at the end of the holding period? What is the leveraged NPV? What is the leveraged IRR? How much will be paid in mortgage interest in Year 4? How much will be paid in debt service over the holding period? 13 How much depreciation will be taken in in Year 2? How much income tax will be paid in Year 3? 15 What is the total expected depreciation over the holding period? What is the adjusted basis at reversion? How much tax will be due upon sale of the property? 18 What is the leveraged after-tax NPV? What is the leveraged after-tax IRR? What is the leveraged after-tax MIRR? Bonus What is the annual compound rate of growth for the NOI over the holding period? 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20. 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 14 16 17 8 = 0 = 5 19 20