Impairment Test (Value in Use)
This blog post provides an illustrative Cash Generating Units (CGUs) impairment test Excel file.
Calculation of Carrying Amounts for Cash Generating Units
This blog explains how to calculate the value of Cash Generating Units by allocating assets and ensuring consistency for impairment testing.
Reversal of Impairment for Cash Generating Units
This blog post explains when and how to reverse impairment for cash-generating units, outlining the key conditions and steps involved.
Linear Programming Optimization in Excel
This post provides a linear programming Excel template to help optimize outcomes with constraints.
Vanilla Bond Interest Rate Swap Valuation
This blog post explains the concept of interest rate swaps for vanilla bonds and how to value them using the binomial pricing model, providing a practical Excel template.
Valuation of American Options
This blog post explains the binomial model for valuing American options, and provides an Excel template for accountants to quickly estimate the fair value of these options.
Revenue Forecasting Template
This blog post provides a basic Excel template for revenue forecasting using time series methods, including simple average, moving average, trend fitting, and exponential smoothing techniques, with adjustable data and formulas for customization.
Valuation of European Options
This blog post explains the valuation of European options using the Black-Scholes model, and provides a practical Excel template for accountants to roughly estimate the fair value.