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 $253,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 $253,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 2 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 Cash Flow $ 48,800 52,700 76,200 95,400 125,200 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.) Year Cash inflow (outflow) Cumulative Net Cash Inflow (outflow) (253,000) 204,200 X 0 (253,000) 48,800 52,700 76,200 95,400 125,200 5 Calculate the portion of the year: Numerator for partial year Denominator for partial year 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 Cash inflow (outflow) Table factor Present Value of Cash Flows (253,000) 44,769 (253,000) 48,800 52,700 76,200 95,400 125,200 145,300 1.0000 0.9174 0.8417 0.7722 0.7084 0.6499 $ $ $ $ $ $ Cumulative Present Value of Cash Flows 253,000 208,229 X 252,587 311,429 379,010 460,377 44,358 58,842 67,581 81,367 5 40 and year: Calculate the break even time: Break-even time occurs between year: Calculate the portion of the year: Numerator for partial year Denominator for partial year O 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