Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $254,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 $254,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 3 years, and it 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 table provided.) Period 1 2 3 4 5 Cash Flow $ 48,000 52,000 76,400 94,700 126,800 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 outflows with a minus sign. Round your Payback period answer to 1 decimal place.) Year Cash inflow (outflow) 0 $ 1 (254,000) 48,000 52,000 76,400 94,700 2 Cumulative Net Cash Inflow (outflow) $ 0 x 48,000 X 100,000 176,400 271,100 397,900 lolololo 3 4 5 126,800 $ 143,900 2X and year: Calculate the payback period: Payback occurs between year: Calculate the portion of the year: Numerator for partial year Denominator for partial year $ 2 years 2 X 1 x $ Payback period = 2.8 X 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 Cash inflow (outflow) Table factor Present Value of Cash Flows Cumulative Present Value of Cash Flows $ 0X 0 $ 0.0000 x 1 0.9174 $ 44,035 X 44,035 43,768 2 0.8417$ 87,803 3 (254,000) 48,000 52,000 76,400 94,700 126,800 143,900 0.7722$ 4 0.7084 $ 0.6499 $ 58,996 67,085 82,407 146,799 213,884 296,291 5 $ Calculate the break even time: 4 and year: 0 x Break-even time occurs between year: Calculate the portion of the year: Numerator for partial year Denominator for partial year $ 0.5 years 40,115 82,407 $ Break-even time = 4.5 years
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