Need help fixing project q

12

Salsa Company is considering an investment in technology to improve its operations. The investment costs $252,000 and will yield the following net cash flows. Management requires a 8% 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 Net cash flow $ 48,800 52,600 76,400 94,500 126, 100 min 3 4 5 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. 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 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 Cash inflow (outflow) Cumulative Net Cash Inflow (outflow) (252,000) Initial investment $ $ Year 1 (203 200) Year 2 (150,600) Year 3 (252,000) 48,800 52,600 76,400 94,500 126,100 146,400 (74 200) Year 4 20,300 Year 5 146.400 $ Calculate the payback period: Payback occurs between year: 0 and year! 4 Calculate the portion of the year. Numerator for partial year Denominator for partial year $ 0.8 years 74,200 94,500 Payback period = 3.8 years Required 1 ENGE 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 Cash inflow (outflow) Table factor Present Value of Cash Flows Cumulative Present Value of Cash Flows $ (252,000) Initial investment IS 1.0000 $ (252,000) 48,800 Year 1 0.9259 $ Year 2 52,600 0.8573 $ (252,000) 45,184 45,094 60,646 69,458 Year 3 76,400 >>> SO 0.7938 $ (206,816) (161,722) (101,076) (31,618) 54,206 Year 4 0.7350 94,500 126,100 Year 5 0_6806 $ 85,824 S 146 400 Calculate the break even time: 4 and year 5 Break-even time occurs between year. Calculate the portion of the year. Numerator for partial year Denominator for partial year $ 31,618 $ (126,100) X Break-even time = 4.3 years