Show how to solve for EBITDA, EBIT, and COGS given "Annual I/S" and "Annual B/S" excel sheet (see footnotes)
E F G I 1 A 1 2 Exhibit 3 Be Our Guest Inc. Income Statements 3 4 5 Years Ended December 31 6 1994 1995 1996 1997 7 8 9 Revenue: 10 Rental Income $1,620,313 $1,794,807 $ 1,990,853 $ 2,469,474 11 Delivery Income 156,035 179,173 168,959 180,567 12 Total Revenue 1,776,348 1,973,980 2,159,812 2,650,041 13 14 Cost of Revenue: 15 Salaries 490,968 575,253 547,611 610,602 16 Other Cost of Revenue 211,468 302,877 347,094 419,050 17 Depreciation 116,119 127,906 128,299 148,707 18 818,555 1,006,036 1,023,004 1,178,359 19 20 Gross Profit 957,793 967,944 1,136,808 1,471,682 21 22 Operating Expenses: 23 General and Administrative Salaries 381,501 434,434 539,168 840,718 24 Other General and Admin. Expenses (a) 402,423 384,863 420,683 500,384 25 Bad Debt Expense 5,702 977 22,186 5,188 26 789,626 820,274 982,037 1,346,290 27 28 Earnings from Operations 168, 167 147,670 154,771 125,392 29 30 Interest, Net (27,820) (33,912) (44,545) (37,580) 31 32 Net Earnings 140,347 113,758 110,226 87,812 33 34 Distributions To Shareholders (60,000) (46,700) (95,000) (27,660) 35 36 Earnings Retained $ 80,347 $ 67,058 $ 15,226 $ 60,152 37 38 39 (a) Other General and Administrative Expenses include depreciation of $3,692; $8,322, $14,025; 40 and $22,612 for the years 1994 through 1997 respectively. 41 E F G H A 1 Exhibit 4 Be Our Guest, Inc. Balance Sheets WN December 31, 4 1994 1995 1996 1997 5 6 ASSETS 8 Current Assets: 9 Cash (Overdraft) $ (2,595) S 565 $ 645 $ (3,498) 10 Accounts Receivable (a) 228,333 303,430 303,476 346,109 11 Due from Officers & Employees 5,000 13,617 22,552 16,763 12 Loan Receivable from Shareholder (b) 7,500 7,500 7,500 7,500 13 Other Current Assets 682 13,332 700 2,678 14 Total Current Assets 238,920 338,444 334,873 369,552 16 Property and Equipment: 17 Rental Equipment 768,481 928,391 1,077,484 1,251,080 18 Leasehold Improvements & Other Equipment 102,272 133,850 208,827 278,508 19 870,753 1,062,241 1,286,311 1,529,588 20 Less Accumulated Depreciation 414,988 551,214 679,734 851,053 21 Net Property and Equipment 455,765 511,027 606,577 678,535 22 23 Other Assets: 24 Loan Receivable from Shareholder (b) 30,000 20,000 10,000 10,000 25 Due from Affiliate (c) 110,000 110,000 158,000 65,950 26 140,000 130,000 168,000 75,950 27 28 Total Assets $ 834,685 S 979,471 $ 1,109,450 $ 1,124,037 29 30 LIABILITIES AND STOCKHOLDERS' EQUITY 32 Current Liabilities: 33 Borrowings under Bank Line of Credit $ 75,000 $ $ 98,270 $ 140,000 34 Current Installments of Term Note (d) 32,539 53,388 70,651 75,268 36 Due to Officer 17,000 32,816 32,816 37 Accounts Payable and Accounts 63,465 69,233 88,296 103,155 38 Total Current Liabilities 188,004 155,437 290,033 318,423 40 Term Notes Payable, Less Current Install. (d) 226,814 337,109 317,266 243,311 41 42 Total Liabilities 414,818 492,546 607,299 561,734 43 44 Shareholders' Equity: 45 Common Stock, $1 Par Value 2,000 2,000 2,000 2,000 46 Additional Paid-In Capital 74,000 74,000 74,000 74,000 47 Retained Earnings 343,867 410,925 426,151 486,303 48 Total Shareho Equity 419,867 486,925 502, 151 562,303 49 50 Total Liabilities and Shareholders' Equity S 834,685 S 979,471 S 1,109,450 $ 1,124,037 51 52 53 (a) Accounts Receivable are shown net of allowance for doubtful accounts of $5,000. 54 (b) A loan was made to a shareholder to purchase shares. $17,500 was outstanding as of 12/31/97. 55 (c) At Dec. 31, 1996, the outstanding balance of the bank term loan was $383,484 of which $69,893 was 56 due in one year. 57
