Chapter 14: Distributions to Shareholders
Comprehensive/Spreadsheet Problem
411
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.
14–10 a. Capital budget = $10,000,000; Capital structure = 60% equity, 40% debt; Common shares
outstanding = 1,000,000.
b. According to the residual dividend model, only $2 million is available for dividends.
NI – Retained earnings needed for capital projects = Residual dividend
c. Retained earnings available = $8,000,000 – $3.00(1,000,000)
d. No. If the company maintains its $3.00 DPS, only $5 million of retained earnings will be
available for capital projects. However, if the firm is to maintain its current capital structure
e. Capital budget = $10 million; Dividends = $3 million; NI = $8 million;
Capital structure = ?
RE available = $8,000,000 – $3,000,000
f. Dividends = $3 million; Capital budget = $10 million; 60% equity, 40% debt; NI = $8
million.
Equity needed = $10,000,000(0.6) = $6,000,000.