Computing compound interest and annuity

Reference no: EM1354683

As a financial planner a client comes to you for investment advice. After meeting with him and understanding his needs, you offer him the following two investment options:

Option 1 (refer to Chapter 3): Invest $5,000 in a savings account at 6.6% interest compounded monthly.

Option 2 (refer to Chapter 3): Invest into an ordinary annuity where $1,100 is deposited each year into an account that earns 4.8% interest compounded annually.

SPREADSHEET:

Set up the formula for compound interest for Option 1 and the formula for Future Value of an Annuity for Option 2 in an Excel spreadsheet to calculate the amount earned at the end of 6 years. Be sure to label all variables in your spreadsheet.

MEMO:

After creating the spreadsheet with the two different investment options, write a memo that addresses the following points for your client:
Explain to your client what compound interest is.
Explain to your client what an annuity is.
From the calculations in the Excel spreadsheet for Option 1 and Option 2, explain which investment option is better for your client and why.

Reference no: EM1354683

Questions Cloud

Calculate the firms operating cycle : James Corporation is worried about managing cash efficiently. On the average, inventories have an age of 90 days, and accounts receivable are collected in sixty days.

What are the magnitude and direction of the electric field : The edge of a cube consist of equal resistors of resistance R, that are joined at the orners, let a battery be connected to two opposite corners of a face of cube. what is the efective resistance.

What price is plotted on the vertical axis : What Price is plotted on the vertical axis, and quantity is plotted on the horizontal axis.

Assessment instruments evaluating suicidal tendencies : What are the assessment instruments that evaluate a construct such as suicidal tendencies.

Computing compound interest and annuity : As a financial planner a customer comes to you for investment advice. After meeting with him and understanding his requirements, you offer him the following two investment options:

Explain how will the level of the velocity of money change : Explain how will the level of the velocity of money change if there is a permanent (one time) increase in the nominal interest rate, holding other factors constant.

Explain what personality traits does maxine clark appear : Explain What personality traits does Maxine Clark appear to be high on and Discuss and What personality traits is she probably low on? Discuss.

Audit engagement letter sample : What items are usually included in an effective engagement letter? Have you seen an engagement letter at your workplace or familiar with one and how are you involved in the process? Please find an engagement letter and comment on it

Illustrate what conclusions can you draw : Illustrate what conclusions can you draw about this period by comparing this cycle to previous business cycles.

User Account

All Pages