Please answer them correctly. Here are short 3 problems. Pleasesolve all 3 problems. I would really appreciate your effort.Thanks.
1). Sandhill Communication Corp. is investing $8,373,700 in newtechnologies. The company’s management expects significant benefitsin the first three years after installation (as can be seen by thefollowing cash flows), and smaller constant benefits in each of thenext four years.
Excel Template
(Note: This template includes the problem statement as itappears in your textbook. The problem assigned to you here may havedifferent values. When using this template, copy the problemstatement from this screen for easy reference to the values you’vebeen given here, and be sure to update any values that may havebeen pre-entered in the template based on the textbook version ofthe problem.)
| Year |
| | 1 | | 2 | | 3 | | 4-7 |
CashFlows | | $2,020,000 | | $4,090,000 | | $2,972,100 | | $1,033,500 |
What is the discounted payback period for the project assuming adiscount rate of 10 percent? (Round answer to 2 decimalplaces, e.g. 15.25. If discounted payback period exceeds life ofthe project, enter 0 for the answer.)
The discounted payback periodfor the project is _______years. |
2). Management of Cullumber, Inc., an aviation firm, isconsidering 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 followingtable.
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 2decimal places, e.g. 15.25%.)
The IRR of this project is_______% |
3). Ivanhoe Specialties just purchased inventory-managementcomputer software at a cost of $1,449,950. Cost savings from theinvestment over the next six years will produce the following cashflow 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 _______?