Last version published: 02/02/2020 21:53
Publication number: ELQ-94377-7
View all versions & Certificate
Productivity VBA tool - Automation of year on year movement computation for multiple periods
A VBA Macro for automatic year on year movements and automatic formatting.
Pierre-Alexandre HEURTEBIZE offers you this Best Practice for free!
download for free
Add to bookmarks
Gain in productivity by automating year on year movement. More time to focus on the important things and analyses.
Have numbers in adjacents columns and sorted out from oldest to newest , left to right
Write a review
- Time changer
People using this Best Practice also downloaded
Price Volume Mix Analysis (PVM) excel template with Charts - Sales mix and Gross Profit by ProductPrice volume mix analysis (PVM) excel template to better understand your sales and improve pricing strategy.4,915add_shopping_cart$49.00by HEURTEBIZE
Multiple investing rounds Cap TableCap table for capital raise / buy in - by out and investor IRR and investment multiple forecast1,536add_shopping_cart
Multiple rounds Cap Table including Safe, pro-rata rights and Management Option PoolMultiple rounds cap table including SAFE conversion, Management option pool and investment performance (IRR) 3 scenarios519add_shopping_cart$40.00by HEURTEBIZE
Due Diligences Excel Template - P&L starter packStarter Pack Template for Financial Due Diligence - P&L776add_shopping_cart
Inventory Management and Analysis best practice with dynamic chartsInventory Management and Analysis best practice. Useful to the Management team as well as to external financial analyst.811add_shopping_cart
Discounted Cash Flow (DCF) and Comparables Valuation ModelDiscounted Cash Flow analysis of your business and compare it to a valuation comparables.396add_shopping_cart
DSO - DPO - DIO computation and graph - Countback method (Includes countforward method!)DSO (Days Sales Outstanding)/ DPO (Days Payable Outstanding)/ DIO (Days Inventory Outstanding) charts countback method.845add_shopping_cart
Due Diligence Excel Best Practice - Balance Sheet starter packStarter Pack Best Practice for Financial Due Diligence - Balance Sheet624add_shopping_cart
Simple Startup and SME Forecast Business PlanA projection Model for startup and SME to forecast a complete P&L, Net Working Capital and Cash flow.270add_shopping_cart$29.00by HEURTEBIZE
Advanced multiple rounds Cap Table Model including SAFE an Management pool with 4 different structuresMultiple rounds cap table including SAFE conversion, Management option pool and performance (IRR) with 3 deal structures105add_shopping_cart$70.00by HEURTEBIZE
P&L (Profit & Loss) Constant Currency Analysis Excel ModelBest practice to assess the impact of FX on a P&L for a business trading in different currencies889add_shopping_cart
SaaS P&L, revenue and churn analysis dashboardDashboard for SaaS and subscription businesses to track and understand their P&L and revenue generation149add_shopping_cart
Any questions on Productivity VBA Tool - Automation Of Year On Year Movement Computation For Multiple Periods?
The user community and author are here to help. Go ahead!