Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This project is individual & needs to be submitted by the due date. Please upload your submissions in both Excel & Word.This assignment is an
This project is individual & needs to be submitted by the due date. Please upload your submissions in both Excel & Word.This assignment is an extension to the one you did in the Accounting for Managers course. In the accounting assignment, we analyzed the accounting choices management made while recognizing revenues and expenses over the study period. In this assignment, we are examining the same companies to assess their financing, investing, and operating decisions. You are required to estimate the cost of financing WACC rate of return on equity & rate of return on invested capital and decide whether management have added value to the shareholders over the study period or not. If you have questions, please let me know. Instructionthe following company & perform the analysis listed below:Exxon Mobil XOMUse Pitchbook to download the most recent years of financial statements. Note: If you can't use Pitchbook or don't have access to Pitchbook, feel free to use any other source. Make sure you mention that and list the sourceVisit Yahoo Finance & collect: I.The most recent five years of monthly prices of your company.IIThe most recent five years of monthly prices of S&P GSPCVisit Macrotrends to collect the historical annual returns of the S&P & the year Treasury bond rates for the last years. Use the information collected to determineestimate the Equity Market Risk Premium. In your report, make sure you discuss the following: Company Information Name of company, Auditor, Industry, Market Capitalization, & Stock Exchange listing. Summary of Managements Discussion and Analysis. Growth Analysis.I.Calculate the Actual & Sustainable growth rates of your company over the last years. Analyze the differences between the rates and explain how the company managed and financed those differences if any. IIAssume the companys sales are expected to grow by next year. Estimate how much external financing the company will need and how that is going to impact its capital structure. Assume the company has the capacity to serve the growthRisk and Return Analysis. Use the prices and returns you downloaded above & calculate the companys Average Monthly Return, the Standard Deviation of Returns, Beta, & Equity Required Rate of Return. Explain the meaning of each of these parametersCost of Capital. Analyze your companys current Capital Structure over the study period. Calculate the companys leverage ratio using both market & book values. Also, calculate the companys Weighted Average Cost of Capital WACCPerformance Analysis. Analyze the companys ROE and ROIC parameters and compare them to the Cost of Equity and WACC you calculated above. Comment on whether management has added value over the last year for its debt and equity investors or not. Make sure you justify and support all of your estimatesValuation. Use the techniques we learned in class to estimate the market value of the company and compare that to the actual stock price and discuss the possible differences.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started