I need help creating a trial sheet, a balance sheet, and finding the current ratio
Assume that the following transactions (in millions) occurred during the next fiscal year (ending on September 29, 2018): a. Borrowed $18,299 from banks due in two years. b. Purchased additional investments for $24,100 cash; one-fifth were long term and the rest were short term. c. Purchased property, plant, and equipment: paid $9,605 in cash and signed a short-term note for $1,443. d. Issued additional shares of common stock for $1,503 in cash; total par value was $1 and the rest was in excess of par value. e. Sold short-term investments costing $19,040 for $19,040 cash. f. Declared $11,158 in dividends to be paid at the beginning of the next fiscal year. P2-5 Part 3 3. Prepare a trial balance for the period ended September 29, 2018. (Enter your answers in millions.) 4. Prepare a classified balance sheet for Mango at September 29, 2018, based on these transactions. (Enter your answers in millions.) 5. Compute Mango's current ratio for the year ending on September 29, 2018, (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. MANGO INC. CONSOLIDATED BALANCE SHEET September 30,2017 (dollars in millions) ASSETS Current assets: Cash Short-term investments Accounts receivable Inventories Other current assets Total current assets Long-term investments Property, plant, and equipment, net Other noncurrent assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities : Accounts payable Accrued expenses Unearned revenue Short-term notes payable Total current liabilities Long-term debt Other noncurrent liabilities Total liabilities Stockholders' equity: Common stock ( $0.00001 per value) Additional paid-in capital Retained earnings Total stockholders' equity Total liabilities and shareholders' equity $14,02411,37717,6812,13424,14169,357131,73220,87312,676$234,63830,56318,6798,5996,38564,22629,34428,196121,76625,21287,659112,872$234,638