financial accounting
MGT 278C Assignment 1
NNS Hospitals Ltd. is a publicly owned company which owns a chain of hospitals. The Balance Sheet of NNS as of 31/3/2015 is given below:
|
Liabilities and Owners’ Equity |
|
|
|
Accounts Payable |
|
120,000 |
|
Salaries Payable |
|
10,000 |
|
Provision for Taxes (2013-14) |
|
90,000 |
|
Provision for Taxes (2014-15) |
|
100,000 |
|
8% Bank Loan |
|
160,000 |
|
Share Capital |
|
400,000 |
|
Share Premium |
|
200,000 |
|
Retained Earnings |
|
20,000 |
|
TOTAL |
|
1,100,000 |
|
|
|
|
|
Assets |
|
|
|
Cash |
|
80,000 |
|
Inventories of Medical Supplies |
|
120,000 |
|
Accounts Receivable |
100,000 |
|
|
Less: Allowance for Doubtful Debts |
-5,000 |
95,000 |
|
Advance Taxes Paid (2013-14) |
|
95,000 |
|
Advance Taxes Paid (2014-15) |
|
100,000 |
|
Prepaid Insurance |
|
20,000 |
|
Investments in 10% Government Bonds |
|
200,000 |
|
Land |
|
150,000 |
|
Building |
200,000 |
|
|
Less: Accumulated Depreciation |
-20,000 |
180,000 |
|
Equipment |
100,000 |
|
|
Less: Accumulated Depreciation |
-40,000 |
60,000 |
|
TOTAL |
|
1,100,000 |
Majority of the cash payments and receipts made during the year are given below:
|
Cash Receipts |
|
Cash Payments |
|
|
Total Cash Collected from Patients |
700,000 |
Cash Paid for Staff Salaries |
110,000 |
|
Interest Received on Govt. Bonds |
20,000 |
Cash Paid for Accounts Payable |
300,000 |
|
Sale of Equipment (31/12/2015) |
15,000 |
Cash Paid for Utilities |
50,000 |
|
Dividends received |
5,000 |
Loan Repaid (31/3/2016) |
20,000 |
|
|
|
Doctors Honorarium |
140,000 |
|
|
|
Equipment Purchase (30/9/2015) |
30,000 |
|
|
|
Advance Tax Paid |
100,000 |
|
|
|
Dividends paid |
50,000 |
|
|
|
Investment in Stock of ND Co. |
20,000 |
Additional Details:
1. NNS provides services to certain patients on a credit basis. During the current financial year, $300,000 worth of services was provided to such patients on a credit basis and $310,000 was collected from such patients. Due to poor financial condition of certain patients, $6,000 was written-off as bad debts in March 2016. $2,000 worth of previously written-off amounts was collected in January 2016. The firm wishes to maintain a balance of 5% of year-end Accounts Receivable as an allowance for doubtful debts.
2. NNS purchases all inventory of medical supplies on credit. The total purchase in the current financial year amounted to $250,000. The ending balance of inventory of medical supplies was $90,000.
3. The interest on 8% Bank Loan is accrued, but due to a computer glitch, could not be paid till 10th April 2016. The company had to pay a penalty of $10,000 along with the interest on 10th April 2016 for late payment of interest. The penalty becomes due in the year of default.
4. The equipment has a useful life of 5 years and Building has a useful life of 10 years. The equipment that was sold on 31/12/2015 was two years old at the beginning of the year and had a historical cost of $20,000.
5. Salaries for the last two weeks of March 2015 will be paid on 5th April 2016. Such salaries amounted to $15,000. Salaries payable for previous years were paid off in the current year.
6. The prepaid insurance is valid for another 15 months starting from 1/4/2015.
7. Tax assessment for the years 2013-14 and 2014-15 was completed in the current year and the tax was assessed to be Rs. 100,000 for 2013-14 and 95,000 for 2014-15. Shortfall (refund), if any, was paid (received) during the year 2015-16. Provision for taxes for the current year is 25% of Profit before Tax.
8. 10,000 new shares were issued. The face value of shares was $1 and Market value was $20.
Based on the above information, prepare the Balance Sheet, Income Statement, and Cash Flow Statement (Use Indirect Method) for the year ended on 31/3/2016.