Explore accounting as the language of business and how income statements, balance sheets, and cash flow statements reveal assets, liabilities, and equity to operators, owners, analysts, lenders, and accountants.

Analyze an income statement through a three-step framework: assess revenue growth, examine profitability margins, and apply peer-based comparable analysis to interpret performance.

Explore how a balance sheet summarizes assets, liabilities, and stockholders' equity, with current and long-term assets and liabilities, and how liquidity is analyzed using working capital and turnover days.

Explore the fundamentals of accounting through the analyst prep program's training material to build your knowledge before financial modeling.

Explore financial statements reporting to understand cash flows, liquidity, and debt capacity; analyze trends and ratios to tell the story of a company's health and due diligence.

Explore the three main financial statements—income statement, balance sheet, and cash flow statement—and learn what each reveals for investors and internal users about profitability, assets, liabilities, and cash movement.

Identify the main line items across income statement, balance sheet, and cash flow statement, and show how revenue relates to accounts receivable and how liabilities and equity fit together.

Explore how cash flow from operations reconciles net income to cash by adjusting for accruals, depreciation, and changes in working capital in a gap format.

Reconcile income statement, balance sheet, and cash flow statement on an accrual basis, showing how accounts receivable, depreciation, net income, and retained earnings flow to assets and equity.

Analyze a student investment presentation on Facebook to explore company profile, products, global footprint, user experience, and competitive market share, while examining financial statements and industry performance.

Analyze Facebook's income statement and margins, noting high EBIT margins, revenue growth, and strong operating cash flow, then assess balance sheet health and valuation via DCF and comps.

Analyze Snapchat's 10-K to examine share structure and voting rights, noting three share classes. Founders control 99 percent of voting power, limiting public shareholder influence.

Analyze a company's income statement from its 10K to assess financial performance, highlighting operating and net income losses from 2017–2019 and the resulting earnings per share.

Analyze the balance sheet for liquidity and working capital, noting 520 million in cash equivalents and 1.5 billion in marketable securities, and review cash flow for inflows and outflows.

Analyze snapchat's cash flow statement: negative operating cash flow and substantial stock-based compensation that dilutes shareholders. Note heavy short-term marketable securities activity and financing through stock issuances and convertible notes.

Explore how to research companies using public information, read and organize financial data, and conduct due diligence to prepare for financial modeling.

Learn to assess a company by analyzing its business model, products, industry dynamics, and growth drivers using a top-down, macro perspective for due diligence.

Understand why stock prices increase through revenue growth, profit margins, and earnings per share growth, leading to explosive gains in six to twelve months.

Map a company’s story to five growth types through due diligence, gather public data from SEC filings, earnings calls, and press releases, and present client-ready insights with a Wal-Mart example.

Analyze the big picture by studying industry trends, size, market share, growth, drivers, and competitors; assess industry margins and capital structure, and the economic cycle to set a price target.

Analyze operating performance using key metrics—revenue growth, net income, earnings per share, profit margins, and returns on assets and equity—and assess liquidity and industry comparisons through working capital.

Equity research reports summarize industry coverage, drivers, and four financial models from bulge-bracket banks, enabling you to form buy or sell recommendations and conduct thorough company diligence.

Explore the mattress industry landscape, including market size of $15 billion, 355 firms, concentration by five majors, growth, shipments, lifespan, and the premium segment for investment analysis.

Explain how GDP, unemployment rate, personal disposable income, median household income, and immigration drive the U.S. mattress market, linking economic strength to demand for new mattresses and furnished housing.

Explore Walmart's company profile, including business description, operating segments, revenue breakdown, and annual EBITA margins, and learn how to obtain data from company filings and the Walmart investor relations site.

Bottom-up analysis benchmarks Walmart against competitors, assessing earnings growth, return on equity, p/e multiples, dividend yields, and EBITA margins to gauge profitability and valuation in the spread of commerce.

Apply a five-step due diligence - company profile, lifecycle, future expectations, and a valuation using DCF and comparable company analysis - then build financial model and assess catalysts and risk.

Learn to locate Wal-Mart's 10-K and read its business overview, segment details, and financial statements, including management discussion and analysis, to understand revenue drivers and margins.

Learn how due diligence builds the company story using SEC filings, press releases, investor relations materials, and the website to form a buy or sell thesis and defend your decision.

Learn to navigate and excel efficiently in Excel, using shortcuts and key functions through analyst prep material to build confidence before financial modeling.

Master Excel modeling through practical application, shortcuts, and powerful functions to speed up analyst work, navigate Excel efficiently, and save time in day-to-day diligence and production tasks.

Master Excel functions, tools, and shortcut keys to boost efficiency in financial models and analyst tasks. PCs dominate financial modeling, while Mac users can run Windows to access the shortcuts.

Configure Excel options and enable iterative calculations to support circular references in financial models, and customize the quick access toolbar for efficient formulas, formatting, and navigation.

Apply consistent color schemes in Excel models to indicate inputs, calculations, and links across sheets. Use blue for inputs, black for calculations, green for links, and red for warnings.

Master Excel navigation and fundamentals to boost efficiency by using keyboard shortcuts such as control+arrow to jump edges, shift+arrow to extend selection, and control+page down to move between sheets.

Master Excel functions to apply logic in your model, starting with the if statement and what-if scenarios. Use offset references, v look up, and index and count to analyze data.

Master Excel basics for financial modeling by setting up toolbars, navigating shortcuts, and formatting cells for client-ready reports. Learn to model scenarios and income statements with color-coded cues and presentation.

Set up your quick access toolbar in Excel, customize formatting options, and study how to remove grid lines, set print area, and review print preview for clean, print-ready spreadsheets.

Navigate Excel efficiently by mastering keyboard shortcuts, such as control and arrow keys, shift selections, and tab navigation, to speed up balance sheet analysis and formatting with quick keystrokes.

apply professional excel formatting for financial statements by centering across, adding borders, and formatting currency and percentages, including custom formats with X to indicate multiples, while avoiding merged cells.

Explore how to use the sum function to calculate totals, copy and paste formulas and formats, and apply paste special to preserve or transpose data in financial statements.

Master anchoring cells in Excel with F4 to create absolute references, drag formulas across and down while keeping cells constant, and use the go to (F5) function to trace dependencies.

Learn to build dynamic scenarios in Excel using choose, offset, and if statements to model upside, baseline, and downside cases on an income statement.

Learn to build and forecast an income statement in Excel by calculating year-over-year changes, gross profit and margins, and projecting revenue with a driver.

Master Excel workflows, from print setup and shortcuts to copy, paste special, and anchoring; build dynamic models with if, choose, and offset, and recreate an income statement for practice.