FormulaCamp
Completed
← Full curriculum
Track 11 · Analyst

Finance and Business Analytics

Loans, deposits, NPV/IRR, Goal Seek, budgets, payroll, and sales reports.

1 free lesson

0 of 16 completed · about 6.3 h

Start

16 lessons left until your certificate

Financial Math

  1. 1Loans: PMT and Total InterestFreelesson15 min
  2. 2Savings: FV and PVlesson15 min
  3. 3Payback: NPV and IRRlesson15 min
  4. 4Goal Seeklesson15 min
  5. 5RATE, NPER and XIRRlesson20 min
  6. 6Practice: Financepractice20 min

Management Accounting and Analysis

  1. 7P&L and Cash Flow: Profit Is Not Cashlesson25 min
  2. 8Unit Economics: Do We Make Money on One Customer?lesson25 min
  3. 9ABC/XYZ Analysis of a Product Rangelesson30 min

Modeling and Optimization

  1. 10Scenario Analysis: a Worst / Base / Best Switchlesson25 min
  2. 11Solver: How to Set Up the Problemtheory and quiz15 min
  3. 12Solver: a Bakery Production Plan Modellesson30 min

Business Projects

  1. 13Project: Family Budgetproject30 min
  2. 14Project: Sales Reportproject30 min
  3. 15Practice: Store Inventorypractice20 min
  4. 16Project: Coffee Shop Financial Modelproject45 min