The CFO Project
avessels1007
TheCFOProjectTemplate8.xlsxBALANCE SHEET
| Your Company Name Here | |||||||||
| Balance Sheet | |||||||||
| For Years Ending X0 - X5 | |||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | ||||
| Assets | |||||||||
| Cash | |||||||||
| Marketable Securities | |||||||||
| Accounts Receivable | |||||||||
| Inventory | |||||||||
| Other Assets | |||||||||
| Total Current Assets | |||||||||
| Property | |||||||||
| Plant | |||||||||
| Equipment | |||||||||
| Accumulated Depreciation | |||||||||
| Total Fixed Assets | |||||||||
| Total Assets | |||||||||
| Liabilities and Equity | |||||||||
| Accounts Payable | |||||||||
| Notes Payable | |||||||||
| Other Current Liabilities | |||||||||
| Total Current Liabilities | |||||||||
| Mortgages | |||||||||
| Total Non-Current Liabilities | |||||||||
| Total Liabilities | |||||||||
| Common Stock | |||||||||
| Paid in Capital | |||||||||
| Treasury Stock | |||||||||
| Retained Earnings | |||||||||
| Total Equity | |||||||||
| Total Liabilities and Equity | |||||||||
ACCT 522 KAREEM TANNOUS DR. BOYLAN
INCOME STATEMENT
| Your Company Name Here | |||||||||
| Income Statement | |||||||||
| For Years Ending X0 - X5 | |||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | ||||
| Sales | |||||||||
| Cost of Goods Sold | |||||||||
| Gross Profit | |||||||||
| Interest Revenue - Corp Bonds | |||||||||
| Net Income From Operations | |||||||||
| Depreciation Expense | |||||||||
| Salaries Expense | |||||||||
| Interest Expense | |||||||||
| Miscellaneous Expense | |||||||||
| Operating Expenses | |||||||||
| Net Income Before Tax | |||||||||
| Taxes | |||||||||
| Interest Revenue - Municipal Bonds | |||||||||
| Net Income | |||||||||
ACCT 522 KAREEM TANNOUS DR. BOYLAN
RETAINED EARNINGS
| Your Company Name Here | |||||||||
| Statement of Retained Earnings | |||||||||
| For Years Ending X0 - X5 | |||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | ||||
| Retained earnings, January 1 | |||||||||
| Add: Net Income | |||||||||
| Less: Dividends | |||||||||
| Retained Earnings, December 31 | |||||||||
ACCT 522 KAREEM TANNOUS DR. BOYLAN
CASH FLOW
| Your Company Name Here | |||||||||
| Cash Flow Statement | |||||||||
| For Years Ending X0 - X5 | |||||||||
| Cash Flow from Operations | 0 | 1 | 2 | 3 | 4 | 5 | |||
| Net Income | |||||||||
| Depreciation Expense | |||||||||
| Increase in Accounts Receivable | |||||||||
| Increase in Accounts Payable | |||||||||
| Increase in Inventories | |||||||||
| Marketable Securities | |||||||||
| Other Assests | |||||||||
| Other Liabilities | |||||||||
| Net Operating Cash | |||||||||
| Cash Flow from Investing | |||||||||
| Property Purchase | |||||||||
| Equipment Purchase | |||||||||
| Net Investing Cash | |||||||||
| Cash Flow from Financing | |||||||||
| Issuance of Mortgage | |||||||||
| Dividend Payments | |||||||||
| Net Financing Cash | |||||||||
| Net Increase in Cash |
ACCT 522 KAREEM TANNOUS DR. BOYLAN
REVENUE
| Your Company Name Here | ||||||
| Revenue | ||||||
| For Years Ending X0 - X5 | ||||||
| 0 | 1 | 2 | 3 | 4 | 5 | |
| Sales | ||||||
| Price | ||||||
| Quanity | ||||||
ACCT 522 KAREEM TANNOUS DR. BOYLAN
INVENTORY
| Your Company Name Here | ||||||
| FIFO Inventory | ||||||
| For Years Ending X0 - X5 | ||||||
| 0 | 1 | 2 | 3 | 4 | 5 | |
| Cost | ||||||
| Quanity | ||||||
| Total Merchandise | ||||||
| BB | Purchases | COGS | EB | |||
| 1 | - 0 | - | - | - | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 2 | - 0 | - | - | - | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 3 | - | - | - | - | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 4 | - | - 0 | - | - | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 5 | - | - 0 | - | - | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
ACCT 522 KAREEM TANNOUS DR. BOYLAN
DEPRECIATION
| Your Company Name Here | |||||||||
| Depreciation for Equipment and Plant | |||||||||
| For Years Ending X0 - X5 | |||||||||
| Equipment | |||||||||
| Cost of Equipment | $ - 0 | ||||||||
| Estimated Useful Life | - | ||||||||
| Estimated Salvage Value | - | ||||||||
| Depreciation per year | ERROR:#DIV/0! | ||||||||
| Plant | |||||||||
| Cost of Plant | $ - 0 | ||||||||
| Estimated Useful Life | - | ||||||||
| Estimated Salvage Value | - | ||||||||
| Depreciation per year | ERROR:#DIV/0! | ||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | ||||
| Yearly Equipment Depreciation | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Yearly Plant Depreciation | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Total Accumulated Depreciation | 200,000 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
ACCT 522 KAREEM TANNOUS DR. BOYLAN
TAXES
| Your Company Name Here | ||||
| Taxable Income Worksheet | ||||
| For Years Ending X0 - X5 | ||||
| Tax Calculation Yr 1 | ||||
| Taxable Income Over | Not Over | Rate | Taxable Inc | Total Tax |
| - 0 | 50,000 | 15% | - 0 | - 0 |
| 50,000 | 75,000 | 25% | - 0 | - 0 |
| 75,000 | 100,000 | 34% | - 0 | - 0 |
| 100,000 | 335,000 | 39% | - 0 | - 0 |
| 335,000 | 10,000,000 | 34% | - 0 | - 0 |
| 10,000,000 | 15,000,000 | 35% | - 0 | - 0 |
| 15,000,000 | 18,333,333 | 38% | - 0 | - 0 |
| 18,333,333 | + | 35% | - 0 | - 0 |
| Income | $ - 0 | Total Tax | $ - 0 | |
| Tax Calculation Yr 2 | ||||
| Taxable Income Over | Not Over | Rate | Taxable Inc | Total Tax |
| 100,000 | 150,000 | 15% | - 0 | - 0 |
| 100,000 | 125,000 | 25% | - 0 | - 0 |
| 125,000 | 150,000 | 34% | - 0 | - 0 |
| 570,000 | 805,000 | 39% | - 0 | - 0 |
| 19,665,000 | 29,330,000 | 34% | - 0 | - 0 |
| 20,000,000 | 25,000,000 | 35% | - 0 | - 0 |
| 21,666,666 | 24,999,999 | 38% | - 0 | - 0 |
| 18,333,333 | + | 35% | - 0 | - 0 |
| Income | $ - 0 | Total Tax | $ - 0 | |
| Tax Calculation Yr 3 | ||||
| Taxable Income Over | Not Over | Rate | Taxable Inc | Total Tax |
| 100,000 | 150,000 | 15% | - 0 | - 0 |
| 100,000 | 125,000 | 25% | - 0 | - 0 |
| 125,000 | 150,000 | 34% | - 0 | - 0 |
| 570,000 | 805,000 | 39% | - 0 | - 0 |
| 19,665,000 | 29,330,000 | 34% | - 0 | - 0 |
| 20,000,000 | 25,000,000 | 35% | - 0 | - 0 |
| 21,666,666 | 24,999,999 | 38% | - 0 | - 0 |
| 18,333,333 | + | 35% | - 0 | - 0 |
| Income | $ - 0 | Total Tax | $ - 0 | |
| Tax Calculation Yr 4 | ||||
| Taxable Income Over | Not Over | Rate | Taxable Inc | Total Tax |
| 200,000 | 250,000 | 15% | - 0 | - 0 |
| 150,000 | 175,000 | 25% | - 0 | - 0 |
| 175,000 | 200,000 | 34% | - 0 | - 0 |
| 1,040,000 | 1,275,000 | 39% | - 0 | - 0 |
| 38,995,000 | 48,660,000 | 34% | - 0 | - 0 |
| 30,000,000 | 35,000,000 | 35% | - 0 | - 0 |
| 28,333,332 | 31,666,665 | 38% | - 0 | - 0 |
| 18,333,333 | + | 35% | - 0 | - 0 |
| Income | $ - 0 | Total Tax | $ - 0 | |
| Tax Calculation Yr 5 | ||||
| Taxable Income Over | Not Over | Rate | Taxable Inc | Total Tax |
| 300,000 | 350,000 | 15% | - 0 | - 0 |
| 200,000 | 225,000 | 25% | - 0 | - 0 |
| 225,000 | 250,000 | 34% | - 0 | - 0 |
| 1,510,000 | 1,745,000 | 39% | - 0 | - 0 |
| 58,325,000 | 67,990,000 | 34% | - 0 | - 0 |
| 40,000,000 | 45,000,000 | 35% | - 0 | - 0 |
| 34,999,998 | 38,333,331 | 38% | - 0 | - 0 |
| 18,333,333 | + | 35% | - 0 | - 0 |
| Income | $ - 0 | Total Tax | $ - 0 |
ACCT 522 KAREEM TANNOUS DR. BOYLAN
MORTGAGE
| Your Company Name Here | ||||||
| Mortgage Amortization Schedule | ||||||
| Principal | $ - 0 | |||||
| i | 0.00% | ERROR:#DIV/0! | ||||
| PaySched | - 0 | |||||
| Years | 0 | - 0 | ||||
| Pmt | ERROR:#DIV/0! | |||||
| # | PAYMENT | INTEREST | PRIN RED | PRINCIPAL | INTEREST EXP | |
| 0 | $ - 0 | |||||
| 1 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 2 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 3 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 4 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 5 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 7 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 8 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 9 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 10 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 11 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 12 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 13 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 14 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 15 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 16 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 17 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 18 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 19 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 20 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 21 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 22 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 23 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 24 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 25 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 26 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 27 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 28 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 29 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 30 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 31 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 32 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 33 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 34 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 35 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 36 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 37 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 38 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 39 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 40 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 41 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 42 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 43 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 44 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 45 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 46 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 47 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 48 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 49 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 50 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 51 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 52 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 53 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 54 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 55 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 56 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 57 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 58 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 59 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 60 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 61 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 62 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 63 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 64 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 65 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 66 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 67 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 68 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 69 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 70 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 71 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 72 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 73 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 74 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 75 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 76 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 77 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 78 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 79 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 80 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 81 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 82 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 83 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 84 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 85 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 86 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 87 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 88 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 89 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 90 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 91 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 92 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 93 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 94 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 95 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 96 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 97 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 98 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 99 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| 100 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||
| ERROR:#DIV/0! |
ACCT 522 KAREEM TANNOUS DR. BOYLAN
INVESTMENTS
| Your Company Name Here | |||||||
| Marketable Securities Investments | |||||||
| For Years Ending X0 - X5 | |||||||
| 0 | 1 | 2 | 3 | 4 | 5 | ||
| Marketable Securities | |||||||
| Interest Revenue | |||||||
| IRR on Corporate Bonds | 5.4% | ||||||
| Marketable Securities | |||||||
| Interest Revenue | |||||||
| IRR on Municipal Securities | 4.6% |
ACCT 522 KAREEM TANNOUS DR. BOYLAN
STOCK PRICE
| Your Company Name Here | ||||||
| Stock Price | ||||||
| For Years Ending X0 - X5 | ||||||
| 0 | 1 | 2 | 3 | 4 | 5 | |
| Common Stock | $ 100,000 | |||||
| Paid in Capital | $ 3,400,000 | |||||
| Treasury Stock | $ - 0 | |||||
| Shares Outstanding | ||||||
| Par Value | $ 0.10 | |||||
| Stock Price | ERROR:#DIV/0! | |||||
| Net Income | $ - 0 | |||||
| Earnings per Share | ERROR:#DIV/0! | |||||
| P/E | ERROR:#DIV/0! |
ACCT 522 KAREEM TANNOUS DR. BOYLAN
RATIOS
| Your Company Name Here | ||||||||||
| Company Ratios | ||||||||||
| For Years Ending X0 - X5 | ||||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | |||||
| Liquidity | ||||||||||
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Quick Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Debt | ||||||||||
| Leverage | ||||||||||
| Debt to Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Debt to Assets Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Interest | ||||||||||
| Interest Coverage Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| Profitability | ||||||||||
| Net Profit Margin Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Return on Assets Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Return on Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Effeciency | ||||||||||
| Inventory Turnover Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| Total Asset Turnover Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| A/R Turnover Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| Average Collection Period | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| Days in Inventory | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| AVERAGES | ||||||||||
| Total Current Assets | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total Assets | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Inventories | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total Current Liabilities | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total Liabilities | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total Equity | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Income (EBDT) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Annual Interest Expense | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Net Income after Taxes | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Sales Revenue | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Cost of Good Sold | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Accounts Payable | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Accounts Receivable | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
ACCT 522 KAREEM TANNOUS DR. BOYLAN
LIQUIDITY DATA
ACCT 522 KAREEM TANNOUS DR. BOYLAN
Liquidity Data
Current Ratio 0 0 0 0 0 Quick Ratio 0 0 0 0 0LEVERAGE DATA
ACCT 522 KAREEM TANNOUS DR. BOYLAN
Leverage Data
Debt to Assets Ratio 0 0 0 0 0 Debt to Equity Ratio 0 0 0 0 0INTEREST DATA
ACCT 522 KAREEM TANNOUS DR. BOYLAN
Interest Coverage Ratio 1 2 3 4 5 0 0 0 0 0PROFITABILITY DATA
ACCT 522 KAREEM TANNOUS DR. BOYLAN
Profitability Data
Return on Assets Ratio 0 0 0 0 0 Return on Equity Ratio 0 0 0 0 0 Net Profit Margin Ratio 0 0 0 0 0EFFECIENCY DATA
ACCT 522 KAREEM TANNOUS DR. BOYLAN
Efficiency Data
Inventory Turnover Ratio 0 0 0 0 0 Total Asset Turnover Ratio 0 0 0 0 0 A/R Turnover Ratio 0 0 0 0 0AVG COLLECTION
Average Collection Period
(In Days)
Average Collection Period 0 0 0 0 0INVENTORY T.O. DATA
ACCT 522 KAREEM TANNOUS DR. BOYLAN
Days in Inventory 0 0 0 0 0
