LBO投资收益测算过程

第一部分：确定投资资金的结构一、近3年一期损益表，并预测近一期的完整年度损益表；现时资产负债表;IncomeStatement2005Historic日IPeriodLTM9/30/2008Proforma200820062007Sales$780.0$850.0$925.0$977.S$1,000.0%growthNA9.0%8.8%NA8.1%CostofGoodsSold471.9512.1555.0585.7600.0GrossProfit$308.1$337.9S37D.0$391.1$400.0%margin395%39.8%40.0%40.0%40.0%SellingGeneral&Administrative198.9214.6231.3244.4250.0%sales255%253%25.0%25.0%25.0%OtherExpense/(Income]-----EBITDA$109.2S123.35138.8$146.7$150.0%margin14.0%14.5%15.0%15.0%15.0%Depreciation&Amortization15.617.018.519.620.0Amortization-----EBIT593.6$106.3$120.35127.1$130.0%margin12.0%12.5%13.0%13.0%13.0%BalanceSheet□penimg如CIBCashandCashEquivalentsS25.D：AccountsReceivable155.D：Inventories125.D：PrepsidsandOtherCurrentAssets 1口⑪TotalCurrentAssets5325.D：Property.PlantandEquipment,net55D.D：GoodwillandIntangibleAse175.0：OtherAssetB75.0：[JeferredFinancingFeesTotalAsset51卯色AccountsPayable75.0：AccruedLiabilities100.0：OtherCurrentLiabilities25⑪TotalCurrentLiabilities52DD.D：RevolvingCreditFacility-।TemnLoanA-।TemnLcian日-।TermLoanC-।ExistingTermLoan3DD.D：2ndLien-।SeniorMotes-।SeniarSubordinst-sdNotem-।OtherDebt-।OtherLcirig-TErmLiabilities 25⑪TotalLiabilities5525.0：NonocintrallmgInterest-;Shsreholder^Equity7口口.口:TotalShmreholders1Equit57D0.0：TotalLiabilitiesiandEquityS1.225.口;Sa/anceGhedf0.000MetWorkingCspitsl r100.0(IncresBs)/E^ecresssinNetViforkingCspit*、计算购买价格及估值比率根据投资时的EBITDA146.7（损益表）及假设的估值/EBITDA倍数7.5倍，计算确定标的收购价格=146.7*7.5=1100；现时需要偿还的有息借款300（资产负债表）、现金25根据投资时的EBITDA146.7（损益表）及假设的估值/EBITDA倍数7.5倍，计算确定标的收购价格=146.7*7.5=1100；现时需要偿还的有息借款300（资产负债表）、现金25（资产负债表），标的现金偿还有息负债后剩余275有息负债；公司股权价值=1100-275=825。Purch-seP「他已OfferPriceperShareFullyDilutedSharesEc|uityPurchasePricePlus:ExistingNetDebtEnterpriseValu&$165050.0$825.0275.0TmnsactionMulti1MesEnterpriseValueISales根据购买价格及现时销售额、函Tda计算市销率和:设计投资资金结构E、设计含蝎南普乔^ITDA1:000,01.1x市值/EBITDA比。12Structu「2345Sou「cr与ofFund与Structure1Structure2Structure3Structure4St-tu与QuoRevokingCreditFacilitySize$100.0$100.0$100.0$100.0-RevoltngiCreditFacilityDraw--25.0--TermLoanA-125.0---TermLoanB450.0350.0350.0425.0-TermLoanC-----2ndLien-----SeniorNotes--150.0--SeniorSubordinatedNotes300.0300.0250.0325.0-EquityContribution385.Q360.0385.0410.020.0RolloverEquity-----CashonHand25.025.0---TotalSourcesofFundsti.iMLn*t11KOO<1i«n.nODOUse导ofFund5EquityPurchasePrice$825.0$825.0$825.0$825.0-RepayExistingBankDebt300.0300.0300.0300.0-Tender/CallPremiums-----FinancingFees20.020.020.020.020.0Othe「Fmm号andExpenses15.015.015.015.0TotalUsesofFundsciwnnciifiinn初1ann*70nFinajncinciStnjctu「es确定各类举债金额（structure1中450、300，注意100是循环信用额度，类似授信总额，不使用无金额借入，但有手续费）及手续费（20结构化私募基金中为各类优先级份额/LP的资金金额及手续费），预计其他费用（15）；据前文已得股权价格825、有息负债300、标的账上现金25,算出需要自有投入的资本数额（基金中的劣后级或GP份额）=（825+300+20+15）-（450+300+25）=385，杠杆率为385：（450+300）=1:1.95。手续费计算如下:将上述举债费用按假定的借款年限摊销（利润表及资产负债表预测时需要使用）：四、完成SourcesofFunds\UsesofFunds表并和签署已做PurchasePrice\TransactionMultiples表合并:TransactionSummarySourcesofFundsUsesofFundsPurchasePrice%ofTotalMultinleofEBITDA%ofTotalOfferPriceperShareFullyDilutedSharesS16.50AmountSources9/30/2008 CumulativePricingL+325bpsAmountUses50.0RevolvingCreditFacility-%RjrchaseValueCoEquity$825.071.1%EquityPurchasePrice1325.0TermLoanA-%NARepayExistingDebtTender/CallPremiums300.025.9%Plus:ExistingNetDebt2750TermLoanB450.038.8%3.1x3.1xL+350bpsg-%EnteroriseValue<11000TermLoanC-%3.1xFinancingFees20.01.7%2ndLien--%3.1xOtherFeesandExpenses15.01.3%LSeniorNotes--%3.1xNABiterpriseValue/SalesSeniorSubordinatedNotes300.025.9%2.0x5.1x10.000%LTM9/30/2008 S977.81.1xEquityContribution3S5.033.2%2.6x7.7x2OO8E 1,000.01.1xRolloverEquity-%7.7xEnterpriseValue1EBITDACashonHand 250 22%7.9xLTM9/30/2008 S146.77.5xTotalSources$1,160.0100.0%7.9x7.9xTotalUses$1,160.0100.0%2OO8E 150.073x第二部分：预测未来财务数据五、损益表和现金流量表预测前提假设条件（一）销售收入：假设各年的销售收入增长率,一般发展稳定后销售收入增长趋缓:（一）销售收入：假设各年的销售收入增长率,一般发展稳定后销售收入增长趋缓:Yearl2009ProjectionPeriodYear102018Year22010Year32011Year42012Year52013Year62014Year72015Year82016Year92017ncomeStatementAssumptionsSales(%growth)8.0%6.0%4.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%Base18.0%6.0%4.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%Sponsor210.0%8.0%6.0%4.0%3.0%3.0%3.0%3.0%3.0%3.0%Management312.0%10.0%8.0%6.0%4.0%4.0%4.0%4.0%4.0%4.0%Downside145.0%4.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%Downside252.0%2.0%2.0%2.0%2.0%2.0%20%2.0%2.0%2.0%

（二）成本：成本以销售收入为基础，假设成本占销售收入的百分比:CostofGoodsSold(%sates)60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%Base160.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%Sponsor260.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%60.0%Management359.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%59.0%Downskle1461.0%61.0%61.0%61.0%61.0%61.0%61.0%61.0%61.0%61.0%Downside2562.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%62.0%（三）SG&A（国内为销售费用和管理费用）：假设占销售收入的百分比:SG&A(%safes)25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%Base125.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%Sponsor225.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%Management3240%240%240%240%240%24.0%24.0%24.0%24.0%24.0%Downside1426.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%25.0%Downside2527.0%26.0%26.0%26.0%26.0%26.0%26.0%26.0%26.0%26.0%（四）折旧和摊销：假设占销售收入的百分比:Depreciation&Amortization(%sales)2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%20%Base12.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%Sponsor22.0%2.0%2.0%2.0%2.0%20%2.0%2.0%2.0%20%Management32.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%Downside142.0%2.0%2.0%2.0%2.0%20%2.0%2.0%2.0%20%Downside252.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%（五）利息收入：假设占现金（根据后续预测的现金流量表中的相邻2年现金平均数）的百分比（即1年期利率？）：3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%39%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%Base 1Sponsor Base 1Sponsor 2Management 3Downside1 4Downside2 53.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%（六）现金流量表中资本化支出：假设占销售收入的比率CashFlowStatementAssumptionsCapitalExpenditures(%sales)2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%Base12.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%Sponsor220%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%Management320%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%Downside142.5%2.5%2.5%2.5%2.5%25%2.5%2.5%2.5%2.5%Downside252.5%25%2.5%2.5%25%2.5%2.5%2.5%2.5%2.5%六、资产负债表预测前提假设条件（一）应收账款周转天数：假设应收账款周转天数，应收账款=销售收入/365*应收账款周转天数ProiectionPeriod

Year1Year2Year3Year4Year5Year6Year7Year8Year9Year10

2009 2010 2011 2012 2013 2014 2015 2016 2017 2018CurrentAssetsDaysSalesOutstanding(DSO)60.260.260.260.260.260.260.260260.260.2Base160.260.260.260.260.260.260.260.260.260.2Sponsor260260.260.260.260260.260.260.260.260.2Management365965.065.065.065065.065.065,065.065.0Downside1459.059.059.059.059059.059.059.059.059.0Downside2557757757.757.757757.757.757.757.757.7（二）存货周转天数：假设存货周转天数，存货=成本/365*存货周转天数DaysInventoryHeld(DIH)76.076.076076.076.076.076076.076.076.0Base176.076.076.076.076.076.076.076.076.076.0Sponsor276.076.076.076.076.076.076.076.076.076.0Management376.076.076076.076.076.076.076.076.076.0Downside1480.080.080.080.080.080.080.080.080.080.0Downside2582.082.082.082.082.082.082.082.082.082.0（三）预付款项：假设占销售收入的百分比:

PrepaidsandOtherCurrentAssets(%PrepaidsandOtherCurrentAssets(%sales)BaseSponsorManagementDownside1Downside21.0%10%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%11.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%210%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%31.0%10%L0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%41.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%51.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%（四）应付账款周转天数：应付账款=成本/365*应付账款周转天数CurrentLiabilitiesDaysPayableOutstanding(DPO)45.645,645.645.645.645.645.645.645.645.6Base145.645645645645645.645.645.645.645.6Sponsor245.645645645645645.645.645.645.645.6Management347.04L047J47947947.047.047.047.047.0Downside1442.542.542.542.542.542.542.542.542.542.5Downsfcle2540.040.040.040.040.040.040.040.040.040.0（五）应计债务：假设占销售收入的百分比AccruedLiabilities(%sales)10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%Base110.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%Sponsor210.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%Management310.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%Downside1410.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%Downside2510.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%（六）其他流动负债：假设占销售收入的百分比七、利润表预测（收入、债表做出后才能做）七、利润表预测（收入、债表做出后才能做）成本EBIT部分，净利润部分需要扣减的财务费用，即利息，得还IncomeStatementP『ojtctEn1LTMProformaYear1Year2Year3Year4Year52皿B2皿9201020口2cM22cH3SalesS977JB$1,000.0$1,080.0J1.144.3$1,190.6$1,226.3$1,263.1%growthNA8.1%8.0%6.0%4.0%3.0%30%CostofGoodsSold BODO714一4735石757.9Gross.Profit1391.1(400.0$4321$457,95476.2$490,5$5O5,2%margin40.0%40.0%40.0%40.0%40.0%40.0%40.0%Selling,General&Administrate244.4250.0270.0236.2297.6306.6315.3%sates25.0%25.0%25.0%25.0%25.0%25.0%25.0%Other&pense/(Income)EBITDAJ146.7$〔50,。$162,0$171,7$17B,6$183.9%margin15.0%15.0%15.0%15.0%15.0%15.0%15.0%Depreciation&Amortization 20023B245AmortizationEBIT1127.1$130,0$140,4$143,3$154,8$159,4$1S4,2%margin13.0%13.0%13.0%13.0%13.0%13.0%/nieresfEcpenseRevolvingCreditFacility------TermLoanA------TermLoanB29.327.S25.322.11S.614.5TermLoanC------BcistingTermLoan------2ndLienr------SeniorNotes------SeniorSubordinatedNotes30.030.030.030.030.030.0CommitmentFeeonUnusedReAdministrativeAgentFee Q2_42ON020.2CashInterestExpenser$59,9$58,5£55.9152.739.2S45.2红框内为利息支出，需要其他表格（还贷计划表中的利息支出等）数据，暂不考虑；销售收入、成本、销售管理费用、折旧及摊销等按照签署假设填入。八、资产负债表预测

（一）由于投资基准日不是完整会计年度（例子中是2008年9月30日），所以需要对930资产负债表按照投资后调整，亿预测2008年年度资产负债表。2。08+-2口082009CashandCashEquivalents$25.0i(25.0)--AccountsReceivable165.0；165.0173.2Inventories125.0：125.0135.0PrepaidsandOtherCurrentAssets10.0：10.010.8TotalCurrentAssets$325总;$300.0$324.0Property,FlantandEquipment,net650.0i650.0650.0GoodwillandIntangibleAsse'175.0；125.0300.0300.0OtherAssets75.0；75.075.0DeferredFinancingFees-!20.020.0■17.5TotalAssets$1“225Q1$1,345.0$1.366.5AccountsPayable75.0■75.081.0AccruedLiabilities100.0；100.0103.0OtherCurrentLiabilities25.0：25.027.0TotalCurrentLiabilities$200.0：$200.。$216.。Revolvinc;CreditFacility-:---TermLoanA-!---TermLoanB-•450.0450.0406.3TermLoanC-----ExistingTermLoan300.0：(300.0)--2ndLien-!---SeniorNotes-•---SeniorSubordinatedNotes-:300.0300.0300.0OtherDebt---OtherLong-TermLiabilities25.0725.025.0TotalLiiabilities$525.0i$975.0$947.3NoncontrollingInterest-:--Shareholders'Equity700.0：370.0(700.0'370.0419.3TotalShareholders'Equity$700.0：$370.0$419,3TotalLiiabilitiesandEquity—$1225.。1-$1.345.0-$1,366.5CashandCashEquivalents：标的账上现金25会支出使用（用于还债？）GoodwillandIntangibleAssets：商誉及无形资产增加125，因为股权收购价格825相对于标的净资产700的溢价125计入商誉及无形资产。DeferredFinancingFees：递延融资费用，投举债在所花的融资费用20TermLoanB：投资举债，标的增加450借款ExistingTerm1。3门：已存在的有息负债300会在投资后还掉SeniorSubordinatedNotes：投资举债，标的增加300借款Shareholders'Equity：投资中股权资本385,扣减其他费用15后，标的所有者权益增加370；标的所有者权益因老股东撤资减少700（暂时按国内减资理解）：

（二）资产负债表预测标的调整后的资产负债表如图红框:Opening20昭Adjustments+二ProForma2。昭Year12mCashandCashEquivalents5250(25.0)--AccountsReceivable1S5.0165.0178.2Inventories125JO125.0135.3Fr&paid5andOtherCurrentAssets■ID：108TatailCurrentAssets$325,0$3MU»$324,0Property.FlantandEquipment,net650.0650.0650.：，GoodwillandIntangibleAssets175.0125.C-SOC-.O货。;，OtherAssets75.075.075.0DeferredFinancingFees2：＜-17.5TotalAsset;1142251A站,逐口41,366.5AccountsPayable75.075.C'B1.：■AccruedLiabilities100.0133.310&.3OtherCurrentLiabilities25.D25.口27.0TotalCurrentLiabilities$2HU0$200,0$216,0RevolvingCreditFacility----TermLoanA----TermLoanB-450.C-TermLoanC----BtistingTermLoan300.0(300.0)--2ndLien----SeniorNotes----SeniorSubordinatedNotes-33-3.3-OtherDebt---OtherLong-TermLiabilities25.025.：•TotalLiabilities$525,01975.0$947,3NoncontrollingInterest---Shareholders'Iquity70口口373.3- (700.0)419.3TotalShareholders'EquitySnu$370,05419.3TotalLiabilitiesandEquity站,M5,DM.366.5未来几年的资产负债表预测如下:

BalanceSh白白tOpening又阻Adjustments+-ProForma如口&Year12皿9Year2CashandCashEquivalents। (26.0)---AccountsReceivable165.0165.C-17&.2188J9Inventories125.0125.C-135.0143.1FTepaidsandOtherCurrentAssets10.010.010.S1T4IotalCurrentAssets$325,0$3MU0$324,0$543,4FToperty.RantandEquipment,net650.0650.C-650.0650.C'GoodwillandIntangibleAsset175.0125.C-MM，；，MX，.。货。.DOtherRssets75.075.C-75.075.0DeferredFinancingFees20.：-2C<-17.5■15.1TotalA3sei11,225.041,345.011,366.5AccountsPayable75.075.C-B1.DB5.9AccruedLiabilities100.01108JO114.5OtherCurrentLiabilities25.025.027.0TotalCurrentLiabilities$200,0tanuo$216,0$229U0RevolvingCreditFacility-----TermLoanA-----TermLoanB-4SO.C-450.C-406.3354.2TermLoanC-----ExistingTermLoan300.0(300.0)---2ndLien-----SeniorNotes-----SeniorSubordinatedNotes-OtherDebt----OtherLong-TermLiabilities25.025.025.0TotalLiabilities$525,0$975,0$947,3$90S_2NoncontrollingInterest----Shareholders'Equity70D.DS7C<- iTOO.O)3700419.34753IotalShareholders'Equi'$700,01370.05419.3S475.3TotalLiabilitiesandEquity11,345.041,366.5£1工53,5CashandCashEquivalents：现金及现金等价物，需要现金流量表数据，攒搁置。AccountsReceivable：应收账款，=收入/365*应收账款周转天数（之前假设数据）。Inventories：存货，=成本/365*存货周转天数。PrepaidsandOtherCurrentAssets：预付账款，=成本/365*预付账款周转天数。Property,PlantandEquipment,net：固定资产（查不到，瞎理解-，-），=上一年固定资产-折旧+资本化支出（折旧和资本化支出在损益表和现金流量表都有，是在损益表中按照收入及假设的比例来预测的数值）。GoodwillandIntangibleAssets：商誉和无形资产，=上年值-摊销（本例中该项目摊销假设0）。OtherAssets：其他长期资产，假设保持不变。DeferredFinancingFees：融资费用，=上年值-摊销（该项目摊销在“第一步-三”已计算）。AccountsPayable：应付账款，=成本/365*应付账款周转天数。AccruedLiabilities：应计负债，根据占收入比例计算。OtherCurrentLiabilities：其他流动负债，根据占收入比例计算。Shareholders'Equity：所有者权益，=上年值+上年净利润（三）循环引用补全相关表格RevolvingCreditFacilityTermLoanATermLoanB450.0450.0406.3354.2294.6228.9157.980.7TermLoanC---------listingTermLoan300.0(300.0)-------2ndLien---------SeniorNotes---------SeniorSubordinatedNotes-300.0300.0300.0300.0300.0300.0300.0300.0OtherDebt--------OtherLong-TermLiabilities25025.0TotalLiab耐讴b$525,0$975,05947.3$908,2SS57J$799,2$735,5$665.9如上图，负债需要循环引用:

初始负债=450,以下为确定年初负债的过程（年初负债为待求解未知数）：年初负债=上年负债-还本数额还本数额=min（年初负债，可用净现金流）；年末负债=年初负债-还本数额可用净现金流=净利润【相关】净利润=EBIT-利息=EBIT-average（年初负债，年末负债）*利率=EBIT-average（年初负债，（年初负债-还本数额））*利率=EBIT-average（年初负债，（年初负债-min（年初负债，可用净现金流）））*利率=EBIT-average（年初负债，（年初负债-min（年初负债，净利润【相关】）））*利率以上计算过程可见，年初负债的求解需要年初负债本身，也需要净利润，而净利润的计算需要净利润本身，也需要年初负债，存在2层循环引用，在Excel中开启即可：Microsoftoffice：WPSoffice：冒百视图编辑常规与保存WPSoffice：冒百视图编辑常规与保存重新计算自定义序列颜色错误检查拼写检查安到生快速访问工具栏重新计算@自动重算㈤手动重算也）也保存工作簿前重新计算呢□迭代计算口）最多迭代次数CE）:100最大误差（匚）： 0.001工作簿选项 以显示精度为准十）使用1904日期系统W）按照上述思路，以负债作为开端，利用公式的循环引用，可以填写完成所资产负债表、损益表、现金流量表、偿债计划表，投资回报分析表最后再说，下面描述现金流量表补全过程中的注意事项：

九、现金流量表补全注意问题上文分析得现金流量表中的净现金流为净利润【相关】，即现金流包括经营活动、投资活动、融资活动产生的现金流，其中：投资活动现金流：InvestingActivitiesCaptalExpenditures (21.6) (22.9) (23.8) (24.5) (25.3)OtherInvestingActivities ] [ _ = = = _CashFlowfromInvokingActivities ・ 〔$21瓦〔$22.9) 〔$23阴 〔$24.5) 〔$25.3)如上图，投资活动现金流主要是资本化支出，资本化支出是按照销售收入的假设百分比计算。融资活动现金流：融资活动现金流为各项有息负债的年末年初余额差，即还本金额(案例里的利息费用貌似算到经营活动里了，在计算净利润时把利息减掉了，所以利息对现金流的影响在经营活动现金流中体现)，如下图：FinancingActivitiesTOC\o"1-5"\h\zRewl^ngCreditFacility - - - - - -TermLoanA - - - - - -TermLoanB | (43.7)1 (52.0) (59.6) (65.7) (71.1) (77.2)TermLoanC - - - - - -ExistingTerniiLoan - - - - - -2ndLien - - - - - -Seni口r'Notes - - - - - -SeniorSubordinatedNotes - - - - - -OtherDebt - - - - - -Dividends - - - - - -EquityIssuance/(Repurchase) ： ： ： ： ： CashFlowfromFinancingActivities 〔$59.6) [$65G %"」)经营活动现金流:CashFlowStatementChangesinWorkingCapitalItems(Inc.)/Dec.inAccountsReceivable(Inc)/ChangesinWorkingCapitalItems(Inc.)/Dec.inAccountsReceivable(Inc)/Dec.inInventories(Inc.)/Dec.inPrepaidandOthg「CurrentAssets-J-\lz716o.&o.XJJ-Ulf.—lr»67-5(7■(5■(-o.,If

