First, define the requirement and not just the goal.
Fixed Recovery Costs will probably meas as many things to as many people.

On a sheet of paper (remember that stuff?) visualise what you want,
including some sample calculations. You can then use that as the start of
constructing your Excel solution.