Wall Street Prep Premium
Exam:Transaction Comps Modeling Wall
Street Prep Exam Questions And Answers
2024 Updated With Detailed Answers
Rated 100%
What is the keyboard shortcut to move sheets within a
workbook? - ANSWER-Alt H O M
,What is the keyboard shortcut to open the formatting
cells dialog box? - ANSWER-ctrl 1
What are the keyboard shortcuts for auto-fitting a range
of columns? - ANSWER-1. Select the columns by hitting
Ctrl Spacebar 2) Hold down the shift key and use left and
right arrow keys to highlight the range of columns 3) Hit
Alt H O I to auto fit the columns
When you are in the Format Cells dialog (Ctrl 1):
1) What is the keyboard shortcut for moving across tabs
(Number, Alignment, Font Border, Fill, Protection)?
2)How do you move counter clockwise across form
elements?
3)How do you select a checkbox (put a checkbox next to
it) - ANSWER-1) Ctrl Tab, 2) Shift Tab 3) Spacebar
,All of the following are keyboard shortcut that allow the
user input to add more sheets to a workbook EXCEPT: -
ANSWER-Alt h i w
What is a keyboard shortcut to open a file? - ANSWER-
Ctrl o
What is the recommended workbook calculation setting
for Excel - ANSWER-Automatic except for Data Tables
To add a cell reference from a different worksheet into
an existing formula with your keyboard , you should
follow the following steps: - ANSWER-1. Hit F2 to get into
the existing formula 2. Holding down Ctrl, use PageUp or
PageDown to find the desired worksheet 3. Let go of the
Ctrl and PageUp/Down keys 4. Use the arrow keys to
locate the desired cell reference 5. Hit enter
Do companies prefer straight-line or accelerated
depreciation?
, For GAAP reporting purposes, companies generally
prefer straight-line depreciation. That's because a
company will record lower depreciation in the early years
of the asset's life than if they had used accelerated
depreciation. As a result, companies using straight-line
depreciation will show higher net income than under
accelerated depreciation.
Do companies depreciate land?
No, land is considered to have an indefinite life and is not
depreciated.
Can companies amortize goodwill?
Under GAAP, public companies are not allowed to
amortize goodwill. Instead, it must be tested annually for
impairment.
The longer answer is that under GAAP, public companies
are not allowed to amortize goodwill and must instead
test it annually for impairment. However, private
companies may elect to amortize goodwill. In addition,
for tax reporting purposes, goodwill may be amortized
over 15 years under some circumstances.
What is the impact of share issuance on EPS?
Exam:Transaction Comps Modeling Wall
Street Prep Exam Questions And Answers
2024 Updated With Detailed Answers
Rated 100%
What is the keyboard shortcut to move sheets within a
workbook? - ANSWER-Alt H O M
,What is the keyboard shortcut to open the formatting
cells dialog box? - ANSWER-ctrl 1
What are the keyboard shortcuts for auto-fitting a range
of columns? - ANSWER-1. Select the columns by hitting
Ctrl Spacebar 2) Hold down the shift key and use left and
right arrow keys to highlight the range of columns 3) Hit
Alt H O I to auto fit the columns
When you are in the Format Cells dialog (Ctrl 1):
1) What is the keyboard shortcut for moving across tabs
(Number, Alignment, Font Border, Fill, Protection)?
2)How do you move counter clockwise across form
elements?
3)How do you select a checkbox (put a checkbox next to
it) - ANSWER-1) Ctrl Tab, 2) Shift Tab 3) Spacebar
,All of the following are keyboard shortcut that allow the
user input to add more sheets to a workbook EXCEPT: -
ANSWER-Alt h i w
What is a keyboard shortcut to open a file? - ANSWER-
Ctrl o
What is the recommended workbook calculation setting
for Excel - ANSWER-Automatic except for Data Tables
To add a cell reference from a different worksheet into
an existing formula with your keyboard , you should
follow the following steps: - ANSWER-1. Hit F2 to get into
the existing formula 2. Holding down Ctrl, use PageUp or
PageDown to find the desired worksheet 3. Let go of the
Ctrl and PageUp/Down keys 4. Use the arrow keys to
locate the desired cell reference 5. Hit enter
Do companies prefer straight-line or accelerated
depreciation?
, For GAAP reporting purposes, companies generally
prefer straight-line depreciation. That's because a
company will record lower depreciation in the early years
of the asset's life than if they had used accelerated
depreciation. As a result, companies using straight-line
depreciation will show higher net income than under
accelerated depreciation.
Do companies depreciate land?
No, land is considered to have an indefinite life and is not
depreciated.
Can companies amortize goodwill?
Under GAAP, public companies are not allowed to
amortize goodwill. Instead, it must be tested annually for
impairment.
The longer answer is that under GAAP, public companies
are not allowed to amortize goodwill and must instead
test it annually for impairment. However, private
companies may elect to amortize goodwill. In addition,
for tax reporting purposes, goodwill may be amortized
over 15 years under some circumstances.
What is the impact of share issuance on EPS?
