Prepare a six-column worksheet for the year ended

Assignment Help Accounting Basics
Reference no: EM132310773

Accounting for Decisions Assignment -

Part 1 -

There are four financial statements - balance sheet, income statement, statement of cash flows, and statement of changes in equity. Briefly describe the information conveyed by the balance sheet relative to that conveyed by the income statement.

Part 2 - End of Period Adjustments and Closings and Financial Statements

The unadjusted trial balance of ABC's Financial Consultant, contains the following account balances as at 30 June 2017:

ABC FINACIAL CONSULTAT Unadjusted Trial Balance, as at 30 June 2017

Account

Debit

Credit

Cash at Bank

$5,200

 

Accounts Receivable

9,260

 

GST Receivable

920

 

Office Supplies

1,140

 

Land

60,000

 

Building

152,000

 

Accumulated Depreciation - Building

 

$64,000

Office Equipment

23,400

 

Accumulated Depreciation - Office Equipment

 

6,420

Accounts Payable

 

7,960

Unearned Consulting Fees

 

1,560

GST Payable

 

2,000

Mortgage Payable

 

88,600

C. Delaney, Capital

 

71,490

C. Delaney, Drawings

52,780

 

Consulting Fees Revenue

 

156,860

Insurance Expense

1,660

 

Salaries Expense

87,940

 

Electricity Expense

760

 

Interest Expense

2,090

 

Telecommunications Expense

1,740

 

Total

$398,890

$398,890

The following additional account titles are included in the chart of accounts:

Prepaid Insurance

Telecommunications Expense Payable

Office Supplies Expense

Depreciation Expense - Buildings

Depreciation Expense - Office Equipment

Interest Payable

Salaries Payable

The following information is also available:

1. A physical count of office supplies reveals that supplies totalling $420 are on hand at 30 June.

2. The balance in the Unearned Consulting Fees account includes $1200 earned for services rendered in the last week of June.

3. Estimated depreciation on the office equipment is $2140. Depreciation on the building is $8760.

4. A 12-month insurance policy was purchased on 1 April for $780 plus GST.

5. The June monthly mortgage payment of $900 has not been paid or recorded. In each payment, $220 is attributable to interest.

6. The June telecommunications costs for $320 are unrecorded. No tax invoice has been received.

7. Salaries of $980 were owing to employees at 30 June 2017.

Required:

1. Prepare a 6-column worksheet for the year ended 30 June 2017. Use the same format of the column worksheet provided.

2. Prepare the income statement, balance sheet (Narrative Format) and statement of changes in equity.

3. Minutes of meetings attended by group members must be kept and detail attendance, work allocations, problems and resolutions to problems (Use template being provided.

All work must be done within the group and a record of meetings and work allocations must be kept. Any non-performance by group members will be noted and marks will be prorated according to the amount of work performed by the students.

Note - Given a case study comprising a trial balance and set of scenarios. Analyse the transactions and calculate and post the closing adjustments necessary to create a final set of financial statements.

Attachment:- Assignment File.rar

Reference no: EM132310773

Questions Cloud

Write a report summary on the topic-5g standards : Write a report summary on the topic-5G standards and critical review in the report. The report should be in IEEE format.
Writing a important suggestions from the plan you select : Search the Internet for IT governance planning. Select a specific governance plan that exists at a company or a plan framework from an organization. Write a.
Identify the surprising concepts that learned about religion : Explain what religion is, and give your opinion as to whether religion is different from spirituality. Identify three surprising concepts that you learned.
Create a requirements breakdown structure : Create a Requirements Breakdown Structure for your selected project, list the requirements then "draw" an RBS. Use the information provided in the Ambriz.
Prepare a six-column worksheet for the year ended : ACC104 Accounting for Decisions Assignment - Prepare a 6-column worksheet for the year ended 30 June 2017. Use the same format of the column worksheet provided
What did the author miss if anything : Do you agree or disagree with the skills and competencies that have been identified in the article this week. What did the author miss if anything?
What is the internet address of your computer : BN208 Networked Applications-Melbourne Institute of Technology Australia- How long did it take from when the HTTP GET message was sent until the HTTP OK reply.
Migrated from a developed marketing : Please find a product that migrated from a developed marketing to an emerging market where the marketing of that product had to be adapted
What is national saving : Supposed that in a closed economy GDP is equal to 11,000, taxes are equal to 1,500, consumption equals 7,500 and government purchases equal 2,000.

Reviews

len2310773

5/23/2019 3:32:25 AM

Hello I have an assignment of accounting and business decision 2. I attached the file of assignment and requirement what i need for assignment. There are more details which are given. Students will be required to form groups and will be given a case study comprising a trial balance and set of scenarios. Students will be required to analyse the transactions and calculate and post the closing adjustments necessary to create a final set of financial statements. Students will be placed in groups and be expected to work together to complete this assignment. In this assignment I need everything according to the requirements. Thanks!

len2310773

5/23/2019 3:32:19 AM

Marking Rubric - Level of understanding of Accounting concepts and literature (3 marks) Provides accurate and well developed explanations of ACCOUNTING Concepts and drawing on most relevant literature. Correct posting of adjusted entries and formation of adjusted trial balance (8 marks) Shows a deep understanding of ACCOUNTING concepts, appropriate adjusted trial balance. Demonstrate the application of relevant methods in preparation of of Income Statements, Financial Statements and Statements of Changes in Equity (7 marks) An extensive analysis developed, reflecting knowledge of Accounting Concepts, and compiling an accurate set of financial statements.

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd