please show the excel formula used to anwser the yellow boxes

clearer image

H 1 1 1 M N D 2021 2022 2023 2024 2025 2026 Shown appuitive became that will 160.000 so (180.000 110.000 110,000 10,000 190.000 1180.000 110,000 110,000 160.000 0.0001 110,000 10.000 110,000 160.000 0.000 (180.000 10,000 110,000 160.000 150,0001 1180.0001 190.000 110,000 A57 fa A c 35 36 income atment 37 Finhado por 3 Deprecate 19 40 Overhe 41 BY #rest Income interest rate 43 Preto 44 TONER 45Notincome 46 ay nhat hangin 48 Cash 49 FI SO Det 51 ity Interest income isbanden Statele royar Net Chains Betty 110,000 33.000 77.000 110,000 13,000 77,000 110,000 13,000 27,000 110,000 11.000 77.000 11070 31.000 77,000 1150,000 500.000 150,000 Cash that of the previous years whered PPC to that of the previous year plast www.Captis hown a neative on the Canto Steen Det in to that of the previous Equity into that of the years now there were Note the Investment had read of the years 53 Cathleen 54 Na SS Die 56 Cachower 57 Chiwum 59 60 Cashflow from 61 Cather 62 0000001 p0.00 150,000 150.000 1150.000 Orbandon Percendit in with thretired athyar. Must be atombombing D E A B H j K 59 Issues (Retirement) Debt 150,000 Debt based on perc 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 value (not the formula) 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 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% SON 75% 100% 79 200,000 80 Investment 250,000 81 Required 300,000 82 350,000 83 84 Which would generate the higher NPV? 85 86 . 27 B C D E F G H H I 2021 2022 2023 2024 2025 2026 9 A B 35 36 Income Statement 37 Finished Goods Expense 38 Depreciation 39 Labor 40 Overhead 41 EBIT 42 Interest Income (5% interest rate) 43 Pretax 44 Tax (30%tax rate) Net Income 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 (150,000) 300,000 150,000 ggggggggg 47 Balance Sheet (change in account) 48 Cash 49 PP&E 50 Debt 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capex 58 Cash Flow from Investing 59 Issues (Retirement) Debt 60 Cash Flow from Financing 61 Cash Generated 62 0 0 0 0 0 (300,000) (300,000) 150,000 150,000 (150,000) H 1 1 1 M N D 2021 2022 2023 2024 2025 2026 Shown appuitive became that will 160.000 so (180.000 110.000 110,000 10,000 190.000 1180.000 110,000 110,000 160.000 0.0001 110,000 10.000 110,000 160.000 0.000 (180.000 10,000 110,000 160.000 150,0001 1180.0001 190.000 110,000 A57 fa A c 35 36 income atment 37 Finhado por 3 Deprecate 19 40 Overhe 41 BY #rest Income interest rate 43 Preto 44 TONER 45Notincome 46 ay nhat hangin 48 Cash 49 FI SO Det 51 ity Interest income isbanden Statele royar Net Chains Betty 110,000 33.000 77.000 110,000 13,000 77,000 110,000 13,000 27,000 110,000 11.000 77.000 11070 31.000 77,000 1150,000 500.000 150,000 Cash that of the previous years whered PPC to that of the previous year plast www.Captis hown a neative on the Canto Steen Det in to that of the previous Equity into that of the years now there were Note the Investment had read of the years 53 Cathleen 54 Na SS Die 56 Cachower 57 Chiwum 59 60 Cashflow from 61 Cather 62 0000001 p0.00 150,000 150.000 1150.000 Orbandon Percendit in with thretired athyar. Must be atombombing D E A B H j K 59 Issues (Retirement) Debt 150,000 Debt based on perc 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 value (not the formula) 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 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% SON 75% 100% 79 200,000 80 Investment 250,000 81 Required 300,000 82 350,000 83 84 Which would generate the higher NPV? 85 86 . 27 B C D E F G H H I 2021 2022 2023 2024 2025 2026 9 A B 35 36 Income Statement 37 Finished Goods Expense 38 Depreciation 39 Labor 40 Overhead 41 EBIT 42 Interest Income (5% interest rate) 43 Pretax 44 Tax (30%tax rate) Net Income 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 (150,000) 300,000 150,000 ggggggggg 47 Balance Sheet (change in account) 48 Cash 49 PP&E 50 Debt 51 Equity 52 53 Cash Flow Statement 54 Net Income 55 Depreciation 56 Cash Flow from Operations 57 Capex 58 Cash Flow from Investing 59 Issues (Retirement) Debt 60 Cash Flow from Financing 61 Cash Generated 62 0 0 0 0 0 (300,000) (300,000) 150,000 150,000 (150,000)