5-26 Spreadsheet Problem: Number of Annuity Payments (LG5-10)ou realize that you can retire when you have $1 million in assets. You currently have $500,000 in retirement assets and contribute $545 more each month? If your investment portfolio earns an 8 percent annual rate of return, how long will it be until you can retire? Note: Do not round intermediate calculations and round your final answer to 2 decimal places. years