Answer by word or excel, please

We have the following data

The opening budget of the so-and-so company on 1/1/2020

Assets liabilities

Current assets 230.078,000 current liabilities 51.255,000

Customers 148.070,000 Suppliers 51.255,000

Bank 29.614,000

fund account 17.085,000 long-term liabilities 85.425,000

Goods inventory 35.309,000 loans 85.425,000

fixed asset suppliers

Fixed Assets 162.877,000 Equity 256.275,000

buildings 68.340,000 capital 256.275,000

hardware 56.950,000 The result 0

transportation mechanics 28.475,000

Furniture 9.112,000

Total assets 392.955,000 total liabilities 392.955,000

Then, during the year 2020

15/1 - It bought merchandise on the account in the amount of 79,730,000 LBP.

2/12 - It paid a municipal fee of 5,125,000 LBP. By check

3/18- It sold merchandise on the account for an amount of 136,680,000 LBP.

4 / 20- It paid an amount of 2,847,000 LBP to a supplier. By check

5/9- The advertising expenses are assigned in the amount of 569,000 LBP. Cash

6 / 1- It paid the rent of 1,139,000 LBP. By check

6/20- It bought a car to transport the goods for an amount of 5.695,000 LBP. On account

7/2 - Purchased industrial equipment for the amount of 2,278,000 LBP. On account

7/30 - the interest on the loans was paid in the amount of 5,695,000 LBP. By check

8/8 - A customer paid 22,750,000 LBP in cash

9/27 It paid maintenance and repair expenses - telephone - and electricity, respectively: 2,278,000 LBP. and 569,000 LBP. and 284.750 LBP. In cash

15/11 - the employees' salaries amounting to 5,125,500 LBP were paid. Cash

12 / 22 - Deposit an amount of 16,750,000 LBP. In the bank was withdrawn from the fund

Required:

1. Preparing the necessary daily entries.
2. Posting to the ledger.
3. Preparing the trial balance with totals and balances.
4. Preparing the resulting account until 12/31/2020
5. Preparing the balance sheet on 12/31/2020

Open-ended questions:

• What is the most unusual and illogical item in the financial movements that occurred during the year and why do you classify it as such?
• How do you describe the relationship of current assets to current liabilities?
• Is there a realistic reason for the company to maintain this level of current assets versus fixed assets?