#11. Need help fixing

Salsa Company is considering an investment in technology to improve its operations. The investment costs $250,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.) Year 1 2 3 4 5 Net Cash Flow $ 47,000 52,000 75,000 94,000 125,000 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. X Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the payback period for this investment. (Enter cash outflows with a minus sign. Round your Payback Period answer to 1 decimal place.) Year Initial investment CA $ Year 1 Cumulative Cash inflow Net Cash (outflow) Inflow (outflow) (250,000) $ (250,000) 47,000 (203,000) 52,000 |(151,000) 75,000 UN (76,000) 94,000 18,000 125,000 143,000 Year 2 Year 3 Year 4 Year 5 $ 143,000 Calculate the payback period: Payback occurs between year: 3 and year: 3 and year: 4 Calculate the payback period: Payback occurs between year: Calculate the portion of the year: Numerator for partial year Denominator for partial year $ 76.000 0.8 years $ 94,000 Payback period = 3.8 years Required 1 Required 2 Required 3 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.) Year Qash inflow (outflow) Table factor Present Value of Cash Flows Initial investment $ (250,000) 1.0000 $ Cumulative Present Value of Cash Flows $ (250,000) (207,272) (164,299) (107,951) (43,749) Year 1 47.000 0.9091 $ Year 2 52,000 0.8264 (250,000) 42,728 42,973 56,348 64,202 77,613 $ Year 3 75,000 0.7513 Year 4 94,000 0.6830 Year 5 125.000 0.6209 33,864 $ 143,000 alculate the break even time: 4 > and year: 5 reak-even time occurs between year: Calculate the portion of the year: Numerator for partial year Denominator for partial year 43.750 0.6 years A A 77.612 Break-even time = 4 x years X Answer is complete but not entirely corre Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the net present value for this investment. Net present value $ 776,112 X