6a) Complete the attached spreadsheet containing the Worksheet, Income Statement for the year ending 30 June 2021
Fantastic news! We've Found the answer you've been seeking!
Question:
6a) Complete the attached spreadsheet containing the Worksheet, Income Statement for the year ending 30 June 2021 and Balance Sheet as at 30 June 2021.
Transcribed Image Text:
Current Assets Bank Accts Receivable Inventory Non-Current Assets Furniture & Fittings Less: Acc Depn Total Assets 3,500 12,500 10,000 Accounting is Fun Ltd Balance Sheet As at 30 June 2020 26,000 50,000 (5.000) 45,000 $71,000 Current Liabilities Accounts payable 7,000 Accrued wages 500 Non-Current Liabilities Loan Total Liabilities Equity Capital 40,000 Retained earnings 5,000 45,000 Transactions for the year ending 30 June 2021 1. Credit Purchases of inventory $27,500 2. Cash Sales $25,000 3. Credit Sales $32,500 4. Paid Accounts Payable $12,500 5. Paid wages $10,000, wages owing at 30 June 2021 $1,500 6. $6,500 in rent was paid during the year. Rent is charged at $500 per month 7. Collection from Accounts Receivable $15,000 7,500 Total Liabilities & Equity $71,000 18,500 26,000 13. Depreciation of Furniture & Fittings 10% of cost 14. Bad debts written off using the direct method $1,500 15. Dividends paid at 30 June 2021 of $2,000 16. Stock at end of June 2020 $22,500 Note: 8. Interest paid on the Loan $750 9. Insurance expense incurred but not yet recorded $2,500 10. The company paid a subscription of $3,000 relating to the period 1 April 2021 to 31 January 2022 11. The Directors agreed to a wages bonus of $10,000 for good performance this year. It was announced to staff in June but had not been paid as at 30 June 2021 12. Electricity of $2,000 for the period March 2021 to June 2021 not paid Accounts Payable are used for inventory purchases only. Current Assets Bank Accts Receivable Inventory Non-Current Assets Furniture & Fittings Less: Acc Depn Total Assets 3,500 12,500 10,000 Accounting is Fun Ltd Balance Sheet As at 30 June 2020 26,000 50,000 (5.000) 45,000 $71,000 Current Liabilities Accounts payable 7,000 Accrued wages 500 Non-Current Liabilities Loan Total Liabilities Equity Capital 40,000 Retained earnings 5,000 45,000 Transactions for the year ending 30 June 2021 1. Credit Purchases of inventory $27,500 2. Cash Sales $25,000 3. Credit Sales $32,500 4. Paid Accounts Payable $12,500 5. Paid wages $10,000, wages owing at 30 June 2021 $1,500 6. $6,500 in rent was paid during the year. Rent is charged at $500 per month 7. Collection from Accounts Receivable $15,000 7,500 Total Liabilities & Equity $71,000 18,500 26,000 13. Depreciation of Furniture & Fittings 10% of cost 14. Bad debts written off using the direct method $1,500 15. Dividends paid at 30 June 2021 of $2,000 16. Stock at end of June 2020 $22,500 Note: 8. Interest paid on the Loan $750 9. Insurance expense incurred but not yet recorded $2,500 10. The company paid a subscription of $3,000 relating to the period 1 April 2021 to 31 January 2022 11. The Directors agreed to a wages bonus of $10,000 for good performance this year. It was announced to staff in June but had not been paid as at 30 June 2021 12. Electricity of $2,000 for the period March 2021 to June 2021 not paid Accounts Payable are used for inventory purchases only.
Expert Answer:
Answer rating: 100% (QA)
Accounting is Fun Ltd Worksheet for the year ending 30 June 2021 Account Debit Credit Dr Sales 57500 ... View the full answer
Posted Date:
Students also viewed these economics questions
-
For the year ending 30 June 2020, Don Ltd reports a net profit after tax of $6.1 million. At the beginning of the financial year Evita Ltd had 2,500,000 fully paid ordinary shares outstanding. Don...
-
For the year ending June 30, 2012, Aspen Medical Services Co. mistakenly omitted adjusting entries for (1) $2,100 of supplies that were used, (2) unearned revenue of $13,900 that was earned, and (3)...
-
For the year ending June 30, 2008, Microsoft Corporation reported short-term unearned revenue of $13,397 million. For the year ending June 30, 2008, Microsoft also reported total revenues of $60,420...
-
At the current year-end, a company shows the following unadjusted balances for selected accounts. a. After an analysis of future sales discounts, the company estimates that the Allowance for Sales...
-
Fill in the blanks below with terminology that describes the benefits of XBRL for organizations and accountants. a. Consolidate results across ___ with much greater speed and reliability. b. Focus...
-
Since cash generally does not yield a return, why does a company hold cash?
-
Using the basic physical constants, show that \(C_{1}=3.742 \times 10^{8} \mathrm{~W} \mu \mathrm{m}^{4} / \mathrm{m}^{2}\) and \(C_{2}=\) \(1.4389 \times 10^{4} \mu \mathrm{m} / \mathrm{K}\) in the...
-
How might the outcome of this case have been different if Cameron had been merely an aircraft parts supplier, with his only profit to be from the sale of components to Anderson?
-
Calculate the current and quick ratios for Toyota (ticker TM) and Honda (ticker HMC) for the fiscal years 2020-2022 (each fiscal year ends on March 31 of the corresponding calendar year). Comment on...
-
The figure is a schematic drawing of a countershaft that supports two V-belt pulleys. For each pulley, the belt tensions are parallel. For pulley A consider the loose belt tension is 15 percent of...
-
Aqueous aluminum nitrate, Al(NO3)3 (ag) reacts with aqueous ammonia, NH, (aq) to form aluminum hydroxide. Write the balanced molecular and net-ionic equa- tions that describe this reaction. Molecular...
-
When financial reporting fraud is committed, what is generally the target of the "help"?
-
Johnson & Johnson, a multinational health care company responsible for manufacturing medical, pharmaceutical, and consumer goods, has been a leader in promoting a decentralized management structure....
-
Do some background searching and determine the main reasons for visiting a physician in the United States.
-
What is the billing/accounts receivable/cash receipts (B/AR/CR) process?
-
Yoyo Corporation bought \(\$ 42,000\) worth of energy equipment in November 2013, taking an investment credit of \(\$ 4,200\). In March 2018, the firm sells the equipment for \(\$ 30,000\). What is...
-
ASSETS ssi 6- Analysis of the Effects of Capitalizing Versus Expensing 04-19-2017 Exhibit 4 Liberator Medical Holdings Consolidated Balance Sheets at (in thousands) September 30, September 30,...
-
Identify the most stable compound:
-
The pocket of hot air appears to be a pool of water because A. Light reflects at the boundary between the hot and cool air. B. Its density is close to that of water. C. Light refracts at the boundary...
-
Which of these changes would allow you to get closer to the mirage before it vanishes? A. Making the pocket of hot air nearer in temperature to the air above it B. Looking for the mirage on a windy...
-
If you could clearly see the image of an object that was reflected by a mirage, the image would appear A. Magnified. B. With up and down reversed. C. Farther away than the object. D. With right and...
Study smarter with the SolutionInn App