e cel x Using a Spreadsheet to Calculate Future Value of Annuities. What is the future value of $1,000 invested each month for 10 years at 5 percent, 6 percent, 8 percent, and 10 percent, compounded monthly? ( LG 2-9 ) Annuity Interest The Answer Payment Periods Rate ⇒ Will Be $1,000 10  12  120 5% $155,282.28 1,000 120 6 163,879.35 1,000 120 8 182,946.04 1,000 120 10 204,844.98