PLEASE ANSWER USING :

1 - EXCEL

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

I WILL UPVOTE YOUR ANSWER

39) Your firm is about to start a new project. The project has a cost of $85,000. The project is expected to generate free cash flows of $51,450 in year 1, $53,750 in year 2, $35,500 in year 3, $42,250 in year 4 and $47,500 in year five. The required rate of return on the project is 8.4% compounded annually. What is the discounted payback period? Option A -2.16 Option B - 1.82 Option C -2.44 Option D -1.94