All tracks

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 timed 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%
1

FV future value

Intermediate

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

FV
Start
2

Gross margin by product

Intermediate

Calculate gross margin % and rank products by profitability.

RANK
Start
3

Loan amortization schedule

Advanced

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

PMT PPMT IPMT
Start
4

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
5

Simple DCF model

Advanced

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

NPV
Start
6

XIRR for real cash flows

Advanced

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

XIRR
Start
7

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

Build on what you learned

When you're ready for the step after Excel, here's where we'd point you next.

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.

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

Explore the FMVA program(affiliate link)