LBO and Valuation Model

See more projects
Intensity
15hr/week
Est. Duration
7days
Location
Remote

Project Overview

1 to 8 years professional experience
Finance & Accounting - Financial Modeling
We are a lower mid market food company. We require a simple dynamic LBO and valuation model in xls to be used as our base case in discussions with a PE sponsor. You will be provided with 3 years of annual historical financials and will be expected construct a 10-year model that starts from a proforma transaction closing point (i.e. expected close date 8/30/17), which will be driven by sources and uses and a base set of assumptions run off the proformas. The model should then project out 10 years on a MONTHLY BASIS (for bank borrowing and collateral management base purposes) -- and a summary annual basis given a set of b/s and i/s assumptions (sales growth etc, receivable days etc...). The model should allow for easy data input and IT MUST HAVE THE ABILITY TO BE UPDATED ON A MONTHLY BASIS TO REFLECT ACTUALS. SHOULD HAVE ALL BASIC LBO BELLS AND WHISTLES FOR A PRIVATE COMPANY. We like the Macabus LBO model but it contains a great deal of info that doesn't involve a private transaction.
Additional Notes
The candidate is/was a professional at a private equity firm or investment bank who is experienced in all aspects LBO modeling. The modeling should be structured to help tell a story.
Preferred Skills and Certifications
Functional
Financial Modeling

About The Client

Top Skills Hiring For
Financial Modeling

$12.8K
Total Spent
9 years
Time On Graphite
1
Hiring Managers
We use cookies for an optimal website experience. By using the site, you consent to our use of cookies as stated in our Privacy Policy.
Accept