Financial and Valuation Modeling Certificate
Built a comprehensive 3-statement model from scratch, including historical data input, circular debt-interest logic, and integrated cash flow projections for financial forecasting.
Mastered valuation techniques using the Unlevered Free Cash Flow method, WACC calculation, terminal value assumptions, and sensitivity analysis to determine enterprise value.
Analyzed the financial impact of mergers and acquisitions, focusing on accretion/dilution analysis, synergies, and pro-forma balance sheet adjustments.
Developed relative valuation skills by selecting peer groups and analyzing LTM multiples (EV/EBITDA, P/E) for public market trading.
Developed relative valuation skills by selecting peer groups and analyzing LTM multiples (EV/EBITDA, P/E) for historical M&A transactions.
Structured complex Leveraged Buyout models including sources and uses of funds, debt waterfall schedules, and internal rate of return (IRR) sensitivity tables.