About the Course
Unlock the power of financial modeling. Learn to build a comprehensive 3-statement model in Excel and make data-driven decisions.
What You’ll Learn
- Build a complete 3-statement model (Income Statement, Balance Sheet, Cash Flow) using assumptions and linked schedules for 5 forecasted years.
- Derive revenue, COGS, gross profit, SG&A, depreciation, taxes, interest, and net income using structured formulas.
- Explore depreciation methods: Straight-Line and Written Down Value with applications using CAPEX and PP&E schedules.
- Create supporting schedules like working capital, fixed assets, and revolver credit with logical dependencies.
- Link Net Income to Retained Earnings using the Retained Earnings Schedule and dividend logic.
- Ensure model integrity through balance sheet balancing, plug calculations for Revolver, and interest adjustments.
- Use Excel formulas effectively across assumptions, trends, and validations for dynamic model building.
Course Format
This course is delivered through on-demand video lessons, allowing you to learn at your own pace. Practical examples and Excel templates are provided to reinforce your understanding.
Who It’s For
- Aspiring financial analysts
- Students studying finance or accounting
- Business professionals looking to enhance their financial modeling skills
- Anyone who wants to understand how financial statements are linked and modeled
Course Structure
- Price: FREE
- Duration: 60 minutes
- Format: On-demand video lessons
- Mode: Self-paced
- Certificate: Yes, with completion
- Where: Available on the Juno School mobile app (Android & iOS)
Why Take This Course
- Gain practical skills in building financial models from scratch.
- Enhance your ability to forecast financial performance.
- Improve your understanding of financial statement relationships.
- Boost your resume with a valuable and in-demand skill.
- Learn from experienced financial professionals.