Reference no: EM131380171
Accounting Fundamentals Assignment
Task 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
|
Calculate the npv and non-discounted payback
: Managerial Finance Assessment Task Project Evaluation. Calculate the NPV, Non-discounted Payback, and the IRR of Plant A and Plant B. Interpret your results. (If relevant, state any assumptions you have made.)
|
|
Describe the history of public administration
: Write an 850- to 1,200-word paper in which you describe the history of public administration and briefly discuss the strengths and weaknesses of at least two public administration theory models.
|
|
What company government should be responsible for defending
: Should the United States assign US Cyber Command with the responsibility of protecting certain private companies and if so what should the general standard be for determining what companies the government should be responsible for defending.
|
|
How each alternative stacks up
: Explain in narrative form how each of your two (2) alternatives stacks up against your first criterion. Next, explain how each alternative stacks up against your second criterion, etc.
|
|
Calculate and provide cash flow statement for first month
: 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. Calculate and provide a cash flow statement for..
|
|
What role does such knowledge play in enabling auditors
: The court decision refers to the importance of the auditors' knowing about third-party usage of the audited financial statements. What role does such knowledge play in enabling auditors to meet their professional and ethical responsibilities?
|
|
Describe how the process was improved
: Research a process that has been substantially improved by information systems.Briefly describe the before and after processes. Describe how the process was improved. Was the process more efficient/effective for both the organization and its custo..
|
|
Describe distribution and summarize the important feature
: Describe the distribution and summarize the important features. What is it about running that might account for the shape you see?
|
|
Compose a thought provoking inquiry
: Compose a thought provoking inquiry along with A analysis/reflection prepared, to engage in class discussion. Please use Sub heading title for the question and sub heading title for the analysis/reflection?
|