PwC
VCM Team / History
Tools / Data Topics
Valuation Topics
Summer Vacations
100

The 3 main lines of service at PwC as of July 1

What are Assurance, Tax, and Advisory?

100

The number of Managers in the VCM group

What is 5?

100
The PwC developed modelling tool in Excel

What is AMBR?

100

The typical range for long-term growth rates

What is 2 - 3%?

100

The city known for advanced constructions such as the aqueducts

What is Rome?

200

The new US Senior Partner

Who is Paul Griggs?

200

The two other acronyms for VCM before we were called VCM

What is SVC and MCoE?

200

The PwC branded AI tool

What is ChatPwC?

200

The reason we typically ignore interest expense in a DCF

What is interest relates to debt holders and is not available to ALL investors of the company? What is interest expense is already accounted for in the WACC? 

200

The city with the tallest ferris wheel in Europe

What is London?

300

The PwC purpose

What is building trust in society and solving important problems?

300

The amount of years the VCM group has been officially active

What is 8 years?

300

The Microsoft data visualization tool

What is Power BI?

300

The difference between Effective tax rate and Marginal tax rate

What is effective tax rate is actual tax expense paid (tax expense / EBT) vs. marginal tax is the rate you pay in your highest income tax bracket? 

300

The city with the Gothic Quarter

What is Barcelona?

400

The 5 PwC values

What is care, make a difference, act with integrity, work together, and reimagine the possible? 
400

The VCM member with an Excel YouTube channel, and the name of that channel

Who is Steve Chin, TheExcelCoder? 

400

The Microsoft automation tool

What is Power Automate?

400

The current Equity Risk Premium according to PwC

What is 5%? 

400

What was the most visited US National Park in 2023

What is The Great Smoky Mountains (13 Million Visitors)?

500
The year PriceWaterhouse and Coopers&Lybrand merged

What is 1998?

500

The most tenured member of the VCM group in terms of total years at PwC

Who is Jay Meldrum?

500

The 3 Vs of Big Data and their definition

Velocity (how fast data comes in) ; Volume (how much data) ; Variety (types of data)

500

The methodology for calculating the mid-year convention factor for the first 3 years

What is first find the partial period (YEARFRAC Val date to end of year), then take half of that as first midyear factor, then second year, take first year and multiply by 2 then add 0.5 then finally, take 2nd year and add 1?

500

The city home to the Van Gogh museum

What is Amsterdam?