Multiply on a Specific Date (investment simulation for students)
I am trying to create an investment simulation for my high school students in Google Sheets. They already have a bank account that they use (in google sheets) for reward for specific behaviors. I would like to teach them about using investment vehicles while using the current system I have for rewarding their behaviors- but I do not want to have to update it every week/month.
I would love to find a formula that multiplies a specific cell by x% every Monday (or any day), then adds the product to the original number. Is there a way to do this in Google Sheets? I have been searching for a few days, but I cannot find this information. (I know investments are based on monthly, but with only having the students for a year, I will not be able to show them how powerful exponential growth can be unless I exaggerate it, which I will clearly explain to them that it is an exaggeration.)