Shortcuts
How do you ensure formats are not pasted when bringing a formula across a row?
Ctrl C
Alt + E + S + F
What should Assets always equal?
Liabilities + Equity
Is it best practice to enter the xIS or xBS first?
xIS
This financial statement shows a company's revenues, expenses, and profits over a period of time.
Income Statement
D-A-N
S-I-O-B-H-A-N
How do you place a filter on a section of data?
Alt + H + S + F
This method of accounting records transactions when cash is received or paid, rather than when the transaction occurs.
Which tabs require the EL/Scope?
Bonus 100: Which tab is done first, before any data?
Cover Page & Notice to Reader
Bonus: Assumptions
FDD often examines this metric, calculated as Cur. Assets - Cur. Liabilities, to assess short-term financial health.
Working Capital
What state are both Tess and Kate from?
Colorado
When you have a section selected, how do you put 0's into all of the cells?
Type 0, Ctrl + Enter
These adjustments are made to financials to reflect more accurate profitability from a futuristic perspective.
Pro Forma
What type of adjustment steadies the effect of an expense or a revenue across a period?
Normalization Adjustment
These adjustments are proposed by the client/target and can be removed/changed in a separate section of the QoE.
Management Adjustments
What neighborhood is Anna moving to?
How do you select all of the blanks in a section of data?
Alt + H + S + K
Revenue Recognition
If AR, and AP have a current balance. What change needs to be made to the aging schedule?
Aged by Invoice Date = never current
Aged by Due Date = you will have current
What are the two main items removed from Net Working Capital?
Cash and Debt.
What is Jimmy's dog's name?
Basil
How do you center align text?
Ctrl + 1
Right Arrow to "Alignment" ribbon
Tab down
Down arrow to enter Horizontal alignment
Select "Center Across Alignment"
A company acquires another for $10M. The fair value of net assets is $8M. How should the $2M difference be recorded?
Goodwill
How is Debt/LOC treated in a Cash Proof?
Proceeds/Draws are removed from Revenue
Payments are removed from Expenses/Disbursements
The target has capitalized certain operating expenses as assets. Why is this a red flag?
EBITDA may be overstated and assets may be inflated
What country is Saif from?
Jordan