PLEASE ANSWER USING :

1 - EXCEL

2 - DISPLAY FUNCTIONS/CELLS USED AND PROVIDE ORGANIZED SOLUTION EXPLAINING ANSWER

I WILL UPVOTE YOUR ANSWER

IN Your firm has started a new project. The project has a cost of $75,000. The project is expected to generate free cash flows of $35,500 in year 1, $42,250 in year 2, $47,500 in year 3, $51,450 in year 4 and $53,750 in year 5. The required rate of return is 8.4% compounded annually. What is the payback period in years? O 1.44 YE 1.93 Ye 1.53 Yed Yea 1.60 Year