Investment Banking Grade -Financial Modelling Course

Explore the Excel home ribbon: clipboard, format painter, font, borders, alignment, wrap text, and number formats. Learn to apply borders, conditional formatting, column width, and sheet protection for templates.

Master one dimensional data tables in Excel to run what-if analysis on profit across varying cost percentages or revenues, linking to the original calculations via row and column inputs.

Explore how financial modelling tests scenarios, handles negative profit before tax, and uses logical operators to calculate tax and validate profitability decisions.

Master nested if logic in Excel by building a single-cell grade calculator using overall average criteria, testing 60, 50, and 36 thresholds to assign a, b, c, or d.

Explore pivot table fundamentals in Excel, learn to arrange data with rows, columns, filters, and values, and build interactive dashboards with slicers and pivot charts.

learn to use index and match to overcome vlookup's leftmost limitation and find revenue by order number with exact match; retrieve the customer number via a combined formula.

Explore how to visualize finance data with axis charts, radar charts, a waterfall chart, underwater curve, drawdown, and whammy index in Excel, using data labels and secondary axes for clarity.

Design a financial analysis template by orienting years to the right, listing items downward, declaring currency in millions, reserving two columns for assumptions, and color coding actuals, calculations, and assumptions.

Explore time value of money using Excel tvm functions pv, fv, rate, nper, and pmt. Apply these to compute present value and future value, highlighting beginning versus ending cash flows.

Master continuous compounding and the exponential growth of value using present value, rate, and periods, applying the exp(rt) formula to compute future value.

Explore discounting as the reverse of compounding, deriving present value from future value using PV = FV divided by (1+r)^n, and practice with the attached Excel template.

Learn to compute the future value of series of cash flows, evaluate net present value, and determine return using IRR and XIRR for uneven cash flows.

Explore the difference between ending and beginning cash flow in financial modeling, including how PMT and present value influence compounding and final value across fiscal years.

Explore the practical challenges of IRR, including when equal IRRs favor the higher NPV project, and how reinvestment, timing, and beginning cash flows affect reliability.

Use the goal seek function to reverse engineer loan value from a fixed emi, using the PMT function, present value concepts, and what-if analysis in Excel.

Explore how statistics informs finance by identifying the data center, analyzing daily returns, and quantifying risk through volatility, distributions, and histogram analysis.

Explore dispersion in financial risk by comparing range, mean absolute deviation, variance, and standard deviation, and learn how drawdown reveals portfolio risk.

Explore the central position of data in statistics, compare mean, median, and mode, and apply descriptive and inferential methods using Yes Bank stock history.

Present and analyze data using frequency distributions, relative and cumulative frequencies, histograms, frequency polygons, and cumulative frequency distributions with Excel's data analysis tool pack.

Explore valuation fundamentals by comparing intrinsic value to market price, using cash flow models, terminal value, and multipliers to evaluate growth and value stock opportunities.

Explore valuation methods across present-value models and multipliers, including dividends, FCFE, FCFF, and various price multiples, plus key dividend terminology and important dates.

Explore valuation methods by applying Gordon growth, dividend discount, and free cash flow models to estimate equity and firm value, including terminal value and enterprise value calculations.

Explain the cost of capital, post-tax debt costs, and how debt versus equity and the tax shield affect the weighted average cost of capital (wacc) in valuation.

Estimate the cost of capital by aligning with target capital structure, evaluate weights from market values, and compute debt and preferred stock costs via yield, ratings, and rental yields.

Learn to estimate the cost of equity using CAPM and the dividend discount model, including beta, risk-free rate, market premium, and the Gordon growth model.

Analyze financial statements—income statement, balance sheet, and cash flow—to assess historical performance and forecast future value for investors, creditors, and lenders, using MD&A, footnotes, and auditor reports.

Learn to build a monthly financial statements package, including the income statement, balance sheet, and cash flow, from equity capital, inventory, depreciation, and accruals.

Analyze how equity and debt financing shape cash flows across operating, investing, and financing activities. Apply working capital principles to reveal true cash effects.

Construct the cash flow statement using the indirect method, starting from net income, adjusting for depreciation and non-cash gains, and mapping balance sheet changes by operating and investing activities.

Explore the matching principle and expense recognition in financial statements, covering inventory methods (FIFO, LIFO, weighted average, specific identification), depreciation, doubtful accounts, and warranties.

Explore how balance sheets differentiate current and non-current assets, define inventories, measure at amortized cost or fair value, and apply impairment concepts including net realizable value and goodwill.

Analyze current and non-current assets, measured by amortized cost or fair value. Explore inventories, tangible and intangible assets, impairment, goodwill, and last-in, first-out treatment under IFRS versus US GAAP.

Explore how balance sheet classifications (held to maturity, available for sale, and trading securities) affect asset values, income, and other comprehensive income, with related current assets, liabilities, and equity concepts.

Learn to derive cash flow from net income by adjusting non-cash items, and to calculate operating, investing, and financing cash flows, including free cash flow to firm and equity.

Explain free cash flow to equity and the firm from the cash flow statement, and adjust for depreciation, interest, working capital, capex, and debt for valuation.