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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started