Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please forecast cash flow for the data attached for over a five year period - template is attached. Income Statement All numbers in thousands Revenue

Please forecast cash flow for the data attached for over a five year period - template is attached.

image text in transcribed Income Statement All numbers in thousands Revenue 12/31/2015 Total Revenue Cost of Revenue Gross Profit 259,488,000 165,590,000 93,898,000 Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss 61,444,000 1,523,000 18,048,000 12,883,000 Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops 1,750,000 22,277,000 311,000 21,966,000 5,415,000 5,999,000 23,794,000 Nonrecurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 16,150,000 16,150,000 Balance Sheet All numbers in thousands Period Ending Current Assets 12/31/2015 Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets 3,705,000 19,875,000 16,245,000 2,798,000 42,623,000 34,245,000 251,605,000 8,285,000 336,758,000 Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities 35,214,000 18,762,000 53,976,000 25,342,000 43,812,000 36,818,000 5,999,000 165,947,000 Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets 11,612,000 412,444,000 229,734,000 23,511,000 170,811,000 170,811,000 Financial Statement Forecasting (Session 2) Assumptions Short term interest rate 15.0% Long-term interest rate 5.0% Inflation Rate 2.5% growth Income Statement Sales Cost of Sales COS as a % of Sales Gross Profit Gros Profit Margin SG&A SG&A as % EBIT (or Operating Income) Interest Expense EBT Taxes @ Net income Dividends (50% POR) Add. to retain. earnings 38% growth growth 2016E 2000.00 1500.00 75% 500.00 25% 100.00 5.0% 400.00 38.00 362.00 137.56 224.44 112.22 112.22 10% 2017P 2200.00 1650.00 75% 550.00 25% 102.50 4.7% 447.50 30.80 416.70 158.35 258.35 129.18 129.18 25% 2018P 2750.00 2062.50 75% 687.50 25% 105.06 3.8% 582.44 26.00 556.44 211.45 344.99 172.50 172.50 15% 2019P 3162.50 2371.88 75% 790.63 25% 107.69 3.4% 682.94 26.00 656.94 249.64 407.30 203.65 203.65 2016 2017 2018 2019.0 26.62 94.80 385.99 519.09 1026.50 Balance Sheet Assets Cash and securities Short Term Investments Accounts receivable Inventories Total current assets 20.00 22.00 290.00 390.00 700.00 319.00 429.00 770.00 24.20 22.65 350.90 471.90 869.65 Net fixed assets 500.00 550.00 605.00 665.50 1200.00 1320.00 1474.65 1692.00 90.00 10.00 80.00 180.00 520.00 700.00 99.00 11.00 32.01 142.01 520.00 662.01 108.90 12.10 119.79 13.31 121.00 520.00 641.00 133.10 520.00 653.10 Total assets Liabilities & Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Preferred Stock Common stock (50M shares @ $1) Additional Paid-In Capital Cumulative Retained earnings Total equity Total liab. & equity AFN (additional funds needed) 75.00 50.00 150.00 225.00 500.00 100.00 50.00 150.00 354.18 654.18 100.00 50.00 150.00 526.67 826.67 100.00 50.00 150.00 730.32 1030.32 1200.00 1316.19 1467.67 1683.42 0.00 3.81 6.98 8.58

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

Investing In Financial Research A Decision Making System For Better Results

Authors: Cheryl Strauss Einhorn, Tony Blair

1st Edition

1501732757, 9781501732751

More Books

Students also viewed these Finance questions

Question

2. Do not crowd the student. Do not get in the students face.

Answered: 1 week ago

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago

Question

1. Background knowledge of the subject and

Answered: 1 week ago