954

◎(4-1:0.,VIJVIT.1——.164(6.14•lo.L㈤十可(6.14•lo.LP「32ctionPeriodYear12009Year22010Year32011Year42012Year52013Year62014OperatingActivitiesNetIncomie$49.3$56.1$61.8$66.8$72.3$78.5Plus:Depreciation&Amortization21.622.923.824525.326.0Plus:Amortization------Plus:AmortizationofFinancingFees2.5252.5Inc./(Dec.)inAccountsPayable6.04.93.4212.82.8Inc.!(Dec.)inAccruedLiabilities8.0373.8Inc.!(Dec.)inOtherCurrentLiabilities2.00.90.9(Inc.)/Dec.inNetWorkingCapital[&Q)⑹5)f4.61□.61□.71⑶用CashFlowfromOperatingActivities$65.3—S74.9S83.4S90.2S96.3S103.2经营活动现金流按照净利润+折旧摊销+融资费用摊销土营运资金项目调整计算。其中净利润通过公式循环引用计算解决，折旧摊销及融资费用摊销前文已计算。ChangesinWorkingCapitalItems(营运资本项目对现金流的影响，暂理解为流动资产和流动负债)(Inc.)/Dec.inAccountsReceivable：【increase/decrease】应收账款增减对现金流的影响，年初应收账款-年末应收账款；(Inc.)/Dec.inInventories：存货增减对现金流影响，年初存货-年末存货(Inc.)/Dec.inPrepaidandOtherCurrentAssets：预付账款对现金流影响，年初-年末

Inc./(Dec.)inAccountsPayable：应付账款对现金流影响，年末-年初Inc./(Dec.)inAccruedLiabilities：应计债务对现金流影响，年末-年初Inc./(Dec.)inOtherCurrentLiabilities：其他短期负债对现金流影响，年末-年初上述调整在资产负债表也有体现:「BalanceSheetYear12皿BYear2201。Year32011Year42m2P「口jTcti口□P~eric3dYear72015Year52013Year62014OtherLong-TermLiabilitiesTotalLiabilitiesS&47二S90L2$857了25.0$799,2$735.51CTE.D$593,0NoncontrollingInterestShareholders'EquityTotal!Shareholders'Equity4193475.3537.1603.9676.2754.7840.3.S475.3$537,1$603,91576.2$754.7Total!LiabilitiesandEquity53弭5如曰M.S 5.403.1打站.433.3.BaianceCheck0.0000.0000.0000.0000.0000.0000.000-JetWorkingCapitalIncrease)/DecreaseinNetWorkingCapital103.0(80)114.5(6.5)119.1(4.6)122.6(3.6)126.3(3-7)130.1(3S)134.0P-9)NetWorkingCapital：流动资产-流动负债(Increase)/DecreaseinNetWorkingCapital：NetWorkingCapital【年初】-【年末】最终将经营活动、投资活动和融资活动现金流汇总得出预测的现金流量表。第三部分：投资回报分析RgturnsAnalvsisProformar2m'Year12aQ9 尸Year22Q1A1Year32011Entry田ITDAMultiple7.5xInitialEquityInvestmentS335.0EBITDAS162.0S171.7S17B.6&itEBrraiAMultiple7.5x _EnterpriseValueatExit$1,215.0瓯9$1图9,4Less:MetDebtRevaidingCreditFacility---TermLoanA---TermLoanB406.3354.2254.6TermLoanC---BiistingTermLoan---2ndLien---SeniorNotes---SeniorSubordinatedNotes3H，.D300.0OtherDebtTotalDebt1706.3$654,2S594J6Less:CashandCashEquivalentsNetDebt$70S,3$654,2$594.6EquityValueatExit=5633了_*7山1RCashReturnTOC\o"1-5"\h\zYear1Year2Year3

2009 的伸 的11InitialEquityInvestmentEquityProceedsInitialEquityInvestmentEquityProceedsS5O5.7 - -S633.7 -S744.S2008年9月30投资，进入EBITDA倍数7.5倍(公司价值1100，实际股权资本投入385)，退出日期待定，退出倍数暂定7.5倍。投资回报计算如下：

退出时股权投资收益=退出时企业估值-净债务=退出时EBITDA*估值倍数-净债务。现金回报率=退出时股权投资收益/InitialEquityInvestmentIRR计算如下:IRR32.1%28.3% 24.6% 21.9%IRR32.1%28.3% 24.6% 21.9%Year1Year2Year3Year42009201020112012InitialEquityInvestment($385.0)($385.0)($385.0)($385.0)EquityProceeds$508.7---$633.7--$744.8-$850.7敏感性分析：不同进入和退出倍数的敏感性分析IRR-AssuminoExitin2013EExitMultiple6.5xG.5x7.Ox7.5k8.Ox8.5x26.6%29.5%32一2%34.7%37.1%Entry7.Ox19.9%22.7%25.3%27.7%29.9%Multiple7.5x15.0%17.7%|20.1%22.4%24.5%8.Ox11.0%13.6%16.0%1S.2%20.3%8.5x7.8%10.3%12.6%14.8%16.7%不同退出年份的敏感性分析:IRR-Assuming17.5EntIeExit201120122013201420156.5x13.7%14.7%15.0%14.9%14.8%Exit7.Ox19.4%18.5%17.7%17.0%16.3%Multiple7.5x24.6%21.9%20.1%18.&%17.8%8.Ox29.4%25.1%22.4%20.5%19.1%8.5x33.9%28.0%24.5%22.1%20.4%按照进入和退出倍数相同，不同倍数的敏感性分析IRR-AssuminqExitin2D13EExitMulti—Ie6.50x7.00k7.25k7.50x6.50x26.6%28.1%29.5%30.9%32.2%6.75x23.0%24.5%25.9%27.2%28.5%Z.OOx19.9%21.4%| 22.7%I24.1%25.3%Entry7.25x17.3%1B.7%20.0%213% .22.6%Multiple7.50x15.0%16.4%17.7%18.9%20.1%

第四部分：TransactionSummary概要表制作总览表：数据均计算过Sour-fFundsAmount%ofTotalSouix"MultiuleofEBITDAPricingCumulativeRevolvingCreditFacility--%-X-XL+325bpsTerniiLoanA--%-X-XNATermLoanB450.038.8%3.1k3.1kL+350bpsTerniiLoanC--%-X3.1xNA2ndLien--%-X3.1xNASeniorNotes--%-X3.1kNASeniorSubordinatedNotes300.025.9%2.Ox5.1x10.000%EquityContribution385.033.2%2.6x7.7xRolloverEquity--%-X7.7xCashonHand25.0 22% L2x TotalSources$1,160.0100.0%7.9x7.9xUsesofFunds%ofTotalAmountUsesPurchaseValueCoEquity$825.071.1%RepayExistingDebt300.025.9%Tender/CallPremiums--%FinancingFees20.01.7%OtherFeesandExpenses15.01.3%TotalUses$1,160.0100.0%PurchamePriceReturnAnalysisOfferPriceperShare $16,50FullyDilutedShares 50一口EquityPurchasePrice $825.0Plus:ExistingNetDebt 2了5一口EnterpriseValue $1.1。。.口ExitYear 2013EntryMultiple 7.5xExitMultiple 7.5xIRR 20%CashReturn 2.5xTransactionMultialesEnterpriseValue/SalesFinancingStructure1LTM9/30/2008$9