Advance - Financial Statement, and Financial Modeling

Explore how internal and external financial reporting, IFRS and US GAAP, and advanced financial statement analysis enable transparent reporting, risk assessment, and informed investment and lending decisions.

Explore the differences between financial accounting and accounting, and how financial reporting presents income statements, balance sheets, cash flows, and notes for external and internal stakeholders under GAAP or IFRS.

Explore the balance sheet as a snapshot of assets, liabilities, and owner's equity on a specific date; understand current versus non-current items, and the basics of depreciation and intangible assets.

Understand balance sheet dynamics by differentiating current liabilities such as accounts payable, trade notes payable, unearned revenue, and accrued liabilities, and explore long-term debt, refinancing, and deferred revenue.

Equity represents the owner's residual stake after liabilities, detailing capital stock, additional paid in capital, retained earnings, accumulated other comprehensive income, and non-controlling interests, linking dividends and liquidation.

Explore the income statement's role in measuring financial performance over a period, linking revenue, cost of goods sold, EBITDA, operating income, and taxes under accrual accounting.

Explore income statement anatomy, including operating income and core business revenue and expenses. Review revenue recognition methods such as percentage of completion, cost recovery, and IFRS 15.

Explore the income statement from expenses to gains. Learn cost recognition methods, matching principle, depreciation, and noncontrolling interest while addressing unusual and extraordinary items.

Explore non-controlling interests and minority equity in consolidated statements. Learn how they affect equity, net income, and cash flow in consolidated reporting.

Explore the statement of cash flow overview, detailing operating, investing, and financing activities, and learn to adjust net income for accruals, depreciation, and working capital changes.

Explore the three cash flow classifications—operating, investing, and financing—within the statement of cash flow, and learn to compute net cash flow, reconcile cash balances, and handle non-cash and trading securities.

Explore the cash flow statement structure—operating, investing, and financing activities—and how depreciation, inventory, receivables, payables, and limitations of indirect methods shape interpretation.

Learn to build a cash flow statement by reconciling net income with operating, investing, and financing activities, adjusting for depreciation and working capital to ensure ending cash matches balance sheet.

Practice solving the statement of cash flows MCQs to calculate operating activities by adjusting net income for depreciation, changes in payables and receivables, and cash and cash equivalents.

Discover how the statement of comprehensive income merges net income with other comprehensive income to show total equity changes, including unrealized gains, accumulated OCI, and retained earnings.

Examine the statement of changes in stockholder equity, focusing on opening and ending balances for common stock, preferred stock, additional paid-in capital, retained earnings, other comprehensive income, and non-controlling interests.

Explore performance analysis by comparing static and flexible budgets, performing variance analysis, and applying horizontal and vertical analyses to assess year-to-date performance for advance financial statement analysis and financial modeling.

Advance financial statement analysis and financial modeling teaches horizontal and vertical analysis in depth in excel, applying common-size, budget versus actual variance, and period-to-period insights.

Analyze an income statement and cash flow using vertical and horizontal (year-on-year) analyses to assess revenue patterns, expenses, gross profit, operating income, and profitability, plus debt and equity implications.

Explore balance sheet analysis by identifying assets, liabilities, and equity, and link them to current and non-current classifications, cash flows, and key items like accounts receivable and inventory.

Explore cash flow statement review and ratio analysis to assess liquidity and profitability, including return on equity, asset turnover, current and quick ratios, and operating cash flow.

Configure Excel for financial modeling with automatic calculations and keyboard workflows. Practice income statements, common size statements, and scenario planning with rc1 referencing, autosave, and the Data Analysis Toolpak.

Learn practical Excel techniques for employee data, including flash fill, vlookup and hlookup, data filtering by department, and using absolute references with F4 to automate updates.

Set the currency to KRW for India and plot historical data with projections. Use Ctrl-1 custom formatting to show actual versus forecast and avoid hard coding.

Learn to build an industry-standard financial model by constructing an income statement, applying blue formula cells and black hard-coded values, and auditing with a color-coded formatting workflow.

Develop common size statements by expressing income statement items as a percentage of revenue, format as percent, lock references with dollar signs, and group data for analysis.

Apply scenario planning to the income statement by analyzing revenue and net income under 5%, 10%, and 12% changes, using blue for hard-coded inputs and black for formulas.

Automate financial models with dynamic income statements, linked assumptions, and scenario planning. Apply common-size analysis and conditional formatting while avoiding hard-coded inputs using robust date formulas.

Learn to build a five-year financial model using historical data to prepare an income statement. Incorporate realistic revenue growth, cogs, operating expenses, depreciation, taxes, and bias considerations from internal teams.

Learn to prepare a balance sheet for a leverage buyout model, linking assets, liabilities, and equity to income statements and cash flow; cover key assumptions, working capital, depreciation, and goodwill.

Explore how to prepare a cash flow statement from net income, add back depreciation, adjust for working capital changes, and reconcile operating, investing, and financing activities.

Learn how regression analysis links time, marketing and other variables to forecast sales, interpret trend lines, R-squared and p-values, and apply seasonality factors in Excel.

Learn to forecast sales using multiple regression analysis by examining how marketing and R&D drive sales, evaluate models with r-squared, adjusted r-squared, and p-values, and refine data for accurate forecasts.

Learn to build and interpret a multiple regression model for forecasting sales using period, quantity, and marketing, evaluate model fit with R square and standard error, and assess variable impact.

Analyze regression analysis with multiple dependent and independent variables, showing how marketing and R&D influence sales using R, R², adjusted R², and p-values to improve forecast accuracy.

Explore causal forecasting by building regression models with correlated variables, selecting independent variables, cleaning data, and interpreting p values, t values, and r-squared to forecast sales.

Explore regression analysis as a data-driven forecast tool linking dependent and independent variables for budgeting and cost estimation. Recognize its limits: relies on historical data and linearity assumptions.

Learn to use expected value for forecasting and budgeting by converting multiple sales forecasts into a single budget, guided by probability, regression analysis, and scenario planning.