Make LBO excel sheet based on a case study

Job ID: 33944942

Budget: $10 – $30 AUD

I have attached the layout of the excel spreadsheet I need. Case study is:

current revenue 7.4million
company growth 7%
purchase with 50% debt
EBITDA mulptiple is 10
EBITA margine 10%

EBITDA margin growth increase by 2% for the next 5 years
initial fees 2.6milion
interest rate is 5%
yearly capital expenditure 1.3million
Related categories: Data Entry Accounting Excel Finance Business Analysis