Question: 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

1 Expert Approved Answer
Step: 1 Unlock

SureHere is a common sized income statement and balance sheet for each of Tesla and General Motors f... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!