LBO and Valuation Model
See more projectsIntensity
15hr/week
Est. Duration
7days
Work Remotely
Work from your own location. No travel is required to apply to this project.
Schedule Expectations
Expert can manage their own schedule
Communication Expectations
(None Provided)
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
10 years
Time On Graphite
1
Hiring Managers