IB Excel assessment prep

Advanced 2 hr 20 min 7 exercises

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

What you'll learn

Apply time-value-of-money functions (FV, NPV, XNPV, and XIRR) to regular and date-driven cash flows
Build a full loan amortization schedule using PMT, PPMT, and IPMT
Project free cash flows, calculate terminal value, and discount them into a basic DCF valuation
Run a one-variable sensitivity analysis to test how NPV responds across discount rates
Calculate gross margin by product and rank products by profitability

Functions you'll practice

FV IF IPMT NPV PMT PPMT RANK XIRR XNPV

Start track

Exercises in this track

0 of 7 completed 0%

FV future value

Intermediate

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

Start

Gross margin by product

Intermediate

Calculate gross margin % and rank products by profitability.

RANK

Start

Loan amortization schedule

Advanced

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

PMT PPMT IPMT

Start

Build a one-variable sensitivity table

Intermediate

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

NPV IF

Start

Simple DCF model

Advanced

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

NPV

Start

XIRR for real cash flows

Advanced

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

XIRR

Start

NPV with irregular cash flows

Advanced

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

XNPV

Start

Start track

Where to go next

Pick another track

Browse all learning tracks to find your next focus area.

Browse all tracks

Ready to get certified in finance?

Once you've put the modeling work in, the FMVA from CFI makes it official. It's the credential finance and FP&A teams actually recognize, and it's hands-on, not just theory.

Use code for 30% off site-wide.

This is an affiliate link. A purchase helps support the site.

Explore the FMVA program