You are going to pay $$800$ into an account at the beginning of each of $20$ years. The account will then be left to compound for an additional $20$ years until the end of year $40,$ when it will turn into a perpetuity. You will receive the first payment from the perpetuity at the end of the ${41}^{st}$ year. If the account pays $14\%,$ how much will you receive from the perpetuity each year $($rounded to nearest $$1,000)?$

A$)$ $$160,000$

B$)$ $$150,000$

C$)$ $$170,000$

D$)$ $$140,000$

Answer this question using Excel