using a financial calculator or an Excel spreadsheet, calculate the following.

a. The present value of $250 to be received 18 years from now, using a(n) 9% discount rate.

b. The present value of the following end-of-year income streams, using a 4% discount rate and assuming it is now the beginning of 2018.

(Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.)

Using a financial calculator or an Excel spreadsheet, calculate the following. a. The present value of $250 to be received 18 years from now, using a(n) 9% discount rate. b. The present value of the following end-of-year income streams, using a 4% discount rate and assuming it is now the beginning of 2018. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) End of Year 2018 2019 2020 2021 2022 2023 2024 Income Stream A $50 50 50 50 50 50 50 Income Stream B $88 75 63 50 38 25 13 a. The present value of the future sum in part (a) is $ 53 (Round to the nearest cent.) b. The present value of Income Stream A in part (b) is $ . (Round to the nearest cent.) The present value of Income Stream B in part (b) is $ . (Round to the nearest cent.)