Answered step by step
Verified Expert Solution
Question
1 Approved Answer
EXCEL SPREADSHEET DATA BELOW: Dividends Dollars in Thousands: Tax rate 40.00% Operating cost % 71.00% Common shares outstanding 340,000 Common stock price $39.00 Dividend payout
EXCEL SPREADSHEET DATA BELOW:
Dividends | |||
Dollars in Thousands: | |||
Tax rate | 40.00% | ||
Operating cost % | 71.00% | ||
Common shares outstanding | 340,000 | ||
Common stock price | $39.00 | ||
Dividend payout ratio | 60.00% | ||
Sales | $11,800 | ||
Operating costs | 8,378 | ||
EBIT | $3,422 | ||
Interest | 297 | ||
EBT | $3,125 | ||
Taxes | 1,250 | ||
Net income | $1,875 | ||
Calculation of current per share dividend: | Formulas | ||
DPS, current year | #N/A | ||
Current dividend yield calculation: | |||
Current dividend yield | #N/A | ||
Calculation of last year's per share dividend: | |||
Last year's net income | $1,600 | ||
DPS last year | #N/A | ||
Calculation of dividend payout ratio based on last year's per share dividend: | |||
Dividend payout ratio on current net income | #N/A |
Step 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