Accounting Formulas
Excel
Audit/Tax
Kansas City
General Firm
100

What is the formula for Assets?

Assets = Liabilities + Equity

100

What is the function to add multiple cells? (not the + sign)

=SUM

100

What does RMM stand for?

Risk of Material Misstatement

100

What is the restaurant right across Walnut from our Lobby?

Pickleman's

100

What does the "A" in CLEARR mean?

Agility

200

What is the formula for Debt to Total Assets

Total Debt / Total Assets

200

What is the shortcut to hide a Column?

Ctrl 0

200

What is the Individual Income Tax Return Form?

Form 1040

200

What is the name of the Conference room with just a couch in it?

Wildcat Room

200

How many independence trainings did the Interns have to do for Orientation?

Two

300

What is the formula for the Debt to Equity?

Total Debt / Total Shareholder's Equity

300

What is the function called that searches for a specific value in a column?

=VLOOKUP

300

What is the Audit Assertion that starts with "E"

Existence

300

How many KC Interns are there? (Audit, Tax, SAAS)

Nine

300

How long is the Summer Internship?

Eight Weeks

400

What is the formula for Current Ratio?

Current Assets / Current Liabilities

400

What is the shortcut to auto sum all cells above?

Alt =

400

Which audit events occur to subsequent to the balance sheet date, BUT prior to the auditor's report date?

Subsequent Events

400

How many different slots/options are there in the Vending Machine?

Thirty-Five

400

How many GT offices are in the USA?

48

500

What is the formula for Net Profit Margin on Sales

Net Income / Net Sales

500

What function extrapolates characters from cells?

=Left or =Right

500

True or False? Fees paid to chiropractors may be deducted as medical expenses if it is medically necessary.

True! 

500

How far is the drive (on average) from the Office to Raymore, MO? In Minutes

45mins

500

How many states does GT have offices in?

Twenty-Nine