Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i havn't got the answer yet for this problem

i havn't got the answer yet for this problem PART...

70.2K

Verified Solution

Question

Accounting

i havn't got the answer yet for this problem
image
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)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

There are two sodium acetate solutions. Their apparent concentrations are 1.00 x 10^-1 M and 1.00...

Chemistry
Q

3. 2 moles of an ideal gas at 17oC has a pressure of 760mm mercury, and...

Physics
Q

A business school claims that students who complete a 3-month typing course can type a mean...

Basic Math
Q

into the cranial nerves spinal cord midbrain telencephalon Question 36 2 points 1 Listen of...

Biology
Q

D Heat is flowing through two cylindrical rods of the same material The diameters of...

Physics
Q

3 If OB has a radius of 4 and mAC 36 what is the area...

Geometry
Q

MaxiDrive manufactures a wide variety of parts for recreational boating, including a gear...

Accounting
Q

Nagios: Nagios is a popular open-source monitoring tool that helps IT teams identify and resolve...

Accounting
Q

4. Explain the flow-through of partnership items to the partners

Accounting
Q

Select an HR policy from your own organisation (or an organisation you are familiar with)....

Accounting
Q

solve fast Ironwood Bank is offering a 30-year mortgage with an APR...

Finance
Q

You are given the following insurance data: Earned Premium = $2,000,000 Exposure...

Finance