Forecast Capital Expenditures and Depreciation

Financial Modelling, Module

Forecast Capital Expenditures and Depreciation

$2.00

Master CapEx and depreciation forecasting. This lesson teaches you how to model long-term investments, apply depreciation methods, and link them across all 3 financial statements.

Categories: Financial Modelling, Module Tags: CapEx forecasting, capital expenditures, depreciation, Excel modelling, financial modelling, financial-statements, investing activities, PP&E, straight-line depreciation

Description
Reviews (0)

This video covers the following learning objectives:

Forecast capital expenditures and depreciation

Define CapEx and distinguish it from operating expenses

Forecast CapEx using revenue %, unit growth, or itemized plans

Apply different depreciation methods (straight-line, declining balance, MACRS/CCA)

Build depreciation schedules in Excel

Link CapEx and depreciation across the income statement, balance sheet, and cash flow statement

Reconcile changes in PP&E using accumulated depreciation

Reviews

There are no reviews yet.

Be the first to review “Forecast Capital Expenditures and Depreciation”