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...
-
As part of the analytical procedures of Mahogany Products, Inc., you perform calculations of the following ratios: For each of the preceding ratios: Required a. State whether there is a need to...
-
Light is an important abiotic factor that determines the distribution and abundance of plants. Some plants are adapted to grow in areas of low light intensity. They are known as shade plants. Some...
-
The finalists can be viewed at http://www .sciencemag.org/projects/data-stories/finalists. Pick a video that interests you, watch it, and answer the following questions: (a) Give a link to the chosen...
-
Multiple Choice Questions 1. Which one of the following managerial accounting approaches attempts to allocate manufacturing overhead in a more meaningful fashion? a. Activity-based costing b....
-
Back Country Airlines has the following accounts and balances as of their year-end, December 31st, 20X1 (assume all balances are "normal"). In good form (including proper headings subtotals, labels,...
-
Suppose that Coke and Pepsi are fighting for the cola market. Each week each person in the market buys one case of Coke or Pepsi. If the persons last purchase was Coke, there is a 0.90 probability...
-
a) b) c) d) A two-factor analysis of variance is (two way ANOVA with replication) conducted to test the effect that price and advertising have on sales of a particular brand of bottled water. Each...
-
What is diffusion?
-
How do endocytosis and exocytosis move materials into and out of cells?
-
Why are electron microscopes particularly useful to cell biologists?
-
How do cells regulate enzymes?
-
What are the end products of mitosis?
-
XYZ Company's bank statement shows a balance of $8,500, while its internal records indicate a balance of $9,200. During the bank reconciliation process, the following information is discovered:...
-
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...
-
Describe the role of a paralegal in a family law practice.
-
Define family law and identify the kinds of issues that are addressed in a family law practice.
-
Describe the characteristics of effective fee agreements, and identify the various types of fee agreements that may be used in divorce cases.
Study smarter with the SolutionInn App