Reading and Understanding Financial Statements
Reading and Understanding Financial Statements
The purpose of this paper is to apply and illustrate what you have learned this semester, by submitting a full financial synopsis based on a hypothetical fast food restaurant. Below is a mock financial report indicating actual sales and expenses versus budgeted sales and expenses for a one year period of time. Review the report and write a 5 to 7 page financial review of this business incorporating the following areas:
Part I: Analysis (Sections 1 – 3)
· Sub-divide your analysis into three distinct sections: 1) Revenue, 2) Expenses, and 3) Profitability
· For each section, review the financial statement below and comment on:
· Current status, apply vertical analysis to both Actual Results and Budgeted Results.
· Determine and comment on the variance as it applies to each section. Ask yourself things like:
· How did management perform against what was budgeted?
· What are the strengths and weaknesses of this operation per section based on your variance analysis?
· Create graphs or charts to illustrate and help clarify your synopsis
Part II: Recommendations & Budgeting (Sections 4 and 5)
· After your financial analysis in sections 1 – 3, add two more sections; 4) Recommendations and 5) Budgeting.
· Section 4: Based on your synopsis in sections 1 – 3, what recommendations would you make to upper management that would reduce expenses and increase revenues. For example:
· Talk about your thoughts on product mix. Where should they focus their marketing dollars next year in order to increase profit margin?
· How will your recommendation affect food cost?
· What other recommendations would you make based on this year’s performance?
· Consider doing some outside research of current fast food chains, compare how they perform versus this operation to support your recommendations
· Section 5: Prepare next year’s budget
· Create next year’s budget based on what it would look like if upper management accepted your recommendations
· Consider doing some outside research of current fast food chains, compare how they perform versus this operation to support your recommendations
|
For year ending December 31, 2010 |
|||||
|
Performance Report Store #: 100 |
Actual Results |
Budgeted Results |
Variance |
||
|
|
Percent of Sales |
Totals |
Percent of Sales |
Totals |
|
|
|
|
|
|
|
|
|
Revenue: |
|
|
|
|
|
|
Burgers |
|
1,000,000 |
|
1,100,000 |
|
|
Fries |
|
600,000 |
|
550,000 |
|
|
Drinks |
|
900,000 |
|
875,000 |
|
|
|
|
|
|
|
|
|
Total Sales |
|
2,500,000 |
|
2,525,000 |
|
|
|
|
|
|
|
|
|
Less: Variable Expenses |
|
|
|
|
|
|
Food Cost: |
|
|
|
|
|
|
Burgers |
|
232,750 |
|
242,500 |
|
|
Fries |
|
151,000 |
|
155,000 |
|
|
Drinks |
|
87,500 |
|
94,000 |
|
|
Other Variable Costs: |
|
175,000 |
|
200,000 |
|
|
|
|
|
|
|
|
|
Total Variable Expenses |
|
646,250 |
|
691,500 |
|
|
|
|
|
|
|
|
|
Contribution Margin |
|
1,853,750 |
|
1,833,500 |
|
|
Less: Fixed Costs |
|
1,100,000 |
|
1,100,000 |
|
|
|
|
|
|
|
|
|
Profit Margin |
|
753,750 |
|
733,500 |
|
Paper:
· Must have a title page that includes date and your name
· Use Arial or New Times Roman 12 font, single space
· Must have a Reference page at the end siting any outside resources for your analysis, have at minimum two sources