Displaying Compound Interest growth

  • Thread starter Thread starter geroneill
  • Start date Start date
G

geroneill

Hi Ger here again
Thanks a million for help with calculating CAGR I now
need to display it in a table, Row Headings year 1 - year
11 Column headings from yr1 Accumalative each year in a
table showing yearly revised growth per year to end year
inclusive of interest. I am doing it by linking
accumalative down to next year and manual formulas.
Seems like a lot of work and must be easier way.

Thanks in advance
 
Hi Ger!

A1: Rate
B1: 5%
A2: Amount
B2: 1000
A3: Term
B3: 11

A6: Year
B6: Amount
A7: 0
B7: =B2
A8: 1
B8:
=(1+$B$1)^A8*$B$2
A9:
=IF(A8=$B$3,"",IF(A8="","",A8+1))

Copy B8 and A9 down to taste.

I'm not sure whether you wanted to go down or across. If across, I
firmly counsel against it because with periodic cash flows you will
very soon run out of columns.

Your job now is to replace A9 with a formula that uses the Excel PV
function.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Will give this a go, thanks a million
Ger
-----Original Message-----
Hi Ger!

A1: Rate
B1: 5%
A2: Amount
B2: 1000
A3: Term
B3: 11

A6: Year
B6: Amount
A7: 0
B7: =B2
A8: 1
B8:
=(1+$B$1)^A8*$B$2
A9:
=IF(A8=$B$3,"",IF(A8="","",A8+1))

Copy B8 and A9 down to taste.

I'm not sure whether you wanted to go down or across. If across, I
firmly counsel against it because with periodic cash flows you will
very soon run out of columns.

Your job now is to replace A9 with a formula that uses the Excel PV
function.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"(e-mail address removed)"
Click to expand...
 
Hi Ger!

You'll see that I gave a bit more than requested and allowed the user
to vary the term. Just make sure that the rate used is the effective
rate per time period that Term is counting. If term is measured in
months, you must use the monthly effective rate.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top