I-need-help-with-the-formulas-for-all-of-the-yellow-squares-Excel-Assignment-Homework-Help

This is FIN/370  I am really confused about the formulas for the questions in the yellow. If someone can please help me to understand these formulas

This is what out instructor advised as well:

Please note the beginning cash balance for January is the ending cash balance of December.  Please note you are providing calculations from January to June. 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.