Question

In sheet “growing annuity”, fill out PV and FV of in “Annuity in Advance” part, both...

In sheet “growing annuity”, fill out PV and FV of in “Annuity in Advance” part, both Tables and Formulas.

Given annual saving, length of investment, and annual interest rate, and saving growth rate, calculate the PV and FV of this growing annuity, if the growing annuity is in arrears, or in advance. Calculate the results using both year-by-year sum and function.

Annual saving $1,000
Number of years 10
Annaul Interest rate 8.00%
Annual saving Growth rate 4.00%

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
FV and PV of an Annuity Suppose you expect to live for 20 years after retiring...
FV and PV of an Annuity Suppose you expect to live for 20 years after retiring at age 65. You would like to save enough money to have $30,000 per year to live on during your retirement. Currently, at age 30, you would like to start saving a fixed amount each year to fund this retirement plan. How much do you need to save each year to reach your goal? (Assume all annuity payments are end-of-period, ordinary annuity payments, and...
Present Value of $1 PV of Annuity of $1 Issuance of a Bond at Face Value...
Present Value of $1 PV of Annuity of $1 Issuance of a Bond at Face Value On January 1, 2017, Whitefeather Industries issued 1,100, $1,000 face value bonds. The bonds have a(n) 10-year life and pay interest at the rate of 10%. Interest is paid semiannually on July 1 and January 1. The market rate of interest on January 1 was 10%. Use the present value tables that may be found by clicking on the present value table links above....
1. What is the PV of an ordinary annuity with 5 payments of $3,400 if the...
1. What is the PV of an ordinary annuity with 5 payments of $3,400 if the appropriate interest rate is 4.5%? Answer just the dollar amount without the + or - sign. Round to the nearest dollar. 2. A public company's bonds mature in 8 years, have a par value of $1,000, and make an annual coupon interest payment of $65. The market requires an interest rate of 7.5% on these bonds. What is the bond's price? Answer just the...
The following situations should be considered independently. (FV of $1, PV of $1, FVA of $1,...
The following situations should be considered independently. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. John Jamison wants to accumulate $69,739 for a down payment on a small business. He will invest $35,000 today in a bank account paying 9% interest compounded annually. Approximately how long will it take John to reach his goal? 2. The Jasmine Tea Company purchased merchandise...
(     ) 1. According to present value (PV) formula, which one of the following changes will...
(     ) 1. According to present value (PV) formula, which one of the following changes will increase the present value when everything else stays the same?             A)        Future value (FV) decrease.             B)        Period discount rate (r) decrease.             C)        Number of periods in discounting (t) increase.             D)        None of the above. (     ) 2. You deposit $100 today into your savings account and you will continue this annual $100 deposit activity for the next 29 years without withdrawing...
PLEASE fill out chart pasted!!!!! Most Company has an opportunity to invest in one of two...
PLEASE fill out chart pasted!!!!! Most Company has an opportunity to invest in one of two new projects. Project Y requires a $320,000 investment for new machinery with a five-year life and no salvage value. Project Z requires a $320,000 investment for new machinery with a four-year life and no salvage value. The two projects yield the following predicted annual results. The company uses straight-line depreciation, and cash flows occur evenly throughout each year. (PV of $1, FV of $1,...
1. What is the present value of 9 equal payments of $21,500 to be made at...
1. What is the present value of 9 equal payments of $21,500 to be made at the end of each year for the next 9 years? The annual interest rate is 10% EYot S1. PV. LS1. EVAots1, and PVA ot 51) (Use the a whole dollar.) 2.Global Stores is downsizing and must let some employees go. Employees volunteering to leave are being offered a severance package of $121,000 cash, another $132,000 to be paid in one year, and an annuity...
Alex Meir recently won a lottery and has the option of receiving one of the following...
Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: (1) $82,000 cash immediately, (2) $30,000 cash immediately and a six-period annuity of $9,000 beginning one year from today, or (3) a six-period annuity of $17,000 beginning one year from today. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. Assuming an interest rate...
Calculate the annuity factor and amount needed to be invested for 7 years’ income at $33,000...
Calculate the annuity factor and amount needed to be invested for 7 years’ income at $33,000 p.a. starting in three years with rates at 3.4%. What is the future value of saving $1,000 each year for the next 20 years if you can deposit at 2.3%? You wish to set up a regular savings plan for your retirement in 27 years’ time. Interest rates are currently 2.5% with long term inflation at 0.5%.You believe that interest rates will be at...
1. You want to take a vacation in 4 years and feel you’ll need $8,500 to...
1. You want to take a vacation in 4 years and feel you’ll need $8,500 to do so. If you can earn 5% on your deposits, how much will you need to deposit in each of the next four years to have the needed amount? PMT = 1972.10058   2. What is the effective annual rate on a credit card that states that their APR is 21%, compounded monthly? 23.144% 3. What is the present value of $1,000 to be received...