To simplify the calculations, we can create an Excel template that takes into account the above calculations. Here's an example template: