Question

In: Accounting

The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is...

The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is given below:

Snapshot, Inc.
Balance Sheet
May 31
Assets
  Cash $ 7,000      
  Accounts receivable 75,000      
  Inventory 39,000      
  Buildings and equipment, net of depreciation 530,000      
  Total assets $ 651,000      
Liabilities and Stockholders' Equity
  Accounts payable $ 113,000      
  Note payable 18,000      
  Capital stock 450,000      
  Retained earnings 70,000      
  Total liabilities and stockholders' equity $ 651,000      


The company is in the process of preparing a budget for June and has assembled the following data:


a.

Sales are budgeted at $280,000 for June. Of these sales, $60,000 will be for cash; the remainder will be credit sales. One-half of a month’s credit sales are collected in the month the sales are made, and the remainder is collected the following month. All of the May 31 accounts receivable will be collected in June.

b.

Purchases of inventory are expected to total $170,000 during June. These purchases will all be on account. Forty percent of all inventory purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the May 31 accounts payable to suppliers will be paid during June.

c. The June 30 inventory balance is budgeted at $50,000 .
d.

Selling and administrative expenses for June are budgeted at $54,000 , exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,300 for the month.

e.

The note payable on the May 31 balance sheet will be paid during June. The company’s interest expense for June (on all borrowing) will be $600 , which will be paid in cash.

f. New warehouse equipment costing $8,000 will be purchased for cash during June.
g.

During June, the company will borrow $21,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.


Required:
1a.

Prepare schedule of expected cash collections from sales and a schedule of expected cash disbursements for inventory purchases.

        

       

1b.

Prepare a cash budget for June.

     

2. Prepare a budgeted income statement for June using the absorption costing income statement format.

      

3. Prepare a budgeted balance sheet as of June 30.

       


Solutions

Expert Solution

1a. Schedule of expected cash collections:

$
Cash Sales 60,000
Collection of Sales of Current Month 110,000
Collection of Sales of Previous Month 75,000
Total 245,000

Schedule of Expected Cash Disbursements:

Disbursements for Purchases of $
Previous Month 113,000
Current Month 68,000
Total 181,000

1b. Snapshot Inc.

Cash Budget

For the month ended June 30

$ $
Beginning Cash Balance 7,000
Add: Cash Receipts 245,000
Add: Borrowing 21,000
Total Cash Available 273,000
Less: Cash Disbursements for
Inventory Purchases 181,000
Selling and Administrative Expenses 54,000
Repayment of Note Payable 18,000
Interest Expense 600
Purchase of Equipment 8,000
Total Cash Disbursement 261,600
Ending Cash Balance 11,400

2. Snapshot Inc.

Budgeted Income Statement

For the month ended June 30

Sales $ 280,000
Less: Cost of Goods Sold
Beginning Inventory 39,000
Add: Purchases 170,000
Less: Ending Inventory (50,000) 159,000
Gross Profit 121,000
Operating Expenses
Selling and Administrative Expenses 54,000
Depreciation 2,300
Total Operating Expenses 56,300
Income from Operations 64,700
Interest Expense 600
Net Income 64,100

3. Snapshot Inc.

Budgeted Balance Sheet

June 30

Assets $
Cash 11,400
Accounts Receivable 110,000
Inventory 50,000
Buildings and Equipment, net of depreciation 535,700
Total Assets 707,100
Liabilities and Stockholders' Equity
Accounts Payable 102,000
Note Payable 21,000
Common Stock 450,000
Retained Earnings 134,100
Total Liabilities and Stockholdrs' Equity 707,100

Related Solutions

The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is...
The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is given below: Snapshot, Inc. Balance Sheet May 31 Assets   Cash $ 6,000         Accounts receivable 90,000         Inventory 38,000         Buildings and equipment, net of depreciation 680,000         Total assets $ 814,000       Liabilities and Stockholders' Equity   Accounts payable $ 81,000         Note payable 33,000         Capital stock 600,000         Retained earnings 100,000         Total liabilities and stockholders' equity $ 814,000       The company...
The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is...
The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is given below: Snapshot, Inc. Balance Sheet May 31 Assets   Cash $ 7,000         Accounts receivable 83,000         Inventory 32,000         Buildings and equipment, net of depreciation 610,000         Total assets $ 732,000       Liabilities and Stockholders' Equity   Accounts payable $ 111,000         Note payable 26,000         Capital stock 530,000         Retained earnings 65,000         Total liabilities and stockholders' equity $ 732,000       The company...
The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is...
The balance sheet of Snapshot, Inc., a distributor of photographic supplies, as of May 31 is given below: Snapshot, Inc. Balance Sheet May 31 Assets   Cash $ 5,000         Accounts receivable 89,000         Inventory 40,000         Buildings and equipment, net of depreciation 670,000         Total assets $ 804,000       Liabilities and Stockholders' Equity   Accounts payable $ 87,000         Note payable 32,000         Capital stock 590,000         Retained earnings 95,000         Total liabilities and stockholders' equity $ 804,000       The company...
The May 31, balance sheet for MPIX, INC., a photographic printing company is as follows: Balance...
The May 31, balance sheet for MPIX, INC., a photographic printing company is as follows: Balance Sheet May 31 Assets: Cash $15,000 Accounts Recivable 65,000 Inventory 30,000 Buildings and equipment, net depreciation 500,000 Total assets $610,000 Liabilities and Stockholders equity Accounts payable $90,000 Notes Payable $5,000 Capital stock 420,000 retained earnings 95,000 total $610,000 The company is in the process of preparing a budget for June and has assembled the following data: a. Sales are budgeted at $250,000 for June.  Of...
he Statement of Financial Position of Picture This, Inc., a distributor of photographic supplies, as of...
he Statement of Financial Position of Picture This, Inc., a distributor of photographic supplies, as of May 31 is given below: PICTURE THIS, INC. Statement of Financial Position May 31 Assets                                              Cash 8,000                                              Accounts receivable 72,000                                              Inventory 30,000                                              Building   500,000                                              Total assets 610,000 Liabilities and Equity                                              Accounts payable, suppliers 90,000                                              Notes payable                                                 15,000                                              Share capital, no par 420,000                                              Retained earnings   85,000                                              Total liabilities and equity 610,000 Picture This, Inc. has...
Balance sheet The balance sheet provides a snapshot of the financial condition of a company. Investors...
Balance sheet The balance sheet provides a snapshot of the financial condition of a company. Investors and analysts use the information given on the balance sheet and other financial statements to make several interpretations regarding the company’s financial condition and performance. Fuzzy Button Clothing Company is a hypothetical company. Suppose it has the following balance sheet items reported at the end of its first year of operation. For the second year, some parts are still incomplete. Use the information given...
2. Balance sheet The balance sheet provides a snapshot of the financial condition of a company....
2. Balance sheet The balance sheet provides a snapshot of the financial condition of a company. Investors and analysts use the information given on the balance sheet and other financial statements to make several interpretations regarding the company’s financial condition and performance. Cute Camel Woodcraft Company is a hypothetical company. Suppose it has the following balance sheet items reported at the end of its first year of operation. For the second year, some parts are still incomplete. Use the information...
2. Balance sheet The balance sheet provides a snapshot of the financial condition of a company....
2. Balance sheet The balance sheet provides a snapshot of the financial condition of a company. Investors and analysts use the information given on the balance sheet and other financial statements to make several interpretations regarding the company’s financial condition and performance. Cute Camel Woodcraft Company is a hypothetical company. Suppose it has the following balance sheet items reported at the end of its first year of operation. For the second year, some parts are still incomplete. Use the information...
2. Balance sheet The balance sheet provides a snapshot of the financial condition of a company....
2. Balance sheet The balance sheet provides a snapshot of the financial condition of a company. Investors and analysts use the information given on the balance sheet and other financial statements to make several interpretations regarding the company’s financial condition and performance. Cute Camel Woodcraft Company is a hypothetical company. Suppose it has the following balance sheet items reported at the end of its first year of operation. For the second year, some parts are still incomplete. Use the information...
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31...
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Assets Current Assets $9,670 $8,740 Property, plant, and equipment (net) 1,900 1,850 Other assets 1,590 1,690 Total assets $13,160 $12,280 Liabilities and Stockholders' Equity Current Liabilities $3,200 $3,320 Long-term liabilities 1,270 1,320 Stockholders’ equity 8,690 7,640 Total liabilities and stockholders' equity $13,160 $12,280 (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT