Attached is a practice problem and possible excel format for understanding the calculations.
Please see the attachment.
The excel file uses the format provided by you. All calculations are through formula. Please see the cell formula for calculation details.
2.) To help me understand this process, please explain why or ...
The solution explains how to determine the cash flows and calculate the NPV, IRR, RoR and Payback