Please show the formulas you used as I need to put the formulas in the blanks.

A B D E F G H 25 For the purpose of developing the model, you have selected some initial values for the two independent variables. 26 27 Investment Required 300,000 28 29 Percent Debt Financed 50% 30 31 You are responsible for developing a model that analyzes the potential investment, providing valuations of alternate strategies and a sensitivity analys 32 The following model should include only the incremental impact on the Income Statement, Balance Sheet and Cash Flow Statement. 33 Please enter formula in the yellow boxes below to develop the model. 34 35 2020 2021 2022 2023 2024 2025 36 Income Statement 37 Finished Goods Expense 200,000 200,000 200,000 200,000 200,000 38 Depreciation (60,000) (60,000) (60,000) (60,000) (60,000) 39 Labor (100,000) (100,000) (100,000) (100,000) (100,000) 40 Overhead (10,000) (10,000) (10,000) (10,000) (10,000) 41 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 Cash (150,000) 49 PP&E 300,000 50 Debt 150,000 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 CapEx (300,000) 58 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 B C D E F G H 47 Balance Sheet (change in account) 48. Cash (150,000) 49 PP&E 300,000 50 Debt 150,000 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capex (300,000) 58 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 D27, to $200,000 and enter the resulting NPV value (not the formula) in the yellow box below. 67 68 69 Keeping the $200,000 'Investment Required' change the 'Percent Debt Financed' to 0% and enter the resulting NPV in the yellow box below. 70 71 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 independ 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 80 Investment 250,000 81 Required 300,000 82 350,000 83 84 which would generate a higher NPV 85 86 87