About Financial Modeling Depreciation
In financial modelingWhat is Financial ModelingFinancial modeling is performed in Excel to forecast a company's financial performance. Overview of what is financial modeling, how & why to build a model. A 3 statement model links income statement, balance sheet, and cash flow statement. More advanced types of financial models are built for valuation, plannnig, and, depreciation can be calculated several different ways: (1) as a percentage of revenue, (2) as a percentage of property plant and equipment, (3) on a straight-line basisStraight Line DepreciationStraight line depreciation is the most commonly used and easiest method for allocating depreciation of an asset. With the straight line method, the annual depreciation expense equals the cost of the asset minus the salvage value, divided by the useful life (# of years). This guide has examples, formulas, explanations, and (4) on an accelerated basis. The most appropriate method to use in your model will depend on how much detail is required and what the ultimate use for the analysis is. An FP&A model, for example, requires lots of detail on depreciation, while an LBO modelLBO ModelAn LBO model is built in excel to evaluate a leveraged buyout (LBO) transaction, which is the acquisition of a company that is funded using a significant amount of debt. The aim of the LBO model is to enable investors to properly assess the transaction earn the highest possible internal rate of return (IRR)., by contrast, does not.
