June 22, 2022
November 8, 2013
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.