Instructions in picture 1, picture 2 is the balance sheet for Apple...

1 Rename this file "Lastname CP5" 2 Copy your clean balance sheet from CP3 to tab "Clean BS" 3 Copy it again to tab "Reformulated BS". Make sure the company name is at the top of the sheet. 4 Reformulate the balance sheet following the model we used in class. Label OA, OL, NOA, FA, FO, NFO, and CSE B D E F G H September 28, 2019 $ 48,844 51,713 22,926 4,106 22,878 12,352 162,819 105,341 37,378 32,978 175,697 338,516 $ 7 8 9 ASSETS: 10 Current assets: 11 Cash and cash equivalents 12 Marketable securities 13 Accounts receivable, net 14 Inventories 15 Vendor non-trade receivables 16 Other current assets 17 Total current assets 18 Non-current assets: 19 Marketable securities 20 Property, plant and equipment, net 21 Other non-current assets 22 Total non-current assets 23 Total assets 24 LIABILITIES AND SHAREHOLDERS' EQUITY: 25 Current liabilities: 26 Accounts payable 27 Other current liabilities 28 Deferred revenue 29 Commercial paper 30 Term debt 31 Total current liabilities 32 Non-current liabilities: -: 33 Term debt 34 Other non-current liabilities 35 Total non-current liabilities 36 Total liabilities 37 Shareholders' equity: 38 Common stock and additional paid in capital, $0.00001 par value: 39 50,400,000 shares authorized; 16,976,763 and 17.772,945 shares 40 issued and outstanding, respectively 41 Retained eamings 42 Accumulated other comprehensive income/(loss) 43 Total shareholders' equity 44 Total liabilities and shareholders' equity 45 $ 46,236 37,720 5,522 5,980 10,260 105,718 91,807 50,503 142,310 248,028 45, 174 45,898 (584) 90,488 338,516 $ 1 Rename this file "Lastname CP5" 2 Copy your clean balance sheet from CP3 to tab "Clean BS" 3 Copy it again to tab "Reformulated BS". Make sure the company name is at the top of the sheet. 4 Reformulate the balance sheet following the model we used in class. Label OA, OL, NOA, FA, FO, NFO, and CSE B D E F G H September 28, 2019 $ 48,844 51,713 22,926 4,106 22,878 12,352 162,819 105,341 37,378 32,978 175,697 338,516 $ 7 8 9 ASSETS: 10 Current assets: 11 Cash and cash equivalents 12 Marketable securities 13 Accounts receivable, net 14 Inventories 15 Vendor non-trade receivables 16 Other current assets 17 Total current assets 18 Non-current assets: 19 Marketable securities 20 Property, plant and equipment, net 21 Other non-current assets 22 Total non-current assets 23 Total assets 24 LIABILITIES AND SHAREHOLDERS' EQUITY: 25 Current liabilities: 26 Accounts payable 27 Other current liabilities 28 Deferred revenue 29 Commercial paper 30 Term debt 31 Total current liabilities 32 Non-current liabilities: -: 33 Term debt 34 Other non-current liabilities 35 Total non-current liabilities 36 Total liabilities 37 Shareholders' equity: 38 Common stock and additional paid in capital, $0.00001 par value: 39 50,400,000 shares authorized; 16,976,763 and 17.772,945 shares 40 issued and outstanding, respectively 41 Retained eamings 42 Accumulated other comprehensive income/(loss) 43 Total shareholders' equity 44 Total liabilities and shareholders' equity 45 $ 46,236 37,720 5,522 5,980 10,260 105,718 91,807 50,503 142,310 248,028 45, 174 45,898 (584) 90,488 338,516 $