Last version published: 16/03/2018 09:18
Publication number: ELQ-85956-2
View all versions & Certificate
VWAP Template Calculator Excel Model (Volume Weighted Average Price)
Simple, ready-to-use VWAP template calculator.
By simply exporting prices and volume you'll be able to work out a company's historic trading bands.
What do you use VWAP for?
You can use VWAP for many things, but usually for trading.
It can be used as a trading signal for the right time to purchase.
Sometimes used by institutional investors to work out whether a certain trade was at a good or a bad price.
Used by ECM teams when liaising with clients during general coverage and issuances.
In Mergers and Acquisitions, the Volume-Weighted Average Price is commonly used to work out the premiums that were paid throughout an acquisition.
You'll also find some rules surrounding 'stakebuilding,' which needs to use this number to find out the prices you have to pay. (See 'best price rule.')
In compulsory offers, the price being offered has to be minimum equal to the 60 days VWAP or the maximum price that was paid in exchange for the securities of the company targeted by whomever is offering in the year previous to the offer- whichever is the highest. (See 'minimum price rule.')
As a result, in the case that the bidder offers a larger amount of money previous to or outside of the offer, it's compulsory that you have to offer this higher price in its public tender offer.
I've only ever had to calculate VWAP when evaluating possible targets and to get an idea of the general trading price and market cap so that I could work out a standard enterprise value before going deeper.
This business tool includes
1 downloadable excel calculator
Acquire business license for $9.00
Add to cart
Add to bookmarks
- No review yet!
People using this tool also downloaded
How to Use Trading Multiples for Valuing a Company.A step-by-step guide on how to use trading multiples for valuing a company.valuevaluationtradingcompany valuationtrading multiplestrading multipleNew!
E-Feeder & Cable Calculator SpreadsheetCalculator in Excel to help you work out E-Feeder & Cablecalculatorexcelengineeringspreadsheetselectrical engineeringe-feedercable96 remove_red_eye
Maintenance ROI Calculator: Cost Justification SpreadsheetExcel workbook to help you calculate Maintenance ROI and lay out Cost Justifications.calculatorexcelspreadsheetsworkbookmaintenance roicost justifications245 remove_red_eye
Pump Efficiency Calculation ToolCalculation tool to work out the energy efficiency and performance of water pumping facilities.calculatorexcelspreadsheetengineeringcalculationspump efficiency30 remove_red_eye
Life Time Value (LTV) Excel Spreadsheet CalculatorExcel calculator and explanatory article to help you work out your LTV.calculatorltvcustomer lifetime valueformulae149 remove_red_eyefreeby David Skok
Bond Yield Calculator Excel ModelAutomatic generation of scheduled bond payments and the calculation of resulting yield to maturity.debtdebt schedulecalculatorbondsyieldyield to maturitycoupons21 remove_red_eye
Cable Designing ProgramFor calculation of cable size and voltage drop.calculatorcalculationelectrical engineeringvoltage dropcable sizemotor and electrical load93 remove_red_eye
Burn Rate CalculatorThis burn rate calculator will help you work out when your business will run out of money.cash flowcalculatorburn ratecash burn rateburn rate calculatorcash situation23 remove_red_eyefreeby Commerce Bank
Bus Bar Size and Voltage Drop Calculation ToolThis tool can be used for calculating the size and voltage drop for bus bar.calculatorexcelspreadsheetengineeringbus barsizevoltageelectrical339 remove_red_eye
Value Creation RoadmapShow your concept/business/project/startup development on an ascending graph roadmap.mapvaluecreationgrowthroadmapstepsmilestonesdatestrategydevelopmentgraphascendingmainplanprogresshistorychronologicalgoalsobjectivesyearlyyearexpansion1,853 remove_red_eye
Any questions on VWAP Template Calculator Excel Model (Volume Weighted Average Price)?
The user community and author are here to help. Go ahead!