Download the Excel worksheet to get the most out of this problem or to add it to your curriculum.
Download is not required to watch the video and see how the problem is worked but working through problems in Excel is the best way to understand accounting.