Salsa Company is considering an investment in technology to improve its operations. The investment costs $240,000...

Transcribed Image Text:

Salsa Company is considering an investment in technology to improve its operations. The investment costs $240,000 and will yield the following net cash flows. Management requires a 10% return on investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Net cash Flow Year 1 $ 47,900 2 53,800 3 75,100 4 94,800 5 125,600 Required: 1. Determine the payback period for this investment. 2. Determine the break-even time for this investment. 3. Determine the net present value for this investment. 4. Should management invest in this project based on net present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Determine the payback period for this investment. (Enter cash outflows with a minus sign. Round your Payback Period answer to 1 decimal place.) Cumulative Net Cash Year Net Cash Flows Flows Initial investment $ (240,000) Year 1 47,900 Year 2 53,800 Year 3 75,100 Year 4 94,800 Year 5 125,600 Payback period = < Required 1 Required 2 Required 1 Required 2 Required 3 Required 4 Determine the break-even time for this investment. (Enter cash outflows with a minus sign. Round your break-even time answer to 1 decimal place.) Present Value of Present Value of Net Year Net Cash Flows 1 at 10% Cash Flows per Year Cumulative Present Value of Net Cash Flows Initial investment $ (240,000) Year 1 Year 2 Year 3 Year 4 Year 5 Break-even time = years < Required 1 Required 3 > 0 0 0 Determine the net present value for this investment. Net present value Required 1 Required 2 Required 3 Required 4 Should management invest in this project based on net present value? Should management invest in this project based on net present value? < Required 3 Invest in the project as it has a positive net present value. Don't invest in the project as it has a negative net present value. Salsa Company is considering an investment in technology to improve its operations. The investment costs $240,000 and will yield the following net cash flows. Management requires a 10% return on investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Net cash Flow Year 1 $ 47,900 2 53,800 3 75,100 4 94,800 5 125,600 Required: 1. Determine the payback period for this investment. 2. Determine the break-even time for this investment. 3. Determine the net present value for this investment. 4. Should management invest in this project based on net present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Determine the payback period for this investment. (Enter cash outflows with a minus sign. Round your Payback Period answer to 1 decimal place.) Cumulative Net Cash Year Net Cash Flows Flows Initial investment $ (240,000) Year 1 47,900 Year 2 53,800 Year 3 75,100 Year 4 94,800 Year 5 125,600 Payback period = < Required 1 Required 2 Required 1 Required 2 Required 3 Required 4 Determine the break-even time for this investment. (Enter cash outflows with a minus sign. Round your break-even time answer to 1 decimal place.) Present Value of Present Value of Net Year Net Cash Flows 1 at 10% Cash Flows per Year Cumulative Present Value of Net Cash Flows Initial investment $ (240,000) Year 1 Year 2 Year 3 Year 4 Year 5 Break-even time = years < Required 1 Required 3 > 0 0 0 Determine the net present value for this investment. Net present value Required 1 Required 2 Required 3 Required 4 Should management invest in this project based on net present value? Should management invest in this project based on net present value? < Required 3 Invest in the project as it has a positive net present value. Don't invest in the project as it has a negative net present value.