KKR - LBO Model

The KKR model is designed is such a way that includes a step by step process to help understand the process with ease.
Step 1 : BUILD INCOME STATEMENT / CAPITAL EXPENDITURE / NET WORKING CAPITAL DRIVERS
Step 2 : BUILD BASIC ASSUMPTIONS
Step 3 : BUILD PURCHASE PRICE CALCULATION
Step 4 : Build Sources and Uses Table
Step 5 : Build Free Cash Flow Table
Step 6 : BEGIN TO BUILD DEBT SCHEDULE
Step 7 : BUILD DEBT PAYDOWN MODEL
Step 8 : MODEL INTEREST EXPENSE INTO YOUR DEBT PAYDOWN AND FREE CASH FLOW BLES
Step 9 : TURN YOUR CIRCULAR ON AND MODEL TAXES INTO YOUR FREE CASH FLOW TABLE
Step 10 : MODEL FIRST SEGMENT OF RETURNS ANALYSIS
Step 11 : BUILD SECOND SEGMENT OF RETURNS ANALYSIS IN ORDER TO RUN SENSITIVITY ANALYSES
Step 12 : MODEL FD SHARES IN SECOND SEGMENT OF RETURNS ANALYSIS
Step 13 : TURN YOUR CIRCULAR BACK ON SO THAT FD SHARES CALCULATES CORRECTLY
Step 14 : SET UP SENSITIVITY TABLES
Step 15 : LINK THE TOP LEFT CORNER OF EACH TABLE TO THE OUTPUT YOU ARE SENSITIZING
Step 16 : HIDE THE TOP LEFT CORNER OF THE SENSITIVITY TABLES FOR COSMETIC PURPOSES
Step 17 : POPULATE SENSITIVITY TABLES

KKR , RJR Nabisco , LBO , Excel , Valuation , Financial Statement analysis , Buyout , M&A , private equity , Corporate finance , leverage , sensitivity analysis , EV , DCF