FINANCE-02 · Secondary · ENGLISH · PLANNED
Trace cash flows, calculate a transparent model, stress-test assumptions and explain risk.
Study time is an initial activity estimate, excluding extra reading, revision and extended laboratory or project work. Videos and question bodies have not been produced by adding this outline.
Complete these courses or demonstrate equivalent knowledge. These are recommended prerequisites, not enforced enrolment locks.
YouTube playlist: ARK Finance | Financial Mathematics and Spreadsheet Modelling
Playlist title reserved in the plan; no YouTube playlist or upload has been created yet.
Sign in to save this learning pathPractical outcome: Build a transparent savings model using fictional rates.
Explain present value using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Explain future value using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Explain compounding periods using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Explain discount rates using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Use the first concepts from this section. Build a transparent savings model using fictional rates. Produce a labelled diagram, trace or calculation; explain each step and check one changed input.
3–6 questions on the preceding first-half concepts only: recall, visual interpretation, application and one plausible misconception. Explain each answer after submission.
Explain ordinary annuities using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Explain annuities due using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Explain perpetuities using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Explain growing cash flows using a visual and one worked real-world example. Context: Build a transparent savings model using fictional rates. End with a prediction or check-for-understanding.
Build a transparent savings model using fictional rates. Work without the example, compare two cases, record assumptions and limitations, then self-review correctness, reasoning and clarity.
6–12 questions covering Present value, Future value, Compounding periods and the remaining section concepts, with cumulative retrieval from earlier sections. Include a new transfer problem; 70% unlocks progression.
Practical outcome: Compare fictional business investments using a spreadsheet.
Explain net present value using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Explain internal rate of return using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Explain multiple irrs using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Explain discounted payback using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Use the first concepts from this section. Compare fictional business investments using a spreadsheet. Produce a labelled diagram, trace or calculation; explain each step and check one changed input.
3–6 questions on the preceding first-half concepts only: recall, visual interpretation, application and one plausible misconception. Explain each answer after submission.
Explain equivalent annual cost using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Explain loan amortisation using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Explain real versus nominal rates using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Explain sensitivity tables using a visual and one worked real-world example. Context: Compare fictional business investments using a spreadsheet. End with a prediction or check-for-understanding.
Compare fictional business investments using a spreadsheet. Work without the example, compare two cases, record assumptions and limitations, then self-review correctness, reasoning and clarity.
6–12 questions covering Net present value, Internal rate of return, Multiple IRRs and the remaining section concepts, with cumulative retrieval from earlier sections. Include a new transfer problem; 70% unlocks progression.
Practical outcome: Audit an illustrative model and document every assumption.
Explain input separation using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Explain formula references using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Explain units and signs using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Explain scenario switches using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Use the first concepts from this section. Audit an illustrative model and document every assumption. Produce a labelled diagram, trace or calculation; explain each step and check one changed input.
3–6 questions on the preceding first-half concepts only: recall, visual interpretation, application and one plausible misconception. Explain each answer after submission.
Explain error checks using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Explain circular references using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Explain model documentation using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Explain independent review using a visual and one worked real-world example. Context: Audit an illustrative model and document every assumption. End with a prediction or check-for-understanding.
Audit an illustrative model and document every assumption. Work without the example, compare two cases, record assumptions and limitations, then self-review correctness, reasoning and clarity.
6–12 questions covering Input separation, Formula references, Units and signs and the remaining section concepts, with cumulative retrieval from earlier sections. Include a new transfer problem; 70% unlocks progression.
Combine all three sections: Audit an illustrative model and document every assumption. Submit an original worked artifact, evidence or tests, assumptions and a reflection. Rubric: correctness, method, practical usefulness, reproducibility and communication. Self-reviewed, not certified.
6–12 balanced questions sampling every section of Financial Mathematics and Spreadsheet Modelling, including interpretation, calculation or reasoning, a misconception and a new application. Passing is 70%; review errors before retrying.
Fictional USD budgets, statement analysis, valuation models and risk scenarios. Guided work leads to an independent attempt, with a diagram, explanation, trace, calculation or tested artifact. Question bodies are generated when opened in your private learning path. Programming submissions are stored as text; the platform does not execute submitted code.
Use original or appropriately licensed datasets. Practical science activities use models or supplied data unless a qualified supervisor has reviewed a physical experiment.
Open the interactive practice sampler →