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.
Google Sheets Translator 🛠️
This tool translates Google Sheets content into another language with easy setup.
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.
Quantitative Approach to Auditing Forecasts in Going Concern Assessments and Valuations
This post discusses how using methods like time series analysis and regression can improve the accuracy of going concern assessments in audits.
Accounting for Acquisition of an Asset or a Group of Assets
This post explains how to account for asset purchases that aren’t businesses by allocating purchase costs based on fair values.
Accounting for Goodwill Impairment Under the Partial Goodwill Method
This post explains how to apply the partial goodwill method when accounting for goodwill impairment and excess losses.
Accounting for Reverse Acquisitions – Handling Non-Controlling Interests, Part 2
This post explains how to account for non-controlling interests in reverse acquisitions and adjust equity for non-participating shareholders.