FCNC Accounting Question Excel

Description

1 attachments

Slide 1 of 1

attachment_1

attachment_1

Unformatted Attachment Preview

Date
Account
02.01.2022
02.01.2022
20.02.2022
20.02.2022
15.04.2022
15.04.2022
01.05.2022
01.05.2022
20.12.2022
20.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
31.12.2022
Debit
🙂
SR 0.00
The following are the transactions during 2022:
02.01.2022 Purchases a shop in Panorama mall, in cash
20.02.2022 Purchases merchandise, in cash
15.04.2022 Sales merchandise, in cash
01.05.2022 Our customer returns 200 units of the 15.04.2022 sale
20.12.2022 Pays youtube advertising campaign for period 01.01.2023-30.06.2023
31.12.2022 Customer goes bankrupt. The account receivable is written off
31.12.2022 Revalues land to:
31.12.2022 Depreciation: 18%, straight line, no resale value (monthly basis)
31.12.2022 Closes beginning inventory
31.12.2022 Records the ending inventory
31.12.2022 Revenues & expenses balanced off
Assignments
1 Record the above transactions on the journal
2 Transfer the journal entries to the T-accounts
3 Prepare the trial balance (appears below)
4 Based on the trial balance, prepare the financial statements:
a) 31.12.2022 statement of financial position
b) 2022 P&L and other comprehensive income
c) 2022 Statement of changes in equity
5 Look on the internet for the financial statements of:
SR 860,000.00
SR 62,000.00
SR 204,000.00
SR 18,000.00
SR 80,000.00
SR 25,000.00
SR 480,000.00
TBD
SR 55,000.00
SR 60,000.00
TBD
Alphabet Inc.
Write on the boxes:
The date the last financial statements refer to ? ? ? ? ? ? ?
Total non curr. assets shown on last available balance sheet ? ?
Total revenue shown on last available P&L ? ? ? ? ? ? ? ?
ACCOUNT
TRIAL BALANCE
31.12.2022
DEBIT
SR 0.00
Credit
A=E+L
b/f
Cash
SR 1,500,000.00
Capital
SR 1,830,000.00
Accounts receivable
SR 25,000.00
SR 0.00
b/f
Inventory (merchandise)
SR 55,000.00
b/f
Land
SR 250,000.00
TRIAL BALANCE
31.12.2022
CREDIT
SR 0.00
DEBIT BALANCE
CREDIT BALANCE
SR 0.00
SR 0.00
BALANCE
SR 0.00
apital
ts receivable
b/f
A=E+L
Non-current assets
Land
Statement financial position
Equity
SR 250,000.00 Capital
Non-current liabilities
Current assets
Inventory (merchandise)
Accounts receivable
Cash
SR 55,000.00
SR 25,000.00
SR 1,500,000.00
Current liabilities
Total
A=E+L
Non-current assets
SR 1,830,000.00
Statement financial position
Equity
Current assets
Non-current liabilities
Current liabilities
Total
SR 0.00
P&L and other comprehensive income
Revenues
Cost of sales
Gross profit
Selling
Administrative
Operating profit
Finance cost
Profit before tax
Income tax
Net profit
Other comprehensive income
Total comprehensive income for the year
Statement of changes in equity
Equity share
capital
Revaluation
surplus
P&L
Balance
01.01.2022
Profit or loss
Revaluation of N/C Assets
Issue of share capital
Balance
31.12.2022
SR 0.00
SR 0.00
SR 0.00
01.01.2022
SR 1,830,000.00
Non-current liabilities
Current liabilities
Total
SR 1,830,000.00
31.12.2022
Non-current liabilities
Current liabilities
Total
SR 0.00
2022
SR 0.00
Retained
earnings
Total
SR 0.00
SR 0.00
SR 0.00
SR 0.00
SR 0.00
SR 0.00
SR 0.00
SR 0.00
SR 0.00

Purchase answer to see full
attachment

Explanation & Answer:

1 Excel Sheet

User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.