I need help with my major Project
Jwertz
MBA655MajorProjectESI.xlsxESI Income Statement 202x
| 202x | |
| Equipment Sales Revenue | 1,333,440 |
| Consulting Service Revenue (Online Help) | 450,000 |
| Total Revenue | 1,783,440 |
| Cost of Goods Sold | 934,450 |
| Selling, General & Administrative | 33,820 |
| Depreciation & Amortization | 58,665 |
| Earning Before Interest and Tax (EBIT) | 756,505 |
| Interest | 35,576 |
| Earnings Before Tax (EBT) | 720,929 |
| Tax | 152,686 |
| Net Income | 568,243 |
| Shares Outstanding | 14,000 |
| Earnings Per Share | 40.59 |
| Equipment sales EBITDA | 667,720 |
| Consulting Online Help EBITDA | 147,450 |
| Total EBITDA | 815,170 |
ESI Balance Sheet 202x
| 202x | 202x | |||
| ASSETS | LIABILITIES | |||
| Cash | $37,000 | Accounts Payable | $40,000 | |
| Marketable Securities | 10,000 | Wages Payable | 10,800 | |
| Accounts Receivable | 63,000 | Taxes Payable | 7,200 | |
| Uncollectible Accounts | -2,000 | Short-Term Note Payable | 30,000 | |
| Inventory | 74,000 | Interest Payable | 2000 | |
| Supplies | 4,000 | Unearned Revenue | 20,000 | |
| Prepaid Insurance | 7,500 | Unearned Consulting Rev. | 5,000 | |
| Total Current Assets | $193,500 | Total Current Liabilities | $115,000 | |
| Land | $111,500 | Long-Term Notes Payable | $50,000 | |
| Equipment | 217,000 | Bonds Payable | 100,000 | |
| Accumulated Depreciation | -97,000 | Mortgage Payable | 350,000 | |
| Building | 590,000 | Total Long-Term Liabilities | $500,000 | |
| Accumulated Depreciation | -110,000 | |||
| Intangible Assets | 60,000 | STOCKHOLDER EQUITY | ||
| Total Long-Term Assets | $771,150 | Capital Stock | $100,000 | |
| Paid in Capital | 140,000 | |||
| Retained Earnings | 110,000 | |||
| Total Stockholders Equity | $350,000 | |||
| Total Assets | $965,000 | Total Liabilities & Equity | $965,000 | |
