my question is long see below and attached

Complete Problems 5-63 and 5-65 in the textbook.

It is okay to prepare Problem 5-63 using Word or Excel. Problem 5-65 should be prepared using Excel. Please note, you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail.