Building Financial Statements in Excel

Explore the three core financial statements—income statement, balance sheet, and cash flow statement—under GAAP, showing revenues, expenses, net income, assets equal liabilities plus stockholders' equity, and operating, investing, financing activities.

Analyze the balance sheet where assets equal liabilities plus equity. Review current and fixed assets, depreciation, and equity items such as retained earnings.

Explore the income statement by examining revenue, cost of goods sold, and gross profit, then subtract operating expenses, depreciation, and interest to reveal pretax income and net income.

Explore the cash flow statement by tracing operating, investing, and financing activities from net income, including depreciation, working capital changes, and capital expenditures, net cash flow, and free cash flow.

Learn to build income statements, balance sheets, and cash flow statements, see their interconnections and automatic updates, balance assets with liabilities and equity, using debt, depreciation, and a PPV schedule.

Learn to build an income statement in excel, calculating revenue, cost of goods sold, gross profit, operating expenses, ebitda, pretax income, income tax expense, and net income, with growth projections.

Compute accounts receivable, inventory, and accounts payable days from revenue and cost of goods sold, average over historical data for five forecasts, then complete balance sheet and cash flow statement.

Build the cash flow statement in Excel by linking net income, depreciation, and working capital to operating, investing, and financing activities, calculating net cash flow and beginning cash balance.

Build the debt schedule by linking long-term debt, line of credit, and minimum cash balance to cash flow and balance sheet data to complete the financial statements.

Build the PPE schedule in an integrated financial model by deriving depreciation from revenue using historical data and a five-year projection, linking PPE and capital expenditures to the balance sheet.

Explore financial ratio analysis as a quantitative tool for evaluating balance sheet, income statement, and cash flow; compute margins and turnover in Excel to assess performance, liquidity, and solvency.

Learn to calculate and interpret performance ratios in Excel, including gross profit margin, operating margin, net margin, ROA, ROE, earnings per share, and price-earnings ratio, using three-year statements.

Learn liquidity ratios in Excel: compute the current ratio to gauge short-term liability coverage, apply the acid test ratio by excluding inventory and prepaid expenses, and determine net working capital.

Explore financing ratios and leverage by examining debt ratio and debt-to-equity ratio, using Excel to calculate how debt and equity fund assets and liabilities.

Explore activity ratios in Excel, including asset turnover and inventory turnover, to assess how efficiently assets generate revenue and how inventory turns over across years.

Keep practicing to master building financial statements from scratch, using Yahoo Finance data to calculate and compare financial ratios, and steadily improve with each exercise.