Financial Statements Modeling 2020 Learn With A Professional

Explore types of financial models—earnings (profit and loss), recapitalization, DCF analysis, and leveraged buyout modeling—across modules two, four, and five, and prepare for common technical interview questions in finance.

Set up a historical financial statements model and forecast the income statement, depreciation, and working capital. Link balance sheet, cash flow, equity, and debt schedules for sanity checks in Excel.

Forecast the income statement by anchoring the first year with stable margins and a driven revenue growth rate, then drag formulas for depreciation, taxes, and net income across periods.

Explore depreciation and amortization concepts, including straight-line and accelerated methods, tax benefits in early years, and forecasting from tangible assets to intangible assets like trademarks and software.

Forecast depreciation and amortization by building a depreciation schedule linked to net sales, capex, and property, plant and equipment, using straight-line depreciation and defined years.

Learn how working capital measures liquidity and operating efficiency, excluding cash and short-term debt, and forecast the balance sheet via turnover ratios for receivables, inventory, payables, and accrued liabilities.

Build and balance the balance sheet by forecasting total assets and liabilities, compute working capital ratios for receivables, inventory, and payables, and apply judgment on assumptions.

Learn to forecast the balance sheet by analyzing assets, liabilities, and owners' equity at a point in time, including cash, accounts receivable, inventory, property, plant and equipment, and goodwill.

Forecast and reconcile the cash flow statement with the balance sheet by modeling operating, investing, and financing activities; link net income, working capital, and capex to cash and equivalents.

Forecast the cash flow statement and balance sheet by linking net income to retained earnings, incorporating amortization, and adjusting intangibles to balance the model.

Forecast and complete the stockholders equity schedule by accounting for issuances, repurchases, and dividends, and link to financing activities while applying issuance and buyback price 75 and 25% payout.

Set up and verify the stockholders' equity schedule by linking beginning and ending balances to the balance sheet, incorporating net income, and validating the match across years.

Model dividend payout as 25 percent of eps, projecting per-share and total cash outflows, reflect in financing activity and adjust the stockholders equity schedule via retained earnings.

Forecast ending cash and debt by calculating cash available to service debt from free cash flow, applying a minimum cash cushion, and modeling revolver draws and repayments.

Make the model fully circular by linking interest income and expense with the net income statement, debt schedule, working capital, and cash flow statement, using iterative calculations.

Link interest income and expense to the income statement in a fully circular model, enable iterative calculation in excel, validate with f9, and run upside, downside, and base-case scenarios.

Link revenue, costs, and drivers to build a dynamic financial model with links across drivers. See how changing case scenarios yield different cash flows and valuations within the dcf framework.

Analyze the stock chart and press releases to assess fundamentals and decide whether a company is a growth, decline, cyclical, asset, or turnaround story, then build and sanity-check the model.

Learn to perform diligence by reviewing the company website's investor section and press releases to analyze stock performance, revenue, and EBITDA margins during turnarounds.

Explore how to read the Chipotle 10-K, focusing on business, MD&A, risk factors, financial statements, balance sheet, income statement, and cash flow to link earnings and stock performance for modeling.

Assess the due diligence findings by reviewing the stock chart, press releases, and sec filings, then interpret the recovery story and improving cash flows in the model.

Forecast working capital on the balance sheet by linking current assets and current liabilities to previous years, ensuring correct formatting and dragging formulas across.

Examine dividend payout by reviewing the 10 K, which reveals a zero dividend policy and no declared or paid dividends.

Forecast interest income by calculating ending cash balances from 2017 and 2018, linking to the income statement, and using the average cash balance to derive the interest on cash equivalents.

Link and adjust the revolver draw down in the financing activity section to keep the revolver line on the balance sheet dynamic, and set the sequence to previous year plus.

Massaging eBid margins and related operating costs aligns the model with consensus and Wall Street expectations through a rigorous sanity check of the operating model.