Question: Question 1 Please find the Breakeven point from the below detail. Question 2 And also give 5 important ratios from the below information. And also
Question 1 Please find the Breakeven point from the below detail.
Question 2 And also give 5 important ratios from the below information. And also give interpretation of ratios and from below financial data.
Question 3 balance sheet for 2015 prepare
| Income Statement For the Year Ended [December 31, 2016] | ||||
| Particular | 2016 | 2015 | ||
| Revenue: |
|
| ||
|
| Service revenue | $ 278,000.00 | $ 250,000.00 | |
|
| Grant |
| $ - | $ - |
|
| Fund raising | $ - | $ - | |
| Total Revenue | $ 278,000.00 | $ 250,000.00 | ||
| Expenses: |
|
| ||
|
| Advertising | $ 1,200.00 | $ 1,100.00 | |
|
| Amortization | $ - | $ - | |
|
| Bad Debts(5% of Revenue) | $ 11,000.00 | $ 9,400.00 | |
|
| Bank Charges | $ 3,000.00 | $ 3,000.00 | |
|
| Charitable Contributions(1% of Sales) | $ 2,780.00 | $ 2,500.00 | |
|
| Commissions(5% of sales) | $ 13,900.00 | $ 12,500.00 | |
|
| Contractor | $ 31,500.00 | $ 28,500.00 | |
|
| Credit Card Fees | $ 1,680.00 | $ 1,524.00 | |
|
| Delivery Expenses | $ 2,800.00 | $ 2,500.00 | |
|
| Depreciation (Computer) | $ 675.00 | $ 675.00 | |
|
| Depreciation (Vehicle) | $ 4,200.00 | $ 4,200.00 | |
|
| Depreciation (Office equipments) | $ 525.00 | $ 525.00 | |
|
| Depreciation (Furniture) | $ 650.00 | $ 650.00 | |
|
| Dues and Subscriptions | $ 850.00 | $ 800.00 | |
|
| Insurance($550 *12)*3 employee | $ 19,800.00 | $ 19,800.00 | |
|
| Interest ($80,000 * 13%) | $ 10,400.00 | $ 10,400.00 | |
|
| Maintenance | $ 1,300.00 | $ 1,100.00 | |
|
| Miscellaneous | $ 1,400.00 | $ 1,200.00 | |
|
| Office Expenses | $ 2,200.00 | $ 2,000.00 | |
|
| Operating Supplies | $ 1,000.00 | $ 1,500.00 | |
|
| Payroll Taxes | $ - | $ - | |
|
| Permits and Licenses( Every 2 years Renew) | $ - | $ 600.00 | |
|
| Postage | $ 650.00 | $ 600.00 | |
|
| Professional Fees | $ 1,400.00 | $ 1,200.00 | |
|
| Property Taxes | $ - | $ - | |
|
| Rent ($1500*12)( lease of 3 years ) | $ 18,000.00 | $ 18,000.00 | |
|
| Repairs | $ 900.00 | $ 700.00 | |
|
| Telephone | $ 1,080.00 | $ 1,080.00 | |
|
| Travel |
| $ 1,300.00 | $ 1,100.00 |
|
| Utilities( between $160 to $170 pm) | $ 2,000.00 | $ 1,800.00 | |
|
| Vehicle Expenses | $ 2,000.00 | $ 1,800.00 | |
|
| Wages($ 14.75 per hour) | $ 23,600.00 | $ 16,520.00 | |
|
| Total Expenses | $ 161,790.00 | $ 147,274.00 | |
| Earnings Before Income Tax | $ 116,210.00 | $ 102,726.00 | ||
|
| Tax Expenses 35% | $ (40,630.00) | $ 35,954.10 | |
| Net Income | $ 75,580.00 | $ 66,771.90 | ||
| Balance Sheet as on 31st Dec 2016 | Amount $ | Amount $ | |
| Assets | |||
| Current Assets: |
|
| |
| Cash |
| $ 33,170.00 |
|
| Accounts Receivable (30% of Revenue) | $ 83,400.00 |
|
|
| Reserve for Bad Debts(10%) | $ (8,340.00) | $ 75,060.00 |
|
| Prepaid Insurance ($800*2 years) |
| $ 24,000.00 |
|
| Notes Receivable |
| $ - |
|
| Total Current Assets (A) | $ 132,230.00 | ||
| Fixed Assets: |
|
| |
| Vehicles | $ 28,000.00 |
|
|
| Accumulated Depreciation (15%) SLM | $ (4,200.00) | $ 23,800.00 |
|
| Computers | $ 4,500.00 |
|
|
| Accumulated Depreciation (15%) SLM | $ (675.00) | $ 3,825.00 |
|
| Office Equipments | $ 3,500.00 |
|
|
| Accumulated Depreciation (15%) SLM | $ (525.00) | $ 2,975.00 |
|
| Furniture and Fixtures | $ 6,500.00 |
|
|
| Accumulated Depreciation (10%) SLM | $ (650.00) | $ 5,850.00 |
|
| Total Fixed Assets (B) | $ 36,450.00 | ||
| Total Assets (A+B) | $ 168,680.00 | ||
| Liabilities and Capital | |||
| Current Liabilities: |
|
| |
| Contract Service Payable | $ 9,000.00 |
|
|
| Interest Payable(80000*13%) | $ 900.00 |
|
|
| Total Current Liabilities | $ 9,900.00 |
| |
| Long-Term Liabilities: |
|
|
|
| Long-Term Notes Payable | $ 80,000.00 |
|
|
| Total Long-Term Liabilities | $ 80,000.00 |
| |
| Total Liabilities (C) | $ 89,900.00 | ||
| Capital: |
|
| |
| Owner's Equity |
| $ 3,200.00 |
|
| Net Profit |
| $ 75,580.00 |
|
| Total Capital (D) | $ 78,780.00 | ||
| Total Liabilities and Capital (C+D) | $ 168,680.00 | ||
| Cash Flow Budget Worksheet December 31, 2016 | |
| Beginning Cash Balance | $ - |
| Cash Inflows (Income): |
|
| Accts. Rec. Collections | $ 83,400.00 |
| Loan Proceeds | $ 80,000.00 |
| Sales & Receipts | $ 75,536.00 |
| Other: | $ - |
|
|
|
| Total Cash Inflows | $238,936.00 |
| Available Cash Balance |
|
| Cash Outflows (Expenses): |
|
| Advertising | $ 1,200.00 |
| Bank Service Charges | $ 3,000.00 |
| Credit Card Fees | $ 1,680.00 |
| Delivery | $ 2,800.00 |
| Health Insurance | $ - |
| Insurance | $ 24,000.00 |
| Interest | $ 10,400.00 |
| Inventory Purchases | $ - |
| Miscellaneous | $ 1,400.00 |
| Office | $ 2,200.00 |
| Wages | $ 23,600.00 |
| Payroll Taxes | $ - |
| Professional Fees | $ 1,400.00 |
| Rent or Lease | $ 18,000.00 |
| Subscriptions & Dues | $ 850.00 |
| Supplies | $ 1,000.00 |
| Taxes & Licenses | $ - |
| Utilities & Telephone | $ 3,080.00 |
| Other: | $ - |
| Subtotal | $ 94,610.00 |
| Other Cash Out Flows: | $ - |
| Capital Purchases | $ - |
| Loan Principal | $ 80,000.00 |
| Owner's Draw | $ 3,200.00 |
| Other: | $ 27,956.00 |
| Total Cash Outflows | $111,156.00 |
| Ending Cash Balance | $ 33,170.00 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
