Post a New Question

Business Algebra

posted by .

Part I:
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 section on Mathematics of Finance in your text.): Invest $23,000 in a savings account at 4.25% interest compounded quarterly.

Option 2 (refer to section on Mathematics of Finance in your text): Invest into an ordinary annuity where $5,000 is deposited each year into an account that earns 6.6% 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 5 years.

  • Business Algebra -

    http://www.jiskha.com/display.cgi?id=1292938297

  • Business Algebra -

    1. Pt = Po(r + 1)n.

    r = (APR/4) / 100 = (4.25/4) / 100 = 0.010625 = Quarterly percentage rate.

    n = 4 comp/yr*5 yrs = 20 comp periods.

    Pt = 23000(1.010625)^20,
    Pt = 23000 * 1.2354 = 28413.75

    Int. = Pt - Po,
    Int. = 28413.75 - 23000 = 5413.75.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Business Algebra

    I need to know the formula for these questions and just how to do them. If you could help please. As a financial planner a client comes to you for investment advice. After meeting with him and understanding his needs, you offer him …
  2. math/ compounded

    Scenario: A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option …
  3. math

    A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option would …
  4. math

    A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option would …
  5. math

    A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option would …
  6. math

    A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option would …
  7. Math

    A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option would …
  8. Investment interest

    Scenario: A client comes to you for investment advice on his $500,000 winnings from the lottery. He has been offered the following options by three different financial institutions and requests assistance to help understand which option …
  9. Algebra I

    5. Holly wants to invest $1000. The table below shows the value of her investment under two different options for two different years: Part A: What type of function, linear or exponential, can be used to describe the value of the investment …
  10. Algebra 1- Help please

    Belinda wants to invest $1000. The table below shows the value of her investment under two different options for three different years: Number of years 1 2 3 Option 1 (amount in dollars) 1100 1210 1331 Option 2 (amount in dollars) …

More Similar Questions

Post a New Question