Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please break down in excel sheet and check answer for me. Please help me make sure the answer is correct. Here is the question below.
Please break down in excel sheet and check answer for me. Please help me make sure the answer is correct. Here is the question below.
Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $249,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 2 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 1 $48,200 52,000 76,100 94,900 125,200 2 4 Required 1. Determine the payback period for this investment. (Enter cash outflows with a minus sign. Round your Payback Period answer to 1 decimal place.) Cash inflow (outflow) Cumulative Net Cash Inflow (outflow) Year $(249,000) $ 48,200 42,000 76,100 94,900 125,000 137,200 (249,000) (200,800) (158,800) (82,700) 12,200 137,200 4 Calculate the payback period Payback occurs between year: Calculate the portion of the year: and year: 82 700 94,900 Numerator for partial year 0.9 years Denominator for partial year $ Payback period 3.9 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