= I IM Merge Center Insert Delete Format Condronal Format as Cell Formatting table Styles Styles Clear Sipboard 5 Font Alignment Number Editing fx Please enter F G B D E in the yellow boxes below to develop the model H 1 M Hints Shown as positive because it is an expense that will cease Interest Income is based on a 5% interest rate applied to Cash is equal to that of the previous year plus Cash Generat PP&E is equal to that of the previous year minus Capex (show Debt is equal to that of the previous year plus issues (Retirer Equity is equal to that of the previous year plus Net Income 5 2020 2021 2022 2023 2024 2025 6 Income Statement 7 Finished Goods Expense 200,000 8 200,000 200,000 200,000 200,000 Depreciation (60,000) 160,000) 19 (60,000) Labor 160,000) 160,000) (100,000) 20 (100,000) (100,000 (100,000) (100,000) Overhead (10,000) (10,000) (10,000) (10,000) 41 (10,000) EBIT 30,000 30,000 30,000 30,000 30,000 42 Interest Income [5% interest rate) 43 Pretax 30,000 30,000 30,000 30,000 30,000 44 Tax (30%tax rate) 9,000 9,000 9,000 9,000 9,000 45 Net Income 21,000 21,000 21,000 21,000 21,000 46 47 Balance Sheet (change in account) 48 (150,000) 49 PPSE 300,000 50 Debt 150,000 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capts (300,0001 59 Cash Flow from Investing (300,000) 59 Issues (Retirement) Debt 150,000 60 Cash Flow from Financing 150,000 61 Cash Generated (150,000) 62 63 Write a fomula that calculates the Net Present Value (NPV) of the cash flows in Row 61 using a 10% discount factor 64 65 66 Change the investment Required',cell 27. to $200,000 and enter the resulting NPV value (not the formula) in the yellow box below. 67 62 MODI DATA TABLES MODEL Marketing Strategy MODEL Make-Buy Decision MODEL Simple Company Net Income from the income Statement Investment Required spread of the useful le 15 years) Debt based on Percent Debt Financed with 1/5th retired eachy 4 Home End Polo = I IM Merge Center Insert Delete Format Condronal Format as Cell Formatting table Styles Styles Clear Sipboard 5 Font Alignment Number Editing fx Please enter F G B D E in the yellow boxes below to develop the model H 1 M Hints Shown as positive because it is an expense that will cease Interest Income is based on a 5% interest rate applied to Cash is equal to that of the previous year plus Cash Generat PP&E is equal to that of the previous year minus Capex (show Debt is equal to that of the previous year plus issues (Retirer Equity is equal to that of the previous year plus Net Income 5 2020 2021 2022 2023 2024 2025 6 Income Statement 7 Finished Goods Expense 200,000 8 200,000 200,000 200,000 200,000 Depreciation (60,000) 160,000) 19 (60,000) Labor 160,000) 160,000) (100,000) 20 (100,000) (100,000 (100,000) (100,000) Overhead (10,000) (10,000) (10,000) (10,000) 41 (10,000) EBIT 30,000 30,000 30,000 30,000 30,000 42 Interest Income [5% interest rate) 43 Pretax 30,000 30,000 30,000 30,000 30,000 44 Tax (30%tax rate) 9,000 9,000 9,000 9,000 9,000 45 Net Income 21,000 21,000 21,000 21,000 21,000 46 47 Balance Sheet (change in account) 48 (150,000) 49 PPSE 300,000 50 Debt 150,000 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capts (300,0001 59 Cash Flow from Investing (300,000) 59 Issues (Retirement) Debt 150,000 60 Cash Flow from Financing 150,000 61 Cash Generated (150,000) 62 63 Write a fomula that calculates the Net Present Value (NPV) of the cash flows in Row 61 using a 10% discount factor 64 65 66 Change the investment Required',cell 27. to $200,000 and enter the resulting NPV value (not the formula) in the yellow box below. 67 62 MODI DATA TABLES MODEL Marketing Strategy MODEL Make-Buy Decision MODEL Simple Company Net Income from the income Statement Investment Required spread of the useful le 15 years) Debt based on Percent Debt Financed with 1/5th retired eachy 4 Home End Polo