What this level covers
The finance formulas, and the dates they depend on. NPV, IRR, PMT and the time value of money, EOMONTH and YEARFRAC and the day-count conventions that decide what a period actually is, plus the statistics that show up in a forecast. Sixty-nine scored cells.
One workbook. Lessons to read, practice grouped by topic, then a mixed checkpoint. 69 scored cells.
Inside the file
- Instructions
- What this level covers, how to work it, how it is marked.
- Lessons
- One card per topic. Read the card, then answer that topic on Practice.
- Practice
- The questions, grouped by topic. Orange cells are yours to fill in.
- Checkpoint
- Ten mixed questions with no topic headings, to see what stuck.
- Score
- Your result, by topic and overall.
- Solutions
- A worked answer for every question, shown when you ask for it.
A toggle at the top of the Test tab stays on N while you build, so you are working blind. Flip it to Y and every cell you filled turns green or red in place — no separate answer key. Values are compared, not formulas, so any construction that lands on the right number scores. The in-sheet coloring needs Excel 2010 or later; the Scoring tab works in any version.