Modeling and Financial Analysis Powerpoint

Held inventory x cost of goods sold 365 inventory

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: s AR (Days Sales Outstanding) Accounts Receivable x 365 Revenue Inventory (Days Inv. Held) Inventory x Cost of Goods Sold 365 Inventory (Inventory Turns) Cost of Goods Sold Inventory AP (Days Payable Outstanding) Accounts Payable x 365 Cost of Goods Sold Balance Sheet —Uses (and sources) of cash —Current assets —Current liabilities —PP&E —Reserves – depletion and replacement —Capitalization —Debt —Revolver Projection Models —Alternative cases —Management case —Base case —Upside case —Downside case Financial Modeling Projection model example Financial Analysis Financial Analysis — Evaluation of a company’s financial performance, financial condition, capitalization and publicly-traded security (stock) price performance — Independently and compared to its peers — Trend analysis — Analysis of an investment or financing decision — Returns analysis — Sensitivity analysis Stock Price and Volume Analysis Superior Energy (SPN) 12 Month Stock Price and Volume Performance Source: Yahoo Finance. Stock Volume at Certain Prices Stockholder Analysis —5% holders —Institutional holders —Insiders — Management and directors —Public Float — Amount of stock that is available for trading Institutional Holders Source: Iberia Capital Partners research report for Baker Hughes. Insider Holders Source: Burkenroad Petroquest research report. Capitalization Table XYZ Company Capit alizat ion Table Fred Jones Mike S it h m Ted Johnson Maria S anson w Ot her Management Tot al Management S rah Henry a Jill Thompson Mark Kennedy Ot her Tot al Ownership S ares h 40,000 40,000 25,000 30,000 35,000 170,000 Percent 20.6% 20.6% 12.9% 15.4% 18.0% 87.4% 5,000 5,000 2,500 12,000 2.6% 2.6% 1.3% 6.2% 194,500 100.0% Capitalization Table Founders Common Shareholder Name Person A Person B Person C Person D Employee and Director Options Subtotal: Common Date of Issue 8/4/98 8/4/98 8/4/98 Number of Shares Strategic Acquisition Stock Option Pool Common A Round (Angels) % of Total 5,100,000 2,100,000 300,000 Investment @ $0.10/sh...
View Full Document

Ask a homework question - tutors are online