header

Finance Review Lab Answers

 

Most of the answers can be found on the FinanceReviewLabAnswers.xlsx workbook. The answers to the what-if type questions can be found on this page.

Problem 1

A. How much interest will be earned on an investment of $1,000 at 5.5% compounded monthly for 7 years? What is the annual percentage yield for this investment?

B. Prepare a table showing how the balance grows during the term of this investment.

C. Prepare a chart illustrating the growth in the balance.

D. What if the interest rate decreases to 1.2% compounded monthly? Find the future value, the total interest earned, and the APY.

At 1.2% compounded monthly, the future value is $1,087.58, the total interest is $87.58, and the APY is 1.207%.

E. Go back to the original interest rate of 5.5% compounded monthly. Use your model to determine what investment would be needed to yield a future value of $2,000.

It would require an investment of $1,362.10.

Problem 2

A. What is the purchase price of a $500 savings bond that pays 4.6% compounded quarterly and matures in 6 years? What is the annual percentage yield for this investment?

B. Prepare a table showing how the value of the savings bond grows during the term of this investment.

C. Prepare a chart illustrating the growth in the balance.

D. What is the purchase price of a $900 savings bond?

A $900 savings bond would cost $684.01.

E. Set the future value back to $500 and use your model to determine what interest rate would result in a purchase price of $350.

The purchase price of a $500 savings bond would be $350 if the interest rate were about 5.99% compounded quarterly.

Problem 3

A. What is the monthly payment on a 5-year car loan of $10,000 at a nominal annual rate of 6.9%? What is the annual equivalent rate for this loan? The annual equivalent rate (AER) is another name for the annual percentage rate (APR).

B. Find the total interest that will be paid on this loan.

C. Prepare an amortization table for this loan.

D. Create a chart illustrating how the balance due decreases over the term of the loan.

E. Create chart showing how each payment is divided between interest and balance reduction.

F. What would the monthly payments be if the nominal rate fell to 0.9% compounded monthly?

The monthly payment would be $170.51.

G. Use your model to find the interest rate that would result in monthly payments of $200.

An interest rate of 7.42% compounded monthly would result in payments of $200 a month.

Problem 4

A. How much you would need to put into your savings account each month if the account paid 3.2% compounded monthly and you hoped to save $20,000 in 18 years? What is the annual percentage yield for this investment?

B. Find the total interest earned during the 18-year term.

C. Use your model to determine how long it would take to save $20,000 if you could invest $100 a month.

At $100 a month, it would take 161 months to save $20,000. That is 13 years and 5 months.

D. Change the number of years back to 18 and prepare a table showing how the balance in this account grows over time.

E. Create a chart illustrating how the balance grows over time.

Problem 5

A. Assuming monthly payments, how much interest will be paid on a 25-year mortgage of $80,000 at 8.19% compounded monthly? What is the annual percentage rate for this loan?

B. Suppose the customer took out a 30-year mortgage instead. How much are the monthly payments and how much interest will be paid?

The monthly payment would be $597.64 and the total interest would be $135,150.40.

C. Set the number of years back to 25 and prepare a table showing how the balance due on this mortgage decreases over time.

D. Create a chart illustrating how the balance decreases.

E. Create a chart showing how each payment is divided between interest and balance reduction.

F. What interest rate would allow the homeowner to pay off this mortgage with payments of $500 a month?

If the interest rate dropped to about 5.68% compounded monthly, the monthly payment would be $500.