In: Finance
Please answer them correctly. Here are short 3 problems. Please solve all 3 problems. I would really appreciate your effort. Thanks.
1). Sandhill Communication Corp. is investing $8,373,700 in new technologies. The company’s management expects significant benefits in the first three years after installation (as can be seen by the following cash flows), and smaller constant benefits in each of the next four years.
Excel Template
(Note: This template includes the problem statement as it
appears in your textbook. The problem assigned to you here may have
different values. When using this template, copy the problem
statement from this screen for easy reference to the values you’ve
been given here, and be sure to update any values that may have
been pre-entered in the template based on the textbook version of
the problem.)
Year | ||||||||
1 | 2 | 3 | 4-7 | |||||
Cash Flows | $2,020,000 | $4,090,000 | $2,972,100 | $1,033,500 |
What is the discounted payback period for the project assuming a discount rate of 10 percent? (Round answer to 2 decimal places, e.g. 15.25. If discounted payback period exceeds life of the project, enter 0 for the answer.)
The discounted payback period for the project is _______years. |
2). Management of Cullumber, Inc., an aviation firm, is considering purchasing three aircraft for a total cost of $166,023,819. The company would lease the aircraft to an airline. Cash flows from the proposed leases are shown in the following table.
Years | Cash Flow | |
1–4 | $20,855,000 | |
5–7 | 75,950,000 | |
8–10 | 94,550,000 |
What is the IRR of this project? (Round answer to 2 decimal places, e.g. 15.25%.)
The IRR of this project is _______% |
3). Ivanhoe Specialties just purchased inventory-management
computer software at a cost of $1,449,950. Cost savings from the
investment over the next six years will produce the following cash
flow stream: $199,340, $304,240, $348,600, $524,250, $734,320, and
$484,740. What is the payback period on this investment?
(Round answer to 2 decimal places,e.g.
15.25.)
Payback Period is _______?
1. discounted payback = 4 + 218,293.949/641,722.19 = 4.34 years
Discount rate | 10.0000% | ||
Cash flows | Year | Discounted CF= cash flows/(1+rate)^year | Cumulative cash flow |
(8,373,700.000) | 0 | (8,373,700.00) | (8,373,700.00) |
2,020,000.000 | 1 | 1,836,363.64 | (6,537,336.36) |
4,090,000.000 | 2 | 3,380,165.29 | (3,157,171.074) |
2,972,100.000 | 3 | 2,232,982.72 | (924,188.355) |
1,033,500.000 | 4 | 705,894.41 | (218,293.949) |
1,033,500.000 | 5 | 641,722.19 | 423,428.24 |
1,033,500.000 | 6 | 583,383.81 | 1,006,812.046 |
1,033,500.000 | 7 | 530,348.92 | 1,537,160.96 |
2. IRR = 22.52%
Use IRR function in Excel
3. Payback = 4 + 73,520/734,320 = 4.10
Discount rate | 0.0000% | ||
Cash flows | Year | Discounted CF= cash flows/(1+rate)^year | Cumulative cash flow |
(1,449,950.000) | 0 | (1,449,950.00) | (1,449,950.00) |
199,340.000 | 1 | 199,340.00 | (1,250,610.00) |
304,240.000 | 2 | 304,240.00 | (946,370.000) |
348,600.000 | 3 | 348,600.00 | (597,770.000) |
524,250.000 | 4 | 524,250.00 | (73,520.000) |
734,320.000 | 5 | 734,320.00 | 660,800.00 |
484,740.000 | 6 | 484,740.00 | 1,145,540.000 |