Excel template - Saved File Home Insert Data Review View Help Tell me what you want to do D F G Residual dividend model Each project's investment cost Cost of capital, - Cost of capitalu IRR - IRRE $6,000,000 3.00% 1.00% Project H (High Risk) M (Medium Risk) L (Low Risk) Cost of Capital 16.00% 13.00% 8.00% Internal Rate of Retum 22.00% 10.00% 9.00% 3 Firm's Capital Structure Weights: % debt in capital structure, w % common equity in capital structure, w 45.00% 55.00% 5 Net income $10,076,000 Calculation of Capital Budget: Include in Budget (Y/N) Investment Cost Project H (High Risk) M (Medium Risk) L (Low Risk) Total Capital Budget NA NA #NA #N/A #N/A #N/A ANA Sheet1 aved to Cengage x Excel template - Saved File Home Insert Data Review View Help Tell me what you want to do Calculation of Capital Budget Financed with Common Equity: Common equity required Formulas #N/A Calculation of Common Dividends Using Residual Model: Common dividends #NA Calculation of Dividend Payout Ratio: Dividend payout ratio #N/A Sheet1 a ed to Cengage Excel template - Saved File Home Insert Data Review View Help Tell me what you want to do D F G Residual dividend model Each project's investment cost Cost of capital, - Cost of capitalu IRR - IRRE $6,000,000 3.00% 1.00% Project H (High Risk) M (Medium Risk) L (Low Risk) Cost of Capital 16.00% 13.00% 8.00% Internal Rate of Retum 22.00% 10.00% 9.00% 3 Firm's Capital Structure Weights: % debt in capital structure, w % common equity in capital structure, w 45.00% 55.00% 5 Net income $10,076,000 Calculation of Capital Budget: Include in Budget (Y/N) Investment Cost Project H (High Risk) M (Medium Risk) L (Low Risk) Total Capital Budget NA NA #NA #N/A #N/A #N/A ANA Sheet1 aved to Cengage x Excel template - Saved File Home Insert Data Review View Help Tell me what you want to do Calculation of Capital Budget Financed with Common Equity: Common equity required Formulas #N/A Calculation of Common Dividends Using Residual Model: Common dividends #NA Calculation of Dividend Payout Ratio: Dividend payout ratio #N/A Sheet1 a ed to Cengage