e cel x Using a Spreadsheet to Calculate Present Values. What is the present value of $100,000 invested for 12 years at 5 percent, 6 percent, 8 percent, and 10 percent compounded annually? ( LG 2-9 ) Future Interest The Answer Value Periods Rate ⇒ Will Be $100,000 12 5% $55,683.74 100,000 12 6 49,696.94 100,000 12 8 39,711.38 100,000 12 10 31,863.08