Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

towards your examination preparation. - Please ensure the academic integrity of your submission. PART A - 15 marks: Preparation of accounting records using formula embedded

image text in transcribed
towards your examination preparation. - Please ensure the academic integrity of your submission. PART A - 15 marks: Preparation of accounting records using formula embedded spreadsheets. Assignment Questions: The unadjusted trial balance columns in the worksheet of ParthKrishna are as follows as of March 31, 2021. (Note: You can copy this table into Excel) Required: 1) Formulate five adjustments (with special attention to dates and months) and journalise the adjusting entries in excel. Adjustments must cover a variety of transactions. For example, Depreciation, unearned revenue and an error requiring a correction entry (enter these adjustments in datasheet only). Your marks depend upon the quality and detail in framing adjustments. 2) Prepare and complete the 10-column worksheet. 3) Prepare the income statement, the statement of changes in owners' equity, and the classified balance sheet. 4) Prepare the closing entries. 5) Calculate the current ratio for the company using formulas. 6) Complete the optional, High-distinction tasks. Prepare a dashboard depicting financial position or financial performance of the business. Or use two functions from any or both of these videos given below. (These 3 marks are individual, not group marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing An Assertions Approach

Authors: G. William Glezen, Donald H. Taylor

7th Edition

047113421X, 978-0471134213

More Books

Students also viewed these Accounting questions

Question

=+ What does the usage of these products abroad look like?

Answered: 1 week ago