Please give a step by step explanation. I need a clear understanding. You are offered an investment with returns of $ 1,652 in year 1, $ 3,677 in...

Please give a step by step explanation. I need a clear understanding.

You are offered an investment with returns of $ 1,652 in year 1, $ 3,677 in year 2, and $ 3,338 in year 3. The investment will cost you $ 6,072 today. If the appropriate Cost of Capital is 13.0 %, what is the Net present Value of the investment?

Given,Initial InvestmentInflow Year 1Inflow Year 2Inflow Year 3Cost of Capital $6,072$1,652$3,677$3,33813% Set this information in the below metioned manner to use excel formula of NPV:...