Extend You Extend Your Skills EA2-E1 Create Financial Statements for Frozen Fractals Corp. In this exercise,...
Part 1: (See photo) prepare finacial statements: income statement, statement of owners equity, and balance sheet. Then: perform ratio analysis a. current ratio b. quick ratio c. debt ratio d. equity ratio e. debt to equity ratio f. profit margin for each reporting period part 2: summarize the firms finacial position based on information in part 1 Extend Your Skills 63 Extend Your Skills EA2-E1 Create Financial Statements for Frozen Fractals Corp. In this exercise, you will create an income...
EA2-A2 Create Financial Statements for Metropolitan Corp In this exercise, you will create a monthly income statement, statement of owner's equity, and balance sheet in Excel for Metropolitan Corp. With the exception of the Terry Mattingly, Capital account (the balance for which is from 5/1/2016), the company had the following account balances as of 5/31/2016. Accounts Payable Accounts Receivable Cash Land Maintenance Expense Notes Payable Printing Expense $27,000 Sales Revenue $24,000 Service Revenue $57,000 Supplies Expense $41,000 Tax Expense $17,000...
EA2-A2 Create Financial Statements for Metropolitan Corp. In this exercise, you will create a monthly income statement, statement of owner's equity, and balance sheet in Excel for Metropolitan Corp. With the exception of the Terry Mattingly, Capital account (the balance for which is from 5/1/2016), the company had the following account balances as of 5/31/2016. Accounts Payable $27,000 Sales Revenue $23,000 Accounts Receivable $24,000 Service Revenue $4,000 Cash $57,000 Supplies Expense $6,000 Land $41,000 Tax Expense $13,000 Maintenance Expense $17,000...
In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet in Excel for Dragon, Inc. With the exception of the William Moss, Capital account (the balance for which is from 8/1/2016), the company had the following account balances as of 8/31/2016: Supplies Expense $1,800 Cash $65,300 William Moss, Capital – 8/1/2016 $73,200 Sales Revenue $33,000 Land $20,000 Accounts Payable $3,000 Accounts Receivable $1,600 Equipment $12,000 Utilities Expense $1,900 Telephone Expense $2,000 Office Expense $2,100...
In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet in Excel for Ampersand Co. With the exception of the Robert Benjamin, Capital account (the balance for which is from 2/1/2016), the company had the following account balances as of 2/29/2016: Notes Payable $1,200 Service Revenue $26,600 Robert Benjamin, Drawing $1,500 Furniture $4,800 Building $18,000 Robert Benjamin, Capital – 2/1/2016 $16,300 Telephone Expense $3,000 Accounts Receivable $7,200 Office Expense $3,400 Utilities Expense $2,200 Interest...
Canvas Exercise on Preparation of Financial Statements I. At the end of Dec. 2019, the following accounts appeared in the trial balance of B Paper Company: Account Title Accounts Payable Accounts Receivable Balance P 25,200 30,500 Account Title Notes Payable Owner's Capital, Dec.1, 2019 Owner's Drawings Balance P 37,000 101,700 45,000 10,000 Accumulated Depr. - Equipment Cash Cost of Goods Sold Freight -Out Equipment Depreciation expense 26,000 518,000 6,500 146,000 11,000 3,500 2,500 2,500 15,000 96,000 1.000 Insurance Expense Interest...
In this exercise, you will use the indirect method to create a statement of cash flows in excel for Zee Co. These amounts relate to July of 2016 Net Income $4,500 Sale Machinery $21,000 Depreciation Expense $900 Purchase of Equipment $18,000 Accounts Receivable (beginning) $6,200 Notes Payable (beginning) $5,600 Account Receivable (ending) $5,100 Notes Payable (ending) $6,600 Account payable (beginning) $3,000 Travis Jackman, Drawing $3,000 Account Payable (ending) $4,800 Cash (beginning balance) $37,400 Use the techniques from his chapter to...
Preparing Financial Statements You will be preparing the Financial Statement for Bolero Auto Repair Shop. Remember the order in which financial statements must be prepared and remember to use good form. Bolero Auto Repair Shop has just completed operations for the year ended December 31, 2020. This is the third year of operations for the company. The following data have been assembled for the business: Insurance Expense Service Revenue Utilities Expense Rent Expense Bolero, Capital, Jan. 1, 2020 Cash Owner...
Exercise 4-11 Preparing the financial statements LO C2 The following is the adjusted trial balance of Wilson Trucking Company. Account Title Cash Accounts receivable Office supplies Trucks Accumulated depreciation-Trucks Land Accounts payable Interest payable Long-term notes payable K. Wilson, Capital K. Wilson, Withdrawals Trucking fees earned Depreciation expense Trucks Salaries expense Office supplies expense Repairs expense-Trucks Totals Credit $ 6,300 16,500 2,000 171,000 $ 35, 226 75,000 10,300 3,000 52,000 169,593 19,000 124,500 22,721 58,391 13,000 10,707 $394,619 $394,619 The...
Flow of Accounts into Financial Statements The balances for the accounts that follow appear in the Adjusted Trial Balance columns of the end-of-period spreadsheet. Indicate whether each account would flow into the income statement, statement of owner's equity, or balance sheet. 1. Accounts Payable 2. Depreciation Expense 3. Nat Hager, Capital (beginning of period) 4. Office Equipment 5. Rent Revenue 6. Supplies Expense 7. Unearned Rent 8. Wages Payable