Question: 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.

Please break down in excel sheet and check answer for me. Please

help me make sure the answer is correct. Here is the question

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!