The goal is to calculate the boxes that is highlighted
Balance Sheet | |||
Current Assets | |||
Cash | 5000 | ||
Marketable Securities | 45000 | ||
Accs Receivable | 30000 | ||
Promissory Notes | 15000 | ||
Inventory | 20000 | ||
TTL Current Assets | 115000 | ||
Non Current Assets | |||
Plant & Equipment | 6000000 | ||
Building & Land | 3500000 | ||
Depreciation @ 6.67% | -633650 | (assuming 6.67% on both assets) | |
TTL Non Current Assets | 8866350 | ||
Miscell Adjustments | 1013400 | ||
Total Assets | 9994750 | ||
Current Liab | |||
Accs Payable | 50000 | ||
Notes Payable | 15000 | ||
Interest PMT @ 2.50% | 56250 | (Assuming 2.5% on Bonds Payable) | |
Accruals (wages etc.) | 36000 | ||
TTL Current Liab | 157250 | ||
Non Current Liab | |||
Bonds Payable | 2250000 | ||
Mortgage | 3500000 | ||
TTL Non Current Liab | 5750000 | ||
Total Liabilities | 5907250 | ||
Equity | 4000000 | (Assuming current loss is adjusted) | |
Total Equity and Liabilities | 9907250 |
Income Statement | ||
Sales Revenue | 195,000 | |
Returns and Allowances | (3,500) | |
Investment Income | 45,000 | |
Net Revenue | 236,500 | |
Expenses | ||
Directly related to production | ||
Beg Inventory | 12,000 | |
New Purchase | 124,000 | |
Returns and Allowances | (2,200) | |
End Inventory | (17,800) | |
CGS | 116,000 | |
Unrelated to production | ||
Rent | 10,000 | |
Utility | 1,500 | |
Salaries | 25,000 | |
Depreciation | 633,650 | |
R&D Expense | 4,875 | |
Marketing | 2,925 | |
Operating Expenses | 677,950 | |
Operating Expenses | 793,950 | |
Operating Income (EBIT) | (557,450) | |
Interest | 56,250 | |
Taxable Income (EBT) | (613,700) | |
Taxes @ 35% | - | |
Net Income (EAT) | (613,700) |
The goal is to calculate the boxes that is highlighted Font Clipboard N1 Alio Alignment Balance...
File Home inset Page Layout Formulas Data Review View Tell me what you want to PROTECTED VIIW Be Careful files from the Internet can contain viruses. Unless you need to edit it's safe to stay in Prote Balance Sheet Income Statement 2 Current Assets Sales en $ 195,000.00 New Inne Income Net Revenue is process ed goods 20.000,00 TIL Current 10 Nom Current Acts Directly related Beyler New Purce Ren Alles Production $ 12,000.00 $ 10 12 Land $ 3.500,000.00...