Exam (elaborations)
Excel crash course exam from wall street prep wall street prep questions and answers updated 2024
- Course
- Institution
Excel crash course exam from wall street prep wall street prep questions and answers updated 2024
[Show more]
Content preview
lOMoARcPSD|5734770Excel 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
,
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Prose1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79373 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now