Balance sheet, Balance day adjustment, General Ledger

User Generated

Wryran

Business Finance

Description

MUST KNOW ALL ACCOUNTING EQUATION AND CONCEPT. Must know how to elaborate and write cash flow statement.

Please answer all question. Thank you😀

Unformatted Attachment Preview

QUESTION 2: Balance Day Adjustments (25 marks) This is not a typo. Q1 was included in Part A of the assignment, which now continues in Q2. Below is the unadjusted Trial Balance for Auldana Custom Concrete Foundations as at 30th June 2016. NOTE: Please use this trial balance to complete the question ( NOT the trial balance you completed in Part A of the assignment). ATRIUM FLORAL SUPPLIES UNADJUSTED TRIAL BALANCE AS AT 30 June 2017 Debit ($) 18 388 19 685 20 050 5 514 2 676 51 030 Cash at Bank Accounts Receivable Inventory Prepaid Insurance Office Supplies on hand Furniture & Fittings Accumulated Depreciation – Furniture & Fittings Equipment Accumulated Depreciation – Equipment Accounts Payable Advertising Payable Loan Payable Penny’s AFS – Capital Penny’s AFS – Drawings Sales Revenue Sales Returns and Allowances Cost of Sales Discount received Freight inwards Sales Salary Expense Delivery Expense Advertising Expense Rent Expense Office Salaries Expense Electricity Expense Discount Allowed Totals Credit ($) 12 634 74 845 18 120 25 327 1 700 48 805 53 580 36 655 725 900 10 010 162 308 13 096 7 920 66 936 19 692 26 660 27 148 35 150 7 656 6 839 599 162 On the next page is Penny’s information related to the year that ended 30 June 2016. 1 599 162 (1) A count of the stationery room showed that Office Supplies on hand at 30th June 2016 were $2 510. (2) Both the Furniture & Fittings and the Equipment will be used evenly over their useful lives. The expected total useful lives and residual values of both assets is as follows: Furniture & Fittings Equipment Estimated Useful life 6 years 10 years Estimated Residual $6030 $800 (3) Interest on the loan is 8.5% per year. Interest accrued but not recorded at 30th June was $248. (4) In order to allow for cash flow fluctuations, the bank has approved a $25,000 overdraft facility for Penny’s business bank account. (5) The balance in the Prepaid Insurance account represents a 12 month insurance policy that commenced on 1st March 2017. (6) $6 250 of the recorded Sales Revenue is for deposits paid for floral arrangements which will not be delivered until July/August 2017. (7) As of 30th June 2017, Penny has estimated that 2% of her Accounts Receivable will not be collected. REQUIRED: As it is now the end of the financial year, you have to undertake the following work for Penny: a. Prepare any necessary Balance Day Adjustment Journals for AFS. Include a brief narration (explanation) for each journal entry. (11 marks) b. Post the journals from (a) above to the General Ledgers provided. (7 marks) c. Complete the Adjusted Trial Balance provided for the account balances calculated in the General Ledgers from (b) above. (7 marks) 2 a. Date Prepare any necessary Balance Day Adjustment Journals for AFS. Include a brief narration (explanation) for each journal entry. Details Debit ($) 3 Credit ($) b. Complete and post the journals from (a) above to the General Ledgers provided below. All ledgers must be footed. Allowance for Doubtful Debts Prepaid Insurance Office Supplies on Hand Accumulated Depreciation – Furniture and Fittings Accumulated Depreciation – Delivery Equipment Unearned Sales Interest Payable Sales 4 Interest Expense Depreciation – Furniture and Fittings Depreciation – Delivery Equipment Office Supplies Expense Insurance Expense Doubtful Debts Expense 5 c. Complete the Adjusted Trial Balance provided below. You may need to insert additional accounts that are not currently listed. ATRIUM FLORAL SUPPIES ADJUSTED TRIAL BALANCE AS AT 30 JUNE 2016 Debit ($) 18 388 19 685 20 050 Cash at Bank Accounts Receivable Inventory Prepaid Insurance Office Supplies on hand Furniture & Fittings Accumulated Depreciation – Furniture & Fittings Delivery Equipment Accumulated Depreciation – Delivery Equipment Accounts Payable Advertising Payable Loan Payable (long term) Penny’s AFS – Capital Penny’s AFS – Drawings Sales Revenue Sales Returns and Allowances Cost of Sales Discount received Freight inwards Sales Salary Expense Delivery Expense Advertising Expense Rent Expense Office Salaries Expense Electricity Expense Discount Allowed Credit ($) 51 030 74 845 25 327 1 700 48 805 53 580 36 655 9 924 162 308 13 096 7 920 66 936 19 692 26 660 27 148 7 656 6 839 Totals 6 QUESTION 3: Financial Statement (18 marks) The following Trial Balance for Perry’s Parisian Pastries has been prepared at year end by Perry, but he realises it is not in the correct order. REQUIRED: Using the Trial Balance provided below, prepare the following for the period in question: 1. Fully classified Balance Sheet 2. Statement of Changes in Equity Perry’s Parisian Pastries TRIAL BALANCE AS AT 30 JUNE 2016 Debit ($) Shop Furniture & Fittings 32 500 Accounts Receivable 63 730 Accumulated Depreciation – Shop Furniture & Fittings Rent Expense – Admin 3 420 Cash at Bank 24 650 Advertising Payable Sales Electricity Expense 1 450 COGS 285 210 Perry, Capital Depreciation Expense – Shop Furniture & Fittings 3 750 Freight Inwards 2 930 Rent Expense – Store 27 500 Accounts Payable Discount Allowed 3 790 Inventory 22 445 Salaries Expense - Store 33 400 Loan Payable Allowance for Doubtful Debts Prepaid Advertising 1 550 Interest Payable Advertising Expense 635 Sales Equipment 12 500 Interest Expense 730 Doubtful Debts Expense 1 100 Perry, Drawings 16 600 Sales Returns & Allowances 6 905 Discount Received Salaries Expense - Admin 13 975 Totals 558 770 • The loan is payable in equal amounts over 30 months Answer on following pages 7 Credit ($) 9 240 3 600 445 385 48 010 15 235 32 400 1 100 580 3 220 558 770 8 QUESTION 4: Accounting Concepts (10 marks) You are employed as a graduate accountant in a mid-tier accounting firm. One of the partners has asked you to review the following cases where a client has violated at least one of the assumptions, concepts or definitions you studied at university. The partner has asked for a written report in your own words (using references where appropriate), to please explain: a) which concept or assumption has been violated, and; b) what the correct treatment should be. i. The bookkeeper of Pest Eradicator Services recorded revenues of $47,000 for the month because the manager told her that was the amount of revenue earned. The manager, whose monthly bonus is based on total revenues, said that the invoices and other documents the bookkeeper was working from were wrong. These invoices and documents showed revenue for the month as $33,000. [5 marks] __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ ii. The owner of a paper delivery round added $65,000 to the assets shown in his Balance Sheet. He did this because he had spent years building up the goodwill of his customers. “Surely”, he said, “this goodwill is an asset that should be shown in the Balance Sheet”. [5 marks] __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ 9 QUESTION 5: Cash Flow Statement (17 marks) Below are the summarised cash flow statements for two businesses. Comment in your own words using referencing where appropriate on which one has a healthier cash flow situation and justify your answer by explaining the significance of each of the three types of cash flows for each business: Amatil Light To the Max Cash flow from Operating Activities 12 900 (13 500) Cash flow from Investing Activities (7 300) 19 700 Cash flow from Financing Activities (6 900) (3 300) Net increase / (decrease) in cash held (1 300) 2 900 Cash at the beginning of the year 7 500 3 700 Cash at the end of the year 6 200 6 600 [Approximately 400 words expected in your answer] __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ 10
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please find the solution attached. Please note that I based my solution on a sales figure of $425,900 not $725,900, I am 100% sure that this is a typo because if it was $725,900 the total credit column would not be $599,162.Thank you

ATRIUM FLORAL SUPPLIES
UNADJUSTED TRIAL BALANCE
AS AT 30 JUNE 2017
Debit ($)
Cash at Bank
18.388
Accounts Receivable
19.685
Inventory
20.050
Prepaid Insurance
5.514
Office Supplies on hand
2.676
Furniture & Fittings
51.030
Accumulated Depreciation- Furniture & Fittings
Equipment
74.845
Accumulated Depreciation- Equipment
Accounts Pyable
Advertising Payable
Loan Payable
Penny's AFS- Capital
Penny's AFS- Drawings
36.655
Sales Revenue
Sales Returns and Allowances
10.010
Cost of Sales
162.308
Discount Received
Freight inwards
7.920
Sales Salary Expense
66.936
Delivery Expense
19.692
Advertising Expense
26.660
Rent Expense
27.148
Office Salaries Expense
35.150
Electricity Expense
7.656
Discount Allowed
6.839
Totals
599.162
Adjustments:
1) Office Supplies
2)
Furniture & Fittings
Equipment
3) Interest on Loan
4) Overdraft

Credit ($)

12.634
18.120
25.327
1.700
48.805
53.580
425.900

13.096

599.162

$2.510
Estimated Useful Life Estimated Residual
6
$6.030
10
$800
8%
$25.000

Accrued Interest

5) Prepaid Insurance

12

6) Unearned Revenue

$6.250

7) Estimated Uncollectibles

2%

months

of Receivables

$248

Date
6/30

6/30

6/30

6/30

6/30

6/30

6/30

Details
Office Supplies Expense
Office Supplies on Hand
(To record supplies used)

Debit ($)
166

166

Depreciation Expense - Furniture & Fittings
Accumulated Depreciation - Furniture & Fittings
(To record depreciation for the month)

625

Depreciation Expense - Delivery Equipment
Accumulated Depreciation - Delivery Equipment
(To record depreciation for the month)

617

Interest Expense
Interest Payble
(To record accrued interest)

248

Insurance Expense
Prepaid Insurance
(To record insurance expired)

613

Sales
Unearned Sales
(To record unearned sales)
Doubtful Debts Expense
Allowance for Doubtful Debts
(To record estimated uncollectibles)

Credit ($)

625

617

248

613

6.250
6.250

394
394

Allowance for Doubtful Debts
394

394

Bal.

Bal.

Office Supplies on Hand
2.676
166

(7)

Bal.

Prepaid Insurance
5.514

Bal.

Bal.

4.901

Accumulated Depreciation-Furniture and Fit
(1)

2.510

Accumulated Depreciation-Delivery Equipment
18.120
Bal.
617
(2)

18.737

Unearned Sales

Bal.

Interest Payable
248

(3)

Sales

248

Bal.

(6)

6.250

(3)

Interest Expense
248

Depreciation-Furniture and Fittings
(2)
625

Bal.

248

Bal.

Depreciation-Delivery Equipment

625
Office Supplies Expense

(2)

617

(1)

166

Bal.

617

Bal.

166

(5)

Insurance Expense
613

(7)

Bal.

613

Bal.

Doubtful Debts Expense
394

394

Prepaid Insurance
613

(5)

d Depreciation-Furniture and Fittings
12.634
Bal.
625
(2)

13.259

Bal.

Unearned Sales
6.250

(6)

6.250

Bal.

Sales
425.900

419.650

ciation-Furniture and Fittings

Office Supplies Expense

Bal.

Doubtful Debts Expense

ATRIUM FLORAL SUPPLIES
ADJUSTED TRIAL BALANCE
AS AT 30 JUNE 2017
Debit ($)
Cash at Bank
18.388
Accounts Receivable
19.685
Allowance for Doubtful Debts
Inventory
20.050
Prepaid Insurance
4.901
Office Supplies on hand
2.510
Furniture & Fittings
51.030
Accumulated Depreciation- Furniture & Fittings
Equipment
74.845
Accumulated Depreciation- Equipment
Accounts Pyable
Advertising Payable
Unearned Sales
Interest Payable
Loan Payable
Penny's AFS- Capital
Penny's AFS- Drawings
36.655
Sales Revenue
Sales Returns and Allowances
10.010
Cost of Sales
162.308
Discount Received
Freight inwards
7.920
Interest Expense
248
Depreciation - Furniture and Fittings
625
Depreciation - Equipment
617
Office Supplies Expense
166
Insurance Expense
613
Doubtful Debts Expense
394
Sales Salary Expense
66.936
Delivery Expense
19.692
Advertising Expense
26.660
Rent Expense
27.148
Office Salaries Expense
35.150
Electricity Expense
7.656
Discount Allowed
6.839
Totals
601.046

Credit ($)

394

13.259
18.737
25.327
1.700
6.250
248
48.805
53.580
419.650

13.096

601.046

I am done I am done 💃 💃 Please find the full solution attachedAgain I really am very sorry for that mistake

QUESTION 2: Balance Day Adjustments (25 marks)
This is not a typo. Q1 was included in Part A of the assignment, which now continues in Q2.
Below is the unadjusted Trial Balance for Auldana Custom Concrete Foundations as at 30th June
2016.
NOTE: Please use this trial balance to complete the question ( NOT the trial balance you completed in
Part A of the assignment).
ATRIUM FLORAL SUPPLIES
UNADJUSTED TRIAL BALANCE
AS AT 30 June 2017
Debit ($)
18 388
19 685
20 050
5 514
2 676
51 030

Cash at Bank
Accounts Receivable
Inventory
Prepaid Insurance
Office Supplies on hand
Furniture & Fittings
Accumulated Depreciation – Furniture & Fittings
Equipment
Accumulated Depreciation – Equipment
Accounts Payable
Advertising Payable
Loan Payable
Penny’s AFS – Capital
Penny’s AFS – Drawings
Sales Revenue
Sales Returns and Allowances
Cost of Sales
Discount received
Freight inwards
Sales Salary Expense
Delivery Expense
Advertising Expense
Rent Expense
Office Salaries Expense
Electricity Expense
Discount Allowed
Totals

Credit ($)

12 634
74 845
18 120
25 327
1 700
48 805
53 580
36 655
725 900
10 010
162 308
13 096
7 920
66 936
19 692
26 660
27 148
35 150
7 656
6 839
599 162

On the next page is Penny’s information related to the year that ended 30 June 2016.

1

599 162

(1)

A count of the stationery room showed that Office Supplies on hand at 30th June 2016 were
$2 510.

(2)

Both the Furniture & Fittings and the Equipment will be used evenly over their useful lives.
The expected total useful lives and residual values of both assets is as follows:

Furniture & Fittings
Equipment

Estimated Useful life
6 years
10 years

Estimated Residual
$6030
$800

(3)

Interest on the loan is 8.5% per year. Interest accrued but not recorded at 30 th June was
$248.

(4)

In order to allow for cash flow fluctuations, the bank has approved a $25,000 overdraft
facility for Penny’s business bank account.

(5)

The balance in the Prepaid Insurance account represents a 12 month insurance policy that
commenced on 1st March 2017.

(6)

$6 250 of the recorded Sales Revenue is for deposits paid for floral arrangements which will
not be delivered until July/August 2017.

(7)

As of 30th June 2017, Penny has estimated that 2% of her Accounts Receivable will not be
collected.

REQUIRED:
As it i...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags