Homework Help is Here – Start Your Trial Now!
Business
Accounting
Undo C15 Ready A ☆ Clipboard S V X 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Calculate the following: 29 OCF-Operating Cash Flow 30 Net Operating Working Capital 31 Change in NOWC 32 Change in Gross Plant & Equipment 33 Investment in Operating Capital 4 Sheet2 + B Total Assets Net sales (all credit) Cost of goods sold Depreciation Font Income Statement ($million) 2400.0 2000.0 2040.0 1700.0 60.0 50.0 EBIT interest EBT taxes Net Income Common dividends 43.4 121.0 D 2020 40.4 8.8 2019 E Alignment F Total Stockhldr Equity Total Liab. and Equity .00 0 Number G S Equals market value per share The firm has no preferred stock H Additional information: Average Tax Rate = 40% Applyaverage tax rate to all Net Income shares outstanding = 50 million Common stock price = $10.00 per share Cell Styl

Undo C15 Ready A ☆ Clipboard S V X 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Calculate the following: 29 OCF-Operating Cash Flow 30 Net Operating Working Capital 31 Change in NOWC 32 Change in Gross Plant & Equipment 33 Investment in Operating Capital 4 Sheet2 + B Total Assets Net sales (all credit) Cost of goods sold Depreciation Font Income Statement ($million) 2400.0 2000.0 2040.0 1700.0 60.0 50.0 EBIT interest EBT taxes Net Income Common dividends 43.4 121.0 D 2020 40.4 8.8 2019 E Alignment F Total Stockhldr Equity Total Liab. and Equity .00 0 Number G S Equals market value per share The firm has no preferred stock H Additional information: Average Tax Rate = 40% Applyaverage tax rate to all Net Income shares outstanding = 50 million Common stock price = $10.00 per share Cell Styl

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
please use formula type in answer
Calibri Format as lab 三= Cell Styles Paste BIU Number Styles Alignment Font Undo Clipboard :XV fx H. 1. Fill in the yellow cells with the appropriate functions/formulas. Do not type in the numerical answer. Let Excel calculate the number using your formula in the cell. Balance Sheet ($million) 2020 2019 Sta 2020 2019 216 180 You Accounts Payble Notes Paybable Accrued wages&taxes Cash 24 20 Accounts receivable 360 300 134 103 you Ad Sub 144 120 Inventory Total Current Assets Gross Plant & Equip. 360 400 494 300 744 720 Total Current Liab. 403 650 Long-term debt/bonds 300 Mu -Accumulated deprciation Net Plant & Equip. 150 Common stock 100 100 Divi Retained earnings Total Stockhldr Equity Total Liab. and Equity 600 500 450 417 Ma Total Assets Do r 17 Income Statement ($million) Exar 18 Net sales (all credit) 2000.0 Additional information: 2400.0 19 Cost of goods sold 2040.0 1700.0 Average Tax Rate = Applyaverage tax rate to all Net Income shares outstanding = 40% 20 Depreciation 60.0 50.0 21 Ea EBIT Sheet2 50 million +) LwOu Ready Accessibility: Investigate
Transcribed Image Text:Calibri Format as lab 三= Cell Styles Paste BIU Number Styles Alignment Font Undo Clipboard :XV fx H. 1. Fill in the yellow cells with the appropriate functions/formulas. Do not type in the numerical answer. Let Excel calculate the number using your formula in the cell. Balance Sheet ($million) 2020 2019 Sta 2020 2019 216 180 You Accounts Payble Notes Paybable Accrued wages&taxes Cash 24 20 Accounts receivable 360 300 134 103 you Ad Sub 144 120 Inventory Total Current Assets Gross Plant & Equip. 360 400 494 300 744 720 Total Current Liab. 403 650 Long-term debt/bonds 300 Mu -Accumulated deprciation Net Plant & Equip. 150 Common stock 100 100 Divi Retained earnings Total Stockhldr Equity Total Liab. and Equity 600 500 450 417 Ma Total Assets Do r 17 Income Statement ($million) Exar 18 Net sales (all credit) 2000.0 Additional information: 2400.0 19 Cost of goods sold 2040.0 1700.0 Average Tax Rate = Applyaverage tax rate to all Net Income shares outstanding = 40% 20 Depreciation 60.0 50.0 21 Ea EBIT Sheet2 50 million +) LwOu Ready Accessibility: Investigate
Data Review View Help Page Layout Formulas File Home Insert Draw Number Conditional Calibri 11 A A" $ % 9 Format as Ta Paste BIUv Cell Styles Alignment Number Style Font Undo Clipboard C15 EXv fx A B. Total Stockhldr Equity Total Liab. and Equity 14 Total Assets 15 D 16 17 Income Statement ($million) Ex Net sales (all credit) Cost of goods sold 18 2400.0 2000.0 Additional information: 19 2040.0 1700.0 50.0 Average Tax Rate = 40% 20 Depreciation EBIT 60.0 Applyaverage tax rate to all Net Income shares outstanding = Common stock price = 21 50 million 22 interest 43.4 40.4 23 $10.00 per share EBT Equals market value per share The firm has no preferred stock 24 taxes 25 Net Income You 26 Common dividends 121.0 bar 8.8 27 28 Calculate the following: 29 OCF-Operating Cash Flow 30 Net Operating Working Capital 31 Change in NOWC 32 Change in Gross Plant & Equipment 33 Investment in Operating Capital 2020 2019 Sheet2 Ready * Accessibility: Investigate lil lili
Transcribed Image Text:Data Review View Help Page Layout Formulas File Home Insert Draw Number Conditional Calibri 11 A A" $ % 9 Format as Ta Paste BIUv Cell Styles Alignment Number Style Font Undo Clipboard C15 EXv fx A B. Total Stockhldr Equity Total Liab. and Equity 14 Total Assets 15 D 16 17 Income Statement ($million) Ex Net sales (all credit) Cost of goods sold 18 2400.0 2000.0 Additional information: 19 2040.0 1700.0 50.0 Average Tax Rate = 40% 20 Depreciation EBIT 60.0 Applyaverage tax rate to all Net Income shares outstanding = Common stock price = 21 50 million 22 interest 43.4 40.4 23 $10.00 per share EBT Equals market value per share The firm has no preferred stock 24 taxes 25 Net Income You 26 Common dividends 121.0 bar 8.8 27 28 Calculate the following: 29 OCF-Operating Cash Flow 30 Net Operating Working Capital 31 Change in NOWC 32 Change in Gross Plant & Equipment 33 Investment in Operating Capital 2020 2019 Sheet2 Ready * Accessibility: Investigate lil lili
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Quality control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS