DCF_Template_Sigma.xlsm - Investment Banking How to use...

This preview shows page 1 - 4 out of 19 pages.

Investment BankingHow to use this DCF with the Factset links:Valuation, Leveraged Buyouts,1. Get Factset and the Factset ribbon for exceland Mergers & Acquisitions2. Get the company ticker from factset and put it in the ticker symbol field3. Press the leftmost button4. Use Factset - Refresh - Workbook5. Press the other two buttons6. ProfitTicker symbolNYSE:BPCurrencyNATIVE CurrencyName of company0.00Country0.00Sector0.00Last stock price#N/A0.00
FinancialsMillions of 12/30/189912/30/189912/30/189912/30/1899Balance SheetCash And ST Investments- - - - Cash- - - - ST Investments- - - - Receivables (Net)- - - - Total Inventories- - - - Raw Materials- - - - Work In Progress- - - - Finished Goods- - - - Progress Payments & Other - - - - Prepaid Expenses - - - - Other Current Assets- - - - Current Assets - Total- - - - Long Term Receivables- - - - Investment In Unconsol Subsidiaries- - - - Other Investments- - - - Property Plant and Equipment - Net- - - - Property Plant Equip - Gross- - - - Land - - - - Buildings- - - - Machinery & Equipment- - - - Rental/Lease Property- - - - Transportation Equipment- - - - Property Plant & Equipment - Other- - - - Property Plant & Equip Under Capitalized - - - - Accumulated Depreciation- - - - Accum Depr - Land- - - - Accum Depr - Buildings- - - - Accum Depr - Machine, Equipment- - - - Accum Depr - Leases- - - - Accum Depr - Transport Equipment- - - - Accum Depr - Other PP&E- - - - Other Assets- - - - Deferred Charges- - - - Tangible Other Assets- - - - Intangible Other Assets- - - - Total Assets- - - - Accounts Payable- - - - Short Term Debt And Cur Portion of LT Debt- - - - Accrued Payroll- - - - Income Taxes Payable- - - - Dividends Payable- - - - Other Current Liabilities- - - - Current Liabilities - Total- - - - Long Term Debt- - - - LT Debt Excluding Capitalized Leases- - - - Capitalized Lease Obligations- - - - Provision For Risks And Charges- - - - Deferred Income- - - - Deferred Taxes- - - - Deferred Taxes - Credit- - - - Deferred Taxes - Debit- - - -
Deferred Tax Liability In Untaxed Reserves- - - - Other Liabilities- - - - Total Liabilities- - - - Non-Equity Reserves- - - - Minority Interest- - - - Preferred Stock- - - - Common Equity- - - - Common Stock- - - - Capital Surplus- - - - Revaluation Reserves- - - - Other Appropriated Reserves- - - - Unappropriated (Free) Reserves- - - - Retained Earnings- - - - Equity In Untaxed Reserves- - - - ESOP Guarantees- - - - Unrealized Foreign Exchange Gain/Loss- - - - Unrealized Gain/Loss On Marketable Securit - - - - Treasury Stock- - - - Total Liabilities & Shareholders' Equity- - - - Common Size Balance SheetCash And ST Investments#DIV/0!#DIV/0!#DIV/0!#DIV/0!Cash#DIV/0!#DIV/0!#DIV/0!#DIV/0!ST Investments#DIV/0!#DIV/0!#DIV/0!#DIV/0!Receivables (Net)#DIV/0!#DIV/0!#DIV/0!#DIV/0!Total Inventories#DIV/0!#DIV/0!#DIV/0!#DIV/0!Raw Materials#DIV/0!#DIV/0!#DIV/0!#DIV/0!Work In Progress#DIV/0!#DIV/0!#DIV/0!#DIV/0!Finished Goods#DIV/0!#DIV/0!#DIV/0!#DIV/0!Progress Payments & Other #DIV/0!#DIV/0!#DIV/0!#DIV/0!Prepaid Expenses #DIV/0!#DIV/0!#DIV/0!#DIV/0!Other Current Assets#DIV/0!#DIV/0!#DIV/0!#DIV/0!Current Assets - Total#DIV/0!#DIV/0!#DIV/0!#DIV/0!Long Term Receivables#DIV/0!#DIV/0!#DIV/0!#DIV/0!Investment In Unconsol Subsidiaries#DIV/0!#DIV/0!#DIV/0!#DIV/0!Other Investments#DIV/0!#DIV/0!#DIV/0!#DIV/0!

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture