Microsoft Word - ACCT2014_Project 2020 1 ACCT XXXXXXXXXXFinancial Accounting I Group Project Semester I 2020/2021  To be completed in groups of 5 or 6 registered students.  Groups can ONLY be formed...

1 answer below »
Are you able to meet deadline ? located in Jamaica



Microsoft Word - ACCT2014_Project 2020 1 ACCT 2014 - Financial Accounting I Group Project Semester I 2020/2021  To be completed in groups of 5 or 6 registered students.  Groups can ONLY be formed with students registered to the same stream  Project MUST be submitted in Excel Template provided by the lecturer. This template cannot be edited in anyway other than what is instructed  All Projects MUST be submitted with grading rubric (provided by the lecturer) completed by all group members Deadline – November 20, 2020 11:59pm 2 The following are summaries of the cash book and bank accounts of Patsy Knight, a sole proprietor, who does not keep her books using the double entry system. Bank Summary $ $ Balance on 1 January 2018 60,000 Receipts: Receivables 350,000 Cash bank 22,200 372,200 432,200 Payments: Trade payables 310,000 Rent 10,100 Machinery 30,400 Wages 90,200 Insurance 8,050 Customers (dishonoured cheque) 800 Loan interest 950 (450,500) Balance on December 2018 (18,300) Cash Summary $ $ Balance on 1 January 2018 10,000 Receipts: Cash sales 90,700 Receivables 10,100 100,800 110,800 Payments: Drawings 60,600 Repairs 10,400 Electricity 5,070 Cash banked 22,200 (98,270) Balance on December 2018 12,530 The following referred to 2018 $ Bad debts written off 2,040 Goods withdrawn by Patsy Knight for own use 10,200 Credit note issued by Patsy Knight 6,040 Discounts allowed by trade suppliers 4,040 Discounts allowed to trade customers 8,000 Goods returned to trade suppliers 6,900 3 Further checks revealed the following during 2018:  During the financial year a trade debt of $10,200 owed by Linda Grayson was off set against the $20,000 owing to the same Linda Grayson a trade creditor.  In addition to the goods returned above, Jane Hutton, a cash sales customer returned goods during the financial year amounting to $7,000. Jane Hutton was repaid her $7,000 from the daily cash sales. This was not yet reflected in the business records.  Patsy Knight grants a credit period of 30 days to customers. The closing trade receivables’ balance includes a debt of $8,000 from Favela Brown. The goods were sold to Favela in November 2017. Favela went to the United States of America for a two (2) weeks’ vacation in February 2018. On December 31, 2018 Favela was still in the USA.  Patsy Knight keeps a cash float of $10,000 for change in his retail outlet. Excess cash is deposited in the bank account and cash shortfall is taken from the bank.  The accounting fee for preparing the 2018 financial statements is estimated at $45,000. The following additional information is also available: 1 January 2018 31 December 2018 $ $ Inventories 8,300 9,400 Machinery 19,800 40,400 Rent paid in advanced - 1,000 Rent outstanding 1,050 - Trade receivables 18,100 19,200 Trade payables 15,700 14,800 Loan from bank at 10% 17,000 17,000 Loan interest owing - 750 Required: a) Prepare a statement of affair to show Patsy Knight’s capital on 1 January 2018. b) Prepare the Trade receivables Control Account c) Prepare the Trade payables Control Account d) Extract a trial balance as at December 31, 2018. e) Prepare the Income Statement for the year ended 31 December, 2018 f) Statement of changes in owner’s equity for the year ended 31 December, 2018. g) Prepare a COMPARATIVE Statement of Financial Position as at 31 December, 2018. h) Prepare a Statement of Cash Flow for the year ended 31 December, 2018
Answered Same DayOct 14, 2021

Answer To: Microsoft Word - ACCT2014_Project 2020 1 ACCT XXXXXXXXXXFinancial Accounting I Group Project...

Angel K answered on Nov 01 2021
138 Votes
INSTRUCTIONS
        INSTRUCTIONS
        1        Only change/ enter data in cells which are highlighted in color
        2        There is a drop down menu that will provide you the options for each financial statement line item. You cannot add your own
        3        Any submission of an excel workbook with unauthorised edits will result in a zero for the grade
        4        There can be blank spaces in the Fin
ancial Statements
        5        You must use the software Microsoft Excel to edit this template. Any submissions that show evidence of unauthorised edits due to utlising a different software will resullt in a zero for the grade.
Group Information
        Course    ACCT2014
        Stream
        Group Administrator ID Number
        Group Name    -
        The details of ALL group members must be stated below, including that of the group adminsitrator
            ID Number    First Name    Last Name    Grading Rubric Total Score
        Group Member 1                0
        Group Member 2                0
        Group Member 3                0
        Group Member 4                0
        Group Member 5                0
        Group Member 6                0
                    Quality of Work    Timeliness of Work    Task Support    Interaction    Attendance    Responsibility    Involvement    Leadership    Overall Performace Rating
            First Name    Last Name
        Group Member 1    0    0
        Group Member 2    0    0
        Group Member 3    0    0
        Group Member 4    0    0
        Group Member 5    0    0
        Group Member 6    0    0
For Lecturers use only
    Control Accounts
        Trade Debtors Control Account                $
            Debit Side
                Balance b/d        18100
                Credit Sales        402480
                0        0
                0        0
                0        0
                0        0
                0        0
            Credit Side
                Bank         350000
                Cash        10100
                Bad Debts        10040
                Discount Allowed        8000
                Returns Inwards        13040
                Set off        10200
                Balance c/d        19200
        Trade Creditors Control Account                $
            Debit Side
                Bank         310000
                Discount Received        12840
                Returns Outwards        6900
                Dishonoured Cheques        800
                Set off        10200
                Balance c/d        14800
                0        0
            Credit Side
                Balance b/d        15700
                Credit Purchases        339840
                0        0
                0        0
                0        0
                0        0
                0        0
    Statement of Affairs                    $
            Non-Current Assets
                Machinery - at cost        19800
            Current Assets
                Closing Inventories        8300
                Debtors        18100
                Bank        60000
                Cash        10000
                0        0
                0        0
                0        0
            Total Current Assets    0        96400
            Total Assets            116200
            Non-Current Liabilities
                Long term loan        17000
            Current Liabilities
                Creditors        15700
                Other payables        1050
                0        0
                0        0
                0        0
            Total Current Liabilities    0        16750
            Capital    0        82450
            Total Liabilities and Capital    0        116200
    Trial Balance
                        Dr    Cr
                Accounting fees        45000    0
                Bank        0    22770
                Capital        0    82450
                Cash        10000    0
                Creditors        0    14800
                Debtors        19200    0
                Discount Allowed        8000    0
                Discount Received        0    12840
                Drawings        70800    0
                Loan interest expense        950    0
                Long term loan        0    17000
                Machinery - at cost        50200    0
                Other payables        0    750
                Other receivables        1000    0
                Purchases        339840    0
                Rent        10100    0
                Sales        0    493180
                Wages        90200    0
                Returns Inwards        13040    0
                Returns Outwards        0    6900
                Insurance expense        8050    0
                Repairs and maintenance expense        10400    0
                Electricity        5070    0
                0        0    0
                Opening Inventories        0    8300
                Bad Debts        0    10040
                Additional capital        0    12820
                0        0    0
                0        0    0
                0        0    0
                        681850    681850
    Income Statement                    $
                Sales        493180
                Returns Inwards        -13040
            Net Sales            480140
            Less Cost of Sales
                Purchases        -339840
                Returns Outwards        6900
                Opening Inventories        -8300
                Closing Inventories        9400
                0        0
                0        0
            Cost of Sales            -331840
            Gross Profit            148300
            Other operating income
                Discount Received        12840
                0        0
            Total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers