Comprehensive Guide to NWC, Valuation Methods, and Financial Ratios in Corporate Finance

What is the calculation for Net Working Capital?

NWC = AR + inventory + prepaids - AP - Accured Exp - Def Revenue

Intuition for NWC equation

AR increasing --> negative adjustment, because AR increasing means there is a positive (profit or deferred revenue) that hasn't been collected yet. Inventory going up --> spending money we haven't run through cogs. AP --> haven't paid for things yet that we are running through expenses, so add back the cash.

Cost of equity calculation

CAPM is the

What does Beta measure?

Beta is a measure of how correlated a particular stock is with the risk-free rate. It is a measure of the stock's volatility compared to the overall market.

Beta interpretation

A beta of 1 means the stock moves with the market. A beta higher than 1 means it is more volatile (greater risk and potentially greater return), lower means less volatile (lower risk and lower return).

CAPM formula

Risk free rate + (Beta * Equity Risk Premium).

Exit Multiple method valuation

Free cash flows + Terminal Value = EBITDA (year n) x Exit Multiple.

Intuition of Exit Multiple Method

With the Exit Multiple method, you're looking at comparable businesses and coming up with a reasonable multiple for the company / what investors would pay based on what investors would be willing to pay for the company at the end of the forecasted period.

Perpetuity Growth method valuation

(Free cash flows in year n+1) / (WACC - growth rate).

Perpetuity Growth method cash flow assumption

Assume an infinite series of cash flows, grow it one my year, and divide WACC - G.

What are the reasonable values for g in Perpetuity Growth method?

A logical growth rate will be 1,2, or 3% (often 3). That is because with higher numbers, it would theoretically come to take over the entire world economy. It will also never be higher than WACC.

Unlevered vs. Levered DCFs

Unlevered (more popular for interviews): ignores capital structure. Unlevered free cash flows. Discount rate is WACC, which reflects cost of both debt and equity. Output is Enterprise Value. Levered: Levered free cash flows, which represents the cash flow available after interest and debt payments. Discount rate is cost of equity. Output is Equity Value.

Discount factor formula

[1 + discount rate (WACC for unlevered, cost of equity for levered)] ^specific year of the projection.

CAGR formula

CAGR = r = (end/begin)^(1/yrs)-1.

5-year return implied by growth rates

10% - 1.6x, 15% - 2x, 20% - 2.5x, 25% - 3.0x, 30% - 3.7x.

Profit to cashflow transition

Assets changing.

Net Working Capital (NWC)

Net Working Capital (NWC) is defined as the difference between a company's operating current assets and its operating current liabilities. It is a key metric that measures a company's short-term liquidity and its ability to meet current obligations using its current assets. A current ratio greater than 1 implies the company is financially healthy in terms of liquidity.

Components of Net Working Capital

NWC comprises the assets and liabilities essential for a company's core, day-to-day operations. Operating Current Assets include: Working cash balances, Accounts Receivable (A/R), Inventories, Prepaid Expenses and other current operating assets. Operating Current Liabilities include: Accounts Payable (A/P), Accrued Expenses, Deferred Revenue, Income Taxes Payable.

What is Excluded from NWC?

Excluded from NWC: Cash and other short-term investments (like marketable securities or commercial paper) and any interest-bearing debt (e.g., loans, revolver, bonds) are excluded because they are non-operational and do not directly generate revenue

Importance of Net Working Capital

Liquidity: A company's liquidity risk is lower when it has more current assets relative to current liabilities. This implies a greater ability to cover short-term obligations.

Growth: In growing businesses, significant upfront investments in working capital are often required, which can cause a divergence between profit and free cash flow. Cash Flow Management: A shorter 'cash-to-cash' cycle, which means lower working capital requirements, facilitates faster internally financed growth.

Changes in NWC and Cash Flows

Changes in NWC provide insight into how a company's cash flows deviate from its accrual-based net income. An increase in NWC signifies that operating assets have grown, and/or operating liabilities have shrunk from the prior year.

Accounts Receivable (A/R)

Money customers owe for goods/services delivered.

Cash-to-Cash Cycle

The time it takes for a company to convert its investments in inventory and other resources into cash flows from sales.

What does an increase in NWC indicate?

This signifies that operating assets have grown, and/or operating liabilities have shrunk from the prior year. An increase in an operating asset is a cash outflow. Therefore, an increase in NWC leads to a decrease in cash flow.

What does a decrease in NWC indicate?

This signifies that operating assets have shrunk, and/or operating liabilities have grown from the prior year. Therefore, a decrease in NWC leads to an increase in cash flow.

Positive Interpretation of Negative NWC

Negative NWC can indicate operational efficiency, particularly common in industries with quick inventory turnover, efficient collection of revenue (e.g., high Accounts Receivable turnover), the ability to delay payments to suppliers (e.g., high Accounts Payable turnover), and efficiently investing excess cash into high-yield investments.

Negative Interpretation of Negative NWC

Negative NWC can also signify impending liquidity issues, especially if a company has mismanaged its cash, faces a high accounts payable balance coming due soon, has low inventory balances needing replenishment, or possesses low levels of accounts receivable.

NWC in Financial Modeling

NWC is often projected as a percentage of sales or revenue. Individual operating working capital items like Accounts Receivable, Inventory, and Accounts Payable are also forecasted (e.g., using 'days sales outstanding' or 'days payable outstanding').

Integration of NWC Forecasts

Ideally, NWC forecasts are derived from a full 3-statement model (Income Statement, Balance Sheet, Cash Flow Statement) to ensure that all interrelated components are dynamically linked.

Impact of NWC on Cash Flow Statement

Changes in operating working capital accounts are a direct component of building the cash flow statement.

NWC Treatment in Financial Institutions

For financial institutions like banks, a traditional unlevered Discounted Cash Flow (DCF) model is generally inappropriate because it's difficult to separate operating cash flows from financing cash flows, which impacts NWC treatment.

Relationship between NWC and Operating Working Capital

Operating Working Capital is often used interchangeably with Net Working Capital in the context of core operations. It comprises operating current assets minus operating current liabilities.

Invested Capital Definition

Invested Capital represents the total capital invested in a company's core operations, without distinguishing between debt and equity financing. It includes both property, plant, and equipment (PP&E) and operating working capital.

Invested Capital Calculation

The calculation is often expressed as: Operating Assets - Operating Liabilities = Invested Capital.

Return on Invested Capital (ROIC)

By isolating operating performance, Return on Invested Capital (ROIC), which relies on NOPLAT and invested capital, becomes independent of financial structure.

How is Net Working Capital (NWC) typically handled in financial modeling and forecasting?

Forecasting Method: NWC is often projected as a percentage of sales or revenue. Individual operating working capital items like Accounts Receivable, Inventory, and Accounts Payable are also forecasted (e.g., using "days sales outstanding" or "days payable outstanding").

Integration: Ideally, NWC forecasts are derived from a full 3-statement model (Income Statement, Balance Sheet, Cash Flow Statement) to ensure that all interrelated components are dynamically linked.

• Impact on Cash Flow Statement: Changes in operating working capital accounts are a direct component of building the cash flow statement.

• Financial Institutions: For financial institutions like banks, a traditional unlevered Discounted Cash Flow (DCF) model is generally inappropriate because it's difficult to separate operating cash flows from financing cash flows, which impacts NWC treatment.

What is the relationship between Net Working Capital, Operating Working Capital, and Invested Capital?

• Operating Working Capital is often used interchangeably with Net Working Capital in the context of core operations. It comprises operating current assets minus operating current liabilities.

• Invested Capital represents the total capital invested in a company's core operations, without distinguishing between debt and equity financing. It includes both property, plant, and equipment (PP&E) and operating working capital.

• The calculation is often expressed as: Operating Assets - Operating Liabilities = Invested Capital. By isolating operating performance, Return on Invested Capital (ROIC), which relies on NOPLAT and invested capital, becomes independent of financial structure.

