Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a common sized income statement and balance sheet for each of Tesla and General Motors for the last 3 fiscal years using the excel

Develop a common sized income statement and balance sheet for each of Tesla and General Motors for the last 3 fiscal years using the excel info below. Do you see any trends? Compare.


2 General Motors Co. (NYS: GM) Millions Gross Property Plant&Equip Net Property Plant & Equip Accounts Payable & Accrued Exps Other Current Liabilities 142220 Additional Paid-In Capital Accum Other Comprehensive Income Total Liabilities& Equity

Tesla Inc (NMS: TSLA) Scale Cash & Equivalents Cash & Equivs & ST Investments Receivables (ST) Inventories 

General Motors Co. (NYS: GM) Scale Cash & Equivalents Cash & Equivs & ST Investments Receivables (ST) Inventories Current Tax Assets Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Receivables (LT) Long Term Investments Intangible Assets Deferred LT Assets Other Assets Total Assets Accounts Payable & Accrued Exps Accounts Payable Accrued Expenses Current Debt Other Current Liabilities Total Current Liabilities LT Debt & Leases Pensions & OPEB Deferred LT Liabilities Minority Interests Other Liabilities Total Liabilities Common Share Capital Additional Paid-In Capital Retained Earnings Accum Other Comprehensive Income For Curr Trans (BS) Other Equity Total Equity Total Liabilities & Equity 2016 Millions 24801 24801 31703 13788 5911 76203 47434 11614 35820 20724 8996 6259 35092 38596 221690 50388 26961 23427 29028 5765 85181 55600 23754 2362 239 10718 177854 15 26983 26168 -9330 0 43836 221690 2015 Millions 23401 23401 26388 13764 8599 5855 78007 40745 9516 31229 18500 9201 5947 28443 23193 194520 44626 24062 20564 19562 7278 71466 43549 26596 2007 452 10579 154649 15 27607 20285 -8036 -2034 2034 39871 194520 2014 Millions 28176 28176 25606 13642 9760 6486 83670 35810 8067 27743 16006 8350 6410 25414 10084 177677 43002 22529 20473 14988 7711 65701 31853 30017 1556 567 12526 142220 16 28937 14577 -8073 -1064 1064 35457 177677

Step by Step Solution

3.29 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

SureHere is a common sized income statement and balance sheet for each of Tesla and General Motors f... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions