Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Avinash chand 85 3 A B c D E F G H K 1 M N P R s T U ear provisions as Unearned Incurred Loans Other per balance Premium Admitted But Not Investme (Part of Current Company sheet Provisions Claims Reported nts assets) assets 2016 BSP HEALTH 12,172 10,082 1,401 691 9,541 0 8,843 2017 BSP HEALTH 15,912 12,664 2,241 1,007 13,537 0 10,437 2018 BSP HEALTH 0 0 0 0 616,464 72,809 15,621 2019 BSP HEALTH 15,262 11,491 2,663 1108 15,500 0 11,392 2020 BSP HEALTH 15,699 12,367 2,531 801 8,000 0 21,301 From your dataset calculate return on equity (ROE) for each year, with a trend analysis, and comment on the firm performance Conting Manageme Net Borrowin ent Net Net Net NON- nt/Adminis profit Net Fixed Intangible Total Other gs Total Liabilit Total Premium Eamed Claims Underwriting Underwriting underwriti trative before profit Year Assets Assets Assets Provisions (Liability) liabilities y Equity Inome Premiums Incurred Expenses Surplus/Deficit ng income expenses tax after tax 2016 486 18,670 219 13,862 50 4,808 16,651 15,298 10,056 1827 3,415 360 3,223 522 534 2017 261 24,271 276 18,222 85 6,049 21,224 18,640 12,667 2,219 3,744 548 3,314 978 753 2018 1,301 10,355 720,794 20.030 633,828 530 86,966 68,006 0 0 0 0 0 25,359 21,835 2019 287 17.940 813 9.239 20.646 20,817 14, 276 2,471 4,070 862 2.997 1.935 19525 2020 431 29,732 19,472 36 10,260 21.055 20,179 13,480 2,504 4192 874 3.763 1,303 0 ooooo 0 0