Question: Excel Case #2 - CSX Corporation Answer Schedule Format Market value of equity (market cap) 10 $ 50.28 billion currency, 2 decimal places Growth

Excel Case #2 - CSX Corporation Answer Schedule Format Market value of equity (market cap) 10 $ 50.28 billion currency, 2 decimal places Growth rate for equity Market price of stock (per share) 7.67% percentage, 2 decimal places $ 55.01 currency, 2 decimal places Annual dividend Beta of stock Risk free rate Market rate of return DGM cost of equity (stock) CAPM cost of equity (stock) Average cost of equity Market value of debt Average tax rate $ 0.78 currency, 2 decimal places 1.19 number, 2 decimal places 1.80% percentage, 2 decimal places 8.70% percentage, 2 decimal places 9.19%% percentage, 2 decimal places 10.01% 9.60% 10 $ 12.07 billion percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places 23.92% percentage, 2 decimal places Pre tax cost of debt (bonds) 3.83% After tax cost of debt (bonds) 2.91% Total market value of equity and debt $ 75.07 billion Weight for equity 0.8064 percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places number, 4 decimal places Weight for debt 0.1936 Weighted average cost of capital 8.30% number, 4 decimal places percentage, 2 decimal places Save your file with this name format: CSXexcelcase2_lastnamefirstinitial Example: CSXexcelcase2_smithj Subtotal Extra credit Capital Structure Debt percentage Equity percentage Total points percentage, 2 decimal places percentage, 2 decimal places

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

the following questions about the Modern Award that could be set up in the payroll system: Banking, Finance, and Insurance Award 2020 The Award can be downloaded from the Fair Work Ombudsman website....

Consider this situation: Your supervisor has requested from you a monthly report on your department's expenditures compared with the budget. What should you do? Check all that apply. Omit all the...

Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...

Explain why, in your opinion, allowing a physician to prescribe lethal medication under aid-in-dying laws is or is not euthanasia.

Cost of goods sold is shown as a distinct line item on the income statement. Where is information related to cost of goods sold shown on the statement of cash flows under both the direct and indirect...

Sketch the regions defined by the polar coordinate inequalities. -4 sin r 0

Identify those characteristics of single-case research that enhance experimental validity, reliability, generalizability, and social validity.

Meriden Company has a unit selling price of $520, variable costs per unit of $286, and fixed costs of $187,200. Compute the break-even point in units using (a) The mathematical equation and (b)...

Which of the following associates a port number with a host on a private network? VLSM CIDR NAT PAT

DATA TABLES Part I Constant Total Mass m2 MT Trial mdiff, (9) (g) m1+ m2 Acceleration m1-m2 (g) (m/s2) (g) 200 200 400 0 0 2 210 190 400 1. 1/4 20 3 220 180 400 2.691 40 4 230 170 400 4. 154 60 5 160...

As a supervisor , write the solution for the employee scenario below Withdrawing from Work: "Chloe is an excellent worker. When she is on, she's on. But when she's not, she can be irritable, erratic,...

Downtown Kingston Transport Centre/ Project management Instructions: Read the case study below, access the links provided and answer all questions. The downtown Kingston and Saint Andrew Centre were...

The J.R. Ryland Computer Company is considering a plant expansion to enable the company to begin production of a new computer product. The company's president must determine whether to make the...

The retail positioning matrix is an analytical tool thatA ) positions retail outlets in terms of the breadth of product line and value addedB ) identifies the best location for building or leasing a...

Since understanding forces in our environment that either help or hinder the acquisition of human capital, answer the following: What are the internal and external factors that influence an...

Make or Buy a Component Review Problem 12-23 on pages 572-573 of the text and answer questions 1 and 2. Based on the information given, should Silven Industries make or buy the tubes? Show...

Describe basic managerial approaches to implementing controls and how these are implemented.

12.35 Each observation in a random sample of 100 bicycle accidents resulting in death was classified according to the day of the week on which the accident occurred. Data consistent with information...

3. Carry out the experiment, and summarize the resulting data in a two-way table like the one shown: Taste Rating Treatment Not Very Good Acceptable Very Good Unaltered Color Altered Color

13.3 The paper Predicting Yolk Height, Yolk Width, Albumen Length, Eggshell Weight, Egg Shape Index, Eggshell Thickness, Egg Surface Area of Japanese Quails Using Various Egg Traits as Regressors...