Question: Please show each working properly with an explanation for each step so that I understand 10. For parts a. and b., use the Selected Financial

 Please show each working properly with an explanation for each step

Please show each working properly with an explanation for each step so that I understand

10. For parts a. and b., use the Selected Financial Data provided below. ($000s except per share data) Total Assets $6,200 Total Debt 4,000 Revenues $10,000 Cost of Goods (6,000) Operating Expenses (1,600) Depreciation (400) Interest (300) Tax Rate 40% Net Income $1,020 Earnings per share $1.02 Dividends/share $0.80 Shares Outstanding 1 million Price/Share $29 Cash $1,000 Acts Receivable 1,370 Inventory 492 Accts Payable 480 a. What is the dividend payout rate? = Div per share / earnings per share = $.80/ 1.02 = 0.78 or 78% b. Using the percent of sales method, calculate the net new funding needed (or surplus if no new funds are needed) at 6% growth rate. You can assume depreciation grows with sales and assets. Dividend Payout rate is unchanged and Interest Expense stays the same. REV 10,600 Assets Liabilities CGS 6,360 Total Assets 6,572 Accts Payable 509 OPEX 1696 Total Debt 4,000 DEP 424 Total Liabilities = 4,509 EBIT 2,120 Equity Int 300 previous + Ret. Earnings = 1,960 1,820 Tax 728 Net Inc. 1,092 Net Income dividends ($852) = retained earnings = $240 (add to Retained Earnings account) External Financing Need = pro-forma Assets pro forma Liabilities and Equity = 6572 (4509 + 1960) = $103,000 needs to be raised from outside the firm. 10. For parts a. and b., use the Selected Financial Data provided below. ($000s except per share data) Total Assets $6,200 Total Debt 4,000 Revenues $10,000 Cost of Goods (6,000) Operating Expenses (1,600) Depreciation (400) Interest (300) Tax Rate 40% Net Income $1,020 Earnings per share $1.02 Dividends/share $0.80 Shares Outstanding 1 million Price/Share $29 Cash $1,000 Acts Receivable 1,370 Inventory 492 Accts Payable 480 a. What is the dividend payout rate? = Div per share / earnings per share = $.80/ 1.02 = 0.78 or 78% b. Using the percent of sales method, calculate the net new funding needed (or surplus if no new funds are needed) at 6% growth rate. You can assume depreciation grows with sales and assets. Dividend Payout rate is unchanged and Interest Expense stays the same. REV 10,600 Assets Liabilities CGS 6,360 Total Assets 6,572 Accts Payable 509 OPEX 1696 Total Debt 4,000 DEP 424 Total Liabilities = 4,509 EBIT 2,120 Equity Int 300 previous + Ret. Earnings = 1,960 1,820 Tax 728 Net Inc. 1,092 Net Income dividends ($852) = retained earnings = $240 (add to Retained Earnings account) External Financing Need = pro-forma Assets pro forma Liabilities and Equity = 6572 (4509 + 1960) = $103,000 needs to be raised from outside the firm

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!