Pro Forma Financial StatementsSlide 2Generic Forms: Income StatementGeneric Forms: Balance SheetGeneric Forms: BridgeSlide 6BridgeThe Forecasting ProcessThe Process…Slide 10Slide 11Slide 12Slide 13Slide 14A Circularity Rather Than A BridgeInteractions…ExampleSlide 18PRO FORMA FINANCIAL STATEMENTSPRO FORMA FINANCIAL STATEMENTSProjected or “future” financial statements.The idea is to write down a sequence of financial statements that represent expectations of what the results of actions and policies will be on the future financial status of the firm.Pro forma income statements, balance sheets, and the resulting statements of cash flow are the building blocks of financial planning.They are also vital for any valuation exercises one might do in investment analysis or M&A planning. Remember, it’s future cash flow that determines value.Financial modeling skills such as these are also one of the most important skills (for those of you interested in finance or marketing) to develop.GENERIC FORMS: INCOME STATEMENTSales (or Revenue)Less Cost of Goods SoldEquals Gross Income (or Gross Earnings)Less Operating ExpensesEquals Operating IncomeLess DepreciationEquals EBITLess Interest ExpenseEquals EBTLess TaxesEquals Net Income (Net Earnings, EAT, Profits)GENERIC FORMS: BALANCE SHEETAssetsCashAccounts ReceivableInventoryPrepaid TaxesMarketable SecuritiesTotal Current AssetsGross PP&EAccumulated DepreciationNet PP&ELandTotal AssetsLiabilities + O’s EquityBank LoanAccounts PayableWages PayableTaxes PayableCurrent Portion – L-T DebtTotal Current LiabilitiesLong-Term DebtPreferred StockCommon StockRetained EarningsTotal Liabilities + EquityGENERIC FORMS: BRIDGEClearly we can’t hope to get anywhere if we develop separate forecasts of the different statements. The income statement records the effect of a given year while the balance sheets show the situation at the beginning of and after that year.Furthermore the balance sheet must balance.The two statements must therefore be intimately linked. There must be a “bridge” between them.GENERIC FORMS: BRIDGEOne important bridge is:Net Income – Dividends = Change in Retained EarningsAn income statement amount less dividends equals a balance sheet amount.Another is:Interest Expense = Interest Rate Interest Bearing DebtAn income statement amount equals a balance sheet amount times a cost figure.These simple relations, plus requiring the balance sheet to balance, tie the income statement directly to the balance sheet and vice versa.BRIDGESales (or revenue)Less COGSEquals Gross Income Less Operating Exp Less DeprEquals EBITLess Interest ExpEquals EBTLess TaxesEquals Net Inc (EAT)Less DividendsChange in Retained EAssetsCashAccts RecInventoryPrepaid Taxes Total Current AssetsGross PP&EAccumulated Depr.Net PP&ELand Total AssetsLiabilities + Owner’s EBank LoanAccts PayWages PayTaxes Pay Total Current LiabL-T DebtCommon StockRetained Earnings Total Liab + OEIncome Statement Balance SheetTHE FORECASTING PROCESSThe most common way to proceed is to fill in the income statement first. The standard approach is called “percent of sales forecasting.”Why?: You first get the sales (or sales growth) forecast.Then, you project variables having a stable relation to sales using forecasted sales and the estimated relations.Then there is the rest.THE PROCESS…How would we describe and estimate the following:COGSOperating expensesDepreciation & AmortizationInterest expenseTaxesTHE PROCESS…COGS will generally vary directly with sales. If not, it is likely that something has gone (or is going) very wrong.Calculate the COGS/Sales ratio for the last few years. Multiply a forecast for this ratio times the forecast for sales to find a forecast for COGS.How do we forecast the COGS/Sales ratio?Note that there may also be a fixed component for some of these relations. How do you adjust?Operating expenses is a good example.THE PROCESS…We then require estimates of the components of expenses that don’t vary directly (and in a stable way) with sales to complete the income statement.Other ExpensesOther IncomeDepreciationTaxesNet IncomeDividendsTHE PROCESS…From the completed income statement, determine the change in retained earnings, transfer it to the balance sheet.Now we have to fill out the rest of the balance sheet.Many of the current assets and liabilities (accounts receivable, accounts payable, inventory, wages payable, etc.) can be expected to vary directly with sales.Forecast these as we just described.THE PROCESS…The cash balance is usually determined by a policy decision via some inventory (of liquidity) model.Alternatively this account may be used as a “plug.”Changes in Gross PP&E are also the result of policy decisions as are changes in preferred or common stock.Often short-term (bank loan or line of credit) or long-term debt is used as a residual to determine the required new financing (a plug to make it balance).But don’t forget that these can’t be chosen in isolation.THE PROCESS…Interest expense comes from the amount of interest bearing debt.Interest expense effects net income,Which effects changes in retained earnings,Which, through the equality requirement for the balance sheet, effects the amount of interest bearing debt that is necessary.The two statements are intimately connected.A CIRCULARITY RATHER THAN A BRIDGESales (or revenue)Less COGSEquals Gross Income Less Operating Exp Less DeprEquals EBITLess Interest ExpEquals EBTLess TaxesEquals Net Inc (EAT)Less DividendsChanges in Retained EAssetsCashAccts RecInventory Total Current AssetsGross PP&EAccumulated Depr.Net PP&ELand Total AssetsLiabilities + Owner’s EBank LoanAccts PayWages PayTaxes Pay Total Current LiabL-T DebtCommon StockRetained Earnings Total Liab + OEINTERACTIONS…The income statement “equation” can be written:[Rev – Operating Exp – Depr&Amort - (Int Bearing Debt)(Int Rate)](1- Tax Rate)- Dividends = Change in retained earningsThe balance sheet “equation” is written:Total Assets = Accts Pay + Wages Pay + Taxes Pay + Int Bearing Debt + Common Stock + Change in retained earningsInterest bearing debt is the unknown in each equation.If we just substitute the LHS of the income statement equation for
View Full Document