Reference no: EM131036062
This assignment is about ten column worksheet with adjustment and income statements and balance sheet.The ledger of Daniel Penny, Financial consultant, contains the following account balances on 30th June 2015 and additional information for adjusting accounts. You are required to:
(A) Prepare a 10-column worksheet for the year ended 30 June 2015.
(B) Prepare the income statement, balance sheet and statement of change in equity.
(C) Journalise the closing entries.
|
Account
|
Debit ($)
|
Credit ($)
|
|
Cash at Bank
|
42,000
|
|
|
Prepaid rent
|
10,000
|
|
|
Accounts receivable
|
92,600
|
|
|
GST Receivable
|
9,200
|
|
|
Office Supplies
|
11,400
|
|
|
Land
|
600,000
|
|
|
Building
|
1,520,000
|
|
|
Accumulated depreciation- Building
|
|
640,000
|
|
Office Equipment
|
234,000
|
|
|
Accumulated depreciation - Office equipment
|
|
64,200
|
|
Accounts Payable
|
|
79,600
|
|
Unearned consulting fees
|
|
15,600
|
|
GST Payable
|
|
20,000
|
|
Mortgage payable
|
|
886,000
|
|
D. penny, Capital
|
|
714,900
|
|
D.penny, Drawings
|
527,800
|
|
|
Consulting fees revenue
|
|
1,568,600
|
|
Insurance expense
|
16,600
|
|
|
Salaries expense
|
879,400
|
|
|
Electricity Expense
|
7,600
|
|
|
Interest expense
|
20,900
|
|
|
Telecommunication expense
|
17,400
|
|
The following information is also available:
1. The rent was paid in advance for 12 months on 1st April 2015
2. The physical count of office supplies reveals that supplies totalling $4,200 are on hand at 30th June.
3. The balance in the unearned consulting fees account includes $ 12,000 earned for services rendered in the last week of June.
4. Estimated depreciation on the office equipment is $21,400. Depreciation on the building is $87,600
5. A 12-month insurance policy was purchased on 1 April for $7,800 plus GST.
6. The June monthly mortgage payment of $9,000 has not been paid or recorded. In each payment, $2,200 is attributable to interest.
7. The June telecommunications costs for $3,200 are unrecorded. No tax invoice has been received.
8. Salaries of $9,800 were owing to employees at 30 June 2015.
9. Office expenses of $2,000 incurred but not paid until 30 June 2015.
10. At the end of the year consultation services of $150,000 were provided but Daniel did not receive any cash for this yet.
|
Effective job of implementing a balanced scorecard approach
: Cattaraugus County Rehabilitation Center did an effective job of implementing a balanced scorecard approach in a fashion that reflects their organizational mission and vision.
|
|
Strategy used by company to achieve its published mission
: Search out an organization on the Internet. Once you have selected your organization to review, locate the company’s mission. Determine the strategy used by the company to achieve its published mission. Identify the 10 OM decisions and how the organi..
|
|
Essential elements of an enforceable contract
: Define the five essential elements of an enforceable contract, and demonstrate how each element relates to your example. Explain the circumstances of a breach of contract in your example, and discuss possible remedies.
|
|
Interface between purchasing and supply management
: Discuss the interface between Purchasing and Supply Management and Logistics Management - specifically with respect to selection of a third party logistics provider, analysis of the total cost of ownership
|
|
Journalise the closing entries
: FINANCIAL ACCOUNTING PRACTICE (BBAC301) - Journalise the closing entries and prepare a 10-column worksheet for the year ended 30 June 2015.
|
|
Evaluate amazon business strategy
: Standing in the year 2000, evaluate Amazon's business strategy. What are its key elements? Is it sustainable? Discuss the merits and shortcomings, if any, of Ravi Suria's assessment of Amazon's financial situation, given the information available ..
|
|
How do we determine what makes a speech good or bad
: Most audience members form an opinion of a speaker during the first minute of his/her speech. But how do we determine what makes a speech good... or bad? Each week, we'll look at an example of public speaking, and we'll dissect it thoroughly. What..
|
|
What corporate governance issues that yahoo face
: What corporate governance issues that Yahoo face? How do these issues impact Yahoo's strategy?
|
|
Final exam care packages
: Lori produces "Final Exam Care Packages" for resale by her sorority. She is currently working a total of 5 hours per day to produce 100 care packages. What is Lori's productivity? What will be the percentage increase in productivity if Lori makes the..
|