Geez, I think it was a mistake up on my part, My FV formula didnt make sense with a first time investment. I changed to use a future value of an annuity formula which I will add below for anyone else interested in making something similar. The image is the main formula and the text is how you would need to input into a Glide math column.
P*((1+R)^n)+PMT*((((1+r)^n)-1)/r)
1 Like