Answered step by step
Verified Expert Solution
Question
1 Approved Answer
OUTPUT Cash Flow Statement (000's) Year 2 Ratio Analysis Year 1 Year 2 US's Business Revenue Growth Net Income Plus Depreciation Plus Amortization on Intagibles
OUTPUT Cash Flow Statement (000's) Year 2 Ratio Analysis Year 1 Year 2 US's Business Revenue Growth Net Income Plus Depreciation Plus Amortization on Intagibles Deffered Taxes Cash Income Asia's Business Gross Margin EBITDA Margin Accounts Receivable Days Inventory Days Days Days Quick Ratio ROE Total Debt / EBITDA (Leverage) Working Capital Activities Accounts Receivable Inventory Prepaid Expenses Other Current Assets Accounts Payable Accrued Income Taxes Accrued Expenses Other Current Liabilities Total Change in Working Capital Operating Cash Flow (OCF) Investment Activities Capital Expenditures Investments (Change) Total Investment Activities Cash Available Before Financing Activities Financing Activities ST Debt Payments LT Payments Equity Contribution Total Financing Activities Free Cash Flow Beginning Cash DOO Ending Cash Year 1 Year 2 Year 1 Year 2 Balance Sheet (000's) Current Assets Cash Accounts Receivable Inventories Prepaid Expenses Other Current Assets Total Current Assets 50,000 23,500 18,000 5,000 36,800 30,000 22,000 3,000 5,000 96,800 Income Statement (000's) Revenues by Geography U.S. Europe Asia Total Revenue 300,000 180,000 120,000 600,000 320,000 160,000 200,000 680,000 3,500 100,000 Cost of Revenues by Geography U.S. Europe Asia Total Cost of Revenue 120,000 80,000 60,000 260,000 128,000 72,000 100,000 300,000 Property and Equipment Land Building Furniture & Equipment Total Gross P&E Less Accumulated Depreciation Net P&E 1,500,000 120,000 80,000 1,700,000 (200,000) 1,500,000 1,500,000 200,000 100,000 1,800,000 (250,000) 1,550,000 Gross Profit 340,000 380,000 Intagibles Assets Long-Term Investments Total Assets 200,000 200,000 2,000,000 180,000 250,000 2,076,800 Operating Expenses EBITDA Depreciation Amortization of Intagibles EBIT Interest Expense EBT Taxes Net Income 120,000 220,000 45,000 20,000 155,000 30,000 125,000 27,500 97,500 125,000 255,000 50,000 20,000 185,000 25,000 160,000 35,200 124,800 Liabilities and Owners Equity Current Liabilities Accounts Payable Accrued Income Taxes Accrued Expenses Other Current Liabilities Current Portion of Long Term D Total Current Liabilities 18,000 7,000 4,000 2,000 9,000 40,000 21,000 10,000 3,000 1,000 11,000 46,000 Long-Term Debt: Deferred Income Taxes Total Liabilties 571,000 14,000 625,000 471,000 20,000 537,000 Owners' Equity Common Stock Paid-in-Capital Retained Earnings Total Owners' Equity 1,000,000 100,000 275,000 1,375,000 1,000,000 140,000 399,800 1,539,800 Total Liabilities & Owner's Equit 2,000,000 2,076,800
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started