BUSN 5200
Homework Assignment for Week 3:
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:
• Prepare a graph of sales and net income for the years 2013 – 2016. For the purposes of this exercise, assume the following historical sales and net income figures for Joe’s Fly-By-Night Oil:
Year Sales Net Income
2013 $8,200 $1,500
2014 $8,000 $1,400
2015 $9,000 $1,600
2016 $10,000 $1,800
Comment on the results displayed on the graph.
• Prepare a pie chart of Joe’s Fly-By-Night Oil’s expense distribution for 2016 and comment on the results displayed.
• Prepare a pie chart of Joe’s Fly-By-Night Oil’s asset distribution for Dec 31, 2016 and comment on the results displayed.
• Prepare a pie chart of Joe’s Fly-By-Night Oil’s capital structure for Dec 31, 2016 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.