Question

In: Accounting

ABC INC, announces the following accounts and balances on 12/31/17: Cash                            $15,000 Equipment (

ABC INC, announces the following accounts and balances on 12/31/17:

Cash                            $15,000

Equipment (net)            20,000

Inventory                    85,000

Retained Earnings       30,000

Common Stock            90,000

During the first quarter [January _ March] of 2018 the business gauges they will sell 150 units of an item at a cost of $200 per unit. All units are sold on account. The business estimates the account receivable balance will be 15% of the sales revenue for the quarter. The business plans to buy 120 units of an item at a cost of $125 per unit during the quarter. They estimate the account payable balance will be 25% of the budgeted quarterly purchases at the end of the quarter. The business estimates selling & general/administrative expenses of $9,000 for the quarter ($500 of this amount is for depreciation expense).

Prepare a budgeted income statement for the first quarter of 2018 and a budgeted balance sheet as of 3/31/18.

Solutions

Expert Solution

Balance sheet as on 31.12.2017
Assets $ Liabilities $
Cash 15000 Retained Earnings 30000
Equipment 20000 Common stock 90000
Inventory 85000
120000 120000
Income statement for the period 01.01.2018 - 31.03.2018
Units selling price Value
Sales 150 200 30000
Opening stock 85000
Purchase 120 125 15000
Closing stock 70000
Cost of Goods sold 30000
Depreciation 500
Selling & Admin(except dep) 8500
Total cost 39000
Net Margin -9000
Balance sheet as on 31.03.2018
Assets $ Liabilities $
Cash 20750 Retained Earnings 30000
Accounts receivable 4500 Add margin during the Quarter -9000
Equipment $ 20000 Net retained earnings 21000
Less :Depreciation $500 19500 Accounts payable 3750
Inventory 70000 Common stock 90000
114750 114750
Working:
Account receivable balance 4500
30000*15%
Account payable balance 3750
15000*25%
Cash 15000
ADD:cash received during the Quarter 25500
30000*85%
Less:Cash Paid during the Quarter 11250
15000*75%
Less: Selling & Distribution exp 8500
Cash in Hand on 31.03.2018 20750
Inventory
Opening 85000
Add Purchase 15000
Less sales 30000
Closing Inventory 70000

Related Solutions

The company's adjusted trial balance as follows includes the following accounts balances: Cash, $15,000; Equipment, $85,000;...
The company's adjusted trial balance as follows includes the following accounts balances: Cash, $15,000; Equipment, $85,000; Accumulated Depreciation, $25,000; Accounts Payable, $10,000; Owner, Capital, $59,000; Owner, Withdrawals, $2,000; Fees Earned, $56,000; Depreciation Expense, $25,000; and Salaries Expense, $23,000. All accounts have normal balances. Prepare closing entry #4 by selecting the account names and dollar amounts from the drop-down menus.
ABC Company reported the following account balances at December 31, 2019: Accounts receivable ......... $33,000 Equipment...
ABC Company reported the following account balances at December 31, 2019: Accounts receivable ......... $33,000 Equipment ................... $47,000 Notes payable ............... $15,000 Utilities expense ........... $23,000 Dividends ................... $18,000 Trademark ................... $16,000 Retained earnings ........... $58,000 (at January 1, 2019) Rental revenue .............. $19,000 Land ........................ ? Cost of goods sold .......... $36,000 Supplies .................... $21,000 Accumulated depreciation .... $11,000 Income tax expense .......... $12,000 Common stock ................ $94,000 Copyright ................... ? Utilities payable ........... $13,000 Sales revenue ............... $90,000...
At 12/31/16, ABC Company had the following balances:                                  &n
At 12/31/16, ABC Company had the following balances:                                                                                                                                                DebitCredit Accounts Receivable$182,000 Allowance for Doubtful Accounts $16,500                During 2017 the following transactions occurred: Accounts receivable of $138,000 were collected, including accounts of $60,000 on which 2% of sales discounts was allowed. The company uses the gross method to record sales made on credit. Several customers notified ABC of bankruptcy, and ABC wrote off the accounts in the amount of $17,500. ABC received $5,300 in payment for an account previously...
Financial Position as of 12/31/16 12/31/17 12/31/18 Cash $ 89,100 $130,100 $154,500 Accounts receivable 79,700 101,600...
Financial Position as of 12/31/16 12/31/17 12/31/18 Cash $ 89,100 $130,100 $154,500 Accounts receivable 79,700 101,600 125,400 Inventory 125,400 139,000 172,500 Other assets 162,800 171,400 198,400    Total assets $457,000 $542,100 $650,800 Accounts payable $ 39,700 $ 59,600 $ 79,700 Other liabilities 78,200 85,700 109,400 Common stock 198,400 198,400 198,400 Retained earnings 140,700 198,400 263,300    Total liabilities and equity $457,000 $542,100 $650,800 Income for Years Ended 12/31/17 12/31/18 Sales revenue $1,062,600 $1,490,760 Less: Cost of goods sold 498,300 746,000 Other expenses...
At December 31, Y1, ABC had the following balances in the accounts it maintains at D...
At December 31, Y1, ABC had the following balances in the accounts it maintains at D Bank and Z Bank: Checking account – D Bank: $200,000 Checking account – D Bank: (10,000) Checking account Z Bank: (5,000) Money market account with check cashing privileges: 50,000 90-day CD, due 2/28/Y2: 25,000 180-day CD, due 4/15/Y2: 75,000 On its December 31, Y1, balance sheet, what amount should ABC report as cash and cash equivalents? $335,000 $225,000 $210,000 $265,000
ABC reports the following accounts and balances at December 31, 2017: Accounts Payable                     $22,800 Accounts Receivable   &nb
ABC reports the following accounts and balances at December 31, 2017: Accounts Payable                     $22,800 Accounts Receivable                  18,800 Cash                                           24,400 Land                                           82,400 Machine                                   129,200 Merchandise Inventory              63,600 Long-term Note Payable            79,200 Short-term Note Payable            14,400 Paid-in Capital                         200,000 Retained Earnings                             ? Sales Revenue                          122,000 Cost of Goods Sold                     80,000 Operating Expenses                   40,000 Required: Prepare a balance sheet at December 31, 2017 Also, prepare an income statement for the year ended December 31, 2017. Ignore depreciation expense and interest expense.
BLOSSOM INC. COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 12/31/17 12/31/16 Cash $5,900...
BLOSSOM INC. COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 12/31/17 12/31/16 Cash $5,900 $6,900 Accounts receivable 61,400 50,800 Short-term debt investments (available-for-sale) 35,000 17,800 Inventory 40,000 59,400 Prepaid rent 5,000 3,900 Equipment 155,200 129,000 Accumulated depreciation—equipment (35,000 ) (25,000 ) Copyrights 45,600 49,900 Total assets $313,100 $292,700 Accounts payable $46,300 $39,800 Income taxes payable 3,900 6,100 Salaries and wages payable 7,900 3,900 Short-term loans payable 8,000 10,100 Long-term loans payable 60,100 68,400 Common stock, $10 par 100,000...
Deedle company began the year with the following account balances: Cash $15,000 Accounts receivable $42,000 Inventory...
Deedle company began the year with the following account balances: Cash $15,000 Accounts receivable $42,000 Inventory $33,000 Accounts payable $24,000 Paid-in capital $45,000 Retained earnings $21,000 During the year, Deedle had the following transactions: a. Borrowed $30,000 on a long-term loan b. Interest expense for the year was $3,000. This amount has not yet been paid in cash c. Sales for the year were $500,000, all on account d. Cash collections of accounts receivable, $280,000 e. Purchased inventory on account,...
Deedle company began the year with the following account balances: Cash $15,000 Accounts receivable $42,000 Inventory...
Deedle company began the year with the following account balances: Cash $15,000 Accounts receivable $42,000 Inventory $33,000 Accounts payable $24,000 Paid-in capital $45,000 Retained earnings $21,000 During the year, Deedle had the following transactions: a. Borrowed $30,000 on a long-term loan b. Interest expense for the year was $3,000. This amount has not yet been paid in cash c. Sales for the year were $500,000, all on account d. Cash collections of accounts receivable, $280,000 e. Purchased inventory on account,...
Following are the 12/31/17 unadjusted and adjustedtrial balances for HW Co. HW Co. Unadjusted and Adjusted...
Following are the 12/31/17 unadjusted and adjustedtrial balances for HW Co. HW Co. Unadjusted and Adjusted Trial Balances December 31, 2017 Unadjusted Adjusted DR CR DR CR Cash   $16,000 $16,000 Accounts Receivable   44,000 51,800 Allowance for Doubtful Accounts   125 1,680 Supplies   17,500 6,800 Prepaid Insurance   6,700 5,100 Equipment   185,000 185,000 Accumulated Depreciation—Equipment   $58,000 $69,700 Accounts Payable 11,000 11,000 Interest Payable     300 Salaries and Wages Payable -   2,600 Notes Payable 10,000 10,000 Unearned Service Revenue 12,000 9,200 Common Stock 20,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT