FIN 550 Final Project Excel Workbook G Doc

Please see attached

Could you help me figure out the cost of equity and WACC for a company based on the information below? This is for a scenario where Kelvin, who’s just been appointed as the financial manager of MetaGreen, wants to apply his understanding of the cost of capital from his finance course to make sound financial decisions. Here’s the company information: Company Listing and Stock Info: Listed on the stock exchange Common stock market value: $2,080,000 Beta: 2 Market risk premium: 4% Risk-free rate: 3% Cost of Capital Components: Cost of debt: 7% Cost of preferred stock: 8% Tax rate: 34% Preferred Stock Details: 40,000 preferred shares outstanding Market price of preferred stock: $34 per share Bond Info: Bonds' total market value: $560,000 Could you show me how to use CAPM to find the cost of equity and then calculate the weighted average cost of capital (WACC) for the company?

I need help on this problem

Solve the following problem with complete solution.1. List five large publicly held companies that you know or whose products and services you enjoy. Then use the web to find the most recent closing stock price. Ignoring commissions, estimate the cost if you purchased ten shares of each of the five companies.

help  please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!

Scenario 2: The homepage for Coca-Cola Company can be found at coca-cola.com Links to an external site.. Locate the most recent annual report, which contains a balance sheet for the company. What is the book value of equity for Coca-Cola? The market value of a company is (# of shares of stock outstanding multiplied by the price per share). This information can be found at www.finance.yahoo.com Links to an external site., using the ticker symbol for Coca-Cola (KO). What is the market value of equity? Which number is more relevant to shareholders – the book value of equity or the market value of equity?

Refer to Figure and look at the listing for Hewlett Packard Enterprise.a. How many shares could you buy for $10,000?b. What would be your annual dividend income from those shares? c. What must be Hewlett Packard Enterprise's earnings per share? d. What was the firm's closing price on the day before the listing?

In question C there is a plot of of cost of debt, cost of equity and cost of capital. Can you show how r_a is calculated to be 0.18667? r_d = Cost of debt r_a = cost of capital r_e = Cost of equity

Consider the table shown below to answer the question posed in part a. Parts b and c are independent of the given table. Callaway Golf (ELY) Alaska Air Group (ALK) Yum! Brands (YUM) Caterpillar Tractor (CAT) Microsoft (MSFT) Number of Market Capitalization ($ millions) $ 2,572 Share (millions) X Stock Price = 94.2 X 27.30 123.7 301.7 543.3 7,560 X 50.70 X 103.07 186.66 242.12 == $ 101,412 = $ 1,830,427 xx $ 6,272 $ 31,096 S a. The price of Yum! Brands stock has risen to $180. What is the market value of the firm's equity if the number of outstanding shares does not change? Note: Enter your answer in dollars not in billions of dollars. b. The rating agency has revised Catalytic Concepts' bond rating to A (use Table 2.2). What interest rate, approximately, would the company now need to pay on its bonds? Note: Enter your answer as a percent rounded to 1 decimal place. c. A farmer and a meatpacker use the commodity markets to reduce their risk. One agrees to buy live cattle in the future…

Can you help me fill out the chart?

please help me analyze and asnwer the questions with formula so that i can learn and get ready for my exam :<

Thanks to who helped me earlier.  All my values were off because I started to answer this on January 1.  My values just needed to be shifted down into the perspective cells.  I am reposting the question to find out what I'm missing for December 31.  The cells are highlighted in yellow (See attached Image) that I need assistance with.  The scenario is in the image.

For this question, you will need to do the following• Download the file "Question 19 Spreadsheet" from Modules - Week 4 and save to your computer.• Complete the problem on your computer.• Once completed you will need to upload the document back to Canvas. Question 19 – Calculate Dividends per share – (1)Using the information below calculate the dividends that each cumulative preferred and common stock shareholder are entitled to each year. (2) For each of the three years, calculate the dividends per share . CD Corporation has outstanding the following classes of stock:o 20,000 shares - Cumulative Preferred 2% stock, $75 paro 70,000 shares – Common Stock $40 paro Dividends distributed were the followingo 2016 - $25,000o 2017 - $15,000o 2018 - $200,000

a corporation purchases 17000 shares of its own $20 par common stock for $25 per share, recording it at cost. What will be the effect on total stockholders' equity? A.) Increase by $425000 B.) Decrease by $425000 C.) Decrease by $85000 D.) Decrease by $340000 Please explain other options why these are incorrect dont use ai boats thank you

3. Below is a snapshot of some information about Microsoft Corporation from Yahoo! Finance on 10/16/2019.    B) What is the Microsoft stock price and the market cap?  C) Based on the information you collected in question (1), what is the total number of shares outstanding for Microsoft? (Hint: Market cap is the short name for “Market capitalization”. It represents the market value of a company’s total outstanding shares. It is equal to the stock price per share* total number of shares outstanding).  D)What is Microsoft dividend payment and dividend yield?

Please dont provide solution in image based solution thanks

Please show all equations and work as needed. Make the correct answer clear. If possible, please type work so it can be copied. Thank you.