What is the present value of

Assignment Help Financial Management

Reference no: EM131928012

Instructions : Complete each of the following four problems using the TVOM calculations within Excel.

The assignment

MUST be done on an Excel spreadsheet (you will need to create your own spreadsheet) and MUST use TVOM calculations within Excel.

These functions are under the Fx button in Excel, then look under the Financial Functions.

The Fx Function is located just above the actual number section of your spreadsheet, right above the B or C column in most blank spreadsheets and most versions of Excel.

Just click on the Fx button and then search for the specific function (present value, future value, etc., whatever you are trying to calculate).

If you get the answers correct and have a good presentation, but you do NOT use the EXCEL TVOM functions,

Problem 1:

What is the present value of:

a. $9,000 in 7 years at 8 percent?

b. $20,000 in 5 years at 10 percent?

c. $10,000 in 25 years at 6 percent?

d. $1,000 in 50 years at 16 percent?

Problem 2:

If you invest $9,000 today, how much will you have:

a.In 2 years at 9 percent?

b. In 7 years at 12 percent?

c. In 25 years at 14 percent?

d. In 25 years at 14 percent (compounded semiannually)?

Problem 3:

Your uncle offers you a choice of $30,000 in 50 years or $95 today. If money is discounted at 12 percent, which should you choose?

Problem 4:

Your aunt offers you a choice of $60,000 in 40 years or $850 today. If money is discounted at 11 percent, which should you choose?

Reference no: EM131928012

Questions Cloud

Hedging using options as compared to futures contracts : Discuss the advantages and disadvantages of hedging using options as compared to futures contracts.

What are some concepts behind variance analysis : Why is it important to test for variances in your data? Explain. How is variance analysis used in your profession? Provide an example.

Write a program that encrypts a given plaintext file : Write a program that encrypts a given plaintext file with the given key. The program gets the name of the file that contains the key, name of the file.

What is a one-way analysis of variance : What is a one-way analysis of variance? What is a two-way analysis of variance? Provide an example of when you would use each approach?

What is the present value of : Your uncle offers you a choice of $30,000 in 50 years or $95 today. If money is discounted at 12 percent, which should you choose?

Find the probability that in a random sample : Please assist me with the lay out to find the probability that in a random sample of 10 newborn babies the mean weight is more than 120.3 ounces

Dependent sample with two variables : What inferential statistic would you use for a independent sample with two variables?

What interest rate would you earn : The U.S. Treasury offers to sell you a bond for $613.81. What interest rate would you earn if you bought this bond at the offer price

How important protecting your online presence is growing : How important protecting your online presence (across all services you use) is growing in importance, both for you, personally, as well as professionally.

User Account

All Pages