Question

In: Accounting

Example Three: Use a Trial Balance to: Calculate Gross Profit (Gross Margin), Current Assets, Long-Term Assets...

Example Three:

Use a Trial Balance to:

Calculate Gross Profit (Gross Margin), Current Assets, Long-Term Assets (PPE), Current Liabilities, and Long-Term Liabilities

Prepare Closing Entries, and

Calculate ending balance in Retained Earnings.

Account Name

Debit

Credit

Cash

143,500

Accounts Receivable

23,250

Allowance for Uncollectible Accounts

465

Inventory

20,750

Prepaid Rent

3,000

Equipment

30,000

Accumulated Depreciation – Equipment

2,300

Accounts Payable

5,000

Salaries Payable

900

Unearned Revenue

3,500

Notes Payable

45,000

Common Stock

150,000

Retained Earnings

10,250

Dividends

1,500

Sales Revenue

133,250

Cost of Goods Sold

69,000

Operating Expenses

20,000

Salaries Expense

30,900

Depreciation Expense

2,300

Rent Expense

6,000

Bad Debt Expense

465

Totals

350,665

350,665

Calculate

gross profit (gross margin) ________________

total current assets __________________

total long-term (PPE) assets ________________

total current liabilities ________________

total long-term liabilities ________________

Prepare the Closing Entries.

Date

Account Name

Debit

Credit

Calculate the ending balance of retained earnings_________________________.

Retained Earnings

Solutions

Expert Solution

1. gross profit (gross margin) = gross margin / sales

=[ sale - cost of goods sold] / sales

= 64250 / 133,250

= 48.22%

total current assets =143,500 + [23,250 - 465] + 20,750 + 3,000

= 190035

total long-term (PPE) assets = [30000 - 2300] = $27700

total current liabilities = 5,000 + 900 + 3,500

= 9400

total long-term liabilities = 45,000

2.

Date Accounts title Dr Cr
31 Dec sales revenue 133,250
To income summary 133,250
31 Dec Income summary 128665
To Cost of Goods Sold 69,000
To Operating Expenses 20000
To Salaries Expense 30900
To Depreciation Expense 2300
To Rent Expense 6000
To Bad Debt Expense 465
31 Dec Income summary 4585
To retained earnings 4585
31 Dec Retained earnings 1,500
To Dividend 1,500

3. Beginning balance of retained earnings = 10,250

Add: net income = 4585

less: dividend = (1500)

ending balance of retained earnings = $13335


Related Solutions

What is the firm's current year gross profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year gross profit margin?
Given an adjusted trial balance how do you calculate profit and the total assets from the adjusted trial balance.
Given an adjusted trial balance how do you calculate profit and the total assets from the adjusted trial balance. There was also another thing she wanted to know, but I can't remember what it was. All she ever showed us how to do was fill out the balance sheet, income statement, and to close accounts. We only brushed over adjusted trial balances and then it was a main part of the test.  
Operating Profit Margin Return on Total Assets Current Ratio Working Capital Long-term debt-to-capital ratio Price-Earnings Ratio...
Operating Profit Margin Return on Total Assets Current Ratio Working Capital Long-term debt-to-capital ratio Price-Earnings Ratio Which measure do you feel is the most important and why?
1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following:...
1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following: Yr. 1 Revenues 500 COGS 400 Gross Profit 100 Gross Margin 20% Sales rise 5%, 3% due to increase in volume and 2% due to increase in price. COGS is 80% variable. 2. What is the primary driver of sales growth for the following company? Explain. Assume COGS is 60% variable. Yr. 1 Yr. 2 Revenues 800    850 COGS 500 519 Gross Profit...
Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for...
Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for each product and for an entire company. Calculate break-even sales dollars for a company. Determine the relevant cash flows for a planned asset purchase. Madison Company produces four lines of accessories for major U.S. combine manufacturers. The lines are known by the code letters A, B, C, and D. The current sales mix for Madison Company and the contribution margin ratio for these product...
A firm has $200,000 in current assets, $800,000 in long-term assets and $900,000 in long-term financing....
A firm has $200,000 in current assets, $800,000 in long-term assets and $900,000 in long-term financing. What is its net working capital (CA -CL)? Hint: Prepare a Balance Sheet.
The trial balance of Miyanda Traders, after the calculation of the gross profit, was as follows:...
The trial balance of Miyanda Traders, after the calculation of the gross profit, was as follows: Dr (K) Cr (K) Gross profit 120 000 Sundry expenses 57 000 Non-current assets (cost) 400 000 Non-current assets (provision for depreciation) 82 000 Trade receivables 55 000 Trade payables 85 000 Inventory at 31 December 2019 125 000 Cash 5 000 Bank loan (repayable 31 January 2020) 35 000 Capital 320 000 642 000 642 000 7 Additional information for the year ended...
Typical balance sheet classifications are as follows. a. Current Assets       b. Long-term Investments    ...
Typical balance sheet classifications are as follows. a. Current Assets       b. Long-term Investments     c. Property Plant & Equipment       d. Intangible Assets    e. Other Assets                   f. Current Liabilities            g. Long-Term Liabilities          h. Capital Stock            i. Additional Paid-In Capital        j. Retained Earnings                       k. Notes to Financial Statements Indicate by use of the above letters how each of the following items would be classified on a balance sheet prepared at December 31,...
Present current and long term assets and liabilities on a balance sheet (statement of financial position)...
Present current and long term assets and liabilities on a balance sheet (statement of financial position) including require disclosures. Please explain.
Ruskin has the following balance sheet: Current assets $30,000,000, Current liabilities $10,000,000, Fixed assets 60,000,000, Long-term...
Ruskin has the following balance sheet: Current assets $30,000,000, Current liabilities $10,000,000, Fixed assets 60,000,000, Long-term debt 25,000,000, Common stock (1 million shares) 1,000,000, Retained earnings 39,000,000, Preferred Stock 15,000,000, Total assets $90,000,000, Total claims $90,000,000. The current liabilities consist entirely of notes payable to banks, and the interest rate on this debt is 10%, the same as the rate on new bank loans. These bank loans are not used for seasonal financing but instead are part of the company’s...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT