# Question: Use a financial calculator or an Excel spreadsheet to estimate

Use a financial calculator or an Excel spreadsheet to estimate the yield each of the following investments.

## Relevant Questions

Sara Holliday must earn a return of 10% on an investment that requires an initial outlay of $2,500 and promises to return $6,000 in 8 years. a. Use present value techniques to estimate the yield on this investment. b. On the ...A company paid dividends of $1.00 per share in 2006 and just announced that it will pay $2.21 in 2013. Estimate the compound annual growth rate of the dividends. Given a real rate of interest of 2%, an expected inflation premium of 3%, and risk premiums for investments A and B of 4% and 6%, respectively, find the following. a. The risk-free rate of return, rf b. The required returns ...Describe, compare, and contrast the concepts of future value and present value. Explain the role of the discount rate in calculating present value. Congratulations! You have won the lottery! Would you rather have $1 million at the end of each of the next 20 years or $15 million today? (Assume an 8% discount rate.)Post your question