Can anyone tell me how to solve this in excel? I am having a hard time with this.

Sherwin Williams will earn $19,750 a year for the next 15 years for a picture he has painted. At an interest rate of 6 percent, how much are the earnings worth today? (Enter your answer as a positive number rounded to 2 decimal places.) b. Should he be willing to sell his future earnings now for $168,000? O Yes No