For Week 3, please complete the following for Joe's Fly-By-Night Oil Company, whose latest income statement...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For Week 3, please complete the following for Joe's Fly-By-Night Oil Company, whose latest income statement and balance sheet are shown below. INCOME STATEMENT, 202 Sales $10,000 Cost of goods solc 4.000 Gross profi $6,000 S. G & A expenses EDIT Interest Before-tax Take Net income EPS earnings 3.000 $3,000 $200 $2,800 1.000 $1,800 $1.80 Dividends $600 Addition to retained earnings $1,200 Joe's Fly-by-Night a BALANCE SHEET, as of Dec 31, 2021 ASSETS Cast Accounts receivable Year Sales 2018 $8,200 2019 $8,000 2020 $9,000 2021 $10,000 Inventory Current assets Equipment (gra Less Accum Depreciation Equipment (net Total assets LIABILITIES AND EQUITY Accounts payable Current liabilities Long-term deb Total liabilities Common stock (1,000 shares) Retained earnings Total equity Total liabilities & Equy Net Income $1,500 $1,400 $5.000 3.000 17,000 $25,000 27,000 (12.000) $1,600 $1,800 $15,000 $40,000 $17.000 $17,000 $3,000 Prepare a graph of sales and net income for the years 2018-2021. For the purposes of this exercise, assume the following historical sales and net income figures for Joe's Fly-By- Night Oil: $20,000 $7.000 $13,000 $20,000 $40.000 Comment on the results displayed on the graph. • Prepare a pie chart of Joe's Fly-By-Night Oil's expense distribution for 2021 and comment on the results displayed. • Prepare a pie chart of Joe's Fly-By-Night Oil's asset distribution for Dec 31, 2021 and comment on the results displayed. • Prepare a pie chart of Joe's Fly-By-Night Oil's capital structure for Dec 31, 2021 and comment on the results displayed. Note: Be sure to comment on each of the four graphs. The numbers mean little without your explanatory comments. Case Study Tasks: 1. Revise your Company Overview file based on your instructor's feedback when received. 2. If you haven't done so already, enter the data from your company's last two years' income statements, balance sheets, and statements of cash flows onto an Excel spreadsheet and begin working on the Financial Overview section of your report. For Week 3, please complete the following for Joe's Fly-By-Night Oil Company, whose latest income statement and balance sheet are shown below. INCOME STATEMENT, 202 Sales $10,000 Cost of goods solc 4.000 Gross profi $6,000 S. G & A expenses EDIT Interest Before-tax Take Net income EPS earnings 3.000 $3,000 $200 $2,800 1.000 $1,800 $1.80 Dividends $600 Addition to retained earnings $1,200 Joe's Fly-by-Night a BALANCE SHEET, as of Dec 31, 2021 ASSETS Cast Accounts receivable Year Sales 2018 $8,200 2019 $8,000 2020 $9,000 2021 $10,000 Inventory Current assets Equipment (gra Less Accum Depreciation Equipment (net Total assets LIABILITIES AND EQUITY Accounts payable Current liabilities Long-term deb Total liabilities Common stock (1,000 shares) Retained earnings Total equity Total liabilities & Equy Net Income $1,500 $1,400 $5.000 3.000 17,000 $25,000 27,000 (12.000) $1,600 $1,800 $15,000 $40,000 $17.000 $17,000 $3,000 Prepare a graph of sales and net income for the years 2018-2021. For the purposes of this exercise, assume the following historical sales and net income figures for Joe's Fly-By- Night Oil: $20,000 $7.000 $13,000 $20,000 $40.000 Comment on the results displayed on the graph. • Prepare a pie chart of Joe's Fly-By-Night Oil's expense distribution for 2021 and comment on the results displayed. • Prepare a pie chart of Joe's Fly-By-Night Oil's asset distribution for Dec 31, 2021 and comment on the results displayed. • Prepare a pie chart of Joe's Fly-By-Night Oil's capital structure for Dec 31, 2021 and comment on the results displayed. Note: Be sure to comment on each of the four graphs. The numbers mean little without your explanatory comments. Case Study Tasks: 1. Revise your Company Overview file based on your instructor's feedback when received. 2. If you haven't done so already, enter the data from your company's last two years' income statements, balance sheets, and statements of cash flows onto an Excel spreadsheet and begin working on the Financial Overview section of your report.
Expert Answer:
Answer rating: 100% (QA)
1 A graph of Sales and Net Income for the year 20182021 2 A Pie Chart of Joes ... View the full answer
Related Book For
Financial Accounting
ISBN: 9780078110825
2nd Edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
The 2017 comparative income statement and balance sheet of Flowell Design Ltd. follow: Flowell Design Ltd. had no non-cash financing and investing transactions during 2017. During the year, there...
-
The following is Folex Company's income statement and balance sheet (in millions): The following additional information is available: i) Operating expenses include $35 million of depreciation. ii)...
-
The Rainmaker Entertainment Inc. income statement and balance sheet on MyAccountingLab provide details about the company's long-term debt and equity. Use the data to answer the following questions:...
-
Assume the initial margin on a Eurodollar futures contract is $878 and the maintenance margin is $650 (the contract size is $1mln). If the contract price declines by 25 basis points, by how much do...
-
Unqualified Audit Report. Following is the unqualified audit report for the City of Sand Key. The Honorable Mayor Members of the City Commission and City Manager City of Sand Key We have audited the...
-
In Exercises 29 and 30, consider a set of webpages hyperlinked by the given directed graph. Find the Google matrix for each graph and compute the PageRank of each page in the set. 2 3 4 5 6
-
Using the following data for Evans \& Sons, calculate the cash paid for merchandise purchased: Cost of goods sold. Inventory, January 1. Inventory, December 31 $128,000 19,000 22,000 Accounts...
-
At a time when demand for ready-to-eat cereal was stagnant, a spokesperson for the cereal maker Kelloggs was quoted as saying, . . . for the past several years, our individual company growth has...
-
Reyes and Miller have a 2:1 ratio allocation for the partnership, which is now being liquidated. The partnership has a building on the books valued at $600,000 that is sold for $750,000. What is the...
-
Problem 1 Company A purchases 10,000 shares of Company B common stock for $100,000 cash. This investment represents 30% of Company B's common stock. Complete the journal entry to record the purchase...
-
When a researcher analyzes the content of advertisements appearing in cartoons on a Saturday morning in terms of the types of characters that appear in the ads, this is an example of what type of...
-
Interpret the illustration about the concept of target costing. Discuss the following two (2) points and justify your answers: 1. Tactic to follow if the market price rises. Would the profit margin...
-
Sip Organics is a cold-pressed juice manufacturer that creates special wellness juices. As the budget accountant in the new processing department, you are given the task of identifying direct and...
-
Carlisle Tire & rubber, inc., is considering expanding Production to meet potential Increases in the demand for one of its fire products. Carlistes alternatives are to construct a new plant, expand...
-
There are countless cases of discriminatory practices within organizations that privilege employees on the basis of race or gender. Research such a case and present some of the pertinent details,...
-
a. Implement an instance method in IntLinkedBag, called split, that returns two linked lists as output (i.e., return data type is IntNode []) where the first linked list include all the odd numbers...
-
Explain why leaders must align the strategic communication efforts to the organizational culture of the stakeholders with the current and future needs of the population and describe methods for...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
Refer to the information provided for Peach Computer in E11-11. E11-11 Portions of the financial statements for Peach Computer are provided below. Required: Prepare the operating activities section...
-
On January 1, 2012, Frontier World issues $40 million of 8% bonds, due in 15 years, with interest payable semiannually on June 30 and December 31 each year. The proceeds will be used to build a new...
-
The year-end financial statements of Blue Devil Tax Services are provided below. Required: 1. Record year-end closing entries. 2. Prepare a post-closing trial balance? BLUE DEVIL TAX SERVICES...
-
Whenever an activity has physical impacts on individuals not directly involved in the activity, if the impact on the outside party is negative, it is called a(n) _________; if the impact is positive,...
-
If a firm can avoid paying the external costs it imposes on others, it _________ its own costs of production but not the _________ cost to society.
-
The benefits of a product or service that spill over to an outside party not involved in producing or consuming the good are called _________.
Study smarter with the SolutionInn App