Calculate financial ratios

Reference no: EM131453558

Question: 1. Hello, would you be able to answer the questions below in regards to the company called Wabco?

2. https://financials.morningstar.com/ratios/r.html?t=WBC

3. Choose a company whose financials you can acquire online or in print.

4. Spread 3 years of financials for the company using Excel. Do actual fiscal year-ends, not estimated.

5. In all calculations, use real numbers from the company's financials, not reported ratios provided by online and other sources. Do all calculations for the most recent 3 years available.

6. Collect stock data-current stock price, shares outstanding.

7. Calculate financial ratios and compare to industry average. Do the same ratios required for Case 1. What can you conclude from the ratios?

8. Any warning signs? Anything that stands out?

9. Perform common size analysis. What does this analysis tell you about your company? Are any trends apparent?

10. Use the extended DuPont equation to provide a summary and overview of your firm's financial condition

11. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method.

12. Estimate the company's WACC. Be sure your selected firm has long term debt.

13. What is your summary of this company's financial condition?

Reference no: EM131453558

Questions Cloud

Describe the guidelines for writing reports : When writing a report what is the most important aspect of formatting? Describe the guidelines for writing reports

Discuss about the case : focused ear exam : When you ask him how he's been spending his summer, James responds that he's been spending a lot of time in the pool.

Report of marketing fundamentals about grilled.com : Prepare a report of Marketing fundamentals - In these we got three sections each should be of 800 words or above and 4th section conclusion can be less words.

Using the profitability index when evaluating projects : Gold Mining, Inc. is using the profitability index (PI) when evaluating projects.

Calculate financial ratios : Spread 3 years of financials for the company using Excel. Do actual fiscal year-ends, not estimated.

Show final tables with data after normalization : The table shown below lists dentist-patient appointment data. A patient is given an appointment at a specific time and date with a dentist

What is the effective annual percentage rate : You put your money in a passbook savings account in which the interest rate is 4.2% per year compounded daily. What is the effective annual percentage rate?

Artistic engineer or an articulate organizer : By using your two to three word statements that are your tagline and brand, create a 30-second elevator speech (pitch) where you will sell your most valuable.

How does telemedicine differ from the traditional medicine : How does telemedicine differ from the traditional medicine?What are other legal or ethical issues involved in telemedicine?

User Account

All Pages