2024 – This was listed in the rubric and must be included in the

This was listed in the rubric and must be included in the final assignment. 

You will also need to submit the Excel files for your chosen business’s balance sheet, income statement, and cash flow statement from Mergent Online.

Spreadsheet: Project Two Financial Formulas
Use this Excel spreadsheet to complete your calculations for the project. You should have already completed parts of the spreadsheet for your Project Two Milestone assignment.

All sources, including your Project Two Financial Formulas spreadsheet, should be included and cited according to APA style.

Here are the financial caluclations that you provided in the report. I just need them in the spreasheet. How can I get Tesla’s balance sheet, income statement and cash flow statement? Do you need access to Mergent Online?

  

Financial Calculations

Working Capital = Current Assets – Current liabilities

26717 – 14248 = 12469 million US dollars. 

Current Ratio = Current Assets/Current Liabilities 

26717/14248 = 1.875

Debt Ratio = Total Liabilities/Total Assets

28469/52148 = 0.546

Earnings per Share =Net Income/Outstanding Common Shares

270/960 = 0.28125

Assets Turnover Ratio = Net Sales/ Total Assets

10744/ 52148 = 0.206

Financial leverage = Total Liabilities/ Shareholders Equity

28469/22225 = 1.281

Net Profit Margin = Net Profit/ Total Revenue 

6630/ 10744 = 0.617

Return on Assets = Net Income/ Total Assets

270/ 52148 = 0.005

Return on Equity = Net Income/ Shareholders Equity

270/ 22225 = 0.0121