Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 5R
To determine
Interpret the behavior of each component from the chart and explain whether the trends are favorable or unfavorable.
To determine
Prepare and print the statement of
To determine
Prepare a line chart explaining the relationship between net income and operating cash flows over the five years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents 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?
a) Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars.
b) On another sheet, create a statement of cash flows for 2019. Do not enter any numbers directly on this sheet. All formulas should be linked directly to the source on previous worksheets.
Garage, Inc., has identified the following two mutually exclusive projects.
a. What is the IRR for each project?
b. If the required return is 11 percent, what is the NPV for each project?
c. What is the crossover rate between these two projects?
Year 0
Year 1
Year 2
Year 3
Year 4
Required return
SSSSS
A
(43,500)
21,400
18,500
13,800
7,600
$
ESSASALA
$
$
$
$
B
(43,500)
6,400
14,700
22,800
25,200
11%
Complete the following analysis. Do not hard code values in your calculations.
You must use the built-in Excel functions to answer this question.
Chapter 14 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- Please be fast.i uploaded an image of information and one where you have to answer, it's a cash flow statement. please do the cash flow statementarrow_forwardPlease answer all of the following questions and kindly type it out if possible so I can easily understand. I have attached two pictures with the information to complete the questions. Thank You :) As part of your analysis, you are required to investigate WITCO’s cash flows. (a)Using the financial statements and additional notes provided, calculate the following for 2020: i. Operating Cash Flow ii. Net Capital Spending iii. Change in Net Working Capital iv. Cash Flow from assets v. Cash Flow to creditors vi. Cash Flow to stockholders (b) Prepare WITCO’s Statement of Cash Flow for the year ended December 31, 2020. (c)What is the purpose and importanceof the Cash Flow Statement?arrow_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_forward
- Please answer all of the following questions and kindly type it out if possible so I can easily understand. I have attached two pictures with the information to complete the questions. Thank You :) As part of your analysis, you are required to investigate WITCO’s cash flows. (a)Using the financial statements and additional notes provided, calculate the following for 2020: iv. Cash Flow from assets v. Cash Flow to creditors vi. Cash Flow to stockholders (b) Prepare WITCO’s Statement of Cash Flow for the year ended December 31, 2020. (c)What is the purpose and importanceof the Cash Flow Statement?arrow_forwardExamine the Statement of Cash flows and the accompanying notes to the financial statements found in the Annual Report that you have downloaded for Question 2. Required: Comment on the company’s cash flows for the latest period. The write-up must not exceed 400 words.arrow_forwardWhich of the following is the final step in preparing a spreadsheet (work sheet) for the statement of cash flows using the indirect method? Add the Debit and Credit Transactions columns and verify that the totals are equal. Analyze all noncash accounts and enter the net increase (decrease) in cash during the period. Add the Balance column totals, which should total to zero. After all noncash accounts have been analyzed, enter the net increase (decrease) in cash during the period.arrow_forward
- Please donot provide solution in image format and provide solution in step by step format and fast solution. You have the following data available for Al Maha Company, which is the income statement at the end of 2022and the statement of financial position (balance sheet) at the end of 2021 and 2022. You are required to:1- Preparing a statement of retained earnings at the end of 20222- A list of cash inflows and outflows at the end of 20223 - A statement of cash flows according to operating, investment and financing activity at the end of 20224 - Free Cash Flow Calculation (from Assets) Free cash flow = operating cash flow - change in net fixed assets - change in net working capital (current assets - current liabilities) Balance sheet at the end of 2021 and 2022 2022 2021 Cash 24000 21000 Receivables 45000 39000 Inventory 30000 27000 Net Fixed Assets = Total - Accumulated Depreciation = (40,000 - 18,000 =) 2021 20000 22000 ( 42000 - 22000 = ) 2022 Total assets…arrow_forwardInstructions: Please provide complete solution for full credit and draw the cash flow diagram. Box your final answers.arrow_forwardPlease prepare a statement of cash flows using the following data. Please include any equations or calculations used through excel.arrow_forward
- How to make monthly cash flow statement in Excel. Give me an example.arrow_forwardFor a cash flow to be done we need a trial balance that was provided ,from which to do an income statement and a balance sheet and finally a cash flow statement. I've already done them all 3 ,but for my assurance,I asked you to do a cash flow statement for me in order to compare my answer/cash flow statement with yours. In consequence, you don't need any previous years to compare anything. Now I am asking again, can you please help me with a statement of cash flow(task 2b) using above information? Thanksarrow_forward. 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.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,