Question

In: Accounting

Trial balance Debit Credit Cash 15300 Accounts receivable 10800 Inventory 1/1/20 3800 Prepaid insurance 2000 Equipment...

Trial balance

Debit

Credit

Cash

15300

Accounts receivable

10800

Inventory 1/1/20

3800

Prepaid insurance

2000

Equipment

37000

Accumulated depreciation

5600

Notes payable

1500

Accounts payable

6100

Unpaid salaries

3600

Share capital

3000

Retained earnings

10600

Dividends

5300

Sale

81000

Purchase of inventory

24600

Market cost

4600

Insurance

3500

Salaries

18000

Total

124900

124900

The inventory costing was 1500. Notes payable was taken at the beginning of 2018 to five years, 5% interest, the interests are paid at the beginning of each year. The equipment uses the straight-line method, 7000 each year. Salary bonuses for December are 1500 has not been recorded. Income tax is 20% of the net income.

A) Make an income statement for the year 2020.

B) Calculate gross profit and gross profit rate.

C) Calculate EBITDA and EBITDA margin

D) Make a retained earnings statement for the period 1/1 – 31/12 2020

Please respond quickly

Solutions

Expert Solution

The income statement for the year 2020 is as follows :

Particulatrs Amount
Sales 81,000
Cost of goods sold (3,800 + 24,600 - 1500) (26,900)
Gross Profit 54,100
Operating expenses :
Insurance 3,500
Salaries and bonus salaries 19,500
Market cost 4,600 27,600
Earning before Interest taxes depreciation and amortization (EBITDA) 26,500
Other Expenses :
Interest on notes payable 75
Depreciation on equipment 7,000 7,075
Earning before taxes 19,425
Income Taxes (3885)
Net Profit 15,540

B) The gross profit for the year is $54,100.

The gross profit rate will be equivalent to 66.8% (54,100/81,000)

C) The EBITDA is equivalent to $26,500.

The EBITDA Margin rate will be equal to 32.71% (26,500/81,000)

D) Retained earnings statement for the period 1/1 - 31/12/2020 is as follows :

Particulars Amount ($)
Retained earnings as on 1/1/2020 10,600
Add : Net income for the year 15,540
Less : Dividends for the period (5,300)
Retained earnings as on 31/12/2020 20,840

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Ryan Company Trial Balance December 31, 2017 Debit Credit Cash 21,800 Accounts Receivable 18,800 Prepaid Insurance...
Ryan Company Trial Balance December 31, 2017 Debit Credit Cash 21,800 Accounts Receivable 18,800 Prepaid Insurance 1,000 Equipment 5,000 Accumulated Depreciation-Equipment 9,600 Accounts Payable 11,600 Salaries and Wages Payable 2,200 Unearned Rent Revenue 1,600 Common Stock 20,000 Retained Earnings 11,000 Dividends 5,600 Service Revenue 69,200 Rent Revenue 26,200 Salaries and Wages Expense 36,200 Supplies Expense 4,000 Rent Expense 21,600 Insurance Expense 3,000 Depreciation Expense 2,400 151,400 151,400 Prepare the income and statement of changes in stockholders' equity statements for the...
Adjusted Trial Balance Debit Credit Cash $40,000 Accounts receivable 38,000 Supplies 1,000 Prepaid Insurance 5,200 Property,...
Adjusted Trial Balance Debit Credit Cash $40,000 Accounts receivable 38,000 Supplies 1,000 Prepaid Insurance 5,200 Property, Plant & Equipment 909,000 Accumulated depreciation $250,000 Accounts payable 22,000 Salaries payable 20,000 Utilities payable 1,500 Deferred revenue 6,000 Notes payable (due in 5 yrs) 100,000 Common stock 300,000 Retained earnings 250,000 Dividends 50,000 Service revenue-new construction 356,000 Service revenue-remodeling 574,000 Salaries expense 750,200 Depreciation expense 50,000 Interest expense 8,000 Supplies expense 2,600 Utilities expense 24,000 Service fee expense 1,500 Total $1,879,500 $1,879,500 Identify...
Debit Credit Cash 4,400 Accounts Receivable 2,000 Prepaid Insurance 1,600 Equipment 15,000 Accumulated Depreciation - Equipment...
Debit Credit Cash 4,400 Accounts Receivable 2,000 Prepaid Insurance 1,600 Equipment 15,000 Accumulated Depreciation - Equipment 3,000 Accounts Payable 2,400 Note Payable 3,920 Unearned Fees 3,200 Common Stock 5,000 Retained Earnings 2,700 Dividends 2,000 ​ Fees Earned 37,000 Wages Expense 19,000 Depreciation Expense 1,800 Utilities Expense 320 Insurance Expense 700 Maintenance Expense 7,700 Income Tax Expense 2,700    57,220 57,220 Use the Adjusted Trial above to calculate the Net Income (or Net Loss), and the Retained Earnings balance. Format: Enter...
Debit Credit Cash 4,400 Accounts Receivable 2,000 Prepaid Insurance 1,600 Equipment 15,000 Accumulated Depreciation - Equipment...
Debit Credit Cash 4,400 Accounts Receivable 2,000 Prepaid Insurance 1,600 Equipment 15,000 Accumulated Depreciation - Equipment 3,000 Accounts Payable 2,400 Note Payable 3,920 Unearned Fees 3,200 Common Stock 5,000 Retained Earnings 2,700 Dividends 2,000 ​ Fees Earned 37,000 Wages Expense 19,000 Depreciation Expense 1,800 Utilities Expense 320 Insurance Expense 700 Maintenance Expense 7,700 Income Tax Expense 2,700    57,220 57,220 Use the Adjusted Trial above to calculate the Net Income (or Net Loss), and the Retained Earnings balance.
Trial Balance Debit Credit 1. Cash 70,000 2. Account Receivable 16,500 3. Prepaid Insurance 2,500 4....
Trial Balance Debit Credit 1. Cash 70,000 2. Account Receivable 16,500 3. Prepaid Insurance 2,500 4. Supplies 13,000 5. Equipment 16,000 6. Accounts Payable 15,000 7. Unearned Revenue 11,400 8. Notes Payable 22,300 9. Capital 49,000 10. Drawings 1,500 11. Service Revenue 55,000 12. Salaries Expense 15,000 13. Utilities Expense 4,000 14. Rent Expense 11,900 15. Supplies Expense 2,300 152,700 152,700 Income Statement Revenues Service Revenue 55,000 Total Revenues 55,000 Expanses Salaries Expense 15,000 Utilities Expense 4,000 Rent Expense 11,900...
Number Name Normal Balance 1110 Cash Debit 1120 Accounts Receivable Debit 1130 Prepaid Insurance Debit 1140...
Number Name Normal Balance 1110 Cash Debit 1120 Accounts Receivable Debit 1130 Prepaid Insurance Debit 1140 Prepaid Rent Debit 1150 Office Supplies Debit 1211 Office Equip. Debit 1212 Accum. Depr.-Office Equip. Credit 1311 Computer Equip. Debit 1312 Accum. Depr.-Computer Equip. Credit 1411 Building Cost Debit 1412 Accum. Depr.-Building Credit 1510 Land Debit 2101 Accounts Payable Credit 2102 Advanced Payments Credit 2103 Interest Payable Credit 2105 Salaries Payable Credit 2106 Income Taxes Payable Credit 2201 Mortgage Payable Credit 2202 Notes Payable...
Trial balance March 31, 2019 Information Debit Credit Cash 10,800,000 Prepaid insurance 4,800,000 Equipment 120,000,000 Office...
Trial balance March 31, 2019 Information Debit Credit Cash 10,800,000 Prepaid insurance 4,800,000 Equipment 120,000,000 Office supplies 2,600,000 Accounts payable 79,200,000 Capital 58,000,000 Income 9,000,000 Salary expense 6,400,000 Electrical Load 1,600,000 AMOUNT 146,200,000 146,200,000 Additional customization information: The insurance premium rate is IDR 400,000 per month. The remaining equipment in the warehouse until March 31, 2019 is IDR 2,000,000. Equipment depreciation per month of IDR 1,800,000. The interest accrued by the company on trade payables on March 31, 2019 is...
Northridge LLC Trial Balance April 30, 20XX Debit Credit Cash $58,791 Accounts receivable 18,495 Merchandise inventory...
Northridge LLC Trial Balance April 30, 20XX Debit Credit Cash $58,791 Accounts receivable 18,495 Merchandise inventory 85,221 Office Supplies 2250 Store Supplies' 885 Prepaid Insurance 1659 Office equipment 2500 Accumulated depreciation-Office Equipment $658 Store equipment 16580 Accumulated depreciation-Store Equipment 2,268 Accounts Payable 50921 J. Spark, Capital 132,534 Totals $186,381 $186,381 Using the information from the Excel workbook from Week 3’s submission, complete a worksheet using the following information for accounting adjustments. Complete the columns for the below adjusting entries, income...
Prepare a Post-Closing Trial Balance Cash – 1,270,676 Accounts Receivable – 190,300 Prepaid Insurance – 17,400...
Prepare a Post-Closing Trial Balance Cash – 1,270,676 Accounts Receivable – 190,300 Prepaid Insurance – 17,400 Land – 75,000 Short-term Investments – 167,000 Fair value adjustment (Trading) – (8,000) Allowance for doubtful accounts – 25,000 LT (Debt) investments (HTM) – 177,824 Bonds Payable – 1,600,000 Premium on Bonds Payable – 118,630 Building – 150,000 Accumulated depreciation: building – 5,400 Equipment – 50,000 Accumulated depreciation: equipment – 29,359 Patent – 37,500 Accounts Payable – 65,340 Notes Payable – 236,175 Income Taxes...
Rank in order of liquidity: Accounts Receivable Accumulated Depreciation - Equipment Cash Equipment Prepaid Insurance Prepaid...
Rank in order of liquidity: Accounts Receivable Accumulated Depreciation - Equipment Cash Equipment Prepaid Insurance Prepaid Rent Rent Revenue Supplies
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT