Financial Analysis and Modeling Using Excel and VBA
by Chandan Sengupta · Wiley
An 800-page Wiley guide that reviews the underlying finance theory, then develops models in Excel and automates them with VBA across time value, bond pricing, portfolio, and simulation problems. Suited to readers wanting programming control over spreadsheets.
This link may earn us a small commission at no extra cost to you. Affiliate disclosure
More resources on Financial Modeling
Wall Street Prep Free Project Finance Course (Heathrow Airport Case Study)
Walkthrough of a project finance model for a Heathrow Airport case study, with a downloadable Excel template. Covers capital expenditure phasing, operating cash flows, debt drawdown and repayment mechanics, and the DSCR and LLCR coverage ratios lenders use.
CFA Institute
Official site of the body that sets and administers the CFA exams, publishing the curriculum topic areas and weights, exam policies, sample questions, the Code of Ethics and Standards of Professional Conduct, and research. Candidates use it to plan study against the tested content.
Financial Modeling for Beginners
Learn financial modeling fundamentals with this free course from BIWS. Build practical skills and start your finance career today!
Aswath Damodaran's Website
Aswath Damodaran's NYU faculty page, hosting his lecture slides, webcasts, valuation spreadsheets, and annually updated datasets on equity risk premiums, betas, and cost of capital by industry. The data feeds real discounted cash flow work.
Macabacus Learn: Operating, Merger and LBO Model Tutorials
Free step-by-step walkthroughs for building an operating model, a public-company merger model and an LBO model in Excel, plus downloadable DCF, merger, short-form and long-form LBO and IPO templates using banking formatting conventions.
Investment Banking: Valuation, LBOs, M&A, and IPOs (3rd Edition)
The standard practitioner text on banker valuation work: comparable companies, precedent transactions, DCF, LBO, merger and IPO analysis, worked step by step. The third edition ships with six downloadable Excel model templates matching the chapters.