Finance data case for chapter 17: payout policy

Don't use plagiarized sources. Get Your Assignment on
Finance data case for chapter 17: payout policy
Just from $13/Page
Order Now

Data Case for Chapter 17: Payout Policy
In your role as a consultant at a wealth management firm, you have been assigned a very powerful client who holds one million shares of Cisco Systems, Inc. purchased on February 28, 2003. In researching Cisco, you discovered that they are holding a large amount of cash. Additionally, your client is upset that the Cisco stock price has been somewhat stagnant as of late. The client is considering approaching the Board of Directors with a plan for half of the cash the firm has accumulated, but can’t decide whether a share repurchase or a special dividend would be best. You have been asked to determine which initiative would generate the greatest amount of money after taxes, assuming that with a share repurchase your client would keep the same proportion of ownership. Because both dividends and capital gains are taxed at the same rate (15%), your client has assumed that there is no difference between the repurchase and the dividend. To confirm, you need to “run the numbers” for each scenario.
1. Go to, enter the symbol for Cisco (CSCO), and click “Key Statistics.”
a. Record the current price and the number of shares outstanding.
b. Click on “Balance Sheet” under “Financials.” Copy and paste the balance sheet data into Excel.
2. Using one-half of the most recent cash and cash equivalents reported on the balance sheet (in thousands of dollars), compute the following:
a. The number of shares that would be repurchased given the current market price.
b. The dividend per share that could be paid given the total number of shares outstanding.
3. Go to to obtain the price at which your client purchased the stock on February 28, 2003.
a. Enter the symbol for Cisco and click “Get Quotes.”
b. Click “Historical Prices,” enter the date your client purchased the stock as the start date and the end date, and hit “Enter.” Record the adjusted closing price.
4. Compute the total cash that would be received by your client under the repurchase and the dividend both before taxes and after taxes.
5. The calculation in Step 4 reflects your client’s immediate cash flow and tax liability, but it does not consider the final payoff for the client after any shares not sold in a repurchase are liquidated. To incorporate this feature, you first decide to see what happens if the client sells all remaining shares of stock immediately after the dividend or the repurchase. Assume that the stock price will fall by the amount of the dividend if a dividend is paid. What are the client’s total after-tax cash flows (considering both the payout and the capital gain) under the repurchase of the dividend in this case?
6. Under which program would your client be better off before taxes? Which program is better after taxes, assuming the remaining shares are sold immediately after the dividend is paid?
7. Because your client is unlikely to sell all 1 million shares today, at the time of dividend/repurchase, you decide to consider two longer holding periods: Assume that under both plans the client sells all remaining shares of stock 5 years later, or the client sells 10 years later. Assume that the stock will return 10% per year going forward. Also
assume that Cisco will pay no other dividends over the next 10 years.
a. What would the stock price be after 5 years or 10 years if a dividend is paid now?
b. What would the stock price be after 5 years or 10 years if Cisco repurchases shares now?
c. Calculate the total after-tax cash flows at both points in time (when the dividend payment or the share repurchase takes place, and when the rest of the shares are sold) for your client if the remaining shares are sold in 5 years under both initiatives. Compute the difference between the cash flows under both initiatives at each point in time. Repeat assuming the shares are sold in 10 years.

8. Repeat Question 7 assuming the stock will return 20% per year going forward. What do you notice about the difference in the cash flows under the two initiatives when the return is 20% and 10%?
9. Calculate the NPV of the difference in the cash flows under both holding period assumptions for a range of discount rates. Based on your answer to Question 8, what is the correct discount rate to use?

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Excellent job
Customer 456821, October 5th, 2022
English 101
Good response. Next time, properly capitalize headings in the requested style.
Customer 460641, March 30th, 2022
Healthcare & Medical
Excellent work.
Customer 452441, May 16th, 2022
Business and administrative studies
Good job.
Customer 459305, April 6th, 2022
Short and precise as I wanted. Thank you!
Customer 462359, October 14th, 2022
Religious studies
This was well done thank you
Customer 452763, December 10th, 2021
Business and administrative studies
Commendable. Review credentials alignment in APA cover page. Student paper
Customer 453187, March 31st, 2022
Business and administrative studies
I had to make some updates but overall the paper was great. Will need to use this writer again for the next part.
Customer 453721, October 29th, 2022
Thank you for your promptness
Customer 453627, January 23rd, 2020
Thank You
Customer 462669, March 11th, 2022
Computer science
Customer 462387, April 4th, 2022
Art (Fine arts, Performing arts)
Always follow instructions, especially on style.
Customer 460547, March 29th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat