You should use Excel to do your work for this project. Financial Statement Analysis Download the financial
Fantastic news! We've Found the answer you've been seeking!
Question:
You should use Excel to do your work for this project. Financial Statement Analysis Download the financial statements for your company here: Tesla. Download Download the financial statements for your company here: Tesla. This Excel file contains 3 tabs with the Income Statements, Balance Sheets and Statement of Cash Flows for the last 5 full fiscal years (2017-2021) for your company. Project To Do List: Overall you will be calculating the ratios in Chapter 4 of the book except for Market Value ratios and analyzing the ratios as instructed below. Convert all the profitability ratios to percentages and round to two decimal places (0.00%) and all other ratios to 3 decimal places (0.123). Use Net Income to Company as Net Income and use a tax rate of 25% for any ratios or calculations requiring a tax rate. A paragraph or two of analysis for each item below will suffice. Your Company’s Trend Analysis. Calculate the liquidity ratios (2 ratios) for each of the last 5 years and access how your company’s liquidity position has changed over time. Calculate the asset management ratios (4 ratios) for each of the last 5 years and access how your company’s asset management position has changed over time. Calculate the debt management ratios (3 ratios including the liabilites to assets ratio) for each of the last 5 years and access how your company’s debt management position has changed over time. Calculate the profitability ratios for each of the last 35years and access how your company’s profitability position has changed over time. What is your company’s biggest strength and weakness based on this trend analysis. DuPont Analysis. Break down your company’s Return on Equity, ROE, into the 3-part DuPont Equation for each year. Comment on what factors caused changes in your company’s ROE over the time period. Free Cash Flow Calculation. Calculate your company’s Free Cash Flow for each of the last 4 fiscal years (2018-2021). Use a tax rate of 25% and use the depreciation and amortization from the Cash Flow statement. Please do not use any other data from the Cash Flow statement, calculate changes in the relevant balance sheet accounts from year to year (for example: total current assets, gross property plant & equipment, accounts payable & accrued expenses). Expert Answer:
Related Book For 
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
