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 semiannually? ( LG 2-9 ) Future Interest The Answer Value Periods Rate ⇒ Will Be $100,000 12  2  24 5% $55,287.54 100,000 24 6 49,193.37 100,000 24 8 39,012.15 100,000 24 10 31,006.79