Using the test model data, design a column chart that will show the components of cash flow
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the test model data, design a column chart that will show the components of cash flow from operating activities (net income etc.)
Transcribed Image Text:
Snanna Company reported a net income of $105.000 for the current year. Depreciation recorded for the year totaled $38,000. Current asset and liability accounts had the following balances at the beginning and end of the year: Cash Accounts receivable Inventory Prepaid rent Accounts payable Salaries payable Ending $39,500 55,000 69,800 5,400 43,700 6,000 Beginning $41,300 48,800 75,000 6,000 54,100 8,400 The president of Shanna Company has asked you to develop a worksheet that will compute cash flow from operating activities (file name CASHFL). Use the information provided as input for the Data Section of your worksheet. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete and ready to be graded. Print the worksheet when done. Check figure: Cash flow from operating activities, $129,800. To test your model, use the following information for the next year, when net income was $60,000 and depreciation totaled $30,000. Beginning $39,500 55,000 Cash Accounts receivable Inventory Prepaid rent Accounts payable * Notes-payable Salaries Ending $33,000 91,300 82,000 4,750 40,500 6,400 69,800 5,400 43,700 6,000 Print the worksheet when done. Check figure: Cash flow from operating activities, $39,350. Snanna Company reported a net income of $105.000 for the current year. Depreciation recorded for the year totaled $38,000. Current asset and liability accounts had the following balances at the beginning and end of the year: Cash Accounts receivable Inventory Prepaid rent Accounts payable Salaries payable Ending $39,500 55,000 69,800 5,400 43,700 6,000 Beginning $41,300 48,800 75,000 6,000 54,100 8,400 The president of Shanna Company has asked you to develop a worksheet that will compute cash flow from operating activities (file name CASHFL). Use the information provided as input for the Data Section of your worksheet. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete and ready to be graded. Print the worksheet when done. Check figure: Cash flow from operating activities, $129,800. To test your model, use the following information for the next year, when net income was $60,000 and depreciation totaled $30,000. Beginning $39,500 55,000 Cash Accounts receivable Inventory Prepaid rent Accounts payable * Notes-payable Salaries Ending $33,000 91,300 82,000 4,750 40,500 6,400 69,800 5,400 43,700 6,000 Print the worksheet when done. Check figure: Cash flow from operating activities, $39,350.
Expert Answer:
Answer rating: 100% (QA)
3 Analysis of Transactions for 4 For the current Year Beginning Balanc... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0078025839
9th edition
Authors: J. David Spiceland, James Sepe , Mark Nelson , Wayne Thomas
Posted Date:
Students also viewed these accounting questions
-
Alciatore Company reported a net income of $150,000 in 2018. The weighted-average number of common shares outstanding for 2018 was 40,000. The average stock price for 2018 was $33. Assume an income...
-
Alciatore Company reported a net income of $150,000 in 2021. The weighted-average number of common shares outstanding for 2021 was 40,000. The average stock price for 2021 was $33. Assume an income...
-
The balance sheet of Castle Inc had the following balances at December 31 2016 Cash 15800 Accounts Receivable 22500 Accounts Payable 11500 Less Allowance for Doubtful Accounts 800 Owners Capital...
-
How are Recovery Audit Contractors paid? Question 23 options: RACs are reimbursed $100,000 annually RACs are reimbursed on a contingency-based system RACs are paid on a contract basis RACs are not...
-
What is the difference between VAR and expected shortfall (ES) as measure of market risk?
-
In 2006, Frank made an installment sale of real property to Stu, his son, for $1 million. Payments are due over a 10-year period. Frank did not file a gift tax return. For 2013, Frank reported...
-
What is a lineage, and how does it relate to a descent group?
-
The standard cost of Product B manufactured by Mateo Company includes three units of direct materials at $5.00 per unit. During June, 28,000 units of direct materials are purchased at a cost of $4.70...
-
As a long-term investment, Painters' Equipment Company purchased 20% of AMC Supplies Inc's 470,000 shares for $550,000 at the beginning of the fiscal year of both companies. On the purchase date, the...
-
What is the difference between an information system and a computer application?
-
An event manager is planning for food services during a large event He wants to set up food kiosks all around the events venue All kiosk will have the same menu offering a limited number of freshly...
-
Which of the following best describes an opportunity for management to issue low-quality financial reports? A. Ineffective board of directors B. Pressure to achieve some performance level C....
-
Galambos Corporation had an average receivables collection period of 19 days in 2003. Galambos has stated that it wants to decrease its collection period in 2004 to match the industry average of 15...
-
Mustard Seed PLC adheres to IFRS. It recently purchased inventory for 100 million and spent 5 million for storage prior to selling the goods. The amount it charged to inventory expense ( millions)...
-
Projecting profit margins into the future on the basis of past results would be most reliable when the company: A. is in the commodities business. B. operates in a single business segment. C. is a...
-
Credit analysts are likely to consider which of the following in making a rating recommendation? A. Business risk but not financial risk B. Financial risk but not business risk C. Both business risk...
-
A company has its stock currently selling at $67.50. The company is expected to grow at a constant rate of 7 percent. If the appropriate discount rate is 17 percent, what is the current dividend? ...
-
Quadrilateral EFGH is a kite. Find mG. E H <105 G 50 F
-
In preparation for developing its statement of cash flows for the year ended December 31, 2018, Rapid Pac, Inc., collected the following information: ($ in millions) Fair value of shares issued in a...
-
Patel Industries has a noncontributory, defined benefit pension plan. Since the inception of the plan, the actuary has used as the discount rate the rate on high quality corporate bonds, which...
-
Schaeffer Corporation reports $50 million accumulated other comprehensive income in its balance sheet as a component of shareholders' equity. In a related disclosure note reporting comprehensive...
-
What are some reasons a potential prospect might not be readily accessible? How far should you go to try to overcome such an accessibility problem before you move to the next lead?
-
List three or four criteria you could use to qualify a lead as a likely prospect. How would you find out if the lead meets these criteria?
-
Who is currently in your own network that you could use for prospecting? How might you add to your network?
Study smarter with the SolutionInn App