You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel. QuickValue PRO is the latest version of this tried and tested business valuation analysis tool for Excel. Includes instructions & guides, valuation benchmark databases. Menu of templates and information pages: Part 1 provides a quick way to value a business using multiples and Present Values.
Quick valuation uses current company financials with Sector Benchmarks.
Notes to help you with valuation calculations plus Price to Sales Benchmarks by sectors.
This template supplies the current P-L template.
Hide unwanted rows
The next spreadsheet extrapolates the current P/L over 10 years at rates of growth you specify. Valuation applies Revenue, EBITDA sector benchmark multiples and calculates discounted cash flow (present value) applying your required rate of return.
Value Net Operating Income after tax (NOPAT) following the forecast period (continuing/terminal value) uses this calculator.
Valuation is adjusted by the current balance sheet and real estate valuations.
Calculate the self sustaining growth rate for any business
Part 2 provides the complete set of financial statement templates to calculate key Financial Ratios
Balance Sheet template
Quick Value PRO
$169.95 $69.95 Secure Payment Options
Buy as part of All Excel Templates Gold Edition - HUGE Value - 80% Discount!
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft