My main issues are calculating the three blank yellow boxes. I am not sure how to create the correct formulas.

I understand the break even point is when the cumulative net cash flow is greater than or equal to the total development cost, but I am not sure how to calculate that properly into the formula because it only says "true", not specifying how many years. Any assistance would be greatly appreciated.

Simple Cash Flow Method Cost-Benefit Analysis Yearly 2021 Increase 2022 2023 2024 2025 2026 Total Factor Benefits Increased hours of data entry and order fulfillment Increased inventory balance and decreased stock-outs Increased inventory turnover ratio Increased warehouse organization Total Benefits 5% 2% 2% 5% 19,000 19,950 20,948 24,000 24,480 24,970 16,000 16,320 16,646 63,000 66,150 69,458 122,000 126,900 132,021 21,995 25,469 16,979 72,930 137,374 23,095 25,978 17,319 76,577 142,969 104,987 124,897 83,265 348,115 661,263 Development Costs Dell Poweredge rack- mounted server Windows Surface Pro (5) (warehouse) Windows SQL Server 2017 software (10 CALS) Development team salaries/benefits Total Development Costs 4,700 9,200 2,600 331,000 4,700 9,200 2,600 331,000 347,500 Operational Costs Hardware (utilities/maintenance) Software (security/malware protection) Operational labor (tech support/ system maintenance) Total Operational Costs NA NA NA 2% 2% 2% 20,500 280 12,000 32,780 20,910 286 12,2401 33,436 21,328 291 12,485 34,104 21,755 297 12,734 34,786 22,190 303 12,989 35,482 106,683 1,457 62,448 170,588 Total Costs 347,500 32,780 33,4361 34,1041 34,786 35,482 518,088 Total Benefits - Total Costs 89,220 93,464 97,917 102,587 107,487 143,175 Cumulative Net Cash Flow 89,220 182,684 280,601 383,188 490,675 633,850 Return On Investment 27.6% Break-Even Point YEARS Create a Simple Cash Flow Method Cost-Benefit Analysis utilizing Microsoft Excel. Before you work on this activity, refer to the Cost-Benefit Analysis example in Figure 1-12 in the textbook. You must utilize this Cost-Benefit Analysis Template XLSX) a to create your Cost-Benefit Analysis. Calculate the missing values and present the data in the yellow-highlighted spreadsheet cells. Do not utilize a calculator to calculate the missing data. You must utilize an Excel formula to calculate the missing data. For example, if you desire to calculate the data in cell E4, you could use the following or other Excel formula: =D4+C4D4 Your instructor will select the cells to validate that you utilized formulas to calculate the missing data. For the Cost-Benefit Analysis: Submit data for a 5-year timeframe (i.e.: 2022-2026). Do NOT add any data in the cells B4, B5, B6, or B7. Be sure to present the aggregate Column I Total data for all applicable rows, except for Rows 29 and 31. Do NOT present any decimal places in your data except for the ROI and BEP data. Present the ROI data with one decimal place. Present the BEP data with two decimal places. Calculate and enter the missing data in the spreadsheet: Benefits Increased hours of data entry and order fulfillment Increased inventory balance and decreased stock-outs Increased inventory turnover ratio Increased warehouse organization Total Benefits Development Costs Dell Poweredge rack-mounted server Windows Surface Pro . Windows SQL Server 2017 software Development team salaries/benefits Total Development Costs Operational Costs Hardware Software Operational labor Total Operational Costs Total Costs Total Benefits - Total Costs Cumulative Net Cash Flow Return on Investment Break-Even Point