How to create exponential growth in excel over a year

0 votes
o I'm attempting to construct an excel model in which the numbers will rise exponentially each month to a certain value at the end of the year that is determined by annual expectations. I currently have it divided by 12, and because of the enormous leaps from one year to the next, the growth chart is highly erratic. Let's assume for the sake of illustration that the required number for the year is 12 for 2020. Currently, I would receive one (12/12) per month. However, I would want for it to increase gradually or exponentially, so for instance, 0.2, 0.5, 0.9, etc., with December being the highest, and have a total of 12 for the full year. Then, starting in January of the following year (2021), it would start with the December 2020 number and increase from there to the desired number (let's say total 24 for 2021), and so on. I'd rather it to expand more rapidly and exponentially, like a hockey stick.

What approach would be the best for this?
Dec 24, 2022 in Others by Kithuzzz
• 38,000 points
578 views

1 answer to this question.

0 votes

To find an interest rate that will provide you a specific target value, utilise the RRI function. Using this, one can locate terms in a geometric series that have a specific sum (which is what you seem to be asking for).

Consider wanting 12 exponentially growing numbers, which, when multiplied by 100, give you the number 2000. Repeatedly multiply from 100 by (1 + RRI(12,100,2000)). Simply compute the difference each month to acquire the desired numbers, which will be 12 figures that add up to 1900:

enter image description here

answered Dec 24, 2022 by narikkadan
• 63,640 points

Related Questions In Others

0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,640 points
759 views
0 votes
0 answers

How to create a batch file in windows?

What is a batch file and How ...READ MORE

Jul 4, 2019 in Others by sindhu
689 views
0 votes
0 answers

How to create a Wordlist generator in Golang?

I want to create a Wordlist Generator ...READ MORE

Jul 14, 2019 in Others by Raj
• 180 points
866 views
0 votes
1 answer

How to create a Project in Flutter?

Hi@akhtar, Flutter has an inbuilt command to create ...READ MORE

answered Jul 20, 2020 in Others by MD
• 95,460 points
880 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,187 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,020 points
1,068 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,020 points
4,356 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,235 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,640 points
1,068 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,640 points
695 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP