WAL-MART ANALYSIS

WAL-MART ANALYSIS – DUE DATE MAY 29 @5PM EST

Directions: Answer all the questions. Please submit your work in Word or PDF formats only. Submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations.

Please run spell check, check your grammar and sentence structure and proofread your answers.

YOUR SUBMISSION WILL BE SUBMITTED TO “TURNITIN” and “GOOGLE” TO CHECK FOR PLAIGIARISM.

PLEASE REVIEW THE TEMPLATE I HAVE ATTACHED TO SEE HOW THE ANALYSIS IS DONE. IT IS JUST AN EXAMPLE YOU DON’T HAVE TO DO EXACTLY THE SAME BUT IT HELPS YOU TO STRUCTURE YOUR ASSIGNMENT IF YOU ARE NOT SURE.

ACT 5140 – Accounting for Decision Makers

Walmart Analysis Assignment

Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file.

Part 1

Perform a vertical and horizontal analysis of Wal-Mart Stores, Inc.’s income statements and balance sheets as of January 31, 2015. In performing this analysis, consider any notable trends or changes that you observe that may provide useful information concerning its financial condition. Also use as many years’ worth of statements as you feel necessary. You should write up your results in paragraph form.

Part 2

Assess Wal-Mart, Stores Inc. concerning liquidity, solvency, profitability, and stock performance as of January 31, 2015. For each area, you should calculate the ratios we discussed in class and provide an analysis of the ratios calculated. I include historical stock price information and outstanding common share information below.

Fiscal Year Ended 1/31/2015 1/31/2014 1/31/2013 1/31/2012
Adjusted Closing Price $83.94 $71.97 $65.79 $56.32
Common Shares Outstanding (millions) 3,228 3,233 3,314 3,418
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Groupon Case

ISSUES IN ACCOUNTING EDUCATION American Accounting Association Vol. 29, No. 1 DOI: 10.2308/iace-50595 2014 pp. 229–245

Growing Pains at Groupon

Saurav K. Dutta, Dennis H. Caplan, and David J. Marcinko

ABSTRACT: On November 4, 2011, Groupon Inc. went public with an initial market capitalization of $13 billion. The business was formed a couple of years earlier as an offshoot of ‘‘The Point.’’ The business grew rapidly and increased its reported revenue from $14.5 million in 2009 to $1.6 billion in 2011. Soon after going public, prior to its announcement of its first-quarter results, the company’s auditors required Groupon to disclose a material weakness in its internal controls over financial reporting that impacted its disclosures on revenue and its estimation of returns.

This case uses Groupon to motivate discussion of financial reporting issues in e- commerce businesses. Specifically, the case focuses on (1) revenue recognition practices for ‘‘agency’’ type e-commerce businesses, (2) accounting for sales with a right of return for new products, and (3) use of alternative financial metrics to better convey the intrinsic value of a business. The case requires students to critically read, analyze, and apply authoritative accounting guidance, and to read and analyze communications between the Securities and Exchange Commission (SEC) and the registrant.

Keywords: Groupon; revenue recognition; allowance for sales returns; e-commerce; non-GAAP metrics.

GROWING PAINS AT GROUPON

A s an undergraduate music major at Northwestern University, Andrew Mason eagerly

sought a version of rock music that would fuse punk with the Beatles and Cat Stevens.

Little did he imagine that within ten years he would be the CEO of one of history’s fastest-

growing businesses. After Northwestern and faded dreams of rock stardom, Mason, a self-taught

computer programmer, was hired to write code by the Chicago firm InnerWorkings. InnerWorkings

was founded in 2001 by Eric Lefkofsky, who had built several businesses around call centers and

the Internet. In 2006, Lefkofsky became interested in an idea of Mason’s for a website that would

act as a social media platform to bring people together with a common interest in some problem—

Saurav K. Dutta is an Associate Professor and Dennis H. Caplan is an Assistant Professor, both at University at Albany, SUNY; and David J. Marcinko is an Associate Professor at Skidmore College.

We thank the editor, associate editor, and two reviewers for their helpful insights, comments, and suggestions. We also acknowledge our accounting students who completed the case and provided us with valuable feedback.

Editor’s note: Accepted by William R. Pasewark

Published Online: August 2013

229

 

 

most often some sort of social cause. Lefkofsky provided Mason with $1 million of capital to

develop the concept that became known as ‘‘The Point.’’1

Virtually no one associated with The Point initially envisioned commercial aspirations for the

venture. In the fall of 2008, at the height of the financial crisis, ventures with little or no commercial

aspirations were in jeopardy. Lefkofsky and Mason faced a decision on how to proceed with The

Point. Lefkofsky seized on an idea proposed by a group of users of The Point. This group attempted

to identify a number of people who wanted to buy the same product, and then approach a seller for a

group discount. Mason had originally mentioned group-buying as one application of The Point, and

now Lefkofsky latched onto the concept and pursued it relentlessly. In response, Mason and his

employees began a side project that they named Groupon.

The business plan was relatively simple. Groupon offered vouchers via email to its subscriber

base that would provide discounts at local merchants. The vouchers were issued only after a critical

number of subscribers expressed interest. At that point, Groupon charged those subscribers for the

purchase and recorded the entire proceeds as revenue. Subsequently, when the subscriber redeemed

the voucher with the merchant, Groupon remitted a portion of the proceeds to the merchant and

retained the remainder. For example, a salon might offer a $100 hairstyling in exchange for a $50

Groupon voucher and agree to a 60-40 split of the price. Once a sufficient number of subscribers

agreed to the deal, Groupon sold the voucher for $50. After providing the service, the salon would

submit the voucher to Groupon and receive $30. Groupon would keep the remaining $20.

The idea took off with enthusiastic support from the local media in Chicago. By the end of

2008, it was clear to Lefkofsky and Mason that The Point would become Groupon. Understanding

that the key to competitive success would be a massive increase in scale, Lefkofsky pushed the

company to grow vigorously through quick expansion to many cities. Within a year, the new

company had 5,000 employees, and by 2012 had more than 10,000. The company’s revenue

growth was also impressive. Beginning with $94,000 in 2008, revenue had grown to $713 million

in 2010. In the first quarter of 2011, the company nearly equaled its entire 2010 sales, reporting

revenue of $644 million, and total revenue for 2011 was $1.6 billion. Andrew Mason became a

media star, appearing on CNBC and The Today Show. In August of 2010, he appeared on the cover of Forbes magazine, which touted Groupon as ‘‘the fastest growing company—ever.’’

The spectacular growth attracted more than media attention. Groupon quickly found itself

pursued by corporate suitors. By mid-2010, Yahoo! offered to purchase the company for a price

between $3 billion and $4 billion—it was an offer that Mason, who had no wish to work at Yahoo!,

quickly turned down. Google then approached Groupon with an offer that would eventually grow to

nearly $6 billion. Groupon rejected Google’s offer, as well. Faced with an ever-growing need for

cash, this decision left Mason and Lefkofsky with only one option: to take Groupon public. They

did so on November 4, 2011, at an IPO price of $20 per share, yielding a market capitalization of

$13 billion.

On the day of the IPO, the stock closed near its all-time high of $26 a share. It traded in the

range of $18 to $24 for several months following the IPO. The stock price then declined

precipitously after March 30, 2012, as shown in Figure 1, following the announcement of a material

weakness in internal controls, when Groupon announced that it planned:

to take additional measures to remediate the underlying causes of the material weakness,

primarily through the continued development and implementation of formal policies,

improved processes and documented procedures, as well as the continued hiring of

additional finance personnel. (Groupon 2012b, 23)

1 For additional background information on Groupon, see Steiner (2010), Carlson (2011), and Stone and MacMillan (2011).

230 Dutta, Caplan, and Marcinko

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

REVENUE RECOGNITION

Sale of products to customers prior to purchase by the vendor/retailer is a common business

model for ‘‘e-tailers’’ such as Expedia and Priceline. These vendors provide a platform for exchange

of goods, but do not necessarily transact in those goods. When the customer makes a purchase

through an e-tailer’s platform or interface, the e-tailer takes the payment from the customer and

places an order with the supplier to send goods directly to the customer. At a later date, it remits a

payment to the supplier for the prearranged price. Like a traditional business, the e-tailer retains the

difference between the payment received from the customer and the payment it makes to the

supplier. However, unlike a traditional merchandiser, the e-tailer never takes possession of the

merchandise.

The manner in which these transactions are recorded has significant impact on the financial

statements. There are primarily two ways of recording the transaction: on a ‘‘gross’’ or ‘‘net’’ basis.

Under the gross method, the entire amount received from the customer is recorded as revenue, and a

corresponding cost of sales is recorded to account for the payment made to the supplier for the

merchandise. Under the net method, only the difference between what is received from the

customer and what is paid to the supplier is recorded as revenue. This is consistent with recognizing

that the vendor earns a commission on the sale. We illustrate the concept further with the use of an

example. Suppose an e-tailer sells an airline ticket to a customer for $1,000 online and remits $950

to the airline. The issue is how the e-tailer should journalize the two transactions: (1) the sale to the

customer, and (2) the payment to the airline. Under the gross method of recognizing revenue, on the

date of sale to the customer, the journal entry is:

FIGURE 1 Groupon’s Stock Price Chart

Growing Pains at Groupon 231

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

Cash 1,000

Revenue 1,000

Cost of Sales 950

Accounts Payable 950

When the company pays the airline, the corresponding journal entry is:

Accounts Payable 950

Cash 950

Under the net method of recording the transaction, the journal entry on the date of sale to the

customer is:

Cash 1,000

Accounts Payable 950

Revenue 50

And on the date of payment to the airline, the journal entry is identical to the gross method:

Accounts Payable 950

Cash 950

The differences between the gross and net methods of recording the transactions are:

� Higher revenue is recorded under the gross method. � Higher cost of sales is recorded under the gross method.

However, gross profit—the excess of revenue over the cost of sales—is the same under the two

methods; $50 in our example.

In its original S-1 filing with the SEC on June 2, 2011, Groupon noted in its footnote on

revenue recognition that, ‘‘The Company records the gross amount it receives from Groupons, excluding taxes where applicable, as the Company is the primary obligor in the transaction’’ (Groupon 2011a, F-11). In its response to the S-1, the SEC commented:

it is unclear to us why you believe the company is the primary obligor in the arrangement.

Please advise us, in detail, and provide us management’s comprehensive analysis of its

revenue generating arrangements and explain the consideration given to each of the

indicators of gross reporting and each of the indicators of net reporting found in ASC 605-

45-45 . . . If, in fact, the company is the primary obligor, then explain to us why it is appropriate for the company to recognize revenue prior to delivery of the underlying

product or service by the merchant to the customer. (SEC 2011a, 11)

In its response, Groupon reasserted that it was the primary obligor and, hence:

it recognizes revenue on a gross basis in accordance with ASC 605-45-45 based on its

assessment of the facts and circumstances of the arrangement. The purchase of a Groupon

voucher gives the Customer the option to purchase goods or services at a specified price in

the future. For instance, a Customer may pay $25 for a Groupon that entitles him or her to

$50 of merchandise or services at a Merchant’s store. However, it is important to note that

the Company is not selling the underlying goods or services, only the voucher to obtain

discounted goods or services. (Groupon 2011b, 31)

232 Dutta, Caplan, and Marcinko

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

The SEC followed up:

Considering your view that the Company, and not the merchant, is the primary obligor in

the Groupon transaction, please explain the terms and conditions included in the

Company’s website that state ‘‘Vouchers you purchase through our Site as a Groupon

account holder are special promotional offers that you purchase from participating

Merchants through our service’’ and further that ‘‘The Merchant is the issuer of the

voucher and is fully responsible for all goods and services it provides to you’’ and why you

believe this is consistent with your view. (SEC 2011b, 4)

In response, Groupon contended:

the Company believes that, by virtue of the credit risk it bears and the Groupon Promise, it

is both a seller and an issuer of vouchers. The Company is the primary obligor when it

issues a Groupon voucher on behalf of a merchant, which in turn is solely responsible to

deliver goods or perform services. (Groupon 2011c, 2)

Although the Company provides the Groupon Promise, the Company does not accept any

other responsibility for the delivery of goods or services provided to a customer and has

never delivered the goods or services underlying a Groupon voucher to a customer on

behalf of a merchant or otherwise. (Groupon 2011c, 3)

However, in an amended S-1 filing on October 7, 2011, Groupon changed the related footnote on

revenue recognition to identify itself as the agent for the merchants. It noted:

we record as revenue the net amount we retain from the sale of Groupons after paying an

agreed upon percentage of the purchase price to the featured merchant excluding any

applicable taxes. Revenue is recorded on a net basis because we are acting as an agent of

the merchant in the transaction. (Groupon 2011d, 68)

The effect of this change in definition of revenue from gross to net on the income statement is

shown in Table 1. The first and third columns present the Income Statements for 2009 and 2010 as

originally reported on June 2, 2011, when revenue was reported on a gross basis. The second and

TABLE 1

Abridged Income Statements for Groupon

Income Statement Account

2009 2010

Gross Net Gross Net

Revenue $30.4 M $14.5 M $713.4 M $312.9 M

Cost of Sales 19.5 M 4.4 M 433.4 M 32.5 M

Gross Margin 10.9 M 10.1 M 280.0 M 280.4 M

Marketing Expense 4.6 M 4.9 M 263.2 M 284.3 M

General and Admin. Expense 7.5 M 6.4 M 233.9 M 213.3 M

Other Expenses 203.2 M 203.2 M

Net Loss 1.34 M 1.09 M 413.4 M 420.1 M

Net Loss to common shareholders 6.92 M 6.92 M 456.3 M 456.3 M

EPS (Basic) (0.04) (0.04) (2.66) (2.66)

This information was obtained from Groupon’s S-1 filing with the SEC on June 2, 2011, and the amended filing (Amendment No. 4) on October 7, 2011.

Growing Pains at Groupon 233

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

the fourth columns present the Income Statements for 2009 and 2010 as amended in the October 7

filing, to reflect revenue recognition on a net basis.

Groupon further elaborated on the change in revenue recognition when it filed its first-quarter

10-Q on May 15, 2012. The company noted that it had to ‘‘restate’’ the Statements of Operations

filed with the SEC on June 2, 2011, to ‘‘correct for an error in its presentation of revenue.’’ It

explained the change as follows:

The Company restated its reporting of revenues from Groupons to be net of the amounts

related to merchant fees. Historically, the Company reported the gross amounts billed to its

subscribers as revenue . . . The effect of the correction resulted in a reduction of previously reported revenues and corresponding reductions in cost of revenue in those periods. The

change in presentation had no effect on pre-tax loss, net loss or any per share amounts for

the period. (Groupon 2012c, 10)

The controversy over reporting revenue on a net versus gross basis is not new. This was a

much-debated issue in 1999, when the company in the center of the controversy was Priceline. In

the third quarter of 1999, Priceline reported revenue of $152 million. This amount included the full

price the customers paid to Priceline for hotel rooms, rental cars, airline tickets, and holiday

packages. However, much like travel agencies, Priceline retained only $18 million, a small portion

of the $152 million; the rest it remitted to the actual service providers, the hotels, the airlines, etc.

The revenue recognition issue was resolved in 2000, when Priceline reported only the commission

as revenue. During the same period, Priceline’s stock decreased about 98 percent from April to

December 2000.

Subsequent to the Priceline revenue recognition controversy, the SEC issued Staff Accounting

Bulletin No. 101, Revenue Recognition in Financial Statements. This guidance specifically required firms to report revenue on a net basis when the firm acts as an agent or broker without assuming the

risks of ownership of the goods or the risk of default on payment. Concurrently, the SEC directed

the Financial Accounting Standards Board (FASB) to explore the issue. In July 2000, the Emerging

Issues Task Force (EITF) of the FASB reached a consensus on Issue No. 99-19. The FASB

affirmed the guidance of EITF 99-19 in ASC Section 605, Revenue Recognition.2

Although net income is generally not affected by the use of gross versus net revenues, the issue

is important because revenue itself is a critical component in the financial statements, and revenue is

materially affected by the choice. ASC Section 605-45-45 (FASB 2012b) identifies indicators

supporting the use of gross revenue rather than net revenue. Two of these indicators, credit risk and

inventory risk, can be assessed for Groupon from its balance sheet and related footnote disclosures.

These are reproduced in Table 2 from Groupon’s original S-1 filing on June 2, 2011 (Groupon

2011a, F-4, F-9).

SALES WITH A RIGHT OF RETURN

Companies that provide a right of return to customers are required to establish an allowance for

sales returns if the amount is material. A merchandiser satisfies its obligations when it provides the

product to the customer and, hence, can recognize revenue for the amount of sale. However, if the

possibility exists that the customer could return the merchandise for a full or partial refund, the

company is required to create a reserve for such occurrences. The amount to be reserved is based on

past experience with returns and management estimates of future trends. When historical data do

not exist and estimation of future returns is not possible, recognition of revenue must be deferred

2 See Phillips, Luehlfing, and Daily (2001) for a discussion of SAB No. 101 and EITF 99-19.

234 Dutta, Caplan, and Marcinko

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

until the right of return has expired (FASB 2012a, ASC 605-15-25). Until then, any cash received

should be accounted for as unearned revenue, a liability.

Groupon’s business plan entails selling coupons for a product or service, and collecting cash

prior to the merchant providing the product or service. That is, customers pay up front for a coupon

for services or goods, and can redeem the coupon within the next six months. Moreover, the

product is provided by a separate merchant, independent of Groupon. To entice customers to

transact with Groupon, rather than directly with the vendor, Groupon features a generous right of

return for its subscribers at least on par with the vendor’s own right of return. The return policy is

featured prominently on the company’s website. Since Groupon does not directly provide the

service, it guarantees the quality of services/goods on behalf of the vendor. Furthermore, since

customers pay cash to Groupon while receiving services/goods from the vendor, customers expect

‘‘cash-back’’ from Groupon should they be dissatisfied. Groupon summarizes its policy as ‘‘The Groupon Promise,’’ which states simply: ‘‘If Groupon ever lets you down, we will return your purchase—simple as that.’’ In addition, it allows for full or partial refunds in the following situations:

� If a business closes permanently; � Any unredeemed Groupon can be returned for a full refund within seven days of purchase;

TABLE 2

Groupon Selected Disclosures Balance Sheet Excerpts (in ’000s)

December 31

2009 2010

Assets

Current assets:

Cash and cash equivalents $12,313 $118,833

Accounts receivable, net 601 42,407

Prepaid expenses and other current assets 1,293 12,615

Total current assets 14,207 173,855

Property and equipment, net 274 16,490

Goodwill — 132,038

Intangible assets, net 239 40,775

Deferred income taxes, non-current — 14,544

Other non-current assets 242 3,868

Total Assets $14,962 $381,570

Footnote Disclosure of Accounts Receivable, net:

Accounts receivable primarily represent the net cash due from the company’s credit card and other payment

processors for cleared transactions. The carrying amount of the company’s receivables is reduced by an

allowance for doubtful accounts that reflects management’s best estimate of amounts that will not be

collected. The allowance is based on historical loss experience and any specific risks identified in

collection matters. Accounts receivable are charged off against the allowance for doubtful accounts when it

is determined that the receivable is uncollectible. The company’s allowance for doubtful accounts at

December 31, 2009, and 2010 was $0 and less than $0.1 million, respectively. The corresponding bad debt

expense for the years ended December 31, 2008, 2009, and 2010 was $0, $0, and less than $0.1 million,

respectively (Groupon 2011a, F-9).

Growing Pains at Groupon 235

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

� In other cases, unredeemed Groupons are evaluated on a ‘‘case-by-case’’ basis; � After the expiration date, the Groupon is still worth the amount paid, which never expires.

In reviewing Groupon’s initial S-1 filing, the SEC noted:

It appears that the ‘‘Groupon Promise’’ is unconditional. In light of your rapid growth and

entry into new markets, explain to us why you believe the amount of future refunds is

reasonably estimable. (SEC 2011a, 11)

While acknowledging its rapidly growing and expanding markets, Groupon defended its ability to

reasonably estimate returns:

as the Company deals with more and more merchants, it does not believe the

characteristics of its merchants within a geographical region differ from one another

such that it would materially affect the Company’s estimates. (Groupon 2011b, 35)

As Groupon expanded to other markets, its product diversity increased from small-ticket items

such as restaurant meals and salon services to high-ticket items such as international vacations and

expensive medical services. Entering new markets with little or no historical experience, it became

increasingly difficult for Groupon to estimate customer returns. In early 2012, Groupon’s internal

accountants discovered that the amount of customer refunds in January exceeded all previous

models Groupon had constructed to predict customer behavior. One example was a large number of

refund requests for a deal involving Lasik eye surgery. Interestingly, many consumers that

purchased the Groupon for eye surgery did not realize that they had to be in good physical

condition to undergo surgical procedures. Hence, when these subscribers were deemed unfit to

undergo the surgical procedure, they returned their purchase to Groupon and asked for a refund.

However, Groupon had already recorded the sale and reported the revenue in the previous quarter

without having made an adequate provision for returns.

The high level of refund activity was significantly correlated with high price-point deals that

the company had only begun offering in 2011. These circumstances led to yet another financial

restatement by the young company. The revision to previously reported financial results for the

fourth quarter of 2011 was announced in the press release reproduced below:

Groupon, Inc. (NASDAQ: GRPN) today announced a revision of its reported financial

results for its fourth quarter and year ended December 31, 2011 . . . The revisions are primarily related to an increase to the Company’s refund reserve accrual to reflect a shift in

the Company’s fourth quarter deal mix and higher price point offers, which have higher

refund rates. The revisions have an impact on both revenue and cost of revenue. (Groupon

2012a)

The press release also noted:

The revisions resulted in a reduction to fourth quarter 2011 revenue of $14.3 million. The

revisions also resulted in an increase to fourth quarter operating expenses that reduced

operating income by $30.0 million, net income by $22.6 million, and earnings per share by

$0.04 . . . There is no change to Groupon’s previously reported operating cash flow of $169.1 million for the fourth quarter 2011 and $290.5 million for the full year 2011.

(Groupon 2012a)

Retroactively, Groupon adjusted its refund reserve, which is a liability for estimated costs to

provide refunds that are not recoverable from merchants. The reserve amount as of December 31,

2011 was $67.45 million, and on March 31, 2012 had increased to $81.56 million. The increase of

236 Dutta, Caplan, and Marcinko

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

$14.1 million in the balance of this account signifies the excess of accrued expense over actual cash

disbursements due to customer refunds.

By its decision to go public, Groupon imposed upon itself the requirements of Section 404 of

the Sarbanes-Oxley Act, which requires the company’s auditors to report annually on the

effectiveness of the company’s internal controls. The SEC permits a company going public to wait

until its second 10-K to comply with this requirement. When preparing for its initial Section 404

audit as required for the year ending December 31, 2012, Groupon and its auditors identified and

reported this material weakness in its 2011 10-K. The need to restate the refund reserve was

attributed to a material weakness in Groupon’s internal controls over its ‘‘financial statement close

process’’ (Groupon 2012a).

ACSOI: AN ALTERNATIVE FINANCIAL METRIC

As a private company, Groupon relied upon a non-GAAP measure of company performance

called Adjusted Consolidated Segment Operating Income (ACSOI). This metric was related, but

not identical, to the commonly used non-GAAP metric Earnings before Interest, Taxes,

Depreciation, and Amortization (EBITDA). While ACSOI included all of the revenues, it excluded

some common expenses, including: marketing expenses, acquisition-related costs, stock

compensation costs, interest, and tax expenses. ACSOI is even more aggressive than EBITDA

because it ignores some significant expenses related to Groupon’s business.

In its initial S-1 filing with the SEC, Groupon appeared more profitable under ACSOI than

under the GAAP metrics of net income and operating income. While on a GAAP basis, the

company lost $413.4 million for 2010 and $113.9 million in the first three months of 2011, the

ACSOI measures were a positive $60.6 million and $81.6 million, respectively. The difference was

in large part due to excluding from ACSOI online marketing costs to attract new customers. In its

response to Groupon’s initial S-1 filing, the SEC commented:

We note your use of the non-GAAP measure Adjusted Consolidated Segment Operating

Income, which excludes, among other items, online marketing expense. It appears that

online marketing expense is a normal, recurring operating cash expenditure of the

company. (SEC 2011a, 4)

In its response, the company provided the following rationale for excluding marketing expenses

from this metric:

The Company’s management utilizes Adjusted CSOI internally as a measure to assess the

performance of the business . . . In utilizing Adjusted CSOI as a performance measure, management does not rely on the non-recurring, infrequent or unusual nature of online

marketing expense. It focuses instead on the fact that such expenses are almost entirely

discretionary and incurred primarily to acquire new subscribers. (Groupon 2011b, 11)

EPILOGUE

In a letter to Groupon employees in early March 2013, CEO Andrew Mason wrote:

After four and a half intense and wonderful years as CEO of Groupon, I’ve decided that

I’d like to spend more time with my family. Just kidding—I was fired today. If you’re

wondering why . . . you haven’t been paying attention. From controversial metrics in our S-1 to our material weakness to two quarters of missing our own expectations and a stock

price that’s hovering around one quarter of our listing price, the events of the last year and

a half speak for themselves. As CEO, I am accountable. (Washingtonpost.com 2013)

Growing Pains at Groupon 237

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

CASE REQUIREMENTS

1. Compare and contrast the business model of Groupon with the business models of

Amazon and Wal-Mart. Referring to the risk factors in the MD&A sections of their 10-Ks,

