Question

1 Approved Answer

Posted on Jun 28, 2024

Financial Position 1. The percentage of Right-of-use Assets was 0% in 2018. However, it became 1.9% in 2019. This increase means that the company may

Financial Position

1. The percentage of Right-of-use Assets was 0% in 2018. However, it became 1.9% in 2019. This increase means that the company may have introduced new system which is related to Right-of-use Assets in 2019.

2. The increase in retained earnings may indicate that not all earnings derived from operations were returned to shareholders. There is possibility that the company has a plan for expansion where such will be financed from internal sources.

3. Accounts Receivables, Inventory and Investment Properties take up high percentages in Assets. Especially, the percentage of Investment Properties is high. It's 34.04% in 2019.

It is said that companies that have a lot of land are stable so we can say that the company is stable from the point.

4. Accounts and Other Payable, Long-Term Debt- Net Current Portion and Retained Earnings take up high percentages in Liabilities and Equity.

5. There are no big changes in the data of Vertical Analysis on Balance Sheet. So, the company is relatively stable.

LOOK FOR THE RESULT OF OPERATION

ABM-5-Final-Examination-1 - Excel ? 0 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut EX _ AutoSum Arial * 11 - A" A" f Wrap Text General AY H Copy Fill - Paste Format Painter BIU . . D . AGE Merge & Center . $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table Styles Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing A1 AYALA LAND, INC. AND SUBSIDIARIES B E F G H AYALA LAND, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF FINANCIAL POSITION (Amounts in Thousands) O MI A WN - BALANCE SHEET Dec. 31 2019 Dec. 31 2018 Increase (Decrease Assets Amount Percent Current Assets Cash and Cash Equivalents 20,413,041 23,996,570 (3,583,529.00) -14.93% Short-term Investments 617,149 3,085,373 (2,468,224) -80.00% Financial Assets at Fair Value through Profit or Loss 485,436 476,245 9,191 1.93% Accounts and Notes Receivable 105,039,306 126,718,877 (21,679,571) -17.11% 12 Inventories 120,287,686 104,371,611 15,916,075 15.25% 13 Other Current Assets 48,591,632 44,181,222 4,410,410 9.98% 14 Total Current Assets 295,434,250 302,829,898 7,395,648) 2.44% 15 16 Non-Current Assets 17 Non-Current Accounts and Notes Receivable 45,563,869 38,804,937 6,758,932 17.42% 18 Financial Assets at Fair Value through other Comprehensive Income 1,529,179 1,495,795 33,384 2.23% 19 Investments in Associates and Joint Ventures 25,317,581 23,389,752 1,927,829 8.24% 20 Right-of-use Assets 13,564,472 13,564,472 21 Investment Properties 243,043,448 225,005,910 18,037,538 8.02% 2 Property & Equipment 43,062,357 35,749,200 7,313,157 20.46% 23 Deferred Tax Assets - Net 11,527,645 13,040,993 (1,513,348) 11.60% 24 Other Non-Current Assets 34,880,477 28,503,997 6,376,480 22.37% Total Noncurrent Asset 418,489,028 365,990,584 52,498,444 14.34% 26 Total Asset 713,923,278 668,820,482 15,102,796 6.74% 27 28 LIABILITIES AND EQUITY 29 Current Liabilities 30 Short-Term Debt 18.032.830 14.386.717 3.646.113 25 34% Horizontal Analysis Vertical Analysis Financial Ratios + READY Lu 100% 1:08 PM Type here to search 9 5/15/2021 LABM-5-Final-Examination-1 - Excel ? 0 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut Arial * 11 - A" A" AutoSum Ex Wrap Text General EX AY H Copy Fill - Paste BIU . B . D AGE Merge & Center . $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting Table Styles Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing A1 I X V fx AYALA LAND, INC. AND SUBSIDIARIES B D E F G H 13 Other Current Assets 18,591,632 14,181,222 4,410,410 9.98% 14 Total Current Assets 295,434,250 302,829,898 (7,395,648) 2.44% 15 16 Non-Current Assets Non-Current Accounts and Notes Receivable 45,563,869 38,804,937 6,758,932 17.42% 8 Financial Assets at Fair Value through other Comprehensive Income 1,529,179 1,495,795 33,384 2.23% 19 Investments in Associates and Joint Ventures 25,317,581 23,389,752 1,927,829 8.24% 20 Right-of-use Assets 13,564,472 13,564,472 21 Investment Properties 243,043,448 225,005,910 18,037,538 8.02% 22 Property & Equipment 43,062,357 35,749,200 7,313,157 20.46% 23 Deferred Tax Assets - Net 11,527,645 13,040,993 (1,513,348) 11.60% 24 Other Non-Current Assets 34,880,477 28,503,997 6,376,480 22.37% Total Noncurrent Assets 418,489,028 365,990,584 52,498,444 14.34% Total Assets 713,923,278 668,820,482 45,102,796 6.74% 27 28 LIABILITIES AND EQUITY 29 Current Liabilities 30 Short-Term Debt 18,032,830 14,386,717 3,646,113 25.34% 1 Accounts and Other Payables 162,979,169 171,999,422 (9,020,253) 5.24% 32 Income Tax Payable 2,123,379 2,588,669 (465,290) 17.97% Current Portion of Lease Liabilities 724,859 724,859 34 Current Portion of Long-Term Debt 17,250,706 23,265,173 (6,014,467) -25.85% 35 Deposits and Other Current Liabilities 25,472,581 28,544,546 (3,071,965 10.76% 36 Total Current Liabilities 226,583,524 240,784,527 (14,201,003) 5.90% 37 38 Noncurrent Liabilities 39 Long-Term Debt - Net of Current Portion 175,813,345 149,446,949 26,366,396 17.64% 0 Pension Liabilities 1,987,605 1,550,198 437,407 28.22% Lease Liabilities - Net of Current Portion 16,738,846 16,738,846 42 Deferred Tax Liabilities - Net 6,090,754 5,894,705 196,049 3.33% Horizontal Analysis Vertical Analysis Financial Ratios + READY 100% 1:08 PM Type here to search 5/15/2021 LABM-5-Final-Examination-1 - Excel ? 0 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut General EX AutoSum Arial 11 - A" A" Ex Wrap Text AY H Copy Fill - Paste Sort & Find & Format Painter BIU . . D . AGE Merge & Center . $ ~ % " Conditional Format as Cell Insert Delete Format Formatting Table Styles Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing A1 I X V fx AYALA LAND, INC. AND SUBSIDIARIES B D E F G H 37 8 Noncurrent Liabilities 39 Long-Term Debt - Net of Current Portion 175,813,345 149,446,949 26,366,396 17.64% 40 Pension Liabilities 1,987,605 1,550,198 437,407 28.22% 41 Lease Liabilities - Net of Current Portion 16,738,846 16,738,846 42 Deferred Tax Liabilities - Net 6,090,754 5,894,705 196,049 3.33% 43 Deposits and Other Non-Current Liabilities 44,003,636 50,922,906 (6,919,270) -13.59% 44 Total Non-Current Liabilities 244,634,186 207,814,758 36,819,428 17.72% 45 Total Liabilities 471,217,710 448,599,285 22,618,425 5.04% 46 47 48 Equity 49 Equity Attributable to Equity Holders of Ayala Land, Inc. 50 Paid-In Capital 62,772,446 62,350,964 421,482 0.68% 51 Retained Earnings 156,940,236 132,090,020 24,850,216 18.81% 52 Stock Options Outstanding 42,279 65,462 (23,183) 35.41% 53 Remeasurement Loss on Defined Benefit Plans -337,210 219,782 (117,428) 53.43% 54 Fair Value Reserve of Financial Assets at FVOCI 457,358 -454,138 3,220) 0.71% 55 Cumulative Translation Adjustments 250,440 868,271 (617,831) 71.16% 56 Equity Reserves -7,056,459 -7,400,945 344,486 -4.65% Treasury Stock -1,104,353 (1,104,353) 58 211,050,02 187,299,852 23,750,169 12.68% 59 Non-Controlling Interests 31,655,547 32,921,345 (1,265,798) -3.84% 60 Total Equity 242,705,568 220,221,197 22,484,371 10.21% 61 713,923,278 668,820,482 45,102,796 6.74% 62 63 64 65 CONSOLIDATED INCOME STATEMENT 99 (Amounts in Thousands) Horizontal Analysis Vertical Analysis Financial Ratios + READY 100% 1:09 PM Type here to search 5/15/2021 LABM-5-Final-Examination-1 - Excel ? 0 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut Arial * 11 - A" A" Ex Wrap Text General EX AutoSum AY H Copy Fill - Paste BIU . . D . AGE Merge & Center . $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting Table Styles Clear Filter * Select Clipboard Font Alignment G Number Styles Cells Editing A1 I X V fx AYALA LAND, INC. AND SUBSIDIARIES B D E F G H 64 65 CONSOLIDATED INCOME STATEMENT 66 (Amounts in Thousands) 67 Years Ended December 31 Horizontal Analysis 68 2019 2018 Amount Percentage 69 REVENUE Increase (Decrease) 70 Real Estate Sales P157, 848, 573 P155, 954, 816 P1, 893, 757 1 . 218 71 Interest Income from Real Estate Sales 7, 890, 972 7, 042, 078 848, 894 12 . 05% 72 Equity in Net Earnings of Associates & Joint Ventures 965 , 787 749, 924 215, 863 28 . 78% 73 166, 705, 332 163, 746, 818 2, 958, 514 1 . 81: 74 Interest & Investment Income 930, 445 958, 236 (27, 791) -2. 90% 75 Other Income 1, 157, 935 1, 540, 717 (382, 782) -24 . 84% 76 2, 088, 380 2, 498, 953 (410, 573) -16. 43% 77 168, 793, 712 166, 245, 771 2, 547, 941 1 . 53% 78 79 COST AND EXPENSES 80 Cost of Real Estate Sales 94, 751, 939 101, 079, 130 # # # ### # # # # -6.268 81 General & Administrative Expenses 9 , 367 , 359 9, 101, 328 266, 031 2. 92% 82 Interest & Other Financing Charges 12, 199, 758 9, 594, 003 2, 605, 755 27. 168 83 Other Expenses 1, 644, 982 1, 270, 281 374, 701 29.50% 84 117, 964, 038 121, 044, 742 # ## #### # # # -2 .55% 85 86 Income Before Income Tax 50, 829, 674 45, 201, 029 5, 628, 645 12 . 458 87 Income Tax 13, 314, 643 11, 984, 440 1, 330, 203 11 . 108 88 NET INCOME P37, 515, 031 P33, 216, 589 P4, 298, 442 12 . 94% 89 90 91 Horizontal Analysis Vertical Analysis Financial Ratios + READY LT 100% Type here to search Y 1:09 PM 9 5/15/2021 L