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