Need help with a time value of money question.

There are three parts to this question. Q1, Q2 and Q3 and each has its separate tab in the spreadsheet.

For question 1 please include where you get the rates that state are given. I can't figure that out and it seems like it should be pretty easy.

For question 2 Please help me understand the differences between and why there are five columns and why is the bottom number in the last four columns 0.

Please do not repost the answer that already exists on CH.

For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016. For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016. For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016. For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016. For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016. For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016. For the exclusive use of K. Weaver, 2016. This document is authorized for use only by Kimberly Weaver in HCMBA 6234 Financial Management taught by Neil G Cohen, George Washington University from October 2016 to December 2016.