Last updated
Build a fully linked income statement, balance sheet, and cash flow statement for a small sample company, with every number provided so you can check your work at each step. Use AI to explain the links, pressure-test assumptions, write spreadsheet formulas, debug a model that does not balance, and summarize scenarios. Works in Google Sheets or Excel. No finance degree needed.
A 3-statement model links a company's income statement, balance sheet, and cash flow statement so a change in one flows through to the others. It is the foundation of most finance jobs, internships, and exams, but beginners often get stuck because they learn each statement on its own and never see the links. This short course fixes that by having you build a complete model for one small sample company, a coffee roaster, with every number provided. You download a ready-made template for Google Sheets or Excel, and at each step you can check your results against the expected figures, down to one decimal. You will learn the four links that tie the statements together, set up an assumptions block, and use AI tools like ChatGPT, Claude, or Gemini to explain concepts, challenge your assumptions, and write formulas that drop straight into your sheet. Then you will link the balance sheet and cash flow statement, add a balance check, and practice finding and fixing the errors that break most models. The course ends with two stress-test scenarios that show how a profitable business can still run out of cash, and an AI-drafted summary you check line by line. The spreadsheet does the math, AI helps you build and explain it. No finance degree needed.
2 modules • 6 lessons
Finish every lesson and pass the final exam to earn this free, shareable certificate.
Certificate of Completion
has successfully completed
6 lessons · Final exam passed
Michail Ouroumis
Founder, FreeAcademy.ai
Sample preview. Your name appears on the certificate when you complete the course. Learn more
Teaching a class or training a team? Assign this course for free
No. The first lesson explains what each statement shows and how they connect, using the sample company's numbers. Basic spreadsheet skills like typing a formula and filling it across are enough.
Yes. You download a template with the sample company's actual year and all assumptions filled in. Each lesson lists the exact results you should see, so you can check your work at every step.
Yes. The template is a CSV file that works in Google Sheets or Excel, and every formula in the course works in both. If your Excel uses commas for decimals, the first lesson shows how to import the file so the columns line up.
No. AI explains concepts, questions your assumptions, writes formulas, and helps you debug. The spreadsheet does the calculations and you check the results. That way your model stays live and you understand every line.
Financial Modeling & Valuation is a longer course that covers larger models, DCF valuation, comparable companies, and LBOs. This micro course focuses on one small, fully worked 3-statement model with AI help. It is a good first step before the full course.
About 50 minutes across six short lessons, plus time in your spreadsheet. Each lesson has a quiz, and there is a final exam with a free certificate when you pass.
Learn to use AI to write complex Excel formulas in just 20 minutes. Master prompting techniques for VLOOKUP, SUMIF, nested IFs, and formula debugging with practical exercises.
Learn practical ways to use AI in finance and accounting: financial analysis, report generation, data extraction, forecasting, audit preparation, tax research, client communication, and automation while understanding compliance considerations.
Master the art of financial modeling and company valuation. Learn to build integrated 3-statement models, perform DCF analysis, conduct comparable company analysis, analyze precedent transactions, and understand LBO mechanics. Bridge theory and practice with hands-on modeling exercises. Perfect for finance students, career changers, and professionals seeking to formalize their skills.
A task-specific course for US and UK finance professionals. Learn to use ChatGPT, Claude, and Microsoft 365 Copilot to speed up variance commentary, flux analysis, accruals, reconciliations, board packs, regulatory drafting, and ledger anomaly detection during month-end close. Built for controllers, FP&A managers, and finance managers. No coding required.
Build rolling forecasts and budgets faster, automate plan-vs-actual variance commentary, run scenario and headcount planning, and turn your numbers into board-ready decks. A practical, no-code course for corporate FP&A analysts, finance managers, and CFO-office staff using ChatGPT, Claude, and Microsoft 365 Copilot.
Learn how to use AI tools to understand, prepare, and double-check your taxes with zero prior experience. Decode confusing forms, find deductions you qualify for, organize documents, handle side income, and review your return, all while keeping your data safe. Earn a free certificate.
