Explore BrainMass

# Calculating Problems In Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

How do you calculate these problems using Excels function key(fx)? All my calculations are negative values.

See attached file for full problem description.

Quiz Questions 1, 2, 6
1. Present Values. Compute the present value of a \$100 cash flow for the following combinations of discount rates and times:
a. r = 8 percent. t = 10 years.
b. r = 8 percent. t = 20 years.
c. r = 4 percent. t = 10 years.
d. r = 4 percent. t = 20 years.
2. Future Values. Compute the future value of a \$100 cash flow for the same combinations of rates and times as in problem 1.

6. Calculating Interest Rate. Find the interest rate implied by the following combinations of present and future values:

Practice Problems 21 (using the excel 'PMT' function), 36, 37
21. Loan Payments. If you take out an \$8,000 car loan that calls for 48 monthly payments at an APR of 10 percent, what is your monthly payment? What is the effective annual interest rate on the loan?

Quiz Questions: 5 and 6
5. Bond Pricing. If Circular File (see question 4) wants to issue a new 6-year bond at face value, what coupon rate must the bond offer?

6. Bond Yields. An AT&T bond has 10 years until maturity, a coupon rate of 8 percent, and sells for \$1,100.
a. What is the current yield on the bond?
b. What is the yield to maturity?

Practice Problem 18
18. Bond Prices and Yields.
a. Several years ago, Castles in the Sand, Inc., issued bonds at face value at a yield to maturity of 7 percent. Now, with 8 years left until the maturity of the bonds, the company has run into hard times and the yield to maturity on the bonds has increased to 15 percent. What has happened to the price of the bond?

b. Suppose that investors believe that Castles can make good on the promised coupon payments, but that the company will go bankrupt when the bond matures and the principal comes due. The expectation is that investors will receive only 80 percent of face value at maturity.
If they buy the bond today, what yield to maturity do they expect to receive?