Hi tutor!

Pl3ase answ3r the following in g00gle sheets and/or in g00gle docs in tables and just shar3 me the link after

I will rate the tutor HELPFUL (thumbs up) if answered ASAPin g00gle sheets and/or in g00gle docs in tables and just shar3 me the link after

Thank you!!

REFERENCE/DETAILS BELOW 1. c0nstruct the Horizontal, Vertical, and Trend Ratio of the details below 2. Create Strategies and recommendations for the company

Years Ended December 31 2020 2019 2018 Net income attributable to: Equity holders of the Parent Company P3.216.636.348 P3.918.623.046 P5.107.328,539 Non-controlling interest in consolidated subsidiaries 268.978.049 631.664.763 717.808.885 P3.485.614.397 P4.550.287.809 P5.825.137.424 Total comprehensive income attributable to: Equity holders of the Parent Company P3.319.269,860 P4,755.279.388 P4,253.812.839 Non-controlling interest in consolidated subsidiaries 241.726.368 620.379.311 749.370.451 P3.560.996.228 P5.375.658,699 P5.003,183,290 Basic/Diluted Earnings Per Share (Note 26) P2.05 P2.49 P3.65 See accompanying Notes to Consolidared Financial Statements.ROBINSONS RETAIL HOLDINGS, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Years Ended December 31 2020 2019 2018 SALES - Net of sales discounts and returns (Notes 6, 20 and 24) P151,070,260,790 P162,915,687,301 P132,680,466,776 COST OF MERCHANDISE SOLD (Notes 6 and 9) 118,172,338.279 125.734.533.662 102.845.384,354 GROSS PROFIT (Note 6) 32,897,922.511 37,181,153.639 29.835.082,422 ROYALTY, RENT AND OTHER REVENUE (Notes 6, 20, 24 and 29) 1.618,219.672 2,740,181.024 2,422,195.884 GROSS PROFIT INCLUDING OTHER REVENUE ( Note 6) 34.516.142.183 39.921.334.663 32.257.278.306 OPERATING EXPENSES (Notes 21, 22, 23, 28 and 29) (28.736.744.849) (32,123,178.669) (25.631,402,164) OTHER INCOME (CHARGES) Interest income (Notes 6, 7 and 1 1) 676.545.269 1,015,573,149 981.862.604 Equity in net earnings in associates (Notes 6 and 13) 196.514,026 104,749,733 108,739.236 Dividend income (Notes 6 and 1 1) 27,347.725 100,315,156 111,500.000 Foreign currency exchange gains (loss) - net (Note 6) (170.615,372) (134,619.196) 200,867,038 Interest expense (Notes 6 and 17) (2,326,256,810) (2,578,499.847) (159,071,734) Others (Notes 1 1, 14. 19 and 28) 235,944.534 (196.094.467 (272.614.314) 1.360,520,628 1,688.575,472 971,282,830 INCOME BEFORE INCOME TAX (Note 6) 1.418,876.706 6.109.580.522 7.597.158.972 PROVISION FOR INCOME TAX (Note 25) Current 1,422.672,062 2,056,973.505 1,807,600,901 Deferred (489.409,753) (497,680,792) (35,579.353) 33.262.309 1,559.292.713 1,772,021.548 NET INCOME 3,485.614,397 4.550,287.809 5.825,137,424 OTHER COMPREHENSIVE INCOME (LOSS) Other comprehensive income (loss) to be reclassified to profit or loss in subsequent periods: Changes in fair value of debt securities at fair value through other comprehensive income (FVOCI) (Note 11) 168,422,421 769,066,737 (922,610,678) Share in change in fair value of debt financial assets in associates (Note 13) 95,150.278 411,345,068 (23,818,458) Share in change in translation adjustment in associates (Note 13) 34,967,113 3,656.329 (6,962,641) Cumulative translation adjustment (56,091,667) (40,371,837) 36,670,185 Income tax effect (39,035,217) (124,500.419) 9.234,330 Other comprehensive income (loss) not to be reclassified to profit or loss in subsequent periods: Changes in fair value of equity securities at FVOCI (Note 11) 20,836.500 67,083,500 (153,600,000) Share in actuarial gain (losses) on retirement obligation in associates (Note 13) 840.628 (8,190,337) (1,243,379) Remeasurement gain (losses) on retirement obligation (Note 23) (181.971,717) (364,536,075) 342,862,134 Income tax effect 32.263,492 111,817.924 (102,485.627) 75.381,831 825,370,890 (821,954,134) TOTAL COMPREHENSIVE INCOME P3.560.996.228 P5,375,658,699 P5,003,183.290