FIN 204 Princess Nourah bint The Time Value of Money problems
Business Finance
solve the following problems by using Microsoft Excel:
Problem 1: You have $12,000 in cash. You can deposit it today in a mutual fund earning 8.2 percent annually; or you can wait, enjoy some of it, and invest $11,000 in your friend’s business in two years. Your friend is promising you a return of at least 10 percent on your investment. Whichever alternative you choose, you will need to cash in at the end of 10 years. Assume your friend is trustworthy and that both investments carry the same risk. Which one will you choose?
Problem 2: You want to buy some bonds that will have a value of $1,000 at the end of seven years. The bonds pay 4.5 percent interest annually. How much should you pay for them today?
Problem 3: Dynamics Telecommunications Corp. has made an investment in another company that will guarantee it a cash flow of $22,500 each year for the next five years. If the company uses a discount rate of 15 percent on its investments, what is the present value of this investment?
Problem 4: A sales executive at a XY firm, is 25 years old and plans to invest $3,000 every year in an account, beginning at the end of this year until she turns 65 years old. If the investment will earn 9.75 percent annually, how much will she have in 40 years when she turns 65 years old?
Name the excel document as “Fin204-Assignment1”. .
Kindly check chapters attached in order to check the equations to solve the questions,
