KEMBAR78
UC SLRC Financial Analysis Assignment Worksheet Tesla | PDF | Equity (Finance) | Balance Sheet
Scribd
Upload
46 views2 pages

UC SLRC Financial Analysis Assignment Worksheet Tesla

The financial analysis summary worksheet for Tesla, Inc. includes consolidated results from the income statement, balance sheet, and cash flow statement, with key metrics such as total revenues, net income, and total debt. However, many fields are marked as #DIV/0!, indicating missing or undefined data for the latest year and previous years. The worksheet also outlines various segments of the business, including Automotive and Energy Generation & Storage, but lacks specific financial figures for analysis.

Uploaded by

Ajay Ramanan Maadapusi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
46 views2 pages

UC SLRC Financial Analysis Assignment Worksheet Tesla

The financial analysis summary worksheet for Tesla, Inc. includes consolidated results from the income statement, balance sheet, and cash flow statement, with key metrics such as total revenues, net income, and total debt. However, many fields are marked as #DIV/0!, indicating missing or undefined data for the latest year and previous years. The worksheet also outlines various segments of the business, including Automotive and Energy Generation & Storage, but lacks specific financial figures for analysis.

Uploaded by

Ajay Ramanan Maadapusi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Financial Analysis Summary Worksheet

Company Name: Tesla, Inc.


Consolidated Results
Italics indicates calculated field
Trend / Comment (Enter size /
Latest Year Y0 - 1 Y0 - 2 direction of trend / comment)
Fill in years –>
Financial Statements
Income Statement - P. 49
Total Revenues
Total Cost of Revenues
Gross Profit 0.00 0.00 0.00
Income from Operations
Interest Expense (enter as positive)
Net Income

Balance Sheet - P. 48
Cash & Equivalents
Total Current Assets
Total Assets
Current Portion of Debt & Finance Leases
Total Current Liabilities
Debt & Finance Leases
Total Debt 0.00 0.00
Total Stockholders' Equity

Cash Flow Statement - P. 52


Net Cash From/Used in Operations
Net Cash From/Used in Investing
Property, Plant & equipment additions
Net Cash From/Used in Financing
Net (Decrease)/Increase in Cash

Margin Analysis
Gross Profit Margin #DIV/0! #DIV/0! #DIV/0!
Operating Profit Margin #DIV/0! #DIV/0! #DIV/0!
Net Income Margin #DIV/0! #DIV/0! #DIV/0!

Financial Ratios
Current Ratio #DIV/0! #DIV/0!
ROA #DIV/0! #DIV/0!
ROE #DIV/0! #DIV/0!
Debt/Equity #DIV/0! #DIV/0!
Interest Coverage #DIV/0! #DIV/0! #DIV/0!
Financial Analysis Summary Worksheet

Company Name: Tesla, Inc.


Segment 1 Name: Automotive Trend/Comment (Enter below the size and
P. 88 Latest Year Y0 - 1 Y0 - 2 direction of the trend and any comment)
Fill in years –>

Revenues
Gross Profit
Gross Profit Margin #DIV/0! #DIV/0! #DIV/0!

Segment 2 Name: Energy Generation & Storage Trend/Comment (Enter below the size and
P. 88 Latest Year Y0 - 1 Y0 - 2 direction of the trend and any comment)
Fill in years –>

Revenues
Gross Profit
Gross Profit Margin #DIV/0! #DIV/0! #DIV/0!

Segment 3 Name: Trend/Comment (Enter below the size and


Latest Year Y0 - 1 Y0 - 2 direction of the trend and any comment)
Fill in years –>

Net Sales
Adjusted EBITDA
Operating Profit Margin #DIV/0! #DIV/0! #DIV/0!

Segment 4 Name: Trend/Comment (Enter below the size and


Latest Year Y0 - 1 Y0 - 2 direction of the trend and any comment)
Fill in years –>

Net Sales
Adjusted EBITDA
Operating Profit Margin #DIV/0! #DIV/0! #DIV/0!

Segment 5 Name: Trend/Comment (Enter below the size and


Latest Year Y0 - 1 Y0 - 2 direction of the trend and any comment)
Fill in years –>

Net Sales
Adjusted EBITDA
Operating Profit Margin #DIV/0! #DIV/0! #DIV/0!

You might also like