I have been attempting this problem for about 4 hours, read through the chapter 3 times, and yet I can still not complete this question. :confused:

Here is the excel template I looked up to view the format, which also includes the question:
Kimmel, Weygandt, Kieso: Financial Accounting: Tools for Business Decision Making, 4th Edition - Student Companion Site

It is question P5-6A.

Please, I really need help. Any feedback would be greatly appreciated. Thank you.

-__-, this isn't my homework, just a problem I'm attempting to gain knowledge about this topic.