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,
You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.
Fill in your assignment instructions on the order form
Immediately you contact us for homework help; we will assign your assignment to an academic expert.
We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission
Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.
Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.
Read on and find out some of the features that make our services superlative.
You can confirm that the content you get is original for free using our plagiarism checker.
We offer unlimited access to our essay homework samples.
Once you place an order, we format it accordingly without demanding additional charges.
We offer free unlimited revisions until your assignment is of your desired quality..
We have a team of specialized editors who review your assignment before submission.
You can track the progress of your homework for free.