lOMoARcPSD|5734770
Excel Crash Course Exam from Wall m m m m m
m Street Prep - Wall Street Prep Questions m m m m m m
And Answers Updated 2024 m m m m
lOMoARcPSD|5734770
Wall Street Prep The Premium Package
m m m m m
Review: Accounting & Financial Statement m m m m
Analysis Exam.
m m
Score: 95%, 38 correct out of 40
m m m m m m
Question 1 m
Assume US GAAP to answer this question.
m m m m m m
In 2017, $2 million in wages were earned and no cash wages were paid. In
m m m m m m m m m m m m m m
m2018, $8 million in wages were earned and $7 million in cash wages were paid.
m m m m m m m m m m m m m m
mCash wages were used to first pay wages earned in 2017 with the remainder
m m m m m m m m m m m m m
mused to pay wages earned in 2018. Any earned but unpaid wages will be paid
m m m m m m m m m m m m m m
mduring the first quarter of 2019. Using only the information provided, which of the
m m m m m m m m m m m m m
mfollowing statements is most accurate?
m m m m
Liabilities increased by $1.0 million in 2018
m m m m m m
Liabilities increased by $3.0 million in 2018
m m m m m m
Assets decreased by $5.0 million in 2018
m m m m m m
Retained earnings decreased by $10.0 million in 2018
m m m m m m m
Retained earnings decreased by $7.0 million in 2018
m m m m m m m
Your answer is correct.
m m m
Since wages were earned in 2017 but not yet paid, the opening balance sheet in
m m m m m m m m m m m m m m
2018 would have an accrued wages liability of $2.0. These were paid in 2018,
m m m m m m m m m m m m m m
reversing the liability. However, since there is only $5.0 million in cash ($7.0 less the
m m m m m m m m m m m m m m m
$2.0 million used to pay 2017 wages) available to pay wages earned in 2018, that
m m m m m m m m m m m m m m m
leaves $3.0 million in earned wages unpaid, raising the accrued wages liability to
m m m m m m m m m m m m m
$3.0 million. The net impact to the liability is $1.0 million (-$2.0 + $3 million). The
m m m m m m m m m m m m m m m m
only asset impacted is cash, which decreases by $7.0 million, while retained
m m m m m m m m m m m m
earnings decreases by $8.0 million, since wages are expensed when they are
m m m m m m m m m m m m
earned, not when they are paid.
m m m m m m
See Lesson: Payable, Accrued Expenses, Deferred Revenue & Debt
m m m m m m m m
,Question 2 m oARcPSD|5734770
A company issued its CEO 100,000 shares of restricted stock in the beginning of
m m m m m m m m m m m m m
2018 that are restricted for two years. The current share price is $10. Based on
m m m m m m m m m m m m m m m
the information provided, which of the following statements is true?
m m m m m m m m m m
An unearned compensation liability in the amount of $1 million is created at
m m m m m m m m m m m m
the grant date
m m m
An unearned compensation asset in the amount of $1 million is created at
m m m m m m m m m m m m
the grant date
m m m
Stockholders' equity increases by $1 million at the grant date m m m m m m m m m
An unearned compensation contra equity account in the amount of $500,000
m m m m m m m m m m
is recognized at the grant date
m m m m m m
Stockholders' equity is unchanged at the grant date m m m m m m m
Your answer is correct. m m m
The entire value of restricted stock issued at grant date is recognized as an equity
m m m m m m m m m m m m m m
account and is immediately offset by a contra equity account in the same amount
m m m m m m m m m m m m m m
so there is no change to stockholders’ equity at the grant date. This contra equity
m m m m m m m m m m m m m m m
account is reversed over the service period. In this case, a $1 million contra equity
m m m m m m m m m m m m m m m
account is created and reduced by $500,000 over the next two years, with an
m m m m m m m m m m m m m m
offsetting reduction in retained earnings.
m m m m m
See Lesson: Stock Based Compensation Accounting: Journal Entries
m m m m m m m
Question 3 m
A company issued its CEO 100,000 stock options in the beginning of 2018 that will
m m m m m m m m m m m m m m
vest equally over 2 years. Assume the following:
m m m m m m m m
The share price at grant date is $10 per share
m m m m m m m m m
The option exercise price is $10 per share
m m m m m m m
The fair value of each option at grant date is $5 per share
m m m m m m m m m m m m
No options are exercised until after year 2
m m m m m m m
Based only on the information provided, which of the following statements is true?
m m m m m m m m m m m m
Stockholders' equity increases by $1,000,000 at the grant date m m m m m m m m
Stockholders' equity increases by $500,000 at the grant date m m m m m m m m
Stockholders' equity increases by $250,000 at the grant date m m m m m m m m
, lOMoARcPSD|5734770
Stockholders' equity decreases by $250,000 at the end of year 1
m m m m m m m m m m
Stockholders' equity does not change at the end of year 1
m m m m m m m m m m
Your answer is correct. m m m
No journal entries occur at the grant date. Stock options are expensed as they vest with
m m m m m m m m m m m m m m m
ma corresponding entry in "APIC – Stock options" account. Since both accounts are part
m m m m m m m m m m m m m
mof stockholders’ equity, there is no change to stockholders’ equity. No asset or
m m m m m m m m m m m m
mliabilities
are recognized on the grant date.
m m m m m
See Lesson: Stock Based Compensation Accounting: Journal Entries
m m m m m m m
Question 4 m
A company recorded the following activities in 2018:
m m m m m m m
$5 million in capital expenditures were made in 2018
m m m m m m m m
$4 million in depreciation expense was recognized in 2018
m m m m m m m m
$3 million in affiliate income recognized on the income statement from a
m m m m m m m m m m m
m25% investment in an affiliate
m m m m
$1 million of insurance proceeds were received in cash due to hurricane damage on
m m m m m m m m m m m m m
mthe company’s corporate headquarters
m m m
Based only on the information provided, calculate the impact of the activities
m m m m m m m m m m m
described above on the company’s 2018 operating income and cash flows
m m m m m m m m m m m
(ignore taxes).
m m
Operating income decreased by $1.0 million. Cash flows decreased by
m m m m m m m m m
$4.0 million.
m m
Operating income decreased by $5.0 million. Cash flows increased by
m m m m m m m m m
$6.0 million.
m m
Operating income decreased by $4.0 million. Cash flows decreased by
m m m m m m m m m
$4.0 million.
m m
Operating income decreased by $6.0 million. Cash flows decreased by
m m m m m m m m m
$1.0 million.
m m
Operating income decreased by $6.0 million. Cash flows decreased by $3.0
m m m m m m m m m m
million.
Your answer is correct. m m m
Only the $4.0 million in depreciation expense impacts operating income.
m m m m m m m m m
Capital expenditures are not recognized on the income statement. Affiliate
m m m m m m m m m m
income and
m m
,
Excel Crash Course Exam from Wall m m m m m
m Street Prep - Wall Street Prep Questions m m m m m m
And Answers Updated 2024 m m m m
lOMoARcPSD|5734770
Wall Street Prep The Premium Package
m m m m m
Review: Accounting & Financial Statement m m m m
Analysis Exam.
m m
Score: 95%, 38 correct out of 40
m m m m m m
Question 1 m
Assume US GAAP to answer this question.
m m m m m m
In 2017, $2 million in wages were earned and no cash wages were paid. In
m m m m m m m m m m m m m m
m2018, $8 million in wages were earned and $7 million in cash wages were paid.
m m m m m m m m m m m m m m
mCash wages were used to first pay wages earned in 2017 with the remainder
m m m m m m m m m m m m m
mused to pay wages earned in 2018. Any earned but unpaid wages will be paid
m m m m m m m m m m m m m m
mduring the first quarter of 2019. Using only the information provided, which of the
m m m m m m m m m m m m m
mfollowing statements is most accurate?
m m m m
Liabilities increased by $1.0 million in 2018
m m m m m m
Liabilities increased by $3.0 million in 2018
m m m m m m
Assets decreased by $5.0 million in 2018
m m m m m m
Retained earnings decreased by $10.0 million in 2018
m m m m m m m
Retained earnings decreased by $7.0 million in 2018
m m m m m m m
Your answer is correct.
m m m
Since wages were earned in 2017 but not yet paid, the opening balance sheet in
m m m m m m m m m m m m m m
2018 would have an accrued wages liability of $2.0. These were paid in 2018,
m m m m m m m m m m m m m m
reversing the liability. However, since there is only $5.0 million in cash ($7.0 less the
m m m m m m m m m m m m m m m
$2.0 million used to pay 2017 wages) available to pay wages earned in 2018, that
m m m m m m m m m m m m m m m
leaves $3.0 million in earned wages unpaid, raising the accrued wages liability to
m m m m m m m m m m m m m
$3.0 million. The net impact to the liability is $1.0 million (-$2.0 + $3 million). The
m m m m m m m m m m m m m m m m
only asset impacted is cash, which decreases by $7.0 million, while retained
m m m m m m m m m m m m
earnings decreases by $8.0 million, since wages are expensed when they are
m m m m m m m m m m m m
earned, not when they are paid.
m m m m m m
See Lesson: Payable, Accrued Expenses, Deferred Revenue & Debt
m m m m m m m m
,Question 2 m oARcPSD|5734770
A company issued its CEO 100,000 shares of restricted stock in the beginning of
m m m m m m m m m m m m m
2018 that are restricted for two years. The current share price is $10. Based on
m m m m m m m m m m m m m m m
the information provided, which of the following statements is true?
m m m m m m m m m m
An unearned compensation liability in the amount of $1 million is created at
m m m m m m m m m m m m
the grant date
m m m
An unearned compensation asset in the amount of $1 million is created at
m m m m m m m m m m m m
the grant date
m m m
Stockholders' equity increases by $1 million at the grant date m m m m m m m m m
An unearned compensation contra equity account in the amount of $500,000
m m m m m m m m m m
is recognized at the grant date
m m m m m m
Stockholders' equity is unchanged at the grant date m m m m m m m
Your answer is correct. m m m
The entire value of restricted stock issued at grant date is recognized as an equity
m m m m m m m m m m m m m m
account and is immediately offset by a contra equity account in the same amount
m m m m m m m m m m m m m m
so there is no change to stockholders’ equity at the grant date. This contra equity
m m m m m m m m m m m m m m m
account is reversed over the service period. In this case, a $1 million contra equity
m m m m m m m m m m m m m m m
account is created and reduced by $500,000 over the next two years, with an
m m m m m m m m m m m m m m
offsetting reduction in retained earnings.
m m m m m
See Lesson: Stock Based Compensation Accounting: Journal Entries
m m m m m m m
Question 3 m
A company issued its CEO 100,000 stock options in the beginning of 2018 that will
m m m m m m m m m m m m m m
vest equally over 2 years. Assume the following:
m m m m m m m m
The share price at grant date is $10 per share
m m m m m m m m m
The option exercise price is $10 per share
m m m m m m m
The fair value of each option at grant date is $5 per share
m m m m m m m m m m m m
No options are exercised until after year 2
m m m m m m m
Based only on the information provided, which of the following statements is true?
m m m m m m m m m m m m
Stockholders' equity increases by $1,000,000 at the grant date m m m m m m m m
Stockholders' equity increases by $500,000 at the grant date m m m m m m m m
Stockholders' equity increases by $250,000 at the grant date m m m m m m m m
, lOMoARcPSD|5734770
Stockholders' equity decreases by $250,000 at the end of year 1
m m m m m m m m m m
Stockholders' equity does not change at the end of year 1
m m m m m m m m m m
Your answer is correct. m m m
No journal entries occur at the grant date. Stock options are expensed as they vest with
m m m m m m m m m m m m m m m
ma corresponding entry in "APIC – Stock options" account. Since both accounts are part
m m m m m m m m m m m m m
mof stockholders’ equity, there is no change to stockholders’ equity. No asset or
m m m m m m m m m m m m
mliabilities
are recognized on the grant date.
m m m m m
See Lesson: Stock Based Compensation Accounting: Journal Entries
m m m m m m m
Question 4 m
A company recorded the following activities in 2018:
m m m m m m m
$5 million in capital expenditures were made in 2018
m m m m m m m m
$4 million in depreciation expense was recognized in 2018
m m m m m m m m
$3 million in affiliate income recognized on the income statement from a
m m m m m m m m m m m
m25% investment in an affiliate
m m m m
$1 million of insurance proceeds were received in cash due to hurricane damage on
m m m m m m m m m m m m m
mthe company’s corporate headquarters
m m m
Based only on the information provided, calculate the impact of the activities
m m m m m m m m m m m
described above on the company’s 2018 operating income and cash flows
m m m m m m m m m m m
(ignore taxes).
m m
Operating income decreased by $1.0 million. Cash flows decreased by
m m m m m m m m m
$4.0 million.
m m
Operating income decreased by $5.0 million. Cash flows increased by
m m m m m m m m m
$6.0 million.
m m
Operating income decreased by $4.0 million. Cash flows decreased by
m m m m m m m m m
$4.0 million.
m m
Operating income decreased by $6.0 million. Cash flows decreased by
m m m m m m m m m
$1.0 million.
m m
Operating income decreased by $6.0 million. Cash flows decreased by $3.0
m m m m m m m m m m
million.
Your answer is correct. m m m
Only the $4.0 million in depreciation expense impacts operating income.
m m m m m m m m m
Capital expenditures are not recognized on the income statement. Affiliate
m m m m m m m m m m
income and
m m
,
