In: Accounting
Listed below are year-end, 12/31/21, account balances ($ in thousands) taken from the records of XYZ Corporation.
XYZ Corporation |
|||
Adjusted Trial Balance |
|||
December 31, 2021 |
|||
Debit |
Credit |
||
Accounts receivable |
700 |
||
Building |
480 |
||
Equipment |
375 |
||
Cash |
125 |
||
Inventory |
90 |
||
Land |
300 |
||
Notes receivable |
530 |
||
Investments |
330 |
||
Prepaid rent (for the next 2 years) |
50 |
||
Supplies |
20 |
||
Trademark |
50 |
||
Prepaid Insurance (for the next 3 years) |
90 |
||
Accounts payable |
620 |
||
Accumulated depreciation- Equipment |
225 |
||
Accumulated depreciation- Buildings |
180 |
||
Total stockholders' equity |
1110 |
||
Dividends payable |
50 |
||
Income tax payable |
80 |
||
Allowance for Doubtful Accounts |
55 |
||
Notes payable |
600 |
||
Interest payable |
60 |
||
Deferred revenue |
160 |
||
TOTALS |
3,140 |
3,140 |
Additional information and requirements:
Additional information: |
1. Land includes land held a possible future plant site $125K and land for the current plant site $175K. |
2. The notes receivable are due in 2023. The balance of $530 includes $30 of accrued interest. The next interest payment is due in July 2022. |
3. Included in the investments are treasury bills of $70K that were purchased in November 2021 and mature in January, 2022; trading securities of $100 which are expected to be sold within the next year. The balance represents securities expected to be held longer than one year. |
4. As of 12/31/21, Stockholders' equity has common stock, $1.00 par value, authorized 300K shares, and issued 150K shares at an average price of $4.50. The remaining balance in stockholders’ equity is retained earnings. |
5. The note payable represents a 12% note, with interest paid annually February 28. The note matures in installments of $100 beginning 2/28/22. |
6. Deferred revenue will be recognized equally over the next 24 months |
1.) Prepare a classified balance sheet for XYZ Corporation at
December 31, 2021. Complete the questions on the following page
about the balance sheet.
2.) Calculate the following ratios :
Current ratio = |
|
Debt to equity ratio = |
|
Acid-test (quick) ratio = |
|
Working capital = |
Thank you so so so so so so so so so much :)
Balance Sheet as at 31st December, 2021 | |||||
Particular |
As At December 31, 2021 |
||||
A | EQUITY AND LIABILITIES | ||||
1 | Shareholders’ Funds | ||||
(a) Stake holder's Equity | 675.00 | ||||
(b) Retained Earning | 435.00 | ||||
2 | Non-current Liabilities | ||||
(a) Notes Payables | 600.00 | ||||
(b)Deffered Revenue | 80.00 | ||||
3 | Current Liabilities | ||||
(a) Short-term Borrowings | |||||
(b) Accounts Payables | 620.00 | ||||
(c) Divident Payable | 50.00 | ||||
(d) Income Tax Payable | 80.00 | ||||
(e) Interest payable | 60.00 | ||||
(f)Deffered Revenue | 80.00 | ||||
TOTAL | 2,680.00 | ||||
B | ASSETS | ||||
1 | Non-current Assets | ||||
(a) Fixed Assets | |||||
Building | 480.00 | ||||
Less: Accumulated Depreciation | 180.00 | 300.00 | |||
Equipment | 375.00 | ||||
Less: Accumulated Depreciation | 225.00 | 150.00 | |||
Land | 300.00 | ||||
b)Investments | 160.00 | ||||
(c) Notes Receivables | 500.00 | ||||
2 | Current Assets | ||||
(a) Inventories | 90.00 | ||||
(b) Account Receivables | 700.00 | ||||
Less: Allowance for Doubtful Accounts | 55.00 | 645.00 | |||
(c) Accrued Interest on Notes Receivables | 30.00 | ||||
b)Investments | 170.00 | ||||
(d) Cash and Bank Balances | 125.00 | ||||
(d) Trade Mark | 50.00 | ||||
(d) Supplies | 20.00 | ||||
(e) Prepaid Rent | 50.00 | ||||
(e) Prepaid Insurance | 90.00 | ||||
TOTAL | 2,680.00 | ||||
Ner Account Receivable | 645.00 | ||||
Total Current Asset | 1,270.00 | ||||
Total Investment (Long term) | 160.00 | ||||
Net Buildings | 300.00 | ||||
Total PPE , Net | 150.00 |
Current Ratio | = Current asset/Current Liability | =1270/890 | |
=1.43 | |||
Debt/Equity Ratio | = Debt/Equity | =600/1110 | |
=0.54 | |||
Acid Test Ratio | |||
= | Cash + Current Receivables + Short Term Investments | ||
Current Liabilities | |||
= | 125 | +647+170 | |
890 | |||
= | 1.058427 | ||
Working Capital | = Current asset - Current Liability = | 380.00 | |