Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions