Attached is a practice problem and possible excel format for understanding the calculations.© BrainMass Inc. brainmass.com April 3, 2020, 8:27 pm ad1c9bdddf
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