Is this Compounding Calculator even possible?

ChadV

New Member
Joined
Jan 27, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
What I am trying to do is make or find a calculator that will show compounding of the money in my account in a network marketing company that I belong to.

What it should show is let's say I have $10,000 in my account and I make 0.5% interest per day for 600 days.
Now I can only repurchase (compound) into my account in increments of $50.

Example 1:
Day 1: $10,000 x 0.5% = $50.00 (compound the $50)
Day 2: $10,050 x 0.5% = $50.25 (compound the $50 leaving $0.25)
Day 3: $10,100 x 0.5% = $50.50 (compound the $50 leaving $0.50 + $0.25 = $0.75)
Day 4: $10,150 x 0.5% = $50.75 (compound the $50 leaving $0.75 + $0.75 = $1.50)
Day 5: $10,200 x 0.5% = $51.00 (compound the $50 leaving $1 + $1.50 = $2.50)
Day 6: $10,250 x 0.5% = $51.25 (compound the $50 leaving $1.25 + $2.50 = $3.75)
ect. to Day 600.

Eventually there should be a 2nd $50 from the money left over that I can compound that day.

I would like to be able to change the starting dollar amount showing the different packages that can be purchased.

There are $300, $500 and $1000 packages or increments of those dollar amounts.

Example 2:
Day 1: $300 x 0.5% = $1.50 (leaving $1.50)
Day 2: $300 x 0.5% = $1.50 (leaving $3.00)
Day 3: $300 x 0.5% = $1.50 (leaving $4.50)
Day 4: $300 x 0.5% = $1.50 (leaving $6.00)
Day 5: $300 x 0.5% = $1.50 (leaving $7.50)
Day 6: $300 x 0.5% = $1.50 (leaving $9.00)
-
-
On day 34 there should be $50 from the money left over that I can compound.
Day 34: $300 x 0.5% = $1.50 (having $51.10, compound the $50 leaving $1.10)
Day 35: $350 x 0.5% = $1.75 (leaving $2.85)
Day 36: $350 x 0.5% = $1.75 (leaving $4.60)
ect. to Day 600.

Is this making sense?
I have been racking my brain for a week now trying to figure out how to do this.
Is this even possible to be able to do?

Can you help me please and thank you?

Sincerely,
Chad V
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Do you initiate the compounding or does it happen automatically?
The following will show the buildup towards the $50.
Copy or fill the ranges down.
If you just need the result, you will require a sum of the series or refer to the last cell of the range like B6:B606


Cell Formulas
RangeFormula
B4B4=FV(B1,600,0,-B2,1)
C4C4=MAX(B6:B606)
B6B6=$B$2
B7:B16B7=B6+(FLOOR(B6,50)*$B$1)
C7:C16C7=B7-FLOOR(B7,50)
 
Last edited:
Upvote 0
Solution

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top