Please complete the highlighed cells and write the descriptive statement. Period Cash Flow Savings PV of...

Transcribed Image Text:

Please complete the highlighed cells and write the descriptive statement. Period Cash Flow Savings PV of Cash Savings End of year Interest Rate 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total 1 2 3 4 5 6 7 8 9 10 11 $110,000 $120,000 $130,000 $150,000 $160,000 $150,000 $90,000 $90,000 $90,000 $90,000 $90,000 $1,270,000 $102,804 $104,813 7% Should we accept this project? Note: The project should be undertaken if the present cash flow savings are greater than the required $860,000. The project should not be undertaken if the present cash flow savings are less than the required $860,000. Please complete the highlighed cells and write the descriptive statement. Period Cash Flow Savings PV of Cash Savings End of year Interest Rate 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total 1 2 3 4 5 6 7 8 9 10 11 $110,000 $120,000 $130,000 $150,000 $160,000 $150,000 $90,000 $90,000 $90,000 $90,000 $90,000 $1,270,000 $102,804 $104,813 7% Should we accept this project? Note: The project should be undertaken if the present cash flow savings are greater than the required $860,000. The project should not be undertaken if the present cash flow savings are less than the required $860,000. Please complete the highlighed cells and write the descriptive statement. Period Cash Flow Savings PV of Cash Savings End of year Interest Rate 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total 1 2 3 4 5 6 7 8 9 10 11 $110,000 $120,000 $130,000 $150,000 $160,000 $150,000 $90,000 $90,000 $90,000 $90,000 $90,000 $1,270,000 $102,804 $104,813 7% Should we accept this project? Note: The project should be undertaken if the present cash flow savings are greater than the required $860,000. The project should not be undertaken if the present cash flow savings are less than the required $860,000. Please complete the highlighed cells and write the descriptive statement. Period Cash Flow Savings PV of Cash Savings End of year Interest Rate 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total 1 2 3 4 5 6 7 8 9 10 11 $110,000 $120,000 $130,000 $150,000 $160,000 $150,000 $90,000 $90,000 $90,000 $90,000 $90,000 $1,270,000 $102,804 $104,813 7% Should we accept this project? Note: The project should be undertaken if the present cash flow savings are greater than the required $860,000. The project should not be undertaken if the present cash flow savings are less than the required $860,000.

Answer rating: 100% (QA)

The image shows a table with the end of year period cash flow savings and the present value PV of th... View the full answer