Prepare the statement of cash flows of cupcake company

Assignment Help Accounting Basics
Reference no: EM131700801

Question - The following are comparative balance sheets and an income statement for the Cupcake Company.

Cupcake Company Balance Sheets As of December 31

                                                                                                   As of December 31

                                                                   2016              2015

Assets:

Cash                                                            $25,000         $100,000

Accounts receivable                                       163,500         125,000

Inventory                                                      183,000        220,000

Property, Plant and Equipment                         70,000         50,000

Less: Accumulated Depreciation                       (40,000)      (35,000)

Long-term investments                                    20,000        65,000

Valuation Allowance - LT Investments               4,000          2,000

Totals                                                            $425,500     $527,000

Liabilities and shareholders' equity:

Accounts payable - Merchandise                       $60,000      $110,000

Operating expenses payable                            29,500        25,000

Notes Payable                                                 10,000       -0-

Bonds payable                                                60,000       110,000

Common stock                                                150,000     125,000

Treasury Stock, Common                                 (10,000)    -0-

Retained earnings                                            122,000     155,000

Accumulated Other Comprehensive Income       4,000         2,000

  Totals                                                           $425,500    $527,000

Cupcake Company Income Statement For the Year Ended December 31, 2016

Sales                                                                             $571,000

Cost of Goods sold                                                          372,500

Gross Profit                                                                    $198,500

Operating expenses (excluding depreciation expense)        182,000

Depreciation expense                                                      5,000

Income from operations                                                  $11,500

Other expenses:

Loss on sale of long-term investment                               (4,500)

Net Income                                                                   7,000

Other comprehensive Income - Unrealized holding gains   2,000

Comprehensive Income                                                 $ 9,000

Additional Information 2016:

  • Cash dividends were declared and paid in 2016.
  • No stock dividends were declared or issued in 2016
  • No Property, Plant or Equipment was sold in 2016
  • During 2016, Property, Plant and Equipment of $10,000 was acquired by signing a $10,000 Notes Payable on the day of acquisition. All other acquisitions were paid with cash
  • The following were purchased using cash: Long-term investments and Treasury Stock
  • Any change in Bonds Payable relates to repayment of principle (face) amounts.
  • All sales of Common Stock (No par value) were for cash

Prepare the Statement of Cash Flows of Cupcake Company for the year ended December 31, 2016. 

A. Prepare a Statement of Cash Flows (direct method) using the "Spreadsheet Approach" we demonstrated in class. 

B. Using your spreadsheet from A above prepare a Statement of Cash Flows, in good form, for the year ended December 31, 2016 (A reconciliation schedule is not required.) 

C. Submit both A and B electronically in Canvas using separate tabs for each.

Reference no: EM131700801

Questions Cloud

Initiating and planning activities for projects : What does research suggest as a best practice for how much time should be spent in initiating and planning activities for projects?
Determine whether you prefer a laptop or desktop : From the e-Activity, determine whether you prefer a laptop or desktop. Elaborate on the features that you would want your desktop or laptop to offer.
Explain at least two ways in which systems theory : Explain at least two ways in which systems theory may be used in the Social Security Administration
Evaluate the projected cost and time savings : Evaluate the projected cost and time savings as estimated by the United States Department of Health and Human Services.
Prepare the statement of cash flows of cupcake company : Prepare the Statement of Cash Flows of Cupcake Company for the year ended December 31, 2016. Cash dividends were declared and paid in 2016
Analyze classes of hardware and system software components : Analyze the main classes of hardware and system software components in an enterprise context. Discuss common input / output technologies.
Looking for budget-priced flight home for holidays : Given that Gabbie is looking for a budget-priced flight home for holidays, she will need to determine which flight features are most important to her.
Analyze the control systems used by a real organization : For this exercise you will analyze the control systems used by a real organization such as a department store, restaurant, hospital, police department.
Describe a cultural diversity policy for the firm : Should U.S. civil rights laws apply to U.S. companies' foreign operations? Express your opinion on this issue.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd