Learning Goal: I’m working on a accounting multi-part question and need an expla

Learning Goal: I’m working on a accounting multi-part question and need an explanation and answer to help me learn.The problem is in the file below “Comprehensive Problem IV.doc”
This problem covers the Capital Investment Analysis calculations such as Cash Payback Period, Annual and Simple Rate of Return, Net Present Value, and Profitability Index for equal cash flow proposals and unequal cash flow proposals.
Please refer to the additional study material provided for Chapter 26 to assist you to complete the assignment. In addition, make sure to watch the comprehensive problem IV overview video and comprehensive problem IV helpful hints video to assist you in completing the assignment.
Make sure to show all work and submit it as an excel or word document.