Question 1 Please find the Breakeven point from the below detail. Question 2 And also...

80.2K

Verified Solution

Question

Accounting

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students