compare significant risks and opportunities across these companies. How do these business

risks translate to risks in financial reporting?

2. ‘‘Revenue and revenue growth are more important than income and income growth for new businesses, especially in the new-age economy.’’ Do you agree with this statement?

Support your opinion by analyzing the relationship between Amazon’s revenue, income,

and its stock price from 1997 to 2010.

3. Using the data provided in Table 1, prepare common size income statements using

revenues and cost-of-goods-sold in the original S-1 and amended S-1. Analyze trends of

expenses as a percentage of revenue for 2009 and 2010. Compare and contrast the

following ratios:

a. Gross Margin Percentage;

b. Asset Turnover Ratio.

4. In the months leading up to Groupon’s IPO, the SEC posed a number of questions

regarding Groupon’s choice of accounting principles for revenue recognition. Specifically,

the SEC referred to the requirements in FASB’s ASC 605-45-45.

a. Compare the amount of revenue reported in the original and amended S-1s. What

caused the difference?

b. Which of the two amounts do you think Groupon preferred? Why did they prefer it?

c. In correspondence with the SEC following its initial S-1 filing, how did Groupon justify

its method of reporting revenue?

d. With reference to ASC 605-45-45, which of Groupon’s arguments were weak, and why?

5. Groupon had recognized revenue for the sale of high-ticket items in late 2011. Purchasers

of the Groupons have a right of return, as specified in the ‘‘Groupon Promise,’’ prominently featured on its website.

a. Assess the U.S. GAAP requirement for recognition of revenue when right of return exists,

specified in ASC Section 605-15-25, in the context of Groupon’s business model.

b. Do you agree with Groupon’s accounting? Why or why not?

c. What could Groupon have done differently, and how would the financial statements

have been affected?

6. Groupon’s restatement of 2011 fourth-quarter financials resulted in a reduction of $14.3

million of revenues and a decrease of $30 million of operating income. However, its

operating cash flow was unaffected. Explain how this is possible.

7. The refund reserve amount for Groupon as of December 31, 2011, was $67.45 million, and

on March 31, 2012, had increased to $81.56 million. Assume that the accrued expense for

refund reserve was $100 million for the first quarter of 2012.

a. How much refund was issued in 2012?

b. Explain why the expense recorded in the first quarter does not equal the amount paid

during the quarter.

8. In its initial S-1 filing, Groupon presented a non-GAAP performance metric called ACSOI.

It was subsequently removed after the SEC objected.

a. Why did the SEC question the inclusion of ACSOI in Groupon’s financial statements?

b. Non-GAAP metrics are common in some industries. These include: Value-at-Risk in

the financial sector, same-store-sales in retail, revenue-passenger-miles for airlines, and

order-backlog in the semiconductor industry. Explain two of these metrics and assess

their value to financial statement users.

238 Dutta, Caplan, and Marcinko

Issues in Accounting Education Volume 29, No. 1, 2014

 

 

c. While the SEC allows the reporting of metrics identified in (b), it did question the use of

ACSOI. What differences between the acceptable non-GAAP metrics in (b) and ACSOI

were of concern to the SEC?

d. Do you agree with Groupon’s contention that discretionary expenses, such as

subscription acquisition costs, should be excluded from the financial measures of a

company’s performance?

9. Groupon’s management needed significant cash to fund its growth. It had three options:

(A) seek private investment, (B) sell the company to Yahoo! or Google, or (C) go public.

a. Contrast the financial reporting challenges across the three options.

b. In March 2012, Groupon’s auditors noted a material weakness in the company’s

internal controls related to ‘‘deficiencies in the financial statement close process.’’ Would this disclosure have been made if Groupon had chosen options (A) or (B)?

10. In your opinion, do the problems with Groupon’s choice of accounting methods, use of a

non-GAAP metric, and material weakness in its internal control reflect a lack of

management experience or a lack of management integrity?

REFERENCES

Carlson, N. 2011. Inside Groupon: The truth about the world’s most controversial company. Business Insider (October 31). Available at: http://www.businessinsider.com/inside-groupon-the-truth-about-the-worlds-

most-controversial-company-2011-10

Financial Accounting Standards Board (FASB). 2012a. Revenue Recognition: Products—Recognition. Accounting Standards Codification (ASC) Section 605-15-25. Norwalk, CT: FASB.

Financial Accounting Standards Board (FASB). 2012b. Revenue Recognition: Principal Agent Consider- ations—Other Presentation Matters. ASC Section 605-45-45. Norwalk, CT: FASB.

Groupon. 2011a. Form S-1: Registration Statement under the Securities Act of 1933. Filed with the SEC on

June 2. Washington, DC: Government Printing Office.

Groupon. 2011b. Letter to SEC dated July 14. Available at: http://www.sec.gov/Archives/edgar/data/1490281/

000104746911006336/0001047469-11-006336-index.htm

Groupon. 2011c. Letter to SEC dated August 29. Available at: http://www.sec.gov/Archives/edgar/data/

1490281/000104746911007725/0001047469-11-007725-index.htm

Groupon. 2011d. Amendment No. 4 to Form S-1: Registration Statement under the Securities Act of 1933.

Filed with the SEC on October 7. Washington, DC: Government Printing Office.

Groupon. 2012a. Groupon Announces Revised Fourth Quarter and Full Year 2011 Results, Confirms First Quarter Guidance (March 30). Press Release. Available at: http://investor.groupon.com/releasedetail. cfm?releaseid¼660861

Groupon. 2012b. Form 10-K. Filed with the SEC on March 30. Washington, DC: Government Printing Office.

Groupon. 2012c. Form 10-Q. Filed with the SEC on May 15. Washington, DC: Government Printing Office.

Phillips, T. J., Jr., M. S. Luehlfing, and C. M. Daily. 2001. The right way to recognize revenue. Journal of Accountancy 191 (6): 39–46.

Securities and Exchange Commission (SEC). 2011a. SEC-generated letter dated June 29. Available at: http://

www.sec.gov/Archives/edgar/data/1490281/000000000011039811/0000000000-11-039811-index.htm.

Securities and Exchange Commission (SEC). 2011b. SEC-generated letter dated August 19. Available at:

http://www.sec.gov/Archives/edgar/data/1490281/000000000011050412/0000000000-11-050412-

index.htm.

Steiner, C. 2010. The next web phenom. Forbes 186 (3): 58–62. Stone, B., and D. MacMillan. 2011. Are four words worth $25 billion? Bloomberg Businessweek 4221 (March

21): 70–75.

Washingtonpost.com. 2013. Groupon’s CEO writes the best resignation letter ever (March 1). Available at:

http://www.washingtonpost.com/blogs/wonkblog/wp/2013/03/01/groupons-ceo-writes-the-best-

resignation-letter-ever/

Growing Pains at Groupon 239

Issues in Accounting Education Volume 29, No. 1, 2014

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Intermediate Accounting/Week 2

eek 2 Exercises

E4-16 – Statement of Cash Flows Preparation

The following summary transactions occurred during 2011 for Bluebonnet Bakers:

Cash Received from:  
Customers $380,000
Interest on note receivable 6,000
Principal on note receivable 50,000
Sale of investments 30,000
Proceeds from Notes Payable 100,000
Cash Paid for:  
Purchase of inventory 160,000
Interest on note payable 5,000
Purchase of equipment 85,000
Salaries to employees 90,000
Principle on notes payable 25,000
Payment on dividends to shareholders 20,000

 

The balance of cash and cash equivalents at the beginning of 2011 was $17.000.

Required:

Prepare a statement of cash flows for 2011 for Bluebonnet Bakers. Use the direct method for reporting operating activities.

E4-19 – Statement of cash flows directly from transactions

The following transactions occurred during March 2011 for the Wainwright Corporation. The company owns and operates a wholesale warehouse.

1. Issued 30,000 shares of capital stock in exchange for $300,000 in cash.

2. Purchased equipment at a cost of $40,000. $10,000 cash was paid and a note payable was signed for the balance owed.

3. Purchased inventory on account at a cost of $90,000. The company uses the perpetual inventory system.

4. Credit sales for the month totaled $120,000. The cost of goods sold was $70,000.

5. Paid $5,000 in rent on the warehouse building for the month of March.

6. Paid $6,000 to an insurance company for fire and liability insurance for a one-year period beginning April 1, 2011.

7. Paid $70,000 on account for the merchandise purchased in 3.

8. Collected $55,000 from customers on account.

9. Recorded depreciation expense of $1,000 for the month on the equipment.

 

 

Required:

1. Analyze each transaction and classify each as a financing, investing and/or operating activity (a transaction can represent more than one type of activity). In doing so, also indicate the cash effect of each, if any. If there is no cash effect, simply place a check mark in the appropriate columns.

