AutoSave Off File Home Insert Formulas Page Layout Data Review View Spreadsheet02Detailedtemplate Protected... Saved to this PC Help F26 Search PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing IL F G H B C D E Please complete the highlighed cells and write the descriptive statement. 1 2 3 4 End of year Period Cash Flow Savings PV of Cash Savings Interest Rate 7% 5 6 2020 1 $110,000 2021 2 $120,000 $102,804 $104,813 2022 3 $130,000 G 2023 4 $150,000 10 2024 5 $160,000 11 2025 6 $150,000 12 2026 7 $90,000 13 2027 8 $90,000 14 2028 9 $90,000 15 2029 10 $90,000 16 2030 11 $90,000 17 18 Total $1,270,000 (a) 19 20 21 22 Should we accept this project? 23 24 Note: The project should be undertaken if the present cash flow savings are greater than the required $860,000. PV Sheet2 | Sheet3 Ready Type here to search + File Home Insert Page Layout L Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing F26 A B C D E F G H 10 2024 5 $160,000 11 2025 6 $150,000 12 2026 7 $90,000 13 2027 8 $90,000 14 2028 9 $90,000 15 2029 10 $90,000 16 2030 11 $90,000 17 18 Total $1,270,000 (a) 19 20 21 22 Should we accept this project? 23 24 Note: The project should be undertaken if the present cash flow savings are greater than the required $860,000. 25 The project should not be undertaken if the present cash flow savings are less than the required $860,000. 26 27 28 29 30 31 32 33 PV Sheet2 | Sheet3 Ready Lenov Type here to search Et