Purchase Solution

Dividends and Taxes, Stock Split and Stock Dividend

Not what you're looking for?

Ask Custom Question

Looking for assistance with the attached Excel spreadsheet utilizing Excel formulas to solve.

#1 Midnight Hour Inc gas declared a $5.10 per share dividend. Suppose capital gains are not taxed, but dividends are taxed at 15%. New IRS regulations require that taxes be withheld at the time the dividend is paid. Midnight Hour sells for $83. per share, and the stock is about to go ex-dividend. What do you think the ex-dividend will be?

#4a-d
Roll Corp currently has 240,000 shares of stock outstanding that sell for $86 per share. Assuming no market imperfections or tax effects exist, what will be the share price after:
a. RC has a five-for-three stock split?
b. RC has a 15% stock dividend?
c. RC has a 42.5 % stock dividend?
d. RC has a four-for-seven reverse stock split?

#7. The market value balance sheet for outbox manuf is shown here. Outbox has declared a 25% stock dividend. The stock goes ex dividend tomorrow. There are 30,000 share of stock outstanding. What will the ex-dividend price be?

Cash $145,000 Debt $127,000
Fixed Assets 598,000 Equity 616,000
total 743,000 743,000

#16. The sharpe co just paid a dividend of 1.60 per share of stock. Its target payout ratio is 40%. The company expects to have earnings per share of $6.20 one year from now.
a. if the adjustment rate is .3 as defined in the Lintner model, what is the dividend one year from now?

Purchase this Solution

Solution Summary

This solution provides the calculations needed, along with required formulas, in the attached Excel file.

Solution Preview

See the attached file.

CHAPTER 16: PROBLEM 1

Dividend $5.10
Dividend Tax 15%
Stock Price $83

Step 1: Calculate the After-Tax Dividend $4.34
Step 2: Ex-Dividend Price = $78.67

CHAPTER 16: PROBLEM 4 (a thru d)

# of shares of stock ...

Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce