I'm trying to get the Value in the "Investment" column for the daily Rate of Return (RoR) using an easier way than adding a new column and valuing say the first 3 days with the initial investment of 1000 and the RoR at 0.07% by (1000*1.7 + (prev val * 1.07) + (prev val * 1.07) wherein the 4th day the RoR is now -0.10 % for a single day and then continues to change at interims such as that. I've attached an example that is much clearer than I'm probably being. Is there a specific function I should be using? PV? I think I'm overthinking this but any help would be greatly appreciated. Here's my example

Problem_example.xlsx