[SOLVED] answer the following questions in excel

I need support with this Business question so I can learn better.

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
[SOLVED] answer the following questions in excel
Get a 15% Discount on this Paper
Order Now
  1. Go to Yahoo Finance, and search for MSFT (MSFT). Click on the historical Data tab, and pull the last 5 years of dividend (not stock price) data into excel. Calculate the yearly dividend payout using the trailing 12-months (does not have to correspond to calendar year).
    1. What is the average the growth rate of the ANNUAL dividend from the previous 4 years?
    2. If you use the dividend growth model, what should the price of the stock be if investors require an 18% return (using part a as your growth rate)? Or 15% return?Or 12% return?
    3. What is the required rate that yields a price closest to the current trading price? (Please write the down the current price that MSFT is trading at when you solve this problem).
    4. If you use the most recent annual growth rate (not the average calculated in part a), what is the required rate that yields a price closest to the current trading price?
    5. If MSFT decides to not increase their dividend anymore, and keep it at $5 a year indefinitely, what is the price of the stock if investors require an 18% return?
  1. Go to Yahoo Finance, and search for Microsoft (MSFT). Click on historical data tab, and pull the last 5 years of monthly stock return data into excel.
    1. What was the average (arithmetic) return for the past 5 years?
    2. What is the geometric return for the past 5 years?
    3. What is the variance and standard deviation of the monthly returns?
    4. What is the expected range of monthly returns we can expect to receive 68% of the time?
    5. What is the expected range of monthly returns we can expect to receive 95% of the time?
    6. What is the expected range of monthly returns we can expect to receive 99% of the time?
  1. GE has 20,000 bonds outstanding with a 7% coupon rate, paid semiannual. There are 20 years left to maturity and have a market price of 990.00 (face value 1000). The company also has 700,000 shares outstanding and currently sell at $32 a share. GE has a beta of 1.09. You expect the market risk premium to be 9% and the risk free rate is currently 2%. Ge also has 200,000 shares of preferred stock which pays an annual dividend of $5. The preferred stock is currently trading at $29 a share. Assuming a 21% tax rate, what is the WACC?

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*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.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment 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.
s
Get personalized services with MyCoursebay
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Other
AWESOME
Customer 452813, July 5th, 2022
Web programming
outstanding!
Customer 452715, September 16th, 2022
Medicine
Thank you for the great services
Customer 452635, April 24th, 2022
Nursing
Great work. thank you again!
Customer 452707, August 7th, 2022
Nursing
Great work! Thank you so much.
Customer 452707, July 15th, 2022
Nursing
Always on time and a life saver for sure!!!!!!!!!!!!
Customer 452453, October 22nd, 2021
Nursing
Paid for the paper to be completed 5 days prior than the day I received the paper.
Customer 452693, July 13th, 2022
Other
GOOD
Customer 452813, July 5th, 2022
Nursing
Thank you!
Customer 452707, October 16th, 2022
Technology
Great job on the paper!
Customer 452885, December 14th, 2022
Criminal Justice
Thank you for the great paper. I like how the writer structured it.
Customer 452627, October 2nd, 2021
Business and administrative studies
Thank you very much for your help.
Customer 452861, September 16th, 2022
OUR GIFT TO YOU
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

Get top-notch homework help now. 20% off first 10 orders!

NEW

Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now