Need help with your Discussion

Get a timely done, PLAGIARISM-FREE paper
from our highly-qualified writers!

glass
pen
clip
papers
heaphones

solve my small case study and prepare spread sheet in excel

solve my small case study and prepare spread sheet in excel

solve my small case study and prepare spread sheet in excel

Description

Unformatted Attachment Preview

Case 2-1 Zodiak, Inc.
Executive Summary
NOTE THIS IS JUST ONE EXAMPLE OF HOW AN EXECUTIVE
SUMMARY MIGHT BE STRUCTURED. YOU ARE FREE TO USE ANY
FORMAT YOU DEEM APPROPRIATE TO THE CASE.
BUAD 658
Team Members:
Elton John
Olivia Newton John
Farmer John
ZODIAK, INC.
Office of the Controller
Date:
March 15, 2020
To:
Chairperson of the Board of Directors
From:
Meg Walters, Corporate Controller
Subject:
Fiscal 2020 Accounting Issues
At your request, I have prepared this executive summary outlining a number of
accounting issues for fiscal 2020 which have come to my attention. Of particular concern are the
following two situations:
1. At the end of 2020, Zodiak booked sales revenues of $2 million when we shipped product
to some of our regular customers even though these customers had not ordered the goods.
Our sales people told the customers they could return the product in 2021 for a full refund
if they didn want the product, but we have made no provision for any return of sales in
our accounting records.
I believe most, if not all, of our customers will return the
unwanted goods in 2021, and although we may be able to eventually sell this product, our
financial statements for 2020 will be incorrectly presented as noted in the attached
restatements. Specifically, the sales revenues and cost of goods sold line items in our
2020 Income Statement are overstated by $2 million and $853,000, respectively.
Likewise, accounts receivable and inventory on our 2020 Balance Sheet are overstated by
$2 million and understated by $853,000, respectively. When I asked Mr. Skilling about
this, he stated that our accounting complied with generally accepted accounting principles
(GAAP); however, the practice outlined above violates one of the basic standards
governing accrual basis accounting, the revenue realization (or recognition) principle.
This principle dictates when revenue is to be recognized and reported. In general, we
should only recognize revenue and report it on our income statement when we exchange
our goods and services for cash or claims to cash (i.e. accounts receivable). Since the
customers described in the situation above did not order the product, clearly no legitimate
exchange took place. When I confronted Mr. Skilling with this fact, his response was
(e sales would %lp4he 2020 numbers.². We added the $1 million cost of corporate reorganization to the balance of our property,
plant, and equipment account(describe the second irregularity similar to #1).
In summary, I believe(comment on the overall impact of the accounting irregularities on
the firmà2020 financial performance and its financial position as of December 31, 2020).
Case 2 Spreadsheet Template — Zodiak, Inc.
Income Statements
For the Years Ended December 31 (in thousands)
As Recast
2020
Adjustments
Sales revenues
Cost of goods sold
Gross pro t
Selling, general, and administra ve expenses
Deprecia on expense
Research and development expense
Opera ng income
Interest expense
Net income
Balance Sheets
December 31 (in thousands)
Statements as Originally Presented
2020
2019
2018
US$ 35.735
15.241
20.494
9.270
645
660
9.919
1.200
US$ 8.719
As Recast
2020
Adjustments
US$ 31.906
13.608
18.298
8.427
640
756
8.475
1.200
US$ 7.275
As Presented
2020
2019
Assets
Cash
Accounts receivable
Inventory
Other current assets
Current assets
US$ 5.728
7.047
5.812
1.649
20.236
US$ 2.123
6.282
4.531
134
13.070
Property, plant, and equipment
Total Assets
33.067
US$ 53.303
34.737
US$ 47.807
US$ 4.253
889
5.142
US$ 3.402
846
4.248
20.000
25.142
20.000
24.248
20.000
8.161
28.161
US$ 53.303
20.000
3.559
23.559
US$ 47.807
Liabili es
Accounts payable
Accrued liabili es
Current liabili es
Notes payable
Total Liabilites
ti
ti
ti
ti
fi
ti
ti
ti
Shareholders’ Equity
Common stock
Retained earnings
Total shareholders’ equty
Total Liabili es and Shareholders’ Equity
US$ 30.100
12.840
17.260
8.025
625
700
7.910
1.200
US$ 6.710
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 1 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 2 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 3 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 4 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 5 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 6 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 7 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 8 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 9 of 10
Ebook Lite Viewer
https://www.bvtlab.com/ebook.php?sid=e4344835211223bd#print
19/03/23, 9:51 AM
Page 10 of 10

Purchase answer to see full
attachment
Explanation & Answer:

2 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter


1. Professional & Expert Writers: Essay Noon only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Essay Noon are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Essay Noon are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Essay Noon, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.

We Can Write It for You! Enjoy 20% OFF on This Order. Use Code SAVE20

Stuck with your Assignment?

Enjoy 20% OFF Today
Use code SAVE20