Log In
Register
Home
VBA function for Quarterly financial calculations
xx na
New Member
Members
Forum Posts: 1
Member Since:
June 22, 2022
June 22, 2022
Offline1
June 22, 2022 - 1:07 am
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.
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Forum Posts: 1939
Member Since:
November 8, 2013
November 8, 2013
Offline2
June 22, 2022 - 8:44 pm
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 6
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 917
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 331
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ahsan AYUB
Daniel Neilson
Joy Nicholes
Earl Hanlon
Paulo Pinto
Tavonga Machigere
Marc Poulopoulos
Viki Hennon
David Tucker
Garima Lal
Forum Stats:
Groups: 3
Forums: 25
Topics: 7058
Posts: 30931
Member Stats:
Guest Posters: 49
Members: 34427
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —