calculating annuity
posted by Ms. Renee
IF a company will generate 80,000 in annual revenue each year for the next eight years and the interest rate is 8.2% what is the present value of the savings?
An EXCEL spreadsheet will be helpful for these types of calculations.
Let S1 be savings in year 1, S2 in year 2, and so on. (For now, unless you have been othewise instructed, assume annual savings is received on the last day of the year.) Let r be the interest rate.
First, calculate the nominal amount of cash that will be there after 8 years.
T = S1*(1+r)^7 + S2*(1+r)^6 ... S8(1+r)^0
Now deflate T by 8 years of annual discounting at rate d. PV = T/(1+d)^8 Since you did'nt specifiy a discount rate d, assume d=r.
Thanks! That is much easier!

joe
456262.25
Respond to this Question
Similar Questions

math
find the present value of ordinary annuity payments of 890 each year for 16 years at 8% compounded annually What is the amount that must be paid (Present Value) for an annuity with a periodic payment of R dollars to be made at the … 
accounting
Mr. Jones intends to retire in 20 years at the age of 65. As yet he has not provided for retirement income, and he wants to set up a periodic savings plan to do this. If he makes equal annual payments into a savings account that pays … 
finances
Calculate the future value of the following: o $5,000 compounded annually at 6% for 5 years o $5,000 compounded semiannually at 6% for 5 years o $5,000 compounded quarterly at 6% for 5 years o $5,000 compounded annually at 6% for 6 … 
Business Algebra
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 … 
Personal Finance
NEED HELP IMMEDIATELY, HAVE UNTIL 10P.M. CENTRAL TO HAVE ANSWERS? 
Finance
What is the present value (or purchase price) of an annuity product which will pay you $2,000 at the end of each year for the next 15 years? 
Financial Management
Your company will generate $68,000 in an nual revenue each year for the next seven years from a new information database. If the appropriate interest rate is 8.5 percent, what is the present value of the savings? 
Finance
An investment will provide Nicholas with $100 at the end of each year for the next 10 years. What is the present value of that annuity if the discount rate is 8% annually? 
Fins nance business
1. Find the future value of current $1,000 5 year from now when annual interest rate 8% is compounded annually 2. Find the present value of a future value (1,000) four years from now when annual interest rate 8% is compounded quarterly. … 
MATH
Use the following time value of money tables to answer the following questions. Assume that the annual rate of interest is 6% for each of the four following problems. i = 6% Time Periods (n) Future Value of 1 Present Value of 1 Future …