I am having difficulty with finding IRR, NPV and Payback on the assignment B&K Distributors. I have looked at other course hero submissions and find that my answers are much different than theirs with the same numbers on the spreadsheet. I'm not sure if I am selecting the right inputs for the calculations which is the problem.

With that said I need assistance sine the professor is MIA...

I wish I could upload my example but your system doesn't allow that...