Principles of Accounting Volume 1
19th Edition
ISBN: 9781947172685
Author: OpenStax
Publisher: OpenStax College
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 16, Problem 2TP
Use a spreadsheet and the following financial information from Mineola Company’s financial statements to build a template that automatically calculates the net operating cash flow. It should be suitable for use in preparing the operating section of the statement of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly.
b. On another worksheet, create a statement of cash flows for 2020. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets.
C. Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section.
d. Suppose that sales were $425,000 in 2020 rather than $412,500. What is the 2020 net income and retained earnings?
e. Undo the changes from part d, and change the tax rate to 20%. What is the 2020 net income and retained earnings?
. ABC company had the following transactions during the month of April 2020. They would like you,
their accountant, to prepare a cash flow statement. Before preparing the statement, you first need to
determine whether the items below results in a cash inflow or outflow in the statement of cash flows.
Second, you are required to determine whether the transaction is an operating, investing, or financing
activity by placing an √ in the appropriate columns.
A company uses a spreadsheet to prepare its statement of cash flows. Indicate whether each of the followingitems would be recorded in the Debit column or Credit column of the spreadsheet’s statement of cashflows section. Increase in interest payable
Chapter 16 Solutions
Principles of Accounting Volume 1
Ch. 16 - Which of the following statements is false? A....Ch. 16 - Which of these transactions would not be part of...Ch. 16 - Which is the proper order of the sections of the...Ch. 16 - Which of these transactions would be part of the...Ch. 16 - Which of these transactions would be part of the...Ch. 16 - Which of these transactions would be part of the...Ch. 16 - What is the effect on cash when current noncash...Ch. 16 - What is the effect on cash when current...Ch. 16 - What is the effect on cash when current noncash...Ch. 16 - What is the effect on cash when current...
Ch. 16 - Which of the following would trigger a subtraction...Ch. 16 - Which of the following represents a source of cash...Ch. 16 - Which of the following would be included in the...Ch. 16 - If beginning cash equaled $10,000 and ending cash...Ch. 16 - Which of the following is a stronger indicator of...Ch. 16 - What function does the statement of cash flows...Ch. 16 - Is it possible for a company to have significant...Ch. 16 - What categories of activities are reported on the...Ch. 16 - Describe three examples of operating activities,...Ch. 16 - Describe three examples of investing activities,...Ch. 16 - Describe three examples of financing activities,...Ch. 16 - Explain the difference between the two methods...Ch. 16 - Why is depreciation an addition in the operating...Ch. 16 - When preparing the operating section of the...Ch. 16 - If a company reports a gain/(loss) from the sale...Ch. 16 - Note payments reduce cash and are related to...Ch. 16 - Is there any significance that can be attributed...Ch. 16 - Would there ever be activities that relate to...Ch. 16 - What insight does the calculation of free cash...Ch. 16 - Why is using the direct method to prepare the...Ch. 16 - Provide journal entries to record each of the...Ch. 16 - In which section of the statement of cash flows...Ch. 16 - In which section of the statement of cash flows...Ch. 16 - Use the following information from Albuquerque...Ch. 16 - What adjustment(s) should be made to reconcile net...Ch. 16 - Use the following information from Birch Companys...Ch. 16 - Use the following information from Chocolate...Ch. 16 - Use the following information from Denmark...Ch. 16 - Use the following excerpts from Eagle Companys...Ch. 16 - Use the following excerpts from Fruitcake Companys...Ch. 16 - Use the following excerpts from Grenada Companys...Ch. 16 - Provide the missing piece of information for the...Ch. 16 - Provide the missing piece of information for the...Ch. 16 - Use the following excerpts from Kirsten Companys...Ch. 16 - Use the following excerpts from Franklin Companys...Ch. 16 - The following are excerpts from Hamburg Companys...Ch. 16 - Use the following excerpts from Algona Companys...Ch. 16 - Use the following excerpts from Huckleberry...Ch. 16 - Provide journal entries to record each of the...Ch. 16 - In which section of the statement of cash flows...Ch. 16 - In which section of the statement of cash flows...Ch. 16 - Use the following information from Hamlin Companys...Ch. 16 - What adjustment(s) should be made to reconcile net...Ch. 16 - Use the following excerpts from Indigo Companys...Ch. 16 - Use the following information from Jumper Companys...Ch. 16 - Use the following information from Kentucky...Ch. 16 - Use the following excerpts from Leopard Companys...Ch. 16 - Use the following information from Manuscript...Ch. 16 - Use the following excerpts from Nutmeg Companys...Ch. 16 - Provide the missing piece of information for the...Ch. 16 - Provide the missing piece of information for the...Ch. 16 - Use the following excerpts from Indira Companys...Ch. 16 - Use the following excerpts from Bolognese Companys...Ch. 16 - The following shows excerpts from Camole Companys...Ch. 16 - Use the following excerpts from Brownstone...Ch. 16 - Use the following excerpts from Jasper Companys...Ch. 16 - Provide journal entries to record each of the...Ch. 16 - Use the following information from Acorn Companys...Ch. 16 - Use the following information from Berlin Companys...Ch. 16 - Use the following information from Coconut...Ch. 16 - Use the following information from Dubuque...Ch. 16 - Use the following information from Eiffel Companys...Ch. 16 - Analysis of Forest Companys accounts revealed the...Ch. 16 - Use the following excerpts from Zowleski Companys...Ch. 16 - Use the following excerpts from Yardley Companys...Ch. 16 - Use the following excerpts from Wickham Companys...Ch. 16 - Use the following excerpts from Tungsten Companys...Ch. 16 - The following shows excerpts from financial...Ch. 16 - Use the following excerpts from Fromera Companys...Ch. 16 - Use the following excerpts from Victrolia Companys...Ch. 16 - Use the following cash transactions relating to...Ch. 16 - Provide journal entries to record each of the...Ch. 16 - Use the following information from Grenada...Ch. 16 - Use the following information from Honolulu...Ch. 16 - Use the following information from Isthmus...Ch. 16 - Use the following information from Juniper...Ch. 16 - Use the following excerpts from Kayak Companys...Ch. 16 - Analysis of Longmind Companys accounts revealed...Ch. 16 - Use the following excerpts from Stern Companys...Ch. 16 - Use the following excerpts from Unigen Companys...Ch. 16 - Use the following excerpts from Mountain Companys...Ch. 16 - Use the following excerpts from OpenAir Companys...Ch. 16 - The following shows excerpts from financial...Ch. 16 - Use the following excerpts from Swansea Companys...Ch. 16 - Use the following excerpts from Swahilia Companys...Ch. 16 - Use the following cash transactions relating to...Ch. 16 - Use a spreadsheet and the following financial...Ch. 16 - Consider the dilemma you might someday face if you...Ch. 16 - If you had $100,000 available for investing, which...
Additional Business Textbook Solutions
Find more solutions based on key concepts
What are the advantages of a culture that emphasizes empathetic communication? Can you think of any disadvantag...
Principles of Management
Margos Memories, a company that specializes in photography and creating family and group photo portfolios, has ...
Principles of Accounting Volume 2
Discussion Questions 1. What characteristics of the product or manufacturing process would lead a company to us...
Managerial Accounting (4th Edition)
E2-13 Identifying increases and decreases in accounts and normal balances
Learning Objective 2
Insert the mis...
Horngren's Accounting (11th Edition)
Journal entries, T-accounts, and source documents. Visual Company produces gadgets for the coveted small applia...
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ravenna Candles recently purchased candleholders for resale in its shops. Which of the following costs would be...
Financial Accounting (12th Edition) (What's New in Accounting)
Knowledge Booster
Similar questions
- Use the following excerpts from Victrolia Companys financial information to prepare a statement of cash flows (direct method) for the year 2018.arrow_forwardUse the following excerpts from Swansea Companys financial information to prepare the operating section of the statement of cash flows (direct method) for the year 2018.arrow_forwardUse the following excerpts from OpenAir Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forward
- Use the following excerpts from Stern Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forwardUse the following excerpts from Kayak Companys financial information to prepare the operating section of the statement of cash flows (indirect method) for the year 2018.arrow_forwardUse the following excerpts from Fromera Companys financial information to prepare the operating section of the statement of cash flows (direct method) for the year 2018.arrow_forward
- Use the following information from Berlin Companys financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018.arrow_forwardUse the following excerpts from Kirsten Companys Statement of Cash Flows and other financial records to determine the companys free cash flow.arrow_forwardUse the following information from Juniper Companys financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018.arrow_forward
- A company uses a spreadsheet to prepare its statement of cash flows. Indicate whether each of the followingitems would be recorded in the Debit column or Credit column of the spreadsheet’s statement of cashflows section. Net incomearrow_forwardUsing the financial statements and additional information below, construct an indirect cash flow statement in Excel for year 4. As long as you are following general cash flow formatting rules (e.g. operating section, investing section, financing section), you can format it as you see fit. Remember that these reports should be clean, easy to read and understand, and useful for decision-making purposes.arrow_forwardUse the following information from Dubuque Company’s financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning