2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Spreadsheet for in vestments

I am trying to organize and make things easier for me to digest. I was looking for a template or budget sheet or someone to make it for me - I am not tech savvy.

I want something that allows me to have the year up top, and all my things I am investing in ie roth, 401k, brokerage, wife’s Roth, wife’s brokerage, kids UTMA x2 accts, extra principal on mortgage.

My idea/intent is to set a value of dollars I’ll contribute that calendar year - and try to reach that goal. Then under that I’ll have the table. Left side column would be those accts and top of each row would be the months of the year. I’ll simply plug in the amount contributed that month and that will subtract from the yearly goal. Once goal is met, green? Color coded would be nice lol.

Then the other would be an investment growth excel. Regarding my brokerage, Roth and 401k then my wife’s brokerage and Roth. I just want to be able to see the charts all in one place. Not necessarily a graph that goes up and down. But the numbers month by month.

Let me know if this is dumb, conceivable, or a waste of time. Help me figure this out but I really think this will help me - especially the first one.

submitted by /u/Dak_The_Gripper
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#row zero
#real-time data collaboration
#real-time collaboration
#interactive charts
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet