Calculate and provide a cash flow statement for first month

Assignment Help Accounting Basics
Reference no: EM131377980

INSTRUCTIONS - Task 2 Part B Requirements:

Stage 1 -

Use the spreadsheet template provided to complete the following requirements.

When using the spreadsheet you are required to provide the links from the General Ledger Accounts to the Live Trial Balance.

1. Link the balances of the General Ledgers to the Live Trial Balance

2. Enter the transactions into the appropriate Special Journals.

3. Important: After each transaction that particular journal should be in balance. If it is not, fix it before recording the next transaction.

4. Do the Bank Reconciliation and enter transactions as required.

5. Post (Link) the transactions from the Special Journals to the appropriate General Ledger Accounts the balances of which should flow to the Live Trial Balance.

6. Important: Posting should be done from the total of each column unless recorded in "Other Account" column.

7. Important: Post the entire journal and check that the Live Trial Balance is in balance before moving to the other journals. If it is not in balance, fix it before moving on.

8. Copy the Live Trial Balance and create a Fixed Trial Balance using Special Paste Values into your worksheet.

9. Do the adjustments into and complete the worksheet

  • Note well: the worksheet is a separate document. No linking is permitted from the worksheet to any of the financial statements. It is used as a checking mechanism that ensures your financial statements prepared in step 13 match the worksheet.

10. Journalise the adjustments in the General Journal and post to the General Ledgers. Check that the Live Trial Balance is in Balance ? before moving to the next transaction. If it is not in balance, fix it before moving on.

11. After all adjustments have been posted the Live trial Balance should be the same as the adjusted trial balance of the worksheet.

12. Copy the Live Trial Balance worksheet and create a Fixed Trial Balance worksheet using Special Paste Values into the worksheet.

13. Use the Fixed Trial balance to help you complete a Profit & Loss statement, Statement of Partners Equity and a Balance Sheet for month of trading.

Stage 2 -

Write a brief report to Julie and Katy commenting on the financial performance of the business:

Calculate the following financial ratios and provide comments -

Current ratio

  • Industry average is 5:1
  • Accounting Norm is 3:1

Quick ratio

  • Industry average is 4 : 1
  • Accounting Norm is 1:1

Calculate and provide a cash flow statement for the first month of trading.

Using academic references (recorded using Harvard Referencing style) list and briefly explain the registrations and legal requirements that Julie and Katy would have undertaken to establish the business name and partnership.

Attachment:- Assignment.rar

Reference no: EM131377980

Questions Cloud

Compare and contrast the ucr and the ncvs : Differentiate between restorative justice and retributive justice. Provide examples. Which does the justice system use today?Name five differences and five similarities between the juvenile justice system and the criminal justice system. Overall, ar..
What pricing plans do they have for residential users : Investigate the providers of VOIP phone service using the Internet (e.g., Vonage.com). What services do they provide and what pricing plans do they have for residential users?
What are the different types of application architectures : What are the different types of application architectures?- Describe the four basic functions of an application software package.
Would you expect eventual fatigue failure : When the latch operates, the end deflects an additional 0.15 in. Would you expect eventual fatigue failure?
Calculate and provide a cash flow statement for first month : ACC506 Task 2 Part B. Write a brief report to Julie and Katy commenting on the financial performance of the business: Calculate the following financial ratios and provide comments. Calculate and provide a cash flow statement for the first month of tr..
Estimate the value of reversed torque that can be applied : With a safety factor of 2, estimate the value of reversed torque that can be applied without causing eventual fatigue failure.
What is the definition of cybercrime : What is the definition of cybercrime?How was the definition of cybercrime developed?What technologies are being used to commit cybercrime?What are the major effects of cybercrime on society?What are the financial effects of cybercrime?
Draw the spectrum of the sampled signal : ECET345- Draw the spectrum of the sampled signal and show the baseband and first two positive frequency replications with their end frequency values marked. (Hint: Follow the method outlined in the lecture.)
What is meant by the working personality of the police : Is about the video interview with Lt. Delmonico. This interview brought out many significant points about ethics and there importance. Explain Lt. Delmonico's main points and answer why they are important to the criminal justice practitioner. This..

Reviews

len1377980

1/31/2017 4:26:47 AM

This assignment must be your own individual work, i.e. it is not a group assignment. If it is believed that a student has copied material from another student or any other source without appropriate referencing, the necessary action will be taken under the University’s Student Academic Integrity - Governing Policy. Please contact your local campus lecturer/tutor if you have any queries. Alternatively, you can post your query to the Discussion Board on the course Blackboard site. The assignment should only be submitted electronically via Safe Assignment on the ACC506 ATMC Blackboard site. When you are using the special journals you do not use the General Journal as well! Just the special Journals.

Write a Review

Accounting Basics Questions & Answers

  Jorge company bottles and distributes b-lite a diet soft

jorge company bottles and distributes b-lite a diet soft drink. the beverage is sold for 50 cents per 16-ounce bottle

  Provide a general overview of peachtree complete accounting

provide a general overview of peachtree complete accounting. make sure the overview provides the reader with a general

  Frado company provides you with following information

frado company provides you with following information related to payroll transactions for the current month. the

  Calculating npv, irr and pp advise which option should taken

By calculating NPV, IRR and PP (show all calculations on excel sheet) advise which option should be taken and say why compared to the other methods.

  Fullerton waste management purchased land and a warehouse

Determine the amounts Fullerton should capitalize as the cost of the land and the building.

  Mckerchie inc manufactures industrial components one of its

mckerchie inc. manufactures industrial components. one of its products used in the construction of industrial air

  Prepare a cost of production report and identify the

prepare a cost of production report and identify the missing amounts for work in process-roasting department. if an

  Company net operating income increase or decrease

The president believes that a $7,700 increase in the monthly advertising budget, combined witha n intensified effort by the sales staff, will result in an $69,000 increase in monthly sales. If the president is right, by how much will the company's..

  How is decision making in a group environment different

How is decision making in a group environment different from individual decision making, and why are information systems that assist in the group environment different? What are the advantages and disadvantages of making decisions as a group?

  Wacky bird company a producer of fine quality clocks

wacky bird company a producer of fine quality clocks produced 5000 clocks at a cost of 1150000 in july. in august the

  Following information to complete phillip

Use the following information to complete Phillip and Claire Dunphy's 2015 federal income tax return. If information is missing, use reasonable assumptions to fill in the gaps. Ignore the alternative minimum tax for this problem.

  Santana rey expected sales of her line of computer

santana rey expected sales of her line of computer workstation furniture to equal 300 workstations at a sales price of

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