Is this Compounding Calculator even possible?

[ChadV]

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

 

[Dave Patton]

A quick idea follows

T202101b.xlsm
	A	B	C	D
1	Rate	0.50%
2	Amount	10,000	0.25
3	Compound	50
4	FV	$199,359.55	$465.30	$198,894.25
6a

Cell Formulas
Range	Formula
B4	B4	=FV(B1,600,0,-B2,1)
C4	C4	=FV(B1,600,-C2/2)
D4	D4	=B4-C4

 

[Dave Patton]

T202101b.xlsm
	A	B	C
6	1	50.00	10,050.00
7	2	50.25	10,100.25
8	3	50.50	10,150.75
9	4	50.75	10,201.50
10	5	51.00	10,252.50
11	6	51.25	10,303.75
6a

Cell Formulas
Range	Formula
B6	B6	=B2*$B$1
C6	C6	=B2+B6
B7:B11	B7	=FLOOR(C6,50)*$B$1
C7:C11	C7	=C6+B7

 

[Dave Patton]

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

T202101b.xlsm
	A	B	C
1	Rate	0.50%
2	Amount	$10,000.00
3	Compound	50
4	FV	$199,359.55	$198,894.25
5
6		10,000.00
7	1	10,050.00	0.00
8	2	10,100.25	0.25
9	3	10,150.75	0.75
10	4	10,201.50	1.50
11	5	10,252.50	2.50
12	6	10,303.75	3.75
13	7	10,355.25	5.25
14	8	10,407.00	7.00
15	9	10,459.00	9.00
16	10	10,511.25	11.25
6a

Cell Formulas
Range	Formula
B4	B4	=FV(B1,600,0,-B2,1)
C4	C4	=MAX(B6:B606)
B6	B6	=$B$2
B7:B16	B7	=B6+(FLOOR(B6,50)*$B$1)
C7:C16	C7	=B7-FLOOR(B7,50)