Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Please completed the calculation under the yellow highlighted sections. INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation

image text in transcribed

Please completed the calculation under the yellow highlighted sections.

INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation and Amortization - Total Operating Income EBIT Interest and Related Expense Pretax Income Income Taxes Expense (Credit) NET INCOME (LOSS) 2017 2018 4,965 2,428 2,537 1,400 138 999 12 987 235 752 2017 2016 4,391 3,962 2,100 1,893 2,291 2,069 1,283 1,169 127 104 881 795 8 5 873 790 294 291 579 499 Part-1 AT-HOME Due Oct.19 Calculate Free Cash Flow for 2 yrs USE 24% INC.TAX RATE 2018 EBIT EBIT X (1-.24 tax rate) Depreciation CHANGE, Work Cap Capital Spending 2018 BALANCE SHEET Cash and Short-Term Investments - To Receivables - Total Inventories - Total Current Assets - Other - Total Current Assets Total Property Plant and Equipment - Total ( Non-Current Assets - Other - Total Long-term Assets Total ASSETS TOTAL 2017 167 117 714 608 1,279 1,093 156 118 2,316 1,936 925 894 81 81 1,005 975 3,322 2,911 2016 113 500 993 115 1,721 900 48 948 2,669 Free Cash Flow A 10 pts A 10 pts Below use Year-end Assets, Equity, not AVG Compute Sustain Growth % 2018 2017 for 2 Yrs Net Profit Margin 'd' Div Payout Debt / Equity Assets / Sales Numerator Denoninator Current Liabilities Debt Payable - Current Liabilities Account Payable/Creditors - Trade Current Liabilities - Other Current Liabilities Total Long-Term Debt Total Deferred Taxes and Investment Tax Cre Long-Term Liabilities Total Liabilities Total Shareholders' Equity Total LIABILITIES + SHAREHOLDERS' EQUITY 2018 3 194 241 437 497 84 581 1,019 2,303 3,322 2017 10 148 194 351 412 51 463 814 2,097 2,911 2016 10 109 156 276 380 81 460 736 1,933 2,669 S.G.R. (end-yr Equity) >> 10 pts 10 pts 2018 752 138 47 2017 579 127 2018 176 continued from lower left Capital Expenditures Other Cash Flow from Investin INVESTING ACTIVITIES - NET 2017 120 -59 -179 2 -174 -18 STATEMENT OF CASH FLOWS Income Before Extraordinary Items Depreciation and Amortization Adjustments to Net Income Accounts Receivable - Decrease (Increa Inventory - Decrease (Increase) Accounts Payable and Accrued Liabilite Other Changes in Operation Activities OPERATING ACTIVITIES - NET CASH FLC -120 193 93 -42 674 -104 -76 74 3 585 2016 499 104 32 -40 -81 -46 46 514 Common and Preferred Stock Cash Dividends Other - Increase (Decrease) FINANCING ACTIVITIES - NET -90 442 0 -73 369 0 -407 -446 INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation and Amortization - Total Operating Income EBIT Interest and Related Expense Pretax Income Income Taxes Expense (Credit) NET INCOME (LOSS) 2017 2018 4,965 2,428 2,537 1,400 138 999 12 987 235 752 2017 2016 4,391 3,962 2,100 1,893 2,291 2,069 1,283 1,169 127 104 881 795 8 5 873 790 294 291 579 499 Part-1 AT-HOME Due Oct.19 Calculate Free Cash Flow for 2 yrs USE 24% INC.TAX RATE 2018 EBIT EBIT X (1-.24 tax rate) Depreciation CHANGE, Work Cap Capital Spending 2018 BALANCE SHEET Cash and Short-Term Investments - To Receivables - Total Inventories - Total Current Assets - Other - Total Current Assets Total Property Plant and Equipment - Total ( Non-Current Assets - Other - Total Long-term Assets Total ASSETS TOTAL 2017 167 117 714 608 1,279 1,093 156 118 2,316 1,936 925 894 81 81 1,005 975 3,322 2,911 2016 113 500 993 115 1,721 900 48 948 2,669 Free Cash Flow A 10 pts A 10 pts Below use Year-end Assets, Equity, not AVG Compute Sustain Growth % 2018 2017 for 2 Yrs Net Profit Margin 'd' Div Payout Debt / Equity Assets / Sales Numerator Denoninator Current Liabilities Debt Payable - Current Liabilities Account Payable/Creditors - Trade Current Liabilities - Other Current Liabilities Total Long-Term Debt Total Deferred Taxes and Investment Tax Cre Long-Term Liabilities Total Liabilities Total Shareholders' Equity Total LIABILITIES + SHAREHOLDERS' EQUITY 2018 3 194 241 437 497 84 581 1,019 2,303 3,322 2017 10 148 194 351 412 51 463 814 2,097 2,911 2016 10 109 156 276 380 81 460 736 1,933 2,669 S.G.R. (end-yr Equity) >> 10 pts 10 pts 2018 752 138 47 2017 579 127 2018 176 continued from lower left Capital Expenditures Other Cash Flow from Investin INVESTING ACTIVITIES - NET 2017 120 -59 -179 2 -174 -18 STATEMENT OF CASH FLOWS Income Before Extraordinary Items Depreciation and Amortization Adjustments to Net Income Accounts Receivable - Decrease (Increa Inventory - Decrease (Increase) Accounts Payable and Accrued Liabilite Other Changes in Operation Activities OPERATING ACTIVITIES - NET CASH FLC -120 193 93 -42 674 -104 -76 74 3 585 2016 499 104 32 -40 -81 -46 46 514 Common and Preferred Stock Cash Dividends Other - Increase (Decrease) FINANCING ACTIVITIES - NET -90 442 0 -73 369 0 -407 -446

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan

15th edition

978-0133428704

Students also viewed these Accounting questions

Question

What is the adverse effects of the Anticholinergics Agents

Answered: 1 week ago