i need help with required 2 & 3
Salsa Company is considering an investment in technology to improve its operations. The investment costs $255,000 and will yield the following net cash flows, Management requires a 9% 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 Year Flow $ 48,900 52,300 3 75,500 95, 100 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 Required 1 Required 2 Required 3 Determine the payback period for this investment. (Enter cash outllows with a minus sign. Round your Payback period answer to 1 decimal place.) Cumulative Net Cash Inflow Year Cash Inflow (outflow) (outflow) Initial investment $ (255,000) $ (255,000) Year 1 48,000 (206,100) Year 2 52,300 (153,800) Year 3 75,500 (78.300) Year 4 96,100 16,800 Year 5 125.000 141,800 $ 141,800 Calculate the payback period Payback occurs between year 3 and year Calculate the portion of the year. Numerator for partial your 25 78.300 0.8 years Denominator for partial your $ 95.100 Payback period 3.8 years Required 2 > 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 Cumulative Cash inflow Present Value of Table factor (outflow) Cash Flows Present Value of Cash Flows Initial investment $ (255,000) 1.0000 $ (255,000) s (255,000) Year 1 48,900 0.91741 $ 44,861 (210.159) Year 2 52,300 0.84171 $ 44,021 (168,138) Year 3 75,500 0.7722 $ 58,301 (107,837) Year 4 95,100 0.7084 $ 87,369 (40,468) Year 5 125,000 0.6500 $ 81,250 40.782 $ 141.800 Calculate the break even time: Break-even time occurs between year: and year 5 Calculate the portion of the year Numerator for partial year Denominator for partial year $ 81,250 Break-even time 4.5 years