Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Essentials For Hospitality Managers

Authors: Chris Guilding

3rd Edition

0415841097, 978-0415841092

More Books

Students also viewed these Accounting questions

Question

Illustrate the link between business

Answered: 1 week ago