72 Below we present a Excel Data Table. 73 The Excel Data Table functionality permits users to identify a set of potential value for two independent variables. 74 The functionality automatically analyzes a formula that is dependent on these two variables and presents the results of all combinations of the two independent variables. 75 The 'EXCEL Financial Functions' Sheet presents how to create a Data Table, but, the output is presented here for those that do not want to dive any deeper. 76 77 Percent Debt Financed 78 0% 25% 50% 75% 100% 79 200,000 30 Investment 250,000 31 Required 300,000 32 350,000 33 34 Which would generate a higher NPV 35 36 board 00 ce Font Aligament Number fx Code B D E F G H Investment Required M 300,000 Percent Debt Financed SOX You are responsible for developing a model that analyzes the potential investment, providing valuations of alternate strategies and a sensitivity analysis of the results. The following model should include only the incremental impact on the income Statement, Balance Sheet and Cash Flow Statement Please enter formula in the yellow boxes below to develop the model 2020 2021 2022 2023 2024 2025 Hints Shows as postive because it is an expense that will 200,000 160,000) (100,0001 (10,0001 30,000 200,000 160,000) (100,000 (10,000) 30,000 200,000 160,000) (100,000) (10,000) 30,000 200,000 160,000 (100,000) (10,000) 30,000 200,000 (60,000) (100.000 (10,000 30,000 Interest income is based on as interest rate applied 30,000 9,000 21.000 30,000 9,000 21.000 30.000 9.000 21.000 30,000 9,000 21.000 30,000 9,000 21,000 5 Income Statement 7 Finished Goods Expense 8 Depreciation 9 Labor 0 Overhead 1 EBIT 32 Interest Income (5% interest rate) 3 Pretax 44 Tax (30%tax rate) 45 Net Income 46 47 Balance Sheet(change in account) 48 Cash 49 PPBE 50 Debt 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capt 58 Cash Flow from investing 59 Issues (Retirement) Debt 60 Cash Flow from Financing 61 Cash Generated 62 MODEL Make Buy Decision (150,000 300,000 150.000 Cash is equal to that of the previous year plus Cash PPE is equal to that of the previous year in Cape Debt is equal to that of the previous year Equity equal to that of the previous year pa Net income from the income atement Investment Required spread of these year 1300,000 (800,000 150.000 150.000 (150.0001 DATA AN MODEL Revise Budget Staffing MODEL Manufacturing Strategy 72 Below we present a Excel Data Table. 73 The Excel Data Table functionality permits users to identify a set of potential value for two independent variables. 74 The functionality automatically analyzes a formula that is dependent on these two variables and presents the results of all combinations of the two independent variables. 75 The 'EXCEL Financial Functions' Sheet presents how to create a Data Table, but, the output is presented here for those that do not want to dive any deeper. 76 77 Percent Debt Financed 78 0% 25% 50% 75% 100% 79 200,000 30 Investment 250,000 31 Required 300,000 32 350,000 33 34 Which would generate a higher NPV 35 36 board 00 ce Font Aligament Number fx Code B D E F G H Investment Required M 300,000 Percent Debt Financed SOX You are responsible for developing a model that analyzes the potential investment, providing valuations of alternate strategies and a sensitivity analysis of the results. The following model should include only the incremental impact on the income Statement, Balance Sheet and Cash Flow Statement Please enter formula in the yellow boxes below to develop the model 2020 2021 2022 2023 2024 2025 Hints Shows as postive because it is an expense that will 200,000 160,000) (100,0001 (10,0001 30,000 200,000 160,000) (100,000 (10,000) 30,000 200,000 160,000) (100,000) (10,000) 30,000 200,000 160,000 (100,000) (10,000) 30,000 200,000 (60,000) (100.000 (10,000 30,000 Interest income is based on as interest rate applied 30,000 9,000 21.000 30,000 9,000 21.000 30.000 9.000 21.000 30,000 9,000 21.000 30,000 9,000 21,000 5 Income Statement 7 Finished Goods Expense 8 Depreciation 9 Labor 0 Overhead 1 EBIT 32 Interest Income (5% interest rate) 3 Pretax 44 Tax (30%tax rate) 45 Net Income 46 47 Balance Sheet(change in account) 48 Cash 49 PPBE 50 Debt 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capt 58 Cash Flow from investing 59 Issues (Retirement) Debt 60 Cash Flow from Financing 61 Cash Generated 62 MODEL Make Buy Decision (150,000 300,000 150.000 Cash is equal to that of the previous year plus Cash PPE is equal to that of the previous year in Cape Debt is equal to that of the previous year Equity equal to that of the previous year pa Net income from the income atement Investment Required spread of these year 1300,000 (800,000 150.000 150.000 (150.0001 DATA AN MODEL Revise Budget Staffing MODEL Manufacturing Strategy