Why is Net Working Capital important for assessing a company's liquidity and growth potential?;

Liquidity: A company's liquidity risk is lower when it has more current assets relative to current liabilities. This implies a greater ability to cover short-term obligations.

• Growth: In growing businesses, significant upfront investments in working capital are often required, which can cause a divergence between profit and free cash flow.

• Cash Flow Management: A shorter "cash-to-cash" cycle, which means lower working capital requirements, facilitates faster internally financed growth

What are the components of Net Working Capital?

NWC comprises the assets and liabilities essential for a company's core, day-to-day operations.

• Operating Current Assets (can be converted to cash within a year):

◦ Working cash balances (cash needed for operations, not excess cash).

◦ Accounts Receivable (A/R): Money customers owe for goods/services delivered.

◦ Inventories: Raw materials, unfinished, and finished goods.

◦ Prepaid Expenses and other current operating assets.

• Operating Current Liabilities (payments due within one year related to operations):

◦ Accounts Payable (A/P): Money owed to suppliers.

◦ Accrued Expenses: Liabilities for services received but not yet paid (e.g., salaries).

◦ Deferred Revenue: Payments received from customers for services/goods not yet delivered.

◦ Income Taxes Payable.

What 5-year return is implied by 10, 15, 20, 25, and 30% growth rates?

10% - 1.6x

15% - 2x

20% - 2.5x

25% - 3.0x

30% - 3.7x

How do you walk from profit to cashflow?

Increase to AR, increase in inventory as negative

Increases in AP and liabilities as a positive adjustment

Can bucket all these together into net working capital

Then, also Capex (not expensed right away, but over time as depreciation), so a negative adjustment

Depreciation - Add back (expense that isn't cash out the door)

Revenue - YoY forecast increase %

EBITDA - EDBITA %

D&A - % of sales

EBIT --> net income

○ Subtract pre-tax interest (but ignoring here, since unlevered)

○ Subtract taxes

Nuance is that this is meant to be unlevered (ignoring interest)

What is included in the income statement?

Revenue, Cost of Goods Sold, Gross Margin (Revenue - COGS), Operating Expenses, EBIT, Net Income (bottom line), Non-recurring charges/items

What is included in the balance sheet?

Assets - Current Assets (cash, AR due in 1 year, inventory), Accounts Receivable, PP&E (property, plant, and equipment), goodwill, non-operating assets (e.g., marketable securities).

Liabilities: Current Liabilites (AP, Accrued Expenses, Deferred Revenue), Long-term debt.

Shareholders' Equity - Retained Earnings, Treasury Stock

Working Capital / Net working Capital - The difference between current assets and current liabilities. Changes in NWC impact cash flow.

What's included in the Cash Flow Statement?

Cash Flow from Operations - cash generated from normal day-to-day business activities

Cash Flow from Investing - Cash flows related to purchase or sale of long-term assets (e.g., Capital Expenditures, Acquisitions).

Cash Flow from Financing - Cash flows related to debt, equity, and dividends (e.g., debt issuance /repayment, stock issuance / repurchase, dividends paid)

Depreciation and Amortization - non-cash expenses added back to net income when calculating cash flow from operations

Cash Reconciliation: Links the net change in cash to the beginning and ending balances in the balance sheet

What is retained earnings?

Accumulated Net Income - Dividends Paid. Any item hitting the income statement flows through retained earnings.

Market Risk Premium (MRP)

The expected excess return of the market portfolio over the risk-free rate

P/B Ratio (Price-to-Book)

Equity value multiple, useful for asset-heavy companies like banks where book value approximates market value

Cost of Debt (Rd)

The interest rate a company pays on its debt.

Often determined from the Yield to Maturity (YTM) of publicly traded debt

Sensitivity Analysis / Scenario Analysis

Testing how changes in key assumptions (e.g., revenue growth, WACC, terminal value multiple) impact the model's outcomes to assess robustness and potential risks