Building Financial Models
by John Tjia · John Tjia
Tjia builds a working projection model from the ground up, pairing accounting and finance fundamentals with Excel mechanics, discounted cash flow, and design principles for maintainable spreadsheets. You finish able to construct a three-statement corporate projection model.
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.