Chapter 15: Distributions to Shareholders
Comprehensive/Spreadsheet Problem
417
Comprehensive/Spreadsheet Problem
Note to Instructors:
The solution to this problem is not provided to students at the back of their text. Instructors
can access the
Excel
file on the textbook’s website.
b. According to the residual dividend model, only $2 million is available for dividends.
Payout ratio = $2,000,000/$8,000,000 = 25%.
e. Capital budget = $10 million; Dividends = $3 million; NI = $8 million;
Capital structure = ?
f. Dividends = $3 million; Capital budget = $10 million; 60% equity, 40% debt; NI = $8
million.