Sensitivity Analysis in Financial Modeling
Introduction to Sensitivity Analysis We apply Sensitivity Analysis to a financial model to determine how different values of an independent variable affect a specific dependent variable under a given set of assumptions. We also refer to it as ‘what-if’ or simulation analysis. Performing such analysis helps us predict better the outcome of a decision, based […]
Least-Squares Method to Estimate the Cost Function
Introduction Linear regression is considered the most accurate method in segregating costs into Fixed and Variable components. Like the High-Low Method and other methods, the Least-Squares Method follows the same simple linear cost function: However, most people consider the Least-Squares Method more accurate, as it computes Fixed and Variable Costs mathematically. When looking into costs, […]
The Absorption Costing Method
Today we take a look at the Absorption Costing Method and how it is used to allocate cost to produced goods. Do not forget to download the Excel working file at the end of the article. What is Absorption Costing? Absorption Costing is a management accounting method for accumulating all costs associated with production in […]