AutoSave OFF B C... Home Developer Insert Draw Page Layout Formulas Data Review View Developer Module 02 Assignment Tell me Share Comments G- Insert Calibri (Body) 11 A A Wrap Text General Delete Paste C8 BIU fx A Merge & Center $ % 9 .00 0 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analyze Data Sensitivity A 1 Accounts payable 2 Accounts receivable 3 Assets 4 Cash and cash equivalents Common stock, no par value; 1,600,000 shares authorized; 5 800,000 shares issued and outstanding 6 Current assets: 7 Current liabilities: 8 Current maturities of long-term debt 9 Deferred revenues 10 Equipment 11 Income taxes payable 12 Interest payable 13 Inventory 14 Less: accumulated depreciation 15 Less: allowance for uncollectible accounts 16 Liabilities and Shareholder's Equity 17 Long-term Liabilities 18 Net accounts receivable 19 Net property, plant, and equipment 20 Notes payable 21 Other assets: 22 Prepaid expenses 23 Property, plant and equipment: 24 Retained earnings 25 Shareholder's equity: 26 Short-term investments in equity securities 27 Total assets 28 Total current assets 29 Total liabilities 30 Total liabilities and shareholder's equity 31 Total shareholder's equity 32 33 34 35 36 37 38 39 40 41 42 B D E F G H J L M N P Q R T U V Company Info Balance Sheet Accounts Ready 100% AutoSave OFF Home G- Paste X Developer Insert Draw Page Layout Formulas Data Review View Developer Module 02 Assignment Tell me Share Comments Insert Calibri (Body) 11 A A ab Wrap Text General Delete v A Merge & Center % 500-00 Conditional Format Formatting as Table Cell Styles Sort & Format Filter Find & Select Analyze Sensitivity Data J6 BIU x fx | 5 B C D F G H 6782922: 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Total assets 28 29 Liabilities and Shareholders' Equity 30 31 32 33 34 35 36 37 38 39 40 41 Total liabilities 42 43 44 45 46 Total shareholders' equity $ Company Info Balance Sheet Accounts Edit K L M N P Q R S T U W X Y Z Fill in the yellow cells only. The subtotals will calculate automatically. 100% Excel File Edit View Insert Format Tools Data Window Help Tue Feb 22 8:33 PM AutoSave OFF C ... Module 02 Assignment Home Developer Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments G Insert Calibri (Body) 11 A A ab Wrap Text General Delete Paste BI U A Merge & Center $ % .00 .00 +0 Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find & Select Analyze Data Sensitivity H35 A fx B C D E F G H K M N P June 30, 2021 classification (see the Accounts tab), as well as titles for each classification's subtotal. You only need to fill out the yellow portion. S T 5 6 Account Title 7 Cash 8 Short-term investments 9 Accounts receivable (net) Debits Credits 83,000 65,000 280,000 10 Prepaid expenses (for the next 12 m 32,000 Additional information The short-term investments account includes $18,000 in U.S. treasury bills purchased in May. The bills mature in July, 2021. 11 Land 75,000 12 Buildings 320,000 The accounts receivable account consists of the following: 13 Accumulated depreciation - buildir 160,000 14 Equipment 265,000 Amounts owed by customers $225,000 15 Accumulated depreciation - equip 120,000 16 Accounts payable 173,000 17 Accrued liabilities 18 Notes payable 19 Mortgage payable 20 Common stock 21 Retained earnings 22 Totals 23 45,000 100,000 250,000 Allowance for uncollectible accounts-trade customers Nontrade notes receivable (due in three years) Interest receivable on notes (due in four months) (15,000) 65,000 Total 100,000 1,120,000 172,000 1,120,000 5,000 $280,000 The notes payable account consists of two notes of $50,000 each. One note is due on September 30, 2021, and the other is due on November 30, 2022. The mortgage payable is a loan payable to the bank in semiannual installments of $5,000 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expe Five hundred thousand shares of no par common stock are authorized, of which 200,000 shares have been issued and are outstanding. The land account includes $50,000 representing the cost of the land on which the company's office building resides. The remaining $25,000 is the cost of land that the company is holding for investment purposes. 24 Additional Information: 25 U.S. treasury bill purchased in May-July, 2021 matu $ 26 Accounts receivable: 18,000 27 Amounts owed by customers $ 28 Allowance for uncollectible accounts-trade custom 225,000 (15,000) 29 Nontrade notes receivable (due in 3 years) 65,000 30 Interest receivable on notes (due in 4 months) 5,000 31 Total $ 280,000 32 33 Note payable due on 9/30/2021 $ 50,000 34 Note payable due on 11/30/2022 $ 50,000 35 Mortgage payable semiannually (excluding interest $ 5,000 36 Shares of no par common stock authorized 500,000 37 Shares of common stock issued and outstanding 200,000 38 Cost of land under office building $ 39 Cost of land held for investment $ 50,000 25,000 40 Company Info Balance Sheet Accounts Ready FEB 22 tv A P W B 100%