Meg's pension plan is an annuity with a guaranteed return of 4% per year (compounded quarterly)....

Meg's pension plan is an annuity with a guaranteed return of 4% per year (compounded quarterly). She would like to retire with a pension of $30,000 per quarter for 25 years. If she works 41 years before retiring, how much money must she and her employer deposit each quarter? (Round your answer to the nearest cent.)

Expert Solution

The amount required at the beginning of retirement is calculated using PV function in Excel :

rate = 4% / 4 (converting annual rate into quarterly rate - there are 4 quarters in a year)

nper = 25 *4 (25 years of pension with 4 deposits each year)

pmt = -30000 (quarterly pension. This is entered with a negative sign because it is a cash withdrawal)

PV is calculated to be $1,890,866.36

The quarterly deposit is calculated using PMT function in Excel :

rate = 4% / 4 (converting annual rate into quarterly rate - there are 4 quarters in a year)

nper = 41 *4 (41 years of deposits with 4 deposits each year)

pv = 0 (beginning amount in savings is zero)

fv = 1890866.36 (amount required at the beginning of retirement)

PMT is calculated to be $4,596.90

The quarterly deposit is $4,596.90

jeff jeffy answered 3 weeks ago

Pensions Your pension plan is an annuity with a guaranteed return of 4% per year (compounded...

Pensions Your pension plan is an annuity with a guaranteed return of 4% per year (compounded quarterly). You can afford to put $1,900 per quarter into the fund, and you will work for 40 years before retiring. After you retire, you will be paid a quarterly pension based on a 25-year payout. How much will you receive each quarter? (Round your answer to the nearest cent.) $ We can use the TMV solver

American General offers a 8 -year annuity with a guaranteed rate of 6.73% compounded annually. How...

American General offers a 8 -year annuity with a guaranteed rate of 6.73% compounded annually. How much should you pay for one of these annuities if you want to receive payments of $600 annually over the 8 year period?

trinity hs invested $8,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly...

trinity hs invested $8,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly for a term of eight years. 1. find the interest rate per conversion interval. 2. find the future value of the investment at the end of eight years. 3. find the total interest earned over the eight years. 4. set up the expression for finding an effective annual rate of 4.28% compounded quarterly and evaluate the expression.

Sarah has invested $7,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly...

Sarah has invested $7,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly for a term of eight years. Note this is a single payment. a. Find the interest rate per conversion interval. b. Find the future value of the investment at the end of eight years. . c. Find the total interest earned over the eight years. d. Set up the expression for finding the effective annual rate (EAR) of 4.28% compounded quarterly and evaluate the...

rob has a pension plan and will receive a pension annuity of $19,000 for 19 years...

rob has a pension plan and will receive a pension annuity of $19,000 for 19 years starting next year. After 19 payments, the following year (t=20) she receives $10,000, which will then grow at 4% per year thereafter. His life expectancy from today is 40 years (he will receive 40 total payments). The interest rate is 8%. What are these two annuity payments worth today?

You are quoted an interest rate of 14% per year, compounded quarterly. What is the effective...

You are quoted an interest rate of 14% per year, compounded quarterly. What is the effective yearly interest rate?You are quoted an interest rate of 14% per year, compounded quarterly. What is the effective yearly interest rate?

A year ago Alisha loaned $12,000 to Chang at the rate of 4% compounded quarterly. Chang...

A year ago Alisha loaned $12,000 to Chang at the rate of 4% compounded quarterly. Chang was required to repay this amount in three equal yearly installments, with payments starting from the end of the first year. How much interest did Aisha earn from this transactions?

If 25,000 is invested into an account paying 4.5% per year, compounded quarterly, how much money...

If 25,000 is invested into an account paying 4.5% per year, compounded quarterly, how much money can be withdrawn from the account every two month for the next 6 years

You borrow $2000 at 4% annual interest compounded quarterly, to be paid off with equal quarterly...

You borrow $2000 at 4% annual interest compounded quarterly, to be paid off with equal quarterly payments. Your first payment will be one year from now, and your last payment will be nine years from now. What will your payments be?

Quarterly compounding implies that interest is compounded times per year. (2,12,3,6,4) You have deposited $42,000 into...

Quarterly compounding implies that interest is compounded times per year. (2,12,3,6,4) You have deposited $42,000 into an account that will earn an interest rate of 8% compounded semiannually. How much will you have in this account at the end of seven years? $50,911.29 $72,730.41 $58,184.33 $87,276.49 $58,184.33 $87,276.49

Question