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?
-
Explain the assumptions of linear regression. How can you determine if each of these assumptions holds?
-
Figure shows a conducting loop of area 20 cm 2 and resistance 4?. If B = 40 cos10 4 ta z mWb/m 2 , find the induced current in the loop and indicate its direction. 4 0
-
Tennessee law imposes durational-residency requirements on persons and companies wishing to operate retail liquor stores, requiring applicants for an initial license to have resided in the state for...
-
Renaissance Capital Group is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated income from operations, and net...
-
3) The cost and revenue function in dollar terms for a fast-food joint is given as follows: C(x)=200x+200 and R(x) = 50x X + 4 If x is measured in hundreds of units, what is the break-even point for...
-
Kerosene at 250 F must be cooled to 180 F by using ethylene glycol, which is available at 72 F. The mass flow rate of kerosene is 150,000 Ibm/hr. You are asked to size a heat exchanger for this...
-
Current Attempt in Progress Pharoah Company has these data at December 31, 2020, the end of its first year of operations. Debt Securities Cost Fair Value Trading $111,600 $130,100 Available-for-sale...
-
A shift in the supply curve for gasoline in the United States would result if ______. a) people decided to travel more by automobile b) the OPEC nations decided to stop sales of crude oil to the...
-
A production function shows a firm how to ______. a) maximize profit b) maximize output c) minimize losses d) minimize output
-
Change in which of the following would not quickly cause a shift in demand? a) number of buyers b) tastes c) buyers perception of quality of product d) income e) price
-
If demand falls and supply stays the same, equilibrium price will _____, and equilibrium quantity will _____.
-
When total output is maximized, marginal output is ________. a) rising b) falling c) positive d) negative e) zero
-
Instructions: What defines you? Is it your values? Maybe it's your car? Well it could also be both and much more. Philosopher William James posited that our whole self is composed of three separate...
-
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...
-
A second-order dynamic system is modeled as \[9 \ddot{x}+6 \dot{x}+\frac{10}{9} x=14 \delta(t), \quad x(0)=0, \quad \dot{x}(0)=-\frac{1}{4}\] a. Find the response \(x(t)\) in closed form. b. Plot the...
-
Consider a first-order system with time constant \(\tau\) and zero initial condition. Find the system's unit-step response for \(\tau=\frac{1}{3}\) and \(\frac{2}{3}\), plot the two curves versus \(0...
-
a. Identify the damping type and find the free response. b. Plot the free response by using the initial command. \(\ddot{x}+3 \dot{x}+4 x=0, \quad x(0)=\frac{2}{5}, \quad \dot{x}(0)=0\)
Study smarter with the SolutionInn App