Cranmer Industries has identified several investment opportunities that will become available over the next three years and would like you to evaluate these projects. They have asked that you use the NOV and IRE methods to determine if these independent projects are acceptable. Each of these investments will occur one year apart and the cash flows will start one year after the investment is made.
|Length of Project||Cost and Date when Cost is incurred|
|A||$ 2,300.00||5 years||$ 12,000.00 @t=1|
|B||$ 3,000.00||5 years||$ 17,000.00 @t=2|
|C||$ 2,800.00||5 years||$ 13,000.00 @t=3|
|D||$ 2,100.00||5 years||$ 15,000.00 @t=4|
Cranmer currently has 2,000,000 shares outstanding and pays a dividend of $2 per share.
With a high degree of certainty, Cranmer has projected their income for the next four years as follows, which includes the annual cash flows from the investments selected above:
|Year||Income After Taxes|
- What is the NOV for each project at the time the investment would be made? Explain your findings.
- What is the IRE for each project at the time the investment would be made? Explain your findings
- Which investments should be selected? Justify your conclusions.
- What will the dividends per share and the external financing required, if the current dividend per share is maintained? Justify your conclusions.
- What will the dividends per share and the external financing required, if the dividend per share payout ratio of 50% is maintained? Explain your answers.
- If the dividend policy is considered a residual decision, what will be the dividends per share and external financing requirement in each year? Explain your answers.
- Under which policy will external financing be minimized? Justify your conclusions.
Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.