# Question: Using a financial calculator or an Excel spreadsheet calculate the

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

a. The present value of $500 to be received 4 years from now, using an 11% discount rate.

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

a. The present value of $500 to be received 4 years from now, using an 11% discount rate.

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

## Answer to relevant Questions

Terri Allessandro has an opportunity to make any of the following investments. The purchase price, the amount of its lump-sum future value, and its year of receipt are given below for each investment. Terri can earn a 10% ...For each of the following initial investment amounts, calculate the future value at the end of the given investment period if interest is compounded annually at the specified rate of return over the given investment period. What is an efficient portfolio, and what role should such a portfolio play in investing? How can the return and standard deviation of a portfolio be determined? Compare the calculation of a portfolio’s standard deviation to that for a single asset. Use the table of annual returns in Problem for Home Depot (HD) and Lowe’s (LOW) to create an Excel spreadsheet that calculates the standard deviation of annual returns for HD, LOW, and the equally weighted portfolio of HD ...Post your question