David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.

Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.

The PMT function is an Excel Financial function that returns the periodic payment for an annuity. The formula for the PMT function is PMT(rate,nper,pv, [fv], [type]). The NPV function returns the net ...

If you are looking to improve your financial modelling skills when using Microsoft Excel spreadsheets you might be interested in this quick overview guide that provides an in-depth exploration of the ...

Microsoft Excel allows us to create Custom Excel Functions or User Defined Functions using VBA. We can create Custom Excel Functions with the functionality we want and they can be accessed in the ...

While I'll always argue that SUM is my favorite and most-used Excel formula, there are plenty of other powerful functions included in the software. These features go far past using Excel as a digital ...

Financial mistakes can be inadvertent or they can be solely due to lack of command over the subject matter. Some mistakes can be fatal and some may be trivial but embarrassing. Whatever the cause or ...