Question

) What is the future value at the end of year 13 of a series of...

) What is the future value at the end of year 13 of a series of deposits that starts at $6,000 in year 1 and shrinks by 7% per year for 13 years (last deposit occurs at the end of year 13)? The annual interest rate is 7% compounded annually.

please answer in excel

Homework Answers

Answer #1

Solution(s):

ANSWER:

All the calculations have been done in excel. 

i = 7%

YEAR 0 1 2 3 4 5 6 7 8 9 10 11 12 13
CASH FLOWS 6,000 5580 5189.4 4826.142 4488.31206 4174.130216 3881.941101 3610.205224 3357.490858 3122.466498 2903.893843 2700.621274 2511.577785
FUTURE VALUE $13,513.15 $11,745.07 $10,208.34 $8,872.67 $7,711.76 $6,702.74 $5,825.75 $5,063.50 $4,400.99 $3,825.16 $3,324.67 $2,889.66 $2,511.58
TOTAL FUTURE VALUE $86,595.02

in excel we calculate future value by using the =-fv function.

=-fv(rate,nper,pmt,pv,type)

the total future value is $86,595.02

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
What is the future value at the end of year 5 of a series of 3...
What is the future value at the end of year 5 of a series of 3 deposits? The first deposit occurs at the end of year 3 and is $800. The remaining deposits increase by $150/year (so the last deposit will be $1100 and will occur at the end of year 5) . Assume i = 7.4% compounded annually.
5) What is the effective annual interest rate for a loan with a nominal annual interest...
5) What is the effective annual interest rate for a loan with a nominal annual interest rate of 12% if compounded: semi-annually. Answer ____________________ monthly. Answer _________________________ continuously. Answer _____________________ 6) You make a series of quarterly deposits every quarter starting at the end Quarter 1 and ending at the end of Quarter 36. The first deposit is $1,100, and each deposit increases by $500 each Quarter. The nominal annual interest rate is 7%, and is compounded continuously. What is...
What will be the future value? (1). A lump-sum of $3000 now, in 5 years at...
What will be the future value? (1). A lump-sum of $3000 now, in 5 years at 7% compounded annually. (2). Series of payment: $3000 at the end of each year for 5 years at 7% compounded annually. (3). $1000 at the end of the first year, then increase at a rate of $100 for the following 4 years. The interest rate of 7% compounded annually. (4). $1000 at the end of the first year, then increase by 10% for the...
What is the future worth of a series of equal​ year-end deposits of ​$3700 for 11...
What is the future worth of a series of equal​ year-end deposits of ​$3700 for 11 years in a savings account that earns 14​% annual interest if the following were​ true? ​(a) All deposits are made at the end of each​ year? ​(b) All deposits are made at the beginning of each​ year?
Future Value Computation You deposit $4,000 at the end of every year for 4 years. How...
Future Value Computation You deposit $4,000 at the end of every year for 4 years. How much will accumulate in 4 years if you earn 6% compounded annually? Use Excel or a financial calculator for computation. Round your answer to nearest dollar.
Future Value of an Annuity: Stone will deposit $9,000 at the end of each year for...
Future Value of an Annuity: Stone will deposit $9,000 at the end of each year for 10 years in a fund that earns 6%, compounded annually. What is the total amount of the fund at the end of 10 years? Please show formula and work!
What is the Present Value of a series of seven cash flows that starts with the...
What is the Present Value of a series of seven cash flows that starts with the cash flow of $2443 in year 1, decreases by 25% each year, and continues until year 7, at a 20% annual interest rate compounded annually?
Find the future value of an annuity of $1800 paid at the end of each year...
Find the future value of an annuity of $1800 paid at the end of each year for 5 years, if interest is earned at a rate of 5%, compounded annually. (Round your answer to the nearest cent.)
What is the future value of an annuity of 11 deposits of $6,447 at the end...
What is the future value of an annuity of 11 deposits of $6,447 at the end of each year with a nominal rate of interest of 6%, compounded continuously, in 21 years?
1.What is the discount rate assuming the present value of $840 at the end of 1-year...
1.What is the discount rate assuming the present value of $840 at the end of 1-year is $765? 2.What is the Future value of $3,500 deposited for 12 years at 5% compounded annually? 3. If $2,800 is discounted back 4 years at an interest rate of 8% compounded semi-annually, what would be the present value? 4. Determine the future value of $6,000 after 5 years if the appropriate interest rate is 8%, compounded monthly. 5. Consider a newlywed who is...