Example:

Financing Investing Operating

1. $300,000

 

2. Prepare a statement of cash flows, using the direct method to present cash flows from operating activities. Assume the cash balance at the beginning of the month was $40,000.

E4-22 – Statement of cash flows; indirect method

Presented below is the 2011 income statement and comparative balance sheet information for Tiger Enterprises.

TIGER ENTERPRISES

Income Statement

For the Year Ended December 31, 2011

($ in thousands)   $7,000
Sales Revenue    
Operating expenses    
Cost of goods sold $3360  
Depreciation 240  
Insurance 100  
Administrative and other 1,800  
Total operating expenses   5,500
Income before income taxes   1,500
Income tax expense   600
Net Income   $900
     
Balance Sheet Information Dec. 31, 2011 Dec. 31, 2010
Assets    
Cash $300 $200
Accounts Receivable 750 830
Inventory 640 600
Prepaid Insurance 50 20
Plant and Equipment 2,100 1,800
Less: Accumulated depreciation (840) (600)
Total assets $3,000 $2,850
     
Liabilities and Shareholders’ Equity Dec. 31, 2011 Dec. 31, 2010
Accounts payable $300 $360
Payables for administrative and other expenses 300 400
Income taxes payable 200 150
Note payable (due 12/31/2012) 800 600
Common stock 900 800
Retained earnings 500 540
Total liabilities and shareholders’ equity $3,000 $2,850

 

Required:

Prepare Tiger’s statement of cash flows, using the indirect method to present cash flows from operating activities. (Hint: You will have to calculate dividend payments.)

 

Judgment Case 4-9

Each of the following situations occurred during 2011 for one of your audit clients:

1. The write-off of inventory due to obsolescence.

2. Discovery that depreciation expenses were omitted by accident from 2010’s income statement.

3. The useful lives of all machinery were changed from eight to five years.

4. The depreciation method used for all equipment was changed from the declining-balance to the straight-line method.

5. Ten million dollars face value of bonds payable were repurchased (paid off) prior to maturity resulting in a material loss of $500,000. The company considers the event unusual and infrequent.

6. Restructuring costs were incurred.

7. The Stridewell Company, a manufacturer of shoes, sold all of its retail outlets. It will continue to manufacture and sell its shoes to other retailers. A loss was incurred in the disposition of the retail stores. The retail stores are considered components of the entity.

8. The inventory costing method was changed from FIFO to average cost.

 

Required:

1. For each situation, identify the appropriate reporting treatment from the list below (consider each event to be material):

a. As an extraordinary item.

b. As an unusual or infrequent gain or loss.

c. As a prior period adjustment.

d. As a change in accounting principle.

e. As a discontinued operation.

f. As a change in accounting estimate.

g. As a change in accounting estimate achieved by a change in accounting principle.

2. Indicate whether each situation would be included in the income statement in continuing operations (CO) or below continuing operations (BC), or if it would appear as an adjustment to retained earnings (RE). Use the format shown to answer requirements 1 and 2.

 

 

Situation

 

Treatment (a-g)

Financial Statement Presentation (CO, BC, or RE)
1.    
2.    
3.    
4.    
5.    
6.    
7.    
8.    

 

 

E5-3 – Installment sales method; journal entries

Charter Corporation, which began business in 2011, appropriately uses the installment sales method of accounting for its installment sales. The following data were obtained for sales during 2011 and 2012.

  2011 2012
Installment sales $360,000 $350,000
Cost of installment sales 234,000 245,000
Cash collections on installment sales during:

2011

2012

 

150,000

 

100,000

120,000

 

Required:

Prepare summary journal entries for 2011 and 2012 to account for the installment sales and cash collections. The company uses the perpetual inventory system.

E5-10 – Long-term contract; percentage of completion, completed contract and cost recovery methods

On June 15, 2011, Sanderson Construction entered into a long-term construction contract to build a baseball stadium in Washington D.C. for $220 million. The expected completion date is April 1 of 2013, just in time for the 2013 baseball season. Costs incurred and estimated costs to complete at year-end for the life of the contract are as follows ($ in millions)

  2011 2012 2013
Costs incurred during the year $40 $80 $50
Estimated costs to complete as of 12/31 120 60

 

Required:

1. Determine the amount of gross profit or loss to be recognized in each of the three years using the percentage-of-completion method.

2. How much revenue will Sanderson report on its 2011 and 2012 income statements related to this contract using the percentage-of-completion method?

3. Determine the amount of gross profit or loss to be recognized in each of the three years using the completed contract method.

4. Determine the amount of revenue, cost and gross profit or loss to be recognized in each of the three years under IFRS, assuming that using the percentage-of-completion method is not appropriate.

5. Suppose the estimated costs to complete at the end of 2012 are $80 million instead of $60 million. Determine the amount of gross profit or loss to be recognized in 2012 using the percentage-of-completion method.

 

5-23 – Using ratios to test reasonableness of data

Review the information pertaining to the audit of Covington Pike Corporation in problem 5-23.  Use the list of ratios and the notes provided to approximate the current year’s balances in the form of a balance sheet and income statement, to the extent the information allows.  Accompany those financial statements with calculations you use to estimate each amount reported.

You are a new staff accountant with a large regional CPA firm, participating in your first audit. You recall from your auditing class that CPA’s often use ratios to test the reasonableness of accounting numbers provided by the client. Since ratios reflect the relationships among various account balances, if it is assumed that prior relationships still hold, prior years’ ratios can be used to estimate what current balances should approximate. However, you never actually performed this kind of analysis until now. The CPA in charge of the audit of Covington Pike Corporation brings you the list of ratios shown below and tells you these reflect the relationships maintained by Covington Pike in recent years.

 

Profit margin on sales = 5%

Return on assets = 7.5%

Gross profit margin = 40%

Inventory turnover ratio = 6 times

Receivables turnover ratio = 25

Acid-test ratio = .9

Current ratio = 2 to 1

Return on shareholders’ equity = 10%

Debt to equity ratio = 1/3

Times interest earned ratio = 12 times

 

Jotted in the margin are the following notes:

· Net income $15,000

· Only one short-term note ($5,000); all other current liabilities are trade accounts

· Property, plant, and equipment are the only noncurrent assets

· Bonds payable are the only noncurrent liabilities

· The effective interest rate on short-term notes and bonds is 8%

· No investment securities

· Cash balance totals $15,000

 

Required:

You are requested to approximate the current year’s balances in the form of a balance sheet and income statement, to the extent the information allows. Accompany those financial statements with the calculations you use to estimate each amount reported.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Guide

Question 1)

Required information

[The following information applies to the questions displayed below.]

 

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method.

 

For Part 1 of this project, you will complete payroll for the last month (December) of the fourth quarter (Q4) of 2016, which consists of the final two pay periods of the year.  Once payroll has been completed for the fourth quarter, you will then file the annual tax forms for Wayland as well as prepare each employee’s Form W-2 in Part 2.

 

The SUTA (UI) rate for Wayland Custom Woodworking is 2.6% on the first $32,200. The state withholding rate is 5.0% for all income levels and marital statuses, which will be used in computing Utah withholding tax for each employee using the tax tables provided below.

 

Rounding can create a challenge. For this project, the hourly rate for the individuals should be rounded to five decimal places. So take their salary and divide by 2,080 (52 weeks at 40 hours per week) for all full time employees, both exempt and nonexempt. For nonexempt employees, such as Stevon Varden, Varden’s salary is $42,000 and is a nonexempt employee, so the calculation will be $42,000/2,080, which would give you $20.19231 per hour, and use this to compute the employee’s gross pay based on the number of hours worked.  When a nonexempt employee has worked overtime hours for a given pay period, take their regular hourly rate and multiply it by 1.5, round the result to 5 decimal places, and multiply the new rate by their number of overtime hours.

 

For exempt employees, such as Anthony Chinson, an hourly rate rounded to five decimal places should be determined using the same method shown above, but gross pay should be determined by taking the exempt employee’s yearly salary and dividing it by 24, which is the number of payroll periods with a semimonthly frequency.  For example, Chinson’s salary is $24,000 and is a full time employee.  Chinson’s hourly rate is $11.53846(determined by taking $24,000/2,080), but as he is an exempt employee, the calculation for his gross pay will be $24,000/24, which would give you $1,000.  For pay periods that include paid holidays, ensure to distribute an exempt employee’s regular pay accordingly to holiday pay based on the number of hours that consist of the holidays for that period.

 

Employees are paid for the following holidays occurring during the final quarter:

· Thanksgiving day and the day after, Thursday and Friday November 24-25

