Posted by Diane on Tuesday, December 21, 2010 at 8:31am.
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 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.

Business Algebra  drwls, Tuesday, December 21, 2010 at 9:35am
Are you supposed to compare the relative merits of these options? The value of an annuity depends upon the actuarial probability of different expected life spans (expected number of payouts), and upon when the payouts begin. At death, the value of an annuity is zero.
Expected life span depends upon the age, sex, smoking history, obesity and general health (preexisting conditions) of the individual.
Anyway, you have not asked a question yet and we do not have access to your text. 
Business Algebra  Diane, Tuesday, December 21, 2010 at 9:48am
Yes. I just don't know how to do them. I have tried and would just like some help please. Thanks

Business Algebra  Diane, Tuesday, December 21, 2010 at 9:53am
Now, I have the formula's I am to use and just can't figure out if it is correct.
Quarterly = P (1 + r/4)4 = (quarterly compounding)
$23,000 (1+0.0425/4) 4 = $28,994.38
Annually = P × (1 + r) = (annual compounding)
$5,000 x (1+0.066) = $5,330
Is this correct? 
Business Algebra  Diane, Tuesday, December 21, 2010 at 9:57am
Then I have to use a worksheet and I have no clue how to do this one.
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. Be sure to label all variables in your spreadsheet. Be sure to upload your spreadsheet for formula verification. 
Business Algebramore help needed  drwls, Tuesday, December 21, 2010 at 10:00am
You seem to be on the right track. We appreciate the feedback.
This is not my field of expertise but one of our other teachers might be able to help. 
Business Algebra  Dr Russ, Tuesday, December 21, 2010 at 10:06am
Taking option 1 from first principles
At time 0 there is $23000
after quarter 1 there is $23000x(1.0425)
after quarter 2 there is $23000x(1.0425)x1.0425
after quarter n there is $23000x(1.0425)^n
With option 2
at time zero there is $5000
after year 1 there is $5000x1.066+$5000
after year 2 there is $5000x1.066x1.066+$5000+45000
after year n there is $5000x(1.066)^n+$5000x(n)
I am not quite sure what you plan to do with these. Initially option 2 is the better, but after about 25 years Option is better. You need to plot these to decide, or solve mathematically. 
Business Algebra  Dr Russ, Tuesday, December 21, 2010 at 10:10am
In the question Option 1 does not state annual interest which your formula implies.
And from my post
after year 2 there is $5000x1.066x1.066+$5000+45000
should be
after year 2 there is $5000x1.066x1.066+$5000+$5000 
Business Algebra  Diane, Tuesday, December 21, 2010 at 10:49am
I got it now. I understand. Thanks so much for your help. Perfect!!!