Everything Excel
The Excel function that allows you to add together multiple numbers without using a plus symbol (+)
What is the SUM formula?
Revenue less cost of goods sold
What is gross profit?
An asset that is NOT physical in nature
What is an intangible asset?
The learning facility developed specifically for KPMG employees and trainings
What is the Lakehouse?
The deadline to submit your timesheet to be in compliance with tax policy
What is 9pm the following business day?
The font color that suggests a cell is an input
What is blue font?
The financial statement representing a snapshot of a company at a specific point in time
What is the balance sheet?
An approach to value a subject interest which relies on the pricing of comparable interests under similar circumstances
What is the market approach?
The three groups that make up EVS
What are Valuation (& Business Modeling) Services, Economic Services, and Transfer Pricing?
All third-party engagements should leverage this platform for all files related to the engagement including administrative files, files provided by the client, valuation models, etc
What is Upslide?
The symbol that allows users to lock a cell reference
What is a dollar sign ($)?
What is the gordon growth model?
An asset representing the future economic benefits arising from other assets acquired in a business combination or an acquisition by a not-for-profit entity that are not individually identified and separately recognized
What is goodwill?
The current business valuation services line leader
Who is Ryan Marren?
The software that allows users to link numbers and charts in Excel to Word documents
What is Upslide?
What is a goal seek?
Funds required to acquire, upgrade, or maintain the physical assets of the business
What are capital expenditures?
The type of transaction that allows the buyer to step-up the fair value of the assets for depreciation purposes, although they will be unable to carryforward any historical losses for tax benefits.
What is an asset or taxable transaction?
Red 0, Green 51, Blue 141
What is KPMG blue?
The credential required for BVAL associates to get promoted to senior associate
What is the FMVA?
The key that allows you to click through the Excel taskbar without using a mouse
What is alt?
The expense that represents the actual decline of an asset over its useful life
The standard of value defined as the price at which the subject property would change hands between a willing buyer and a willing seller when the former is not under any compulstion to buy and the latter is not under any compulsion to sell, both parties having reasonable knowledge of the relevant facts.
What is fair market value?
KPMG is an abbreviation for these four individuals
Who are Klynveld Peat Marwick Goerdeler?
The internal group that researches technical topics to develop guidance and positions to the practice
What is the VSTC?