Purchase Solution

Use an Excel Spreadsheet andthe FV function for following

Not what you're looking for?

Ask Custom Question

A. The future value of a $2,000 annuity for 30 yrs at 8% compound annually.
b. The future value of a $2,000 annuity for 30 years at 8% compound semiannually.
c. The future value of a $2,000 annuity for 30 years at 8% compound quarterly.
d. How much extra interest is earned onthe annuity above simply by chnaging the compounding period from annually to quarterly?
e. How much extra interest would be earned by changing from annual compounding to daily compounding?
f. Louisa set up an individual retirment account (IRA account) on her 35th birthday. She contributed $2,000 to the account on each subsequent birthday through her 65th. The account earned 8% compounded annually. What amount of interest (in dollars) wil she have earned on this investment?
g. Suppose she had startd an IRA account 10 yrs earlier whe she was 25 years old. How much would additional inte33rret wold she have earned on this investment by age 65? (Hint: Her first payment into the account was on which birthday?)

Purchase this Solution

Solution Summary

The expert uses Excel Spreadsheets and the FV function for annuity. A Complete, Neat and Step-by-step Solution is provided in the attached file.

Purchase this Solution


Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts