Pierre Imports has a capital budget of $20 million.It wants to maintain a capital structure of 45 percent debt and 55 percent equity.This year it expects net income of $8 million. The company has 30 million authorized shares, and 10 million are outstanding.Last year the company paid a dividend of $0.30 per share.

In Excel - 

a. How much equity is required?

b. How much external equity does the company need to raise if it follows a residual dividend policy?

c. How much external equity will the company require if it pays the same dividend as last year?

d. What are 3 advantages following a residual dividend policy?

e. What are 3 disadvantages of following a residual dividend policy?

All must be done in Excel