[SOLVED] Financial Analysis

• Project summary: You will conduct a relatively thorough financial analysis of a firm. Students will obtain relevant data, and perform valuation of the firm’s statement analysis, risk, common stock, and cost of capital and determine if they are financially stable. • Submission: Only Electronic copies will be accepted and handed in via Moodle. Dropbox will be set up for the project. • Deadline: • SUNDAY NOVEMBER 22nd. • Grading Please show all work, assumptions and identify all sources used. This project will be graded on: – (1/2) Use of financial theory, critical thinking, and data analysis, – (1/2) Use of Excel: Is the model developed efficiently using input fields, etc., are the worksheets formatted neatly and effectively, and are models accurate? • Sources Below are some suggested reference sources for your project. However, feel free to use other resources as required: • Your company’s annual report • Security Exchange Commission • http://finra-markets.morningstar.com/MarketData/CompanyInfo/default.jsp • http://finance.yahoo.com/   1 GUIDELINES You should select a firm! Make certain that you have access to all financial information of the firm. The firm must have outstanding common stock, outstanding bonds, and you have access to all their financial information with relatively little transactions cost. This will be incumbent upon you to find this out immediately and have it be a basis upon firm selection. Failure to do this will result in lower project grade. • Tasks: Task 1: Financial Statement Analysis Task 2: Risk and Return Analysis Task 3: Stock Valuation Analysis Task 4: Determining Cost of Capital • Deliverables Financial Analysis (Excel file) – Part I in the project (80 points): Presentation (power point file) – Part II in the project (20 points) Part I: Excel File Do the following for the firm selected, in an EXCEL file: a) Introductory Sheet (Financial Statements): Obtain the last 4 years of financial statements: balance sheet, income statement, and statement of owner’s equity. Import these items into an Excel workbook. Remember that this data will be recalled later in this project for analysis. The intent is not for you to manually enter these data, but to import, then format them. b) Sheet 1 (Chapter 7-Financial Statement Analysis): The goal in this sheet is to evaluate your firm’s financial situation, as follows: Use actual and pro forma statements to construct financial ratios for your firm. Use financial ratios to determine the firm’s liquidity, asset management, debt management, profitability and market value. Analyze the ratios of the firm over a three-year horizon and compare them with that of the industry averages. You are to calculate the ratios and compare them to the published ratios. Most of these industry ratios can be found on the FINRA.org website. Comment on the firm’s prognosis. Once that is done, interpret the ratios to describe in words the state of the firm relative to the five areas of performance identified above. 2 c) Sheet 2 (Chapter 2 – Risk and Return): Find the firm’s BETA using BETA formula (Equation 2-14) in Chapter 2 Use the following link to get the risk-free rate ????: http://pages.stern.nyu.edu/~adamodar/ A good approach is to the most current rate for the 10-year U.S. Treasury bond yield. For the market risk premium (?????? ? ????), use 4.42%. The risk premium is the expected 10-year S&P 500 return relative to a 10-year U.S. Treasury bond yield. A typical ?????? is an annual average return of S&P 500 index based on a sample period like 10 years. Obtain the firm’s BETA from the latest (2018) VLIS (Value Line Investment Survey) reports for your firm choice from the VLIS website: https://research.valueline.com/research?_ga=2.51649774.673777525.1550770910- 1640214787.1550770899#list=dow30&sec=list Find the required rate of return using CAPM formula (Equation 2-15) in Chapter 2 d) Sheet 3 (Chapter 8 – Common Stock Valuation): Using the free cash flow model of stock valuation, compute the price per share of the firm’s common stock. (Use chapter 8 as a guide). Find the firm’s growth rate using the following formula: g = constant dividend growth rate = ROE x Earnings retention ratio Estimate the intrinsic value per share using Gordon growth model (Equation 9-3) in Chapter 9 How do the calculated intrinsic values compare to the actual current price of your firm? Use an IF statement to display whether the stock is undervalued, overvalued, or fairly valued. a) Sheet 4 (Chapter 11 – Cost of Capital): Estimate your firm’s WACC: (Information comes from various chapters of your text) ?  Estimate your firm’s beta coefficient using 5 years of quarterly data for your firm and the S&P 500 index, found on Yahoo! Finance. ?  Use the last 10 years of the annual closings of the S&P 500 (Use the GSPC ticker). Use the trend function to forecast one year ahead return. This is expected return for the market. ?  Using the most current estimate of the 20-year T-Bond as the proxy for the risk-free interest and the expected market return from 2.b, estimate the firm’s cost of common equity. ?  Use FINRA.org to find the firm’s cost of debt. Obtain the firm’s marginal tax rate and use it to find the firm’s after-tax cost of debt. If you have multiple bonds outstanding, use the weighted average YTM of each bond. ?  If applicable, obtain the price of preferred stock and use the dividend to calculate the firm’s cost of preferred stock. ?  Use all of the above information and the firm’s market capital structure to determine the firm’s WACC.   3 Part III: Final Report PPT Presentation /// Slide 1 (Cover Slide): Final Report of your firm’s Financial Analysis “Your Report Title” “Your Name” FIN 5100, Corporate Finance, /// Slide 2: Company’s Overview: ///Slide 3: Firm’s Financial Statement Analysis /// Slide 4: Firm’s Risk and Return Analysis /// Slide 5: Firm’s Stock Valuation Analysis /// Slide 6: Firm’s Cost of Capital Analysis /// Slide 7: Summary and Conclusions /// Slide 8: Key References


So much stress and so little time? Take care of yourself: let us help you with your task on
[SOLVED] Financial Analysis
Get a 20% Discount on this Paper
Get Help Now

Haven’t found relevant content or pressed for time? –Don’t worry,  you have a team of Finance professionals to help you.

All you need to do is fill in the order form in the upper right corner and upload the files that are crucial for your assignment. Also, don’t forget to specify whether your assignment has to be based upon specific research, theory, method, or program. After that, we will assign the most suitable expert to complete your assignment. You can always chat with your expert and ask any questions you have during the working process.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*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.
Get personalized services with Do My Homeworkk
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
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Thank you
Customer 452445, September 8th, 2021
M5A1 Outline and Thesis
Paper was late
Customer 452457, November 15th, 2021
Thank you - much appreciated!
Customer 452493, April 2nd, 2022
Customer 452493, April 12th, 2022
Good work, professional and beat the deadline. Thank you so very much
Customer 452445, August 24th, 2021
National Security Intelligence and Security Analysis
Customer 452457, November 3rd, 2021
Thank you!
Customer 452493, March 16th, 2022
Thank you! :)
Customer 452493, May 14th, 2022
Leadership Studies
This is great! Thanks a bunch
Customer 452485, March 1st, 2022
Looks good. Thank you!
Customer 452523, September 27th, 2022
Looks good. Thank you!!!
Customer 452503, April 25th, 2022
Although the paper did not make it at the requested time, the writer did reach out to me and asked for a short extension which I was okay with.
Customer 452493, March 16th, 2022
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