In lieu of a final exam, you are tasked with building VBA code to solve some sort of Excel problem that

plagues you. This can be an academic problem or a work$-$related problem. It should be related to

accounting, finance, or business in general.

At a minimum, your code must incorporate:

$$ variables,

$$ looping,

$$ and logic

I will give bonus points for more complexity.

You must also add comments in your code explaining what the code is doing.