Tools to Apply to Financial Statements… (Clevenger& Baker)
Table I
Income Statements
Year 1 Year 2 Year 3 Year 4
Sales $100,000 $150,000 $210,000 $450,000
Cost of Good Sold 50,000 77,000 110,000 125,000
Gross Profit 50,000 73,000 100,000 325,000
Operating Expenses
Credit Card Expense 5,000 7,500 10,500 13,000
Depreciation 5,000 5,000 5,000 5,000
Other Expenses 25,000 38,500 54,500 72,000
EBIT 15,000 22,000 30,000 235,000
Interest 1,000 1,000 1,000 1,000
Earning Before Taxes 14,000 21,000 29,000 234,000
Taxes (40%) 5,600 8,400 11,600 93,600
Earnings After Taxes 8,400 12,600 17,400 140,400
Cash Flow. $13,400 $17,600 $22,400 $145,400
Value of the firm (20%) $67,000 $88,000 $112,000 $727,000
Table II
Balance Sheets
Ending Ending Ending Ending Ending
12/31/00 12/31/01 12/31/02 12/31/03 12/31/04
Cash $ 9,000 $ 41,400 $ 52,000 $ 79,400 $ 4,800
Net Accounts Rec 25,000 15,000 20,000 50,000 305,000
Inventory 35,000 25,000 15,000 10,000 5,000
Fixed Assets 50,000 45,000 40,000 35,000 30,000
Total $119,000 $126,400 $127,000 $174,400 $344,800
Accounts Payable$ 18,000 $ 17,000 $ 5,000 $ 35,000 $ 65,000
LT Debt 10,000 10,000 10,000 10,000 10,000
Common Stock 46,000 46,000 46,000 46,000 46,000
Retained Earnings 45,000 53,400 66,000 83,400 223,800
Total $119,000 $126,400 $127,000 $174,400 $344,800