Financial Analysis & Modeling with Excel

Master end-of-period closing procedures, including depreciation, provisions, and accruals or deferments, to finalize the balance sheet and the profit and loss statement and determine income tax.

Analyze liquidity, activity, debt, profitability, and market-value ratios to assess financial health. Learn how to calculate current and quick ratios, inventory turnover, DSO, asset turnover, and price-earnings ratio.

Learn to value a business with the discounted cash flow approach by forecasting cash flows, estimating terminal value, and deriving enterprise and equity values using the weighted average cost of capital.

Master essential and advanced techniques for financial analysis, including fundamentals, Excel for InSight's core analysis techniques, valuation, and forecasting, to enable data-driven decisions and professional reports.

Perform horizontal and vertical analysis in Excel on a simplified income statement for two products, using the revenue growth formula and the item-to-total revenue percentage to derive insights.

Analyze net profit sensitivity in Excel using base, optimistic, and pessimistic growth scenarios, applying the previous-year profit multiplied by (1 + growth) to product A and B revenues.

Apply an Excel exercise to compute unit costs (cost of goods sold divided by units sold) and determine contribution margins (selling price minus unit cost) for products A and B.

Learn to prepare an annual budget with revenue forecasts, expense estimates, and capital expenditures, and use variance analysis to manage cash flow and reach financial targets.

Create a five-year Excel financial projection model with revenue forecast, operating expenses, capex, EBITDA, net income, free cash flow, and discounted cash flow, using assumptions and projections tabs.

Use stress tests to assess how forecasts behave under extreme market conditions, gauge resilience, identify vulnerabilities, and craft mitigation strategies to navigate worst-case scenarios.

Monte Carlo simulations quantify randomness and uncertainty in financial analysis by running thousands of simulations with varied inputs to produce a probability distribution of outcomes for budgeting, investments, and forecasting.

Learn to master rolling financial projections that update with actual data to deliver dynamic, real-time forecasts, enabling quick decisions, risk mitigation, and strategic agility.

Identify key financial red flags such as declining profit margins, high debt levels, negative cash flow, and slowing revenue growth to prevent long-term financial trouble.

Apply your knowledge to build financial models and analyze budgets, then develop a portfolio of valuations, forecasting, dashboards, and professional reports to showcase your skills.

Explore unit economics as the glue between marketing, product, and finance, and learn key metrics, funnels, and how to evaluate acquisition cost, revenue, and growth.

Explore unit economics by analyzing one unit, typically a client, through metrics like customer acquisition cost, arpu, ltv, churn and retention, using cohorts to understand profitability.

Examine two SaaS funnel case studies to calculate customer acquisition cost, payback periods, and bottlenecks, then show how improved conversions and lower click costs create viable unit economics.

Analyze a promo code launch case study for Yasna, examining influencer campaigns, free sessions, end-to-end conversions, customer acquisition cost, and unit economics to decide scale.

Explore unit economics by applying LTV, churn, and retention concepts, calculate ARPU-based LTV, compare with CAC, and assess payback and growth scenarios.

Explore how cohorts provide a horizontal view of customer lifetime, comparing absolute and relative cohorts to reveal retention trends and the impact of product changes on unit economics.

Define your goal, select metrics, and test hypotheses to optimize unit economics, focusing on the most broken metric with pirate metrics, omtm, and a north star.

Highlight how unit economics serves as the language among product, marketing, and CEO, tying CAC, LTV, cohorts, and funnels to explain revenue growth, vanity metrics, and forecasting.

Update your mental model of work for 2026 by understanding how value is created, evaluated, trusted, and rewarded across roles, industries, and seniority. Explain where AI helps and where it hurts, adopt a tool-agnostic approach, and build lasting relevance that survives changes in tools and rules.

Pause to reset and reflect on what worked in 2025 and decide what to carry forward. Use AI responsibly as a baseline to enhance judgment and outcomes in 2026.

In 2026, professionals are evaluated by prioritization, outcomes, and ownership, not volume, with reliability, explainability, and judgment driving decisive, accountable work.

Learn to frame problems before solving, negotiate solutions across teams, act under ambiguity, and explain your work clearly under time pressure, reflecting 2026 default patterns across all roles.

In 2026, balance speed with judgment by separating low-risk from high-stakes decisions, using AI to accelerate safely while preserving human ownership and accountability.

Question AI outputs in 2026, treat them as advice, and avoid delegation without explainability; then validate high-stakes decisions manually and explain AI reasoning to stakeholders to protect trust.

Focus on meaning over output in 2026 by framing insights around decisions, filtering noise, and delivering implications and actions that guide choices with confidence.

Develop career defensibility in 2026 by focusing on defensible work grounded in judgment, trust, and domain depth. Prioritize tasks that cannot be automated or easily replaced.

Join the interactive part to leverage networking and practical knowledge for real growth, share feedback through channels, and connect with alumni via telegram while receiving real frameworks and career support.

Finish the course to unlock career and business opportunities, share your achievement on social networks, join the alumni community, and receive ongoing support with practical knowledge for work success.