Question
Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $259,000 and will yield the
Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $259,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 3 years, and it 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 table provided.) Period Cash Flow $ 47,900 1 2 52,700 3 76,100 4 95,400 5 126,500 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. 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.) Cumulative Net Cash inflow Year Cash Inflow (outflow) (outflow) 0 $ (259,000) $ (259,000) 1 47,900 (211,100) 2 52,700 (158,400) 3 76,100 (82,300) 4 95,400 13,100 5 126,500 139,600 $ 139,600 Calculate the payback period: Payback occurs between year: 3 and year: 4 Calculate the portion of the year: Numerator for partial year Denominator for partial year Payback period = 0 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 0 1 2 3 4 5 Cash inflow (outflow) Table factor Present Value of Cash Flows Cumulative Present Value of Cash Flows (259,000) Break-even time = 0 0 0 0 Required 1 Required 2 Required 3 Determine the net present value for this investment. Net present value
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started