Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 firmStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started