Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
monthly growth rate
Hi,
Not sure how relevant this is... but I need help calculating a monthly growth rate for the following: Start Value in Month 1: 750,000 End Value in Month 12: 1,500,000 How do I calculate the monthly growth rate so that I start with 750,000 and end up with 1,500,000 on the twelfth month? Thanks in advance :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
monthly growth rate
Use 11.57%
In A1 enter 750000 in A2 enter: =A1*(1+$B$1) and copy down In B1 enter say .01 and then pull-down: Tools Goal seek... and request A12 be 2500000 by setting B1 Goal seek should prodect the following in column A: 750,000.00 836,749.95 933,533.97 1,041,512.67 1,161,980.90 1,296,383.28 1,446,331.52 1,613,623.77 1,800,266.15 2,008,496.81 2,240,812.80 2,500,000.00 -- Gary's Student "my" wrote: Hi, Not sure how relevant this is... but I need help calculating a monthly growth rate for the following: Start Value in Month 1: 750,000 End Value in Month 12: 1,500,000 How do I calculate the monthly growth rate so that I start with 750,000 and end up with 1,500,000 on the twelfth month? Thanks in advance :) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
monthly growth rate
Thanks. Greatly appreciate it!
But, is there a more methodical approach to solve it rather than the short cut? "Gary''s Student" wrote: Use 11.57% In A1 enter 750000 in A2 enter: =A1*(1+$B$1) and copy down In B1 enter say .01 and then pull-down: Tools Goal seek... and request A12 be 2500000 by setting B1 Goal seek should prodect the following in column A: 750,000.00 836,749.95 933,533.97 1,041,512.67 1,161,980.90 1,296,383.28 1,446,331.52 1,613,623.77 1,800,266.15 2,008,496.81 2,240,812.80 2,500,000.00 -- Gary's Student "my" wrote: Hi, Not sure how relevant this is... but I need help calculating a monthly growth rate for the following: Start Value in Month 1: 750,000 End Value in Month 12: 1,500,000 How do I calculate the monthly growth rate so that I start with 750,000 and end up with 1,500,000 on the twelfth month? Thanks in advance :) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
monthly growth rate
"my" wrote:
I need help calculating a monthly growth rate for the following: Start Value in Month 1: 750,000 End Value in Month 12: 1,500,000 How do I calculate the monthly growth rate so that I start with 750,000 and end up with 1,500,000 on the twelfth month? Depends on what you mean by "growth rate". The geometric growth rate is (1500000/750000)^(1/11) - 1. If that formula is in B1 and 750000 is in A1, you compute the next month in A2 by A1*(1+$B$1) and copy down through A12. By the way, if the formula throws you for a loop, you can think of this as a savings account where you start with 750000 at the start of the 1st month and it grows to 1500000 by the start of the 12th month. Then the monthly growth rate can be computed by RATE(11,,-750000,1500000). The linear growth rate (change per month) is (1500000-750000)/11. If that formula is in B1 and 7500000 is in A1, then A2 would be A1+$B$1 and copy down through A12. Beware of rounding. It will cause a small error in the final month. Well, in every month. But you might not notice until you see that the 12th month is not 1500000. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
monthly growth rate
On Wed, 1 Mar 2006 15:55:27 -0800, "my"
wrote: Hi, Not sure how relevant this is... but I need help calculating a monthly growth rate for the following: Start Value in Month 1: 750,000 End Value in Month 12: 1,500,000 How do I calculate the monthly growth rate so that I start with 750,000 and end up with 1,500,000 on the twelfth month? Thanks in advance :) I don't think there's an Excel Financial function, but the basic formula to calculate the periodic compound interest rate is: 1 - (FV/PV) ^ (1/n) where PV = Present Value, FV = Future Value and n = number of periods. Slotting your numbers in we get 1 - (1500000/750000) ^ (1/12) = .059463094 % HTH Richard Buttrey __ |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
monthly growth rate
exact explanation i was looking for! thanks so much!
:D " wrote: "my" wrote: I need help calculating a monthly growth rate for the following: Start Value in Month 1: 750,000 End Value in Month 12: 1,500,000 How do I calculate the monthly growth rate so that I start with 750,000 and end up with 1,500,000 on the twelfth month? Depends on what you mean by "growth rate". The geometric growth rate is (1500000/750000)^(1/11) - 1. If that formula is in B1 and 750000 is in A1, you compute the next month in A2 by A1*(1+$B$1) and copy down through A12. By the way, if the formula throws you for a loop, you can think of this as a savings account where you start with 750000 at the start of the 1st month and it grows to 1500000 by the start of the 12th month. Then the monthly growth rate can be computed by RATE(11,,-750000,1500000). The linear growth rate (change per month) is (1500000-750000)/11. If that formula is in B1 and 7500000 is in A1, then A2 would be A1+$B$1 and copy down through A12. Beware of rounding. It will cause a small error in the final month. Well, in every month. But you might not notice until you see that the 12th month is not 1500000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions | |||
how do I calculate a monthly payment based on a variable rate? | Excel Worksheet Functions | |||
Using MIRR, if cash flows are monthly, should rate be / 12? | Excel Worksheet Functions | |||
Compound Annual Growth Rate | Excel Discussion (Misc queries) | |||
How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions |