Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone please solve this in an excel worksheet? 2009 35.00% 2,000 4,000 OUTPUT Source Use Operating Investing Financing 2014 10,000 $ 6,000 $ 8,000

image text in transcribed
can someone please solve this in an excel worksheet?
2009 35.00% 2,000 4,000 OUTPUT Source Use Operating Investing Financing 2014 10,000 $ 6,000 $ 8,000 $ 8,000 $ 32,000 $ 2013 Chance 6,000 1,500 10,000 9,000 26,500 Additional Input Data for 2014: Effective Tax rate Stock dividends paid $ Depreciation Expense $ Balance Sheet Assets Cash $ Accounts Receivable $ Inventory $ Net Property, Plant & Equipment $ Total Assets $ Liabilities & Stockholders' Equity Accounts Payable $ Accrued Expenses $ Long-term Note Payable $ Total Debt $ Preferred Stock $ Common Stock $ Retained Earnings $ Total Liabilities & Stockholders' Equity $ Income Statement 2014 Sales $ $ Cost of Goods Sold $ Gross Profit $ Operating Expenses (including depreciation) EBIT Interest Expense EBT 4,000 $ 1,000 $ 10,000 $ 15,000 $ 800 $ 10,000 $ 6,200 $ 32,000 $ 5,800 2,000 10,000 17,800 700 5,000 3,000 26,500 change in cash CFO CFI CFF 135,000 108,000 27,000 16.000 11,000 3.000 8,000 2,800 5,200 Tax S Net income from continuing operations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Financial Markets And Institutions

Authors: Jeff Madura

10th Edition

1285531507, 9781285531502

More Books

Students also viewed these Finance questions