Financial Statements - Sau Young Lee

Financial Statements - Sau Young Lee - 02/13/2012 Sau Young...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
02/13/2012 Sau Young (Sal y) Lee FBE 527: Entrepreneurial Finance Financial Statements Assignment Revenue Model The Food Bar Restaurant Concept Basic Premise # of tables 52 Year on Year Growth # of people per table 3 Year 2 10.0% % of seats 70% Year 3 7.0% $ spend per person $10 Year 4 5.0% # of turns per table per day 4 Year 5 3.0% # of customers per day 437 rev. per night $4,368.00 % of food rev 80% % of bev rev 20% food rev $3,494 bev rev $874 # days open per year 310 revenue per year (not adjusted for growt $1,354,080 Income Statement The Food Bar For the Period 2011 to 2015 Year 1 Year 2 Year 3 Year 4 Year 5 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 # customers served per period 33852 35545 37322 39188 # days operating per period 78 78 78 78 $ spend per person $10.00 $10.00 $10.00 $10.00 Total Revenue $338,520 $355,446 $373,218 $391,879 $401,676 $411,718 $422,011 $432,561 $440,131 $447,833 $455,671 $463,645 $469,440 $475,308 $481,250 $487,265 $490,920 $494,602 $498,311 $502,049 Assumptions Year 1 Year 2 Year 3 Year 4 Year 5 Costs as Percent of Total Sales Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Cost of Food and Beverages 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% 32.2% Wages and Benefits 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% 29.0% Restaurant Occupancy Costs 11.0% 10.5% 10.0% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% 9.5% General and Administrative Expenses 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Depreciation and Amortization 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% Other Costs 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% 13.0% Year 1 Year 2 Year 3 Year 4 Year 5 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Revenues $338,520 $355,446 $373,218 $391,879 $401,676 $411,718 $422,011 $432,561 $440,131 $447,833 $455,671 $463,645 $469,440 $475,308 $481,250 $487,265 $490,920 $494,602 $498,311 $502,049 Food and beverage costs $109,003 $114,454 $120,176 $126,185 $129,340 $132,573 $135,888 $139,285 $141,722 $144,202 $146,726 $149,294 $151,160 $153,049 $154,962 $156,899 $158,076 $159,262 $160,456 $161,660 Labor Costs $98,171 $103,079 $108,233 $113,645 $116,486 $119,398 $122,383 $125,443 $127,638 $129,872 $132,144 $134,457 $136,138 $137,839 $139,562 $141,307 $142,367 $143,434 $144,510 $145,594 Occupancy Costs $37,237 $35,545 $33,852 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 $32,159 General and Administrative Expenses $27,082 $28,436 $29,857 $31,350 $32,134 $32,937 $33,761 $34,605 $35,210 $35,827 $36,454 $37,092 $37,555 $38,025
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Financial Statements - Sau Young Lee - 02/13/2012 Sau Young...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online