· Christmas, which is a Sunday. When holidays occur on a weekend, the preceding Friday, December 23, is considered a holiday. Employees receive holiday pay for Monday, December 26.

 

For the completion of this project, refer to the tax-related information in the table below.  For federal withholding calculations, use the percentage method tables in Appendix C, which is provided below. For Utah state withholding calculations, use the Utah Schedule 3 tax tables linked below (ensure to use the appropriate Utah table based on each employee’s marital status). Both 401(k) and insurance are pretax for federal income tax and Utah income tax.

 

 

   
Federal Withholding Allowance (less 401(k), Section 125) $168.80 per allowance claimed
Semimonthly Federal Percentage Method Tax Table Appendix C Page 254 Table #3
Federal Unemployment Rate (employer only) (less Section 125) 0.6% on the first $7,000 of wages
State Withholding Rate (less 401(k), Section 125) See Utah Schedule 3, Table 1 or use the Excel Version of Schedule 3
State Unemployment Rate (employer only) (less Section 125) 2.6% on the first $32,200 of wages
 

 

 

The balance sheet for WCW as of November 30, 2016, is as follows:

Wayland Custom Woodworking Balance Sheet 11/30/2016
Assets   Liabilities & Equity
Cash $ 1,086,269.51   Accounts Payable $ 150,230.89
Supplies   10,283.15   Salaries and Wages Payable   10,319.19
Office Equipment   130,202.16   Federal Unemployment Tax Payable   1,920.92
Inventory   221,163.81   Social Security Tax Payable   3,219.22
Vehicle   25,000.00   Medicare Tax Payable   752.88
Accumulated Depreciation, Vehicle   (1,420.00)   Federal Unemployment Tax Payable   92.32
Building   164,000.00   State Unemployment Tax Payable   674.99
Accumulated Depreciation, Building   (3,221.00)   Employee State Income Tax Payable   1,088.86
Land   35,750.00   401(k) Contributions Payable   1,018.66
Total Assets   1,668,027.63   Employee Medical Premiums Payable   750.00
        Notes Payable   211,000.00
        Utilities Payable   2,825.43
        Total Liabilities   383,893.36
        Owners’ Equity   1,250,000.00
        Retained Earnings   34,134.27
        Total Equity   1,284,134.27
        Total Liabilities and Equity   1,668,027.63
 

 

October 1:

Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland’s staff:

 

Employee Number Name and Address Payroll information
00-Chins Anthony Chinson Married, 1 Withholding allowance
  530 Sylvann Avenue Exempt
  Logan, UT 84321 $24,000/year + commission
  435-555-1212 Start Date: 10/1/2016
  Job title: Account Executive SSN: 511-22-3333
     
00-Wayla Mark Wayland Married, 5 withholding allowances
  1570 Lovett Street Exempt
  Logan, UT 84321 $75,000/year
  435-555-1110 Start Date: 10/1/2016
  Job title: President/Owner SSN: 505-33-1775
     
01-Peppi Sylvia Peppinico Married, 7 withholding allowances
  291 Antioch Road Exempt
  Logan, UT 84321 $43,500/year
  435-555-2244 Start Date: 10/1/2016
  Job title: Craftsman SSN: 047-55-9951
     
01-Varde Stevon Varden Married, 2 withholding allowances
  333 Justin Drive Nonexempt
  Logan, UT 84321 $42,000/year
  435-555-9981 Start Date: 10/1/2016
  Job title: Craftsman SSN: 022-66-1131
     
02-Hisso Leonard Hissop Single, 4 withholding allowances
  531 5th Street Nonexempt
  Logan, UT 84321 $49,500/year
  435-555-5858 Start Date: 10/1/2016
  Job title: Purchasing/Shipping SSN: 311-22-6698
     
00-Succe Student F Success Single, 1 withholding allowance
  1650 South Street Nonexempt
  Logan, UT 84321 $36,000/year
  435-556-1211 Start Date: 10/1/2016
  Job title: Accounting Clerk SSN: 555-55-5555
     

 

Voluntary deductions for each employee are as follows:

 

Name Deduction
Chinson Insurance: $50/paycheck
  401(k): 3% of gross pay
Wayland Insurance: $75/paycheck
  401(k): 6% of gross pay
Peppinico Insurance: $75/paycheck
  401(k): $50 per paycheck
Varden Insurance: $50/paycheck
  401(k): 4% of gross pay
Hissop Insurance: $75/paycheck
  401(k): 3% of gross pay
Student Insurance: $50/paycheck
  401(k): 3% of gross pay
 

 

 

The departments are as follows:

Department 00: Sales and Administration

Department 01: Factory workers

Department 02: Delivery and Customer service

 

You have been hired as of October 1 as the new accounting clerk. Your employee number is 00-SUCCE. Your name is Student F Success. Your address is 1650 South Street, Logan, UT 84321. Your phone number is 435-556-1211, you were born July 16, 1985, your Utah driver’s license number is 887743 expiring in 7/16/2018, and your Social Security number is 555-55-5555. You are considered a nonexempt employee, have one withholding allowance, and paid a rate of $36,000 per year.

 

For additional instructions on how to navigate and work through through Part 1 of this project, please download the student project guide here.

rev: 01_11_2017_QC_CS-74391

Required:

 

1. Complete the W-4 and, using the given information, complete the I-9 form to start your employee file. Complete it as if you are single with one withholding, you contribute 3% to a 401(k), and health insurance is $50 per pay period. The following file provides the lists of acceptable documents for Form I-9.

 

(NOTE): Further instructions on format can be found on certain cells within the forms. Employer I9 PG 2 Section should also be completed.

 

 

 

 

Question 2) Required information

[The following information applies to the questions displayed below.]

 

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method.

 

For Part 1 of this project, you will complete payroll for the last month (December) of the fourth quarter (Q4) of 2016, which consists of the final two pay periods of the year.  Once payroll has been completed for the fourth quarter, you will then file the annual tax forms for Wayland as well as prepare each employee’s Form W-2 in Part 2.

 

The SUTA (UI) rate for Wayland Custom Woodworking is 2.6% on the first $32,200. The state withholding rate is 5.0% for all income levels and marital statuses, which will be used in computing Utah withholding tax for each employee using the tax tables provided below.

 

Rounding can create a challenge. For this project, the hourly rate for the individuals should be rounded to five decimal places. So take their salary and divide by 2,080 (52 weeks at 40 hours per week) for all full time employees, both exempt and nonexempt. For nonexempt employees, such as Stevon Varden, Varden’s salary is $42,000 and is a nonexempt employee, so the calculation will be $42,000/2,080, which would give you $20.19231 per hour, and use this to compute the employee’s gross pay based on the number of hours worked.  When a nonexempt employee has worked overtime hours for a given pay period, take their regular hourly rate and multiply it by 1.5, round the result to 5 decimal places, and multiply the new rate by their number of overtime hours.

 

For exempt employees, such as Anthony Chinson, an hourly rate rounded to five decimal places should be determined using the same method shown above, but gross pay should be determined by taking the exempt employee’s yearly salary and dividing it by 24, which is the number of payroll periods with a semimonthly frequency.  For example, Chinson’s salary is $24,000 and is a full time employee.  Chinson’s hourly rate is $11.53846 (determined by taking $24,000/2,080), but as he is an exempt employee, the calculation for his gross pay will be $24,000/24, which would give you $1,000.  For pay periods that include paid holidays, ensure to distribute an exempt employee’s regular pay accordingly to holiday pay based on the number of hours that consist of the holidays for that period.

 

Employees are paid for the following holidays occurring during the final quarter:

· Thanksgiving day and the day after, Thursday and Friday November 24-25

· Christmas, which is a Sunday. When holidays occur on a weekend, the preceding Friday, December 23, is considered a holiday. Employees receive holiday pay for Monday, December 26.

 

For the completion of this project, refer to the tax-related information in the table below.  For federal withholding calculations, use the percentage method tables in Appendix C, which is provided below. For Utah state withholding calculations, use the Utah Schedule 3 tax tables linked below (ensure to use the appropriate Utah table based on each employee’s marital status). Both 401(k) and insurance are pretax for federal income tax and Utah income tax.

 

   
Federal Withholding Allowance (less 401(k), Section 125) $168.80 per allowance claimed
Semimonthly Federal Percentage Method Tax Table Appendix C Page 254 Table #3
Federal Unemployment Rate (employer only) (less Section 125) 0.6% on the first $7,000 of wages
State Withholding Rate (less 401(k), Section 125) See Utah Schedule 3, Table 1 or use the Excel Version of Schedule 3
State Unemployment Rate (employer only) (less Section 125) 2.6% on the first $32,200 of wages
 

 

The balance sheet for WCW as of November 30, 2016, is as follows:

Wayland Custom Woodworking Balance Sheet 11/30/2016
Assets   Liabilities & Equity
Cash $ 1,086,269.51   Accounts Payable $ 150,230.89
Supplies   10,283.15   Salaries and Wages Payable   10,319.19
Office Equipment   130,202.16   Federal Unemployment Tax Payable   1,920.92
Inventory   221,163.81   Social Security Tax Payable   3,219.22
Vehicle   25,000.00   Medicare Tax Payable   752.88
Accumulated Depreciation, Vehicle   (1,420.00)   Federal Unemployment Tax Payable   92.32
Building   164,000.00   State Unemployment Tax Payable   674.99
Accumulated Depreciation, Building   (3,221.00)   Employee State Income Tax Payable   1,088.86
Land   35,750.00   401(k) Contributions Payable   1,018.66
Total Assets   1,668,027.63   Employee Medical Premiums Payable   750.00
        Notes Payable   211,000.00
        Utilities Payable   2,825.43
        Total Liabilities   383,893.36
        Owners’ Equity   1,250,000.00
        Retained Earnings   34,134.27
        Total Equity   1,284,134.27
        Total Liabilities and Equity   1,668,027.63
 

 

October 1:

Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland’s staff:

 

Employee Number Name and Address Payroll information
00-Chins Anthony Chinson Married, 1 Withholding allowance
  530 Sylvann Avenue Exempt
  Logan, UT 84321 $24,000/year + commission
  435-555-1212 Start Date: 10/1/2016
  Job title: Account Executive SSN: 511-22-3333
     
00-Wayla Mark Wayland Married, 5 withholding allowances
  1570 Lovett Street Exempt
  Logan, UT 84321 $75,000/year
  435-555-1110 Start Date: 10/1/2016
  Job title: President/Owner SSN: 505-33-1775
     
01-Peppi Sylvia Peppinico Married, 7 withholding allowances
  291 Antioch Road Exempt
  Logan, UT 84321 $43,500/year
  435-555-2244 Start Date: 10/1/2016
  Job title: Craftsman SSN: 047-55-9951
     
01-Varde Stevon Varden Married, 2 withholding allowances
  333 Justin Drive Nonexempt
  Logan, UT 84321 $42,000/year
  435-555-9981 Start Date: 10/1/2016
  Job title: Craftsman SSN: 022-66-1131
     
02-Hisso Leonard Hissop Single, 4 withholding allowances
  531 5th Street Nonexempt
  Logan, UT 84321 $49,500/year
  435-555-5858 Start Date: 10/1/2016
  Job title: Purchasing/Shipping SSN: 311-22-6698
     
00-Succe Student F Success Single, 1 withholding allowance
  1650 South Street Nonexempt
  Logan, UT 84321 $36,000/year
  435-556-1211 Start Date: 10/1/2016
  Job title: Accounting Clerk SSN: 555-55-5555
     

 

Voluntary deductions for each employee are as follows:

 

Name Deduction
Chinson Insurance: $50/paycheck
  401(k): 3% of gross pay
Wayland Insurance: $75/paycheck
  401(k): 6% of gross pay
Peppinico Insurance: $75/paycheck
  401(k): $50 per paycheck
Varden Insurance: $50/paycheck
  401(k): 4% of gross pay
Hissop Insurance: $75/paycheck
  401(k): 3% of gross pay
Student Insurance: $50/paycheck
  401(k): 3% of gross pay
 

 

 

The departments are as follows:

Department 00: Sales and Administration

Department 01: Factory workers

Department 02: Delivery and Customer service

 

You have been hired as of October 1 as the new accounting clerk. Your employee number is 00-SUCCE. Your name is Student F Success. Your address is 1650 South Street, Logan, UT 84321. Your phone number is 435-556-1211, you were born July 16, 1985, your Utah driver’s license number is 887743 expiring in 7/16/2018, and your Social Security number is 555-55-5555. You are considered a nonexempt employee, have one withholding allowance, and paid a rate of $36,000 per year.

 

For additional instructions on how to navigate and work through through Part 1 of this project, please download the student project guide here.

rev: 01_11_2017_QC_CS-74391

Required:

 

2. Complete the payroll process for Wayland Custom Woodworking’s last two pay periods of the fourth quarter.  Please note that you must carry the ending balance from each account in the December 15 General Ledger to the following period’s General Ledger to the input boxes titled “Ending account balance from the prior period” before posting the payroll journal entries from the current period to the Ledger.

 

For additional instructions on how to carry information from one pay period General Ledger to another, along with a guided walkthrough example of this process, refer to the project user guide in the project information section above.

 

 

December 15

December 15 is the end of the first pay period for the month of December. Employee pay will be disbursed on December 19, 2016. Remember that the employees are paid on a semimonthly basis.

 

Compute the net pay and update the Employees’ Earning Record with the December 15 pay and the new YTD information. Any hours worked in excess of 80 hours during this pay period are considered overtime for nonexempt employees.

 

· Complete the Employee Gross Pay tab.

· Complete the Payroll Register for December 15 Pay. Employee pay will be disbursed on December 19, 2016.

· Refer to the Employee Earning Record Forms for each employee for the current YTD amounts after you have completed the December 15 Payroll Register and update each EERF with the amounts from the current period.  YTD amounts from the previous four pay periods of the fourth quarter are shown for each employee.

· Complete the General Journal entries for the December 15 payroll.

· Post the journal entries to the General Ledger. Amounts for the ledger accounts from the previous four pay periods of the fourth quarter are shown.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

December 31

The final pay period of the year will not be paid to employees until January 3, 2017. The company will accrue the wages for the final pay period only. Since the pay period is complete, there will not be a reversing entry for the accrual.  As a result, paychecks will not be issued for this pay period since they will be paid in the following year and reflected on the Employee Earning Record forms for each employee when paid.

 

The company pays for the day before and the day of Christmas, and if the holiday is on a weekend, the company pays for the Friday before. Christmas fell on a Sunday, so employees will be paid for both the Friday and Monday as holiday pay.  Employees worked extra hours on Saturday during the week of 12/23-12/29.  Reminder, holidays and vacations are not included as hours worked for calculation of overtime.

 

· Complete the Employee Gross Pay tab.

· Complete the Payroll Register for December 31.

· Complete the General Journal entries for the December 31 payroll.

· Update the General Ledger with the ending ledger balances from the December 15 pay period ledger accounts first, and then post the journal entries from the current period to the General Ledger.

 

 

 

 

 

Question 3)

 

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method. The SUTA (UI) rate for Wayland Custom Woodworking is 2.6% on the first $32,200. The state withholding rate is 5.0% for all income levels and marital statuses.

 

For Part 2 of this project, you will use the fourth quarter payroll information that you calculated in Part 1 to complete the following tax forms for Wayland Custom Woodworking:

· U.S. Form 941

· U.S. Form 940

· Utah Form TC-941

· Utah Form 33H

· Form W-2s for all 6 employees

· Form W-3 for WCW

 

Specific instructions on how to complete each form can be found within the individual forms themselves. The employee information for Wayland has been presented again below, for convenience.

 

Employee Number Name and Address Payroll information
00-Chins Anthony Chinson Married, 1 Withholding allowance
  530 Sylvann Avenue Exempt
  Logan, UT 84321 $24,000/year + commission
  435-555-1212 Start Date: 10/1/2016
  Job title: Account Executive SSN: 511-22-3333
     
00-Wayla Mark Wayland Married, 5 withholding allowances
  1570 Lovett Street Exempt
  Logan, UT 84321 $75,000/year
  435-555-1110 Start Date: 10/1/2016
  Job title: President/Owner SSN: 505-33-1775
     
01-Peppi Sylvia Peppinico Married, 7 withholding allowances
  291 Antioch Road Exempt
  Logan, UT 84321 $43,500/year
  435-555-2244 Start Date: 10/1/2016
  Job title: Craftsman SSN: 047-55-9951
     
01-Varde Stevon Varden Married, 2 withholding allowances
  333 Justin Drive Nonexempt
  Logan, UT 84321 $42,000/year
  435-555-9981 Start Date: 10/1/2016
  Job title: Craftsman SSN: 022-66-1131
     
02-Hisso Leonard Hissop Single, 4 withholding allowances
  531 5th Street Nonexempt
  Logan, UT 84321 $49,500/year
  435-555-5858 Start Date: 10/1/2016
  Job title: Purchasing/Shipping SSN: 311-22-6698
     
00-Succe Student F Success Single, 1 withholding allowance
  1650 South Street Nonexempt
  Logan, UT 84321 $36,000/year
  435-556-1211 Start Date: 10/1/2016
  Job title: Accounting Clerk SSN: 555-55-5555
     

 

If you have submitted Part 1 already, it is recommended that you access your submission while attempting Part 2, as you will need the information from Part 1 in order to complete all applicable tax forms.

 

For additional instructions on how to navigate and work through through Part 2 of this project, please download the student project guide here.

rev: 01_11_2017_QC_CS-74391

Required:

 

1. Complete Form 941 for the remittance of quarterly federal taxes.

 

 

 

 

 

 

 

Question 4)

 

Required information

[The following information applies to the questions displayed below.]

 

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method. The SUTA (UI) rate for Wayland Custom Woodworking is 2.6% on the first $32,200. The state withholding rate is 5.0% for all income levels and marital statuses.

 

For Part 2 of this project, you will use the fourth quarter payroll information that you calculated in Part 1 to complete the following tax forms for Wayland Custom Woodworking:

· U.S. Form 941

· U.S. Form 940

· Utah Form TC-941

· Utah Form 33H

· Form W-2s for all 6 employees

· Form W-3 for WCW

 

Specific instructions on how to complete each form can be found within the individual forms themselves. The employee information for Wayland has been presented again below, for convenience.

 

Employee Number Name and Address Payroll information
00-Chins Anthony Chinson Married, 1 Withholding allowance
  530 Sylvann Avenue Exempt
  Logan, UT 84321 $24,000/year + commission
  435-555-1212 Start Date: 10/1/2016
  Job title: Account Executive SSN: 511-22-3333
     
00-Wayla Mark Wayland Married, 5 withholding allowances
  1570 Lovett Street Exempt
  Logan, UT 84321 $75,000/year
  435-555-1110 Start Date: 10/1/2016
  Job title: President/Owner SSN: 505-33-1775
     
01-Peppi Sylvia Peppinico Married, 7 withholding allowances
  291 Antioch Road Exempt
  Logan, UT 84321 $43,500/year
  435-555-2244 Start Date: 10/1/2016
  Job title: Craftsman SSN: 047-55-9951
     
01-Varde Stevon Varden Married, 2 withholding allowances
  333 Justin Drive Nonexempt
  Logan, UT 84321 $42,000/year
  435-555-9981 Start Date: 10/1/2016
  Job title: Craftsman SSN: 022-66-1131
     
02-Hisso Leonard Hissop Single, 4 withholding allowances
  531 5th Street Nonexempt
  Logan, UT 84321 $49,500/year
  435-555-5858 Start Date: 10/1/2016
  Job title: Purchasing/Shipping SSN: 311-22-6698
     
00-Succe Student F Success Single, 1 withholding allowance
  1650 South Street Nonexempt
  Logan, UT 84321 $36,000/year
  435-556-1211 Start Date: 10/1/2016
  Job title: Accounting Clerk SSN: 555-55-5555
     

 

If you have submitted Part 1 already, it is recommended that you access your submission while attempting Part 2, as you will need the information from Part 1 in order to complete all applicable tax forms.

 

For additional instructions on how to navigate and work through through Part 2 of this project, please download the student project guide here.

rev: 01_11_2017_QC_CS-74391

Project guideP

Required:

 

2. Complete Form 940 for Wayland Custom Woodworking.

 

 

 

 

 

Question 5)

 

Required information

[The following information applies to the questions displayed below.]

 

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method. The SUTA (UI) rate for Wayland Custom Woodworking is 2.6% on the first $32,200. The state withholding rate is 5.0% for all income levels and marital statuses.

 

For Part 2 of this project, you will use the fourth quarter payroll information that you calculated in Part 1 to complete the following tax forms for Wayland Custom Woodworking:

· U.S. Form 941

· U.S. Form 940

· Utah Form TC-941

· Utah Form 33H

· Form W-2s for all 6 employees

· Form W-3 for WCW

 

Specific instructions on how to complete each form can be found within the individual forms themselves. The employee information for Wayland has been presented again below, for convenience.

 

Employee Number Name and Address Payroll information
00-Chins Anthony Chinson Married, 1 Withholding allowance
  530 Sylvann Avenue Exempt
  Logan, UT 84321 $24,000/year + commission
  435-555-1212 Start Date: 10/1/2016
  Job title: Account Executive SSN: 511-22-3333
     
00-Wayla Mark Wayland Married, 5 withholding allowances
  1570 Lovett Street Exempt
  Logan, UT 84321 $75,000/year
  435-555-1110 Start Date: 10/1/2016
  Job title: President/Owner SSN: 505-33-1775
     
01-Peppi Sylvia Peppinico Married, 7 withholding allowances
  291 Antioch Road Exempt
  Logan, UT 84321 $43,500/year
  435-555-2244 Start Date: 10/1/2016
  Job title: Craftsman SSN: 047-55-9951
     
01-Varde Stevon Varden Married, 2 withholding allowances
  333 Justin Drive Nonexempt
  Logan, UT 84321 $42,000/year
  435-555-9981 Start Date: 10/1/2016
  Job title: Craftsman SSN: 022-66-1131
     
02-Hisso Leonard Hissop Single, 4 withholding allowances
  531 5th Street Nonexempt
  Logan, UT 84321 $49,500/year
  435-555-5858 Start Date: 10/1/2016
  Job title: Purchasing/Shipping SSN: 311-22-6698
     
00-Succe Student F Success Single, 1 withholding allowance
  1650 South Street Nonexempt
  Logan, UT 84321 $36,000/year
  435-556-1211 Start Date: 10/1/2016
  Job title: Accounting Clerk SSN: 555-55-5555
     

 

If you have submitted Part 1 already, it is recommended that you access your submission while attempting Part 2, as you will need the information from Part 1 in order to complete all applicable tax forms.

 

For additional instructions on how to navigate and work through through Part 2 of this project, please download the student project guide here.

rev: 01_11_2017_QC_CS-74391

Required:

 

3. Complete Utah Forms TC-941 and 33H for the remittance of quarterly state taxes.

 

 

 

 

 

 

 

 

Question 6)

 

Required information

[The following information applies to the questions displayed below.]

 

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method. The SUTA (UI) rate for Wayland Custom Woodworking is 2.6% on the first $32,200. The state withholding rate is 5.0% for all income levels and marital statuses.

 

For Part 2 of this project, you will use the fourth quarter payroll information that you calculated in Part 1 to complete the following tax forms for Wayland Custom Woodworking:

· U.S. Form 941

· U.S. Form 940

· Utah Form TC-941

· Utah Form 33H

· Form W-2s for all 6 employees

· Form W-3 for WCW

 

Specific instructions on how to complete each form can be found within the individual forms themselves. The employee information for Wayland has been presented again below, for convenience.

 

Employee Number Name and Address Payroll information
00-Chins Anthony Chinson Married, 1 Withholding allowance
  530 Sylvann Avenue Exempt
  Logan, UT 84321 $24,000/year + commission
  435-555-1212 Start Date: 10/1/2016
  Job title: Account Executive SSN: 511-22-3333
     
00-Wayla Mark Wayland Married, 5 withholding allowances
  1570 Lovett Street Exempt
  Logan, UT 84321 $75,000/year
  435-555-1110 Start Date: 10/1/2016
  Job title: President/Owner SSN: 505-33-1775
     
01-Peppi Sylvia Peppinico Married, 7 withholding allowances
  291 Antioch Road Exempt
  Logan, UT 84321 $43,500/year
  435-555-2244 Start Date: 10/1/2016
  Job title: Craftsman SSN: 047-55-9951
     
01-Varde Stevon Varden Married, 2 withholding allowances
  333 Justin Drive Nonexempt
  Logan, UT 84321 $42,000/year
  435-555-9981 Start Date: 10/1/2016
  Job title: Craftsman SSN: 022-66-1131
     
02-Hisso Leonard Hissop Single, 4 withholding allowances
  531 5th Street Nonexempt
  Logan, UT 84321 $49,500/year
  435-555-5858 Start Date: 10/1/2016
  Job title: Purchasing/Shipping SSN: 311-22-6698
     
00-Succe Student F Success Single, 1 withholding allowance
  1650 South Street Nonexempt
  Logan, UT 84321 $36,000/year
  435-556-1211 Start Date: 10/1/2016
  Job title: Accounting Clerk SSN: 555-55-5555
     

 

If you have submitted Part 1 already, it is recommended that you access your submission while attempting Part 2, as you will need the information from Part 1 in order to complete all applicable tax forms.

 

For additional instructions on how to navigate and work through through Part 2 of this project, please download the student project guide here.

rev: 01_11_2017_QC_CS-74391

Required:

 

4. Complete the employee W-2s and Wayland Custom Woodworking W-3 for 2016.

 

 

 

 

 

 

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"