Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need excel looks like this This is excel cash flow 2021 Statement of Cash Flows Source/(Use) Cash, beginning of year Operating activity Net income Plus:

image text in transcribedimage text in transcribedNeed excel looks like this

This is excel cash flow

2021 Statement of Cash Flows Source/(Use) Cash, beginning of year Operating activity Net income Plus: Depreciation Source/(Use) of Cash from: Change in accounts receivable Change in Inventory Change in Non Current Assets Change in Accounts Payable Change in Other Current Liabilities Net cash from operating activity Investment activity Fixed asset acquisitions Net cash from investment activity Financing activity Change in notes payable Change in long-term debt Change in othe Long term liabilities Dividends paid Common Stock Repurchase Change in common stock Net cash from financing activity Net increase in cash Cash, end of year CHECK YOUR WORK!! Do these 2 cells match cells J6 & K6??) 2021 Inc/(Dec) 2020 2021 Inc/(Dec) 90,943 16,120 4,061 111,124 175,998 (9,614) (6,806) (45) (16,465) 2,449 42,296 8,773 54,323 Balance Sheet - Liabilities & Equity Liabilities and Owners' Equity Current liabilities Accounts payable Current Portion Notes payable Other current liabilities Subtotal Current Liabilities Long-term debt Other Long term liabilities Owners' equity Common stock & paid-in surplus Retained earnings Subtotal Equity Total liabilities & owners' equity 46,236 10,260 49,222 105,718 91,807 50,503 (3,940) (1,487) 5,101 (326) 6,860 98,667 54,490 803 3,987 36,766 323,888 (612) (14,628) 44,590 45,898 90,488 338,516 50,373 14,966 65,339 5,783 (30,932) (25,149) (14,628) 2021 Income Statement -2021 $ in Thousands Balance Sheet - Assets 2020 Sales $274,515 Assets Cost of goods sold 169,559 Current assets Gross Margin 104,956 Cash 100,557 Research & Development Expense 18,752 Accounts receivable 22,926 Selling and Administrative Expense 11,481 Inventory 4,106 Depreciation 6,829 Subtotal Current Assets 127,589 Earnings before interest and taxes $67,894 Non Current Assets 173,549 Interest owed Fixed assets Taxable income $67,091 Net plant and equipment 37,378 Taxes (21%) 9,680 Total Assets 338,516 Net income $57.411 Dividends 14,087 Statement of Cash Flows Source/(Use) Common Stock Repurchased 74,256 Cash, beginning of year Addition to retained earnings (30,932) Operating activity Net income This is the section where you present NEWCO's "Financial Story" Plus: Start typing in this box..... Depreciation Source/(Use) of Cash from: Change in accounts receivable Change in Inventory Change in Non Current Assets Change in Accounts Payable Change in Other Current Liabilities Net cash from operating activity Investment activity Fixed asset acquisitions Net cash from investment activity Financing activity Change in Fixed Assets Ending Fixed Assets Add back non cash impact from Depreciation Adjusted Ending Fixed Assets Beginning Fixed Assets Incr/Decr) in Fixed Assets

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

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

More Books

Students also viewed these Accounting questions

Question

Develop successful mentoring programs. page 418

Answered: 1 week ago