Question

Sentinel Company is considering an investment in technology to improve its operations. The investment will require...

Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $258,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 3 years, and it requires a 8% 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,800
2 53,900
3 75,900
4 95,900
5 125,400


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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution 1:

Year Cash inflows (Outflow) Cumulative Cash inflow (Outflow)
0 -$258,000.00 -$258,000.00
1 $48,800.00 -$209,200.00
2 $53,900.00 -$155,300.00
3 $75,900.00 -$79,400.00
4 $95,900.00 $16,500.00
5 $125,400.00 $141,900.00
Calculate the portion of the year: 3
Numerator for partial year $79,400.00
Denominator for partial year $95,900.00
Payback period = 3.8 Years

Solution 2:

Chart values are based on:
i= 8%
Year Cash inflows (Outflow) Table Factor Present value of cash flows Cumulative Present value of Cash inflow (Outflow)
0 -$258,000.00 1.0000 -$258,000 -$258,000
1 $48,800.00 0.9259 $45,185 -$212,815
2 $53,900.00 0.8573 $46,211 -$166,604
3 $75,900.00 0.7938 $60,252 -$106,352
4 $95,900.00 0.7350 $70,489 -$35,863
5 $125,400.00 0.6806 $85,345 $49,482
Calculate the portion of the year: 4
Numerator for partial year $35,863.00
Denominator for partial year $85,345.00
Breakeven time = 4.42 Years

Solution 3:

Computation of NPV - Sentinel Company
Particulars Amount Period PV Factor Present Value
Cash Outflows:
Cost of Equipment $258,000.00 0 1 $258,000
Present Value of Cash Outflows (A) $258,000
Cash Inflows:
Annual cash inflows:
Year 1 $48,800.00 1 0.92593 $45,185
Year 2 $53,900.00 2 0.85734 $46,211
Year 3 $75,900.00 3 0.79383 $60,252
Year 4 $95,900.00 4 0.73503 $70,489
Year 5 $125,400.00 5 0.68058 $85,345
Present Value of Cash Inflows (B) $307,482
Net Present Value (B-A) $49,482
Add a comment
Know the answer?
Add Answer to:
Sentinel Company is considering an investment in technology to improve its operations. The investment will require...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Sentinel Company is considering an investment in technology to improve its operations. The investment will require...

    Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $257,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 3 years, and it requires a 8% 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,700 2 52,100 3 76,600 4 95,600...

  • Sentinel Company is considering an investment in technology to improve its operations. The investment will require...

    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 3 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 $ 48,800 52,700 76,700 94,900 126,300 Required: 1. Determine...

  • Sentinel Company is considering an investment in technology to improve its operations. The investment will require...

    Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $245,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 4 years, and it requires a 8% 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,500 53,200 75,800 96,000 126,800 Required: 1. Determine...

  • Problem 24-5A Payback period, break-even time, and net present value LO P1, A1 Sentinel Company is...

    Problem 24-5A Payback period, break-even time, and net present value LO P1, A1 Sentinel Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of $252,000 and will yield the following expected cash flows. Management requires investments to have a payback period of 3 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...

  • Park Co. is considering an investment that requires immediate payment of $30,500 and provides expected cash...

    Park Co. is considering an investment that requires immediate payment of $30,500 and provides expected cash inflows of $11,000 annually for four years. What is the investment's payback period? Payback Period Choose Numerator: Choose Denominator: Payback Period Payback period Required information [The following information applies to the questions displayed below.] Park Co. is considering an investment that requires immediate payment of $30,490 and provides expected cash inflows of $8,800 annually for four years. Park Co. requires a 5% return on...

  • Siemens AG invests €100,000,000 to build a manufacturing plant to build wind turbines. The company predicts...

    Siemens AG invests €100,000,000 to build a manufacturing plant to build wind turbines. The company predicts net cash flows of €20,000,000 per year for the next 5 years. Assume the company requires an 10% rate of return from its investments. (PV of $1. FV of $1, PVA of $1. and FVA of $1) (Use appropriate factor(s) from the tables provided.) (1) What is the payback period of this investment? Payback Period Ghoose Numerator: I Choose Denominator: - Payback Period Payback...

  • Siemens AG invests €96,000,000 to build a manufacturing plant to build wind turbines. The company predicts...

    Siemens AG invests €96,000,000 to build a manufacturing plant to build wind turbines. The company predicts net cash flows of €19,200,000 per year for the next 5 years. Assume the company requires an 12% rate of return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) (1) What is the payback period of this investment? Payback Period Choose Numerator: Choose Denominator: Payback Period Payback period (2)...

  • Park Co. is considering an investment that requires immediate payment of $32,500 and provides expected cash...

    Park Co. is considering an investment that requires immediate payment of $32,500 and provides expected cash inflows of $11,800 annually for four years. If Park Co. requires a 5% return on its investments. What is the net present value of this investment? (FV of $1, PV of $1, FVA of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.) 1-a Cash Flow Select Chart Amountx x PV FactorPresent Value Annual cash flow 0 Net present value 1-b...

  • LA Company is considering the purchase of an asset for $235,000. It is expected to produce...

    LA Company is considering the purchase of an asset for $235,000. It is expected to produce the following net cash flows. The cash flows occur evenly within each year. Assume that Beyer requires a 12% return on its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1). Year 1 Year 2 Year 3 Year 4 Year 5 Total Net cash flows $ 74,000 $ 52,000 $ 97,000 $ 143,000 $ 50,000 $ 416,000 a. Compute...

  • ! Required information [The following information applies to the questions displayed below.] A company is considering...

    ! Required information [The following information applies to the questions displayed below.] A company is considering investing in a new machine that requires a cash payment of $47,947 today. The machine will generate annual cash flows of $21,000 for the next three years. Assume the company uses an 8% discount rate. Compute the net present value of this investment. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Chart...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT