80.2K
Verified Solution
Link Copied!
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 |
Answer & Explanation
Solved by verified expert