Please show all work and if you know how to enter it in Excel as PMT.
Upon graduating from college 35 years ago, Dr. Nick Riviera was already planning for his retirement. Since then, he has made deposits into a retirement fund on a monthly basis in the amount of $100. Nick has just completed his final payment and is at last ready to retire. His retirement fund has earned 6 percent compounded monthly. Use five decimal places for the periodic interest rate in your calculations. a. How much has Nick accumulated in his retirement account? b. In addition to this, 10 years ago Nick received an inheritance check for $25,000 from his beloved uncle. He decided to deposit the entire amount into his retirement fund. What is his current balance in the fund? a. The amount Nick has accumulated in his retirement account is $ (Round to the nearest cent.) b. The amount the $25,000 inheritance check has accumulated to over 10 years is $ (Round to the nearest cent.) The current balance in Nick’s retirement fund is $ (Round to the nearest cent.)