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: 1944
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: Velouria
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Malcolm Lambeth
Waqas Arshad
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
Forum Stats:
Groups: 3
Forums: 25
Topics: 7157
Posts: 31386
Member Stats:
Guest Posters: 50
Members: 34657
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —