I need help finishing the cash flow statement, as well as the table in green and cash
Fantastic news! We've Found the answer you've been seeking!
Question:
I need help finishing the cash flow statement, as well as the table in green and cash flow valuation. If possible, please help on formulas, by typing them and listing the cell in Excel I should put them in.
Transcribed Image Text:
1 Formulas needed: 2 3 4 5 Income Statement 6 Net Sales 7 COGS 8 SG&A 9 Legal costs (*) 10 Depreciation & Amortization 11 EBIT Operating NWC = Non-cash Operating CA - Non-interest bearing Operating CL Invested Capital = Debt + Equity - Nonoperating assets Economic Profit Spread = Average Invested Capital * (ROIC - WACC) 25 26 27 WACC 28 2020 30,280 20,350 6,100 250 580 3,000 12 13 Investment Income 14 Interest expense 15 EBT 16 17 Income Taxes (35%) 18 Net Income 19 20 21 Other data 22 Plowback ratio 23 24 Company was sued one time in their history 10 130 2,880 1,008 1,872 2019 100% 11.50% Balance Sheet Cash & equivalents Receivables Inventory Total CA Net PP&E Goodwill Total Assets ST Debt Accounts Payable Accrued Salaries Total CL LT Debt Common stock and PIC Retained earnings Treasury stock Total Equity & Liabilities 2019 850 1,000 4,000 5,850 7,754 930 14,534 0 2,070 1,400 3,470 4,596 2,685 9,243 -5,460 14,534 2020 915 1,070 4,460 6,445 8,870 2,105 17,420 10 2,450 1,845 4,305 4,775 2,685 11,115 -5,460 17,420 11,115 ROIC = NOPLAT / Average Invested Capital CapEx = (PPE₁ - PPE) + Depreciation Cash Flow Statement Net Income Depr & Amort Dec (inc) in receivables Dec (inc) in inventory Inc (dec) in accts payable Inc (dec) in accrued salaries Change in Operating Cash Flow Capital expenditure Dec (inc) in acquisitions CF investing Inc (dec) in debt Inc (dec) in CS Dividends CF financing Change in cash Balance sheet change in cash Change 2020 in NWC 1,872 580 70 460 380 445 3,807 1,696 0 65 Invested Capital = Operating NWC + Operating Assets Invested Capital/ Assets Operating CA Operating CL Net Working Capital Invested Capital Invested Capital/ Financing Invested Capital Check Change 2019 2020 in NWC 2019 2020 correct correct Cash Flow Valuation Non-GAAP EBIT NOPAT Depreciation & Amort Change in NWC Capital expenditure Acquisition Free Cash Flow Non-GAAP ROIC GAAP ROIC Economic Profit 2020 This firm grows via acquisition 1 Formulas needed: 2 3 4 5 Income Statement 6 Net Sales 7 COGS 8 SG&A 9 Legal costs (*) 10 Depreciation & Amortization 11 EBIT Operating NWC = Non-cash Operating CA - Non-interest bearing Operating CL Invested Capital = Debt + Equity - Nonoperating assets Economic Profit Spread = Average Invested Capital * (ROIC - WACC) 25 26 27 WACC 28 2020 30,280 20,350 6,100 250 580 3,000 12 13 Investment Income 14 Interest expense 15 EBT 16 17 Income Taxes (35%) 18 Net Income 19 20 21 Other data 22 Plowback ratio 23 24 Company was sued one time in their history 10 130 2,880 1,008 1,872 2019 100% 11.50% Balance Sheet Cash & equivalents Receivables Inventory Total CA Net PP&E Goodwill Total Assets ST Debt Accounts Payable Accrued Salaries Total CL LT Debt Common stock and PIC Retained earnings Treasury stock Total Equity & Liabilities 2019 850 1,000 4,000 5,850 7,754 930 14,534 0 2,070 1,400 3,470 4,596 2,685 9,243 -5,460 14,534 2020 915 1,070 4,460 6,445 8,870 2,105 17,420 10 2,450 1,845 4,305 4,775 2,685 11,115 -5,460 17,420 11,115 ROIC = NOPLAT / Average Invested Capital CapEx = (PPE₁ - PPE) + Depreciation Cash Flow Statement Net Income Depr & Amort Dec (inc) in receivables Dec (inc) in inventory Inc (dec) in accts payable Inc (dec) in accrued salaries Change in Operating Cash Flow Capital expenditure Dec (inc) in acquisitions CF investing Inc (dec) in debt Inc (dec) in CS Dividends CF financing Change in cash Balance sheet change in cash Change 2020 in NWC 1,872 580 70 460 380 445 3,807 1,696 0 65 Invested Capital = Operating NWC + Operating Assets Invested Capital/ Assets Operating CA Operating CL Net Working Capital Invested Capital Invested Capital/ Financing Invested Capital Check Change 2019 2020 in NWC 2019 2020 correct correct Cash Flow Valuation Non-GAAP EBIT NOPAT Depreciation & Amort Change in NWC Capital expenditure Acquisition Free Cash Flow Non-GAAP ROIC GAAP ROIC Economic Profit 2020 This firm grows via acquisition
Expert Answer:
Related Book For
Horngrens Accounting
ISBN: 978-0133855388
10th Canadian edition Volume 2
Authors: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo-Ann L. Johnston, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
Wingate Corporation was formed several years ago. The following is a list of its stockholders equity accounts and balances as of June 1, 2014. Preferred Stock 7%, $100 par, cumulative, 2,000 shares...
-
The cash flow statement categorizes like transactions for optimal reporting. Requirement 1. Identify each of the following transactions as one of the following: Operating activity (O) Investing...
-
The cash flow statement categorizes like transactions for optimal reporting. Identify each of the following transactions as one of the following: Operating activity (O) Investing activity (I) ...
-
Why is globalization of industries a common factor today?
-
Try to think of additional examples of brands that adopted either a back-to-basics or reinvention revitalization strategy. How well did they work?
-
What are the Quality Records (QRs) and work products of SITE?
-
The adjusted trial balance for Sparkys Electrical Supply, Inc., as of November 30, 2010, is presented next: Requirements 1. Prepare the multi-step income statement for November for Sparkys Electrical...
-
Collyer Products Inc. has a Valve Division that manufactures and sells a standard valve as follows: The company has a Pump Division that could use this valve in the manufacture of one of its pumps....
-
Wildhorse Company's income statement for the year ended December 31, 2025, contained the following condensed information. Service revenue Operating expenses (excluding depreciation) $619,000...
-
Consolidated Income Statement, Intercompany Transactions ments for Pon and its 80 percent-owned subsidiary, Star, appear below. Condensed income state- Condensed Income Statements Star Pon $9,000,000...
-
What innovative approaches do companies adopt to integrate employee wellness programs seamlessly into their overall engagement strategies, aiming for holistic employee satisfaction and productivity?
-
What is the first step in the economic justification process? a. Identify potential solutions. b. Assess the value proposition. c. Assess business requirements. d. Estimate costs. e. All of these.
-
The critical path in a PERT chart represents: a. the sequencing of tasks. b. the most important tasks of the whole project. c. the longest path of tasks needed for project completion. d. the tasks...
-
Give examples of process automation applications.
-
The triple constraints of project management do not include the constraint of: a. technical issues. b. time. c. cost. d. scope.
-
Which phase of the systems development life cycle would include describing in detail the desired features of the system? a. Analysis phase b. Design phase c. Planning phase d. Maintenance phase e....
-
Western Led, recorded revenue for a five year construction contract evenly over the five years. describe Qualitative characteristic of financial statement foundation.
-
Why do CPA firms sometimes use a combination of positive and negative confirmations on the same audit?
-
HMR Associates Inc. includes the following selected accounts in its general ledger at December 31, 2017: Bonds Payable..........................................................................
-
CNZ Corporation Inc. completed the following selected transactions during 2017: Feb. 4 Declared a cash dividend on the 30,000, $1.40 preferred shares. Declared a $0.20 per share cash dividend on the...
-
Tasis Ventures Inc. is authorized to issue 10-year, 5 percent convertible bonds with a maturity value of $9,000,000. Interest is payable on June 30 and December 31. The bonds are convertible on the...
-
The audit procedures applied to accrued liabilities differ from those applied to accounts payable because a. Accrued liabilities balances are less material than accounts payable balances. b. Evidence...
-
Match each assertion to the related audit objective. Each assertion may be used once, more than once, or not at all. Audit objective 1. To determine whether the amount shown as invento- ries in the...
-
Audit procedures should be designed to accomplish specific audit objectives. Review the following inventory audit procedures and indicate which audit objectives are being accomplished and how. a....
Study smarter with the SolutionInn App