Check my workCheck My Work button is now enabled1ltem 7 Problem 2 - 22 Calculating Cash Flow Use the following information for Ingersoll, Incorporated. Assume the tax rate is 24 percent. 2020 2021 Sales $ 24, 549 $ 19,248 Depreciation 2,536 2,644 Cost of goods sold 6, 490 6,891 Other expenses 1,455 1,258 Interest 1, 190 1,405 Cash 8,756 9,727 Accounts receivable 11,648 13,962 Short-term notes payable 1,834 1,801 Long-term debt 29, 540 35,629 Net fixed assets 73, 137 78,090 Accounts payable 6, 365 7, 120 Inventory 20, 696 22, 022 Dividends 2,779 2,474 For 2021, calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders.

Check my workCheck My Work button is now enabled1ltem 7 Problem 2 - 22 Calculating Cash Flow Use the following information for Ingersoll, Incorporated. Assume the tax rate is 24 percent. 2020 2021 Sales $ 24, 549 $ 19,248 Depreciation 2,536 2,644 Cost of goods sold 6, 490 6,891 Other expenses 1,455 1,258 Interest 1, 190 1,405 Cash 8,756 9,727 Accounts receivable 11,648 13,962 Short-term notes payable 1,834 1,801 Long-term debt 29, 540 35,629 Net fixed assets 73, 137 78,090 Accounts payable 6, 365 7, 120 Inventory 20, 696 22, 022 Dividends 2,779 2,474 For 2021, calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

What is the value on 1/1/95 of the following cash flows? Date Cash Received Amount of Cash 12/31/96 $100 12/31/97 $200 12/31/98 $100 12/31/99 $100 12/31/00 $100 Use a 10% discount rate and round your answer to the nearest $1.
A machine with a cost of $144.000, accumulated depreciation of $92,000, and current year depreciation expense of $20,500 is sold for $45,600 cash. The amount that should be reported as a source of cash under cash flows from investing activities is: Multiple Choice $46,400. $6.400. $20,500 Prev 6 of 10 Next > 6:35 PM 3/28/2022
evious Ned You are a financial Manager of Chevron Corp You need to assess the effectiveness of working capital management of the company for 2018 using the following data What is the 2018 Cash Conversion Cycle using 365 days? 2017 Account Recevable-15.653 000 2018 Account Receivable=15:050 000 2017 Inventory= 5 585 000 2018 Inventory = 5704 000. 2017 Accounts Payable 14.565 000 2018 Accounts Payable 13 053 000 2017 Sales134674 000 2018 Sales 158 902 000 2017 Cost of Sales=9511430 2018 COs oSales = 1:3997 0 2017 Purchases 2018 Purchases 總 I99
Consider the following cash flows: Year 0 Cash Flow -$ 5,100 es 01234 1,500 2,600 1,300 1,000 Check my work 4 What is the payback period for the cash flows? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Payback period -32.16 years
What is the payback period for the following set of cash flows? Year O -23 + 4 Cash Flow -$ 1,600 1,200 1,700 2,000 1,600 Multiple Choice O O O 1.54 years 1.24 years 1.30 years
Create an Excel spreadsheet that calculates the internal rate of return for the following set of cashflows: Period 012345 Cashflow $1123.01 $100 $100 $100 $100 $ 1,100 Note your spreadsheet should calculate the present value of each of the individual cashflows as well as the sum based on your IRR input. Once you have completed your IRR calculation check your work with the Excel IRR function
After-Tax Cash Flows Below is a list of aspects of various capital expenditure proposals that the capital budgeting team of Anchor, Inc., has incorporated into its net present value analyses during the past year. Unless otherwise noted, the items listed are unrelated to each other. All situations assume a 40% income tax rate and an 11% minimum desired rate of return. 1. Pre-tax savings of $4,000 in cash expenses will occur in each of the next three years. 2. A machine is purchased now for $37,000 cash. 3. A long-haul tractor costing $27,000 will be depreciated $9,000, $12,000, $4,050, and $1,950, respectively, on the tax return over four years. 4. Equipment costing $200,000 will be depreciated over five years on the tax return in the following amounts: $25,000; $50,000; $50,000; $50,000; and $25,000. 5. Pre-tax savings of $8,800 in cash expenses will occur in each of the next six years. 6. Pre-tax savings of $7,000 in cash expenses will occur in the first, third, and fifth years from…
S Year 0 1 2 3 Cash Flow -$ 9,900 2,300 2,900 5,200 a. What is the profitability index for the cash flows if the relevant discount rate is 6 percent? Profitability index 0.949 0.967 0.875 0.893 0.921 b. What is the profitability index for the cash flows if the relevant discount rate is 16 percent? Profitability index c. What is the profitability index for the cash flows if the relevant discount rate is 23 percent?
What is the IRR of the following set of cash flows? Year Cash Flow -$ 0 10,512 123 7,000 4,800 3,300 Multiple Choice 22.7% 25.09% 24.38% 23.9% 23.42%
e to search ☐ shaikh amir - Easy E... Texas Department o Inspectors Depart... A Does an MIS make i... Question 10 What is the IRR of Project C if the outlay is $225,000 and the after-tax cash inflows for years one through four are: $45,000, $70,000, $80,000, and $105,000? O 13.21% O 12.90 11.00 O 11.80 O 13.53. D Question 11 What is the NPV of Project C? $4,274.96 1,138.33 O3.891.33 2,884.34 O2.638.33 Question 12 Based on IRR. ABC should accept all throe only A and B only A and C only C a
What is the IRR of the following set of cash flows? Year 0 2 WN Cash Flow -$ 8,213 4,800 3,300 3,700 Multiple Choice O 20.71% 22.24% 21.36% 21.8% 22.89%
ok ences Mc Graw Hill Graff, Incorporated, has sales of $50,000, costs of $23,000, depreciation expense of $2,250, and interest expense of $2,000. If the tax rate is 23 percent, what is the operating cash flow, or OCF? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Operating cash flow 2 #3 3 89 $ 4 000 000 % 5 8