Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Worksheet 2: Problem A – Balance Sheet SnackTastics’s Corp.

Worksheet 2:  Problem A – Balance Sheet

SnackTastics’s Corp. makes and distributes snacks and beverages which are sold in kiosks at malls, entertainment venues and big-box stores. Below is a list of all of their accounts as of December 31, 2013:

10% Bonds, 20-year bonds, due 12/31/2020 800,000
Accounts Payable 83,750
Accounts Receivable 352,400
Accumulated Amortization – Patent 34,920
Accumulated Amortization – Trademark 34,650
Accumulated Depreciation – Building 120,000
Accumulated Depreciation – Equipment 60,000
Additional Paid-in Capital – preferred stock 28,000
Additional Paid-in-Capital, common stock 150,000
Advertising Expense 86,700
Allowance for Doubtful Accounts 15,250
Amortization Expense 7,030
Bad Debt Expense 9,750
Building 1,020,500
Cash 1,354,600
Common Stock ($5 par) 300,000
Cost of Goods Sold 129,850
Depreciation Expense (Building & Equipment) 35,000
Discount on Bonds Payable 73,010
Dividend Revenue 3,280
Dividends 55,000
Equipment 365,000
Income Tax Expense 242,903
Interest Expense 124,268
Interest Revenue 8,490
Inventories 374,500
Investment in Ferrari Corp stock 41,250
Investment in Sampson Corp stock 48,750
Investment in Durango Corp bonds 51,500
Land 585,000
Long-term Notes Payable 677,500
Patent 77,600
Preferred Stock, ($10 par) 100,000
Rent Expense 88,650
Retained Earnings       ?
Sales 1,554,600
Short-Term Notes Payable 336,870
Supplies (office) 27,850
Supplies Expense 47,750
Trademark 63,000
Unrealized holding gain – equity 3,350
Utilities Expense 22,660
Wages Expense 255,640
Wages Payable 42,000

Additional information:

  1. The building had a $220,500 salvage value and a 50 year useful life, however, SnackTastics, Inc. only expected to use the building for 40 years. The building was purchased on Jan 1, 2008. SnackTastics uses the straight-line method for depreciation purposes.
  • The company had purchased 1,000 shares of Sampson Company stock three years ago for a total of $37.50 per share. They intended to hold the Sampson Company stock for a while, although the exact holding period was undetermined.Non-Current Asset – Long Term Investment
  • SnackTastics Corp. purchased 10,000 shares of Ferrari Corp stock two weeks ago for a total of $41,250. They expect to sell Ferrari Company stock as soon as it reaches $4.50 per share, which is expected to happen in the next two months.Short Term Investment – Available for Sale
  • SnackTastics purchased the 10-year bonds of Durango Corp. last year. They plan to hold them for two or three years, at which time they hope to sell them and make a profit.Non-Current Asset – Long Term Investment
  • Upon further evaluation, it was determined that $180,000 of the land was not being used in operations.
  • SnackTastics Corp. had pledged $18,200 of Accounts Receivable as collateral against a $15,000 loan it obtained from First National Bank.
  • The value of the inventories was determined using the lower of cost, using LIFO, or market.
  • SnackTastics had $172,000 of inventory out on consignment with Stadium Concessions Corp.
  • Total Inventory = 374,500 + 172,000 = $546,500
  • The interest expense includes interest on the bonds and notes payable,depreciation expense includes depreciation on both the building and equipment and amortization expense includes amortization on both the Trademark and Patent.
  • The company is authorized to issue 100,000 shares of common stock  and 25,000 shares of preferred stock. There have been no additional issuances of stock, nor have there been any repurchases of stock since the initial issuance.
  • The unrealized holding gain reported above pertains to the Available-for-Sale security(ies) and must be reported in the equity section of the Balance Sheet. You do not need to do a statement of comprehensive income for this problem.

Required: (You MUST show all work to receive full credit)

  1. Prepare a classified balance sheet in good form, including all disclosures.

Prepaid Expenses:

            Utilities Expense: 22,660

            Supplies Expense: 47,750

            Wages Expense: 255,640

            Advertising Expense: 86,700

            Rent Expense: 88,650

            Total Prepaid Expenses: $501,400

  • What was the beginning Retained Earnings amount (as of December 31st, 2012?)  Hint: You need to find net income to solve for this.
  • What is the difference between authorized, issued and outstanding shares of stock?
  • Authorized shares are the number of stock units that a publicly traded company can issue.
  • Issued shares of stock are the number of authorized shares that is sold to and held by the shareholders of a company. Issued shares include the stock that a company sells publicly in order to generate capital.
  • Outstanding shares are a company’s stock currently held by all its shareholders, including share blocks held by institutional investors and restricted shared owned by the company’s officers and insiders.
  • What principle, constraint or assumption dictates that we record inventories at the lower of cost or market?
  • What is the company’s current ratio? Show formula & answer.
  • What are the NET assets of the business? Show formula & answer.

Hints:

Problem One:

  1. Separate the accounts into Income Statement, Retained Earnings and Balance Sheet accounts.  (I usually highlight mine in different colors, but you are free to use whatever method works best for you).
  2. Determine the Accumulated Depreciation for the building before solving for ending Retained Earnings.
  • Remember, your Balance Sheet “equation” is the same as the Accounting Equation.
  • To solve for beginning Retained Earnings, you first need to solve for ending Retained Earnings and then work backwards.
  • You will only need to adjust the balance in one balance sheet account and add one balance sheet account for this problem.
  • See pages 218 and 221 of the loose leaf, 15th edition of the text for help on how to classify the various Investments.
  • Financial ratios can be found on page 246 of the loose-leaf, 15th edition of the text.

Problem B:  Statement of Cash Flows:

Billingsley Company presented the following comparative financial data at December 31, 2013:

             December 31
 
2013 2012  
 
Cash $10,000 $42,000  
Accounts receivable 91,000 53,000  
Building and Equipment 300,000 200,000  
Accumulated Depreciation 60,000 51,000  
  Total assets $341,000 $244,000  
 
 
Accounts payable $55,000 $21,000  
Dividends payable 42,000 21,000  
Common stock 110,000 110,000  
Additional paid in capital 60,000 60,000  
Retained earnings 74,000 32,000  
   Total liabilities and stock- $341,000 $244,000  
     holders’ equity  
 

Additional information for the year 2013:

  1. Equipment costing $80,000 was sold at a $1,000 gain and was 30 percent depreciated at the time of sale
  2. Depreciation expense was recorded.
  3. Net income was $75,000.

Required

  1. In good form, prepare the operating section of the statement of cash flows for 2013 using the INDIRECT METHOD.
  2. Can a company have positive net income and negative cash flows or negative income and positive cash flows? Why or why not?

Hints:

Problem 2

  1. You are only dealing with the operating section of the Statement of Cash flows for this problem, so concentrate on the accounts that affect that section.
  2. Do a T-account for Equipment and one for the Accumulated Depreciation accounts to help determine the depreciation expense for the period.
  3. Question 2 was covered in chat, so be sure to review the archive if you missed it.
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"