Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
197
Views
Topic starter
Hello,
I am new in VBA, and I would be glad if someone could direct me on a function that would allow me to calculate quarterly financials (Revenue, COGS, G&A,% growth) using VBA function.
Posted : 22/06/2022 11:07 am
Hi,
Unfortunately, there is no magic function, some topics you mentioned are pretty complex. For example, COGS needs a specific method, like FIFO or LIFO.
To calculate it, an application needs access to purchasing records, orders.
For financial complex calculations, these are best handled by specialized software, building a financial application in excel is not that easy.
Posted : 23/06/2022 6:44 am
