These sorts of calculations always do my head in.
It’s likely that the $4M has some rate of return, meaning that you could do this on a bit less. Well, as long as the return exceeded the increase in median income each year. You don’t want the capital to run out before you.
I taught myself VBA when I inherited a job that involved taking data from multiple sources and producing summary reports of various types for multiple stakeholders. The person before me spent days each week doing it, it took me about a week of learning and playing to bring that down to 5 minutes or so.
I found VBA useful for dealing with administrivia.
I ended up doing similar things multiple times afterwards, with variations on source data (excel, text files, word docs), source data location (local drive, network, databases, SharePoint) and output (pivots, charts, tables, text files, email, word docs, etc.) depending on what was needed. Someone else mentioned data validation already.
Automate the boring stuff.
Opinion seems to be that Ferrari failed in building an electric car that no-one wants to buy.
I wonder if they deliberately built something they know won’t be a success so they can point to that failure as pushback on regulations that would prevent them continuing to build traditional petrol cars.
Task failed successfully.