Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exhibit 2 Westlake Lanes Annual Income Statements, 2004-2009 2004 2005 2006 2007 2008 2009 Income 637 888,50 Lane and Shoe Rentals 708,765.00 $548.584.11 521,154.90 $489,705.00
Exhibit 2 Westlake Lanes Annual Income Statements, 2004-2009 2004 2005 2006 2007 2008 2009 Income 637 888,50 Lane and Shoe Rentals 708,765.00 $548.584.11 521,154.90 $489,705.00 $417533.00 $87,681.93 $ 83,506.60 588,721 53 Food & Soda Sales $191,366.55 $159,472.13 $ 165851.01 153,603.55 $ 120.688.50 145,92337 137,889.00 $114.654.08 Beer Sales 134,624.00 126456.00 $1,034,755.55 754,050,00 Total $963.211.64 822876.17 781,732.36 Cost of Sales $ 48,261.15 $ 29,08488 55,815.24 $53,761.24 $27,758.36 26304.58 Food 66,978.29 $51,073.18 $ 26370.44 Alcohol 30,963.52 38,145.73 16.70132 98,301.78 Supplies Coupons and Discounts 91505.11 $78173.24 $78,173.24 $90,486.00 47,097.72 31,042.67 28,896.35 24,686.28 $23,451.97 22,621.50 17,661.65 $ 227,286.26 $ 214,362.43 $ 184379.12 $ 179,068.83 Total Cost of Sales 107,765.27 $190,453,53 Gross Profit 807,46929 748,849.20 638,497.05 602,663.53 563,59647 480,956.26 General Expens es $236,599.20 231,89088 205390,00 Employee Wages Advertising 231,960.00 234,233.21 219,390.00 31,973.95 32.293.69 29,354.96 31,042.67 $32616.62 15,865.00 $ 8,623.03 $ 234521 Legal and Audit 8,898.90 8,453.95 $10951.25 $24,648.96 15,900.00 Licenses and Permits 2,276.46 2,299.23 2368.66 2,39235 $2,416.27 Office Expenses Repairs and Maintenance 3,104.27 3,414.69 3,482.99 4702.03 6,112.64 3346.00 77,60667 86,432.00 100,888.67 $70,622.07 $115447.00 76,974.00 $ 36.672.00 Utilities 51,737.78 $52,255.16 53822.81 $54,899.27 $55,448.26 63,412.00 Insurance 50,000.00 54,000.00 58,320.00 62985.60 $ 107.800.00 68,024.45 $107,800.00 Rent 107,800.00 $107800.00 $107,800.00 107800.00 3,166.35 $ 2,422.26 Miscellaneous 3,104.27 2374.76 $3,148.94 $3510.00 Depreciation & Amortization 1,200.00 $1200.00 1,200.00 1,782.23 4359.40 6,076.01 Total Operating Expenses 546,819.29 $568,731.00 $602,051.19 575,117.76 627,865.80 597,653.96 238,738.29 63,37928 (65,863.02) Operating Income (Loss) 146,798.01 (25,202.27) (34,057.49) 2,800.00 $ 9,72536 7588.00 Interest 2,400.00 3,200.00 3200.00 $ 60,179.28 Income Before Taxes $236,338.29 $143,998.01 Tax 82,718.40 $50399.30 21.062.75 $ (43,782.85) $ (73,451.02) S 39,118.53 Net Income (Loss) $153,619.89 93,598.71 (28,402.27) $ 153,619.89 $93598.71 Dividend 39,118.53 opportunities (Kid Friendly Entertainment vs. Upscale Bowiling Lounge)r I-2 pages 5. Based on the financial statements available in the case study, create a future budget for the next five years (2010, 2011, 2012, 2013, 2014) of operation. a. Use the budget template posted on Moodle for your forecasts 4431 West lake Lanes: How Can This Business Be Saved? Exhibit 3 Westlake Lanes Balance Sheet, 2006-2009 December 31,2006-2009 2007 2008 2009 2006 ASSETS Current Assets Cash 45,488 $ 30.412 29,491 20600 9,057 Inventory 21,571 17.943 4,200 Fixed Assets $ 132,103 Property, Plant & Equipment 54,007 184,122 178,046 222,665 Total Assets 129,907 183,165 $186,824 LIABILITIES Accounts Payable 14,907 15,000 25,000 33,252 $ 40,000 Debt 121,567 94,850 124,208 Total Liabilities 54,907 $136,567 119,850 157,460 EQUITY $ 30,000 Common Stock 30,000 130,000 130,000 Retained Earnings $ 45,000 (27,185) 16,598 (100.636) Total Equity 46,598 75,000 102,815 29,364 Exhibit 2 Westlake Lanes Annual Income Statements, 2004-2009 2004 2005 2006 2007 2008 2009 Income 637 888,50 Lane and Shoe Rentals 708,765.00 $548.584.11 521,154.90 $489,705.00 $417533.00 $87,681.93 $ 83,506.60 588,721 53 Food & Soda Sales $191,366.55 $159,472.13 $ 165851.01 153,603.55 $ 120.688.50 145,92337 137,889.00 $114.654.08 Beer Sales 134,624.00 126456.00 $1,034,755.55 754,050,00 Total $963.211.64 822876.17 781,732.36 Cost of Sales $ 48,261.15 $ 29,08488 55,815.24 $53,761.24 $27,758.36 26304.58 Food 66,978.29 $51,073.18 $ 26370.44 Alcohol 30,963.52 38,145.73 16.70132 98,301.78 Supplies Coupons and Discounts 91505.11 $78173.24 $78,173.24 $90,486.00 47,097.72 31,042.67 28,896.35 24,686.28 $23,451.97 22,621.50 17,661.65 $ 227,286.26 $ 214,362.43 $ 184379.12 $ 179,068.83 Total Cost of Sales 107,765.27 $190,453,53 Gross Profit 807,46929 748,849.20 638,497.05 602,663.53 563,59647 480,956.26 General Expens es $236,599.20 231,89088 205390,00 Employee Wages Advertising 231,960.00 234,233.21 219,390.00 31,973.95 32.293.69 29,354.96 31,042.67 $32616.62 15,865.00 $ 8,623.03 $ 234521 Legal and Audit 8,898.90 8,453.95 $10951.25 $24,648.96 15,900.00 Licenses and Permits 2,276.46 2,299.23 2368.66 2,39235 $2,416.27 Office Expenses Repairs and Maintenance 3,104.27 3,414.69 3,482.99 4702.03 6,112.64 3346.00 77,60667 86,432.00 100,888.67 $70,622.07 $115447.00 76,974.00 $ 36.672.00 Utilities 51,737.78 $52,255.16 53822.81 $54,899.27 $55,448.26 63,412.00 Insurance 50,000.00 54,000.00 58,320.00 62985.60 $ 107.800.00 68,024.45 $107,800.00 Rent 107,800.00 $107800.00 $107,800.00 107800.00 3,166.35 $ 2,422.26 Miscellaneous 3,104.27 2374.76 $3,148.94 $3510.00 Depreciation & Amortization 1,200.00 $1200.00 1,200.00 1,782.23 4359.40 6,076.01 Total Operating Expenses 546,819.29 $568,731.00 $602,051.19 575,117.76 627,865.80 597,653.96 238,738.29 63,37928 (65,863.02) Operating Income (Loss) 146,798.01 (25,202.27) (34,057.49) 2,800.00 $ 9,72536 7588.00 Interest 2,400.00 3,200.00 3200.00 $ 60,179.28 Income Before Taxes $236,338.29 $143,998.01 Tax 82,718.40 $50399.30 21.062.75 $ (43,782.85) $ (73,451.02) S 39,118.53 Net Income (Loss) $153,619.89 93,598.71 (28,402.27) $ 153,619.89 $93598.71 Dividend 39,118.53 opportunities (Kid Friendly Entertainment vs. Upscale Bowiling Lounge)r I-2 pages 5. Based on the financial statements available in the case study, create a future budget for the next five years (2010, 2011, 2012, 2013, 2014) of operation. a. Use the budget template posted on Moodle for your forecasts 4431 West lake Lanes: How Can This Business Be Saved? Exhibit 3 Westlake Lanes Balance Sheet, 2006-2009 December 31,2006-2009 2007 2008 2009 2006 ASSETS Current Assets Cash 45,488 $ 30.412 29,491 20600 9,057 Inventory 21,571 17.943 4,200 Fixed Assets $ 132,103 Property, Plant & Equipment 54,007 184,122 178,046 222,665 Total Assets 129,907 183,165 $186,824 LIABILITIES Accounts Payable 14,907 15,000 25,000 33,252 $ 40,000 Debt 121,567 94,850 124,208 Total Liabilities 54,907 $136,567 119,850 157,460 EQUITY $ 30,000 Common Stock 30,000 130,000 130,000 Retained Earnings $ 45,000 (27,185) 16,598 (100.636) Total Equity 46,598 75,000 102,815 29,364
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started