All tracks

IB Excel assessment prep

Focused investment banking interview prep covering the valuation and modeling patterns commonly tested in timed assessments.

Advanced 7 exercises
0 of 7 completed 0%
Start track

Exercises in this track

1

FV future value

Calculate the future value of a savings account with regular deposits.

FV PV PMT
Start
2

Gross margin by product

Calculate gross margin % and rank products by profitability.

RANK RANK.EQ LARGE
Start
3

Loan amortization schedule

Build a full loan amortization table (payment, principal, interest, balance by period).

PMT PPMT IPMT
Start
4

Build a one-variable sensitivity table

Build a project NPV model and test whether it clears a required threshold under different discount rates.

NPV IF XNPV
Start
5

Simple DCF model

Build a basic DCF: project cash flows, calculate terminal value, discount to present.

NPV PV FV
Start
6

XIRR for real cash flows

Calculate XIRR for irregular investment cash flows while excluding a non-performance fee row.

XIRR IRR XNPV
Start
7

NPV with irregular cash flows

Calculate NPV where cash flows occur on specific dates (not regular periods).

XNPV NPV XIRR
Start