Please complete the following in Excel and show formulas. Many thanks!

According to the Insurance Information Institute (III), the largest writer of property/casualty insurance by direct premiums written in 2020, is State Farm Mutual Automobile Insurance. The 2020 annual report to policy holders can be found below and contains data for 2019 and 2020: To forecast 2021 values, assume that the growth rate in the values between 2020 and 2019 will remain the same for 2021. To calculate the 2021 values (where X is any specific variable), apply the Future Value formula

Part 1: Balance Sheet Fill in the assets portion of the table and calculate Total Assets Fill in the liabilities portion of the table and calculate Total Liabilities Fill in the surplus portion of the table and calculate Surplus

STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY Statement of Condition (In Millions of dollars) Assets 2020 2019 Cash and Short Term Investments $ 3,969 $ 2,434 Bonds 58,902 55,759 Unaffiliated Common & Preferred Stocks 65,404 58,802 Equity in Insurance Subsidiaries 46,160 45,233 Other Assets 19,500 16,248 Total Assets Liabilities Claims and Claim Expenses $ 31,701 $ 32,544 Unearned Premiums 12,688 13,022 Other Liabilities 23,494 16,752 Surplus Funds for Protection of State Farm Mutual Policyholders, including the Investment Fluctuation Reserve $ 75,649 $ 65,907 Funds Assigned for Protection of Customers of Subsidiaries 46,542 47,141 Funds Assigned for Catastrophe Reinsurance Assumed from Affiliates 3,861 3,110 Total Liabilities and Surplus Summary of Operating Data (in Millions of dollars) 2019 Premium Earned $ 41,986 $ 42,137 Less:Dollars for Claims 22,748 27,536 Expenses for Paying Claims 4,679 5,065 Service and Administrative Fees 10,144 10,299 Underwriting Gain or (Loss) 4,415 (763) Plus: Investment Gain and Other Income 2,659 3,456 Income before Dividends and Taxes 7,074 2,693 Less: Dividends to Policyholders 1,929 0 Income Taxes Incurred (Recoverable) 927 383 Net Income 2020 2019 2020 Growth Rates 2021 5 7 Part 1) Balance Sheet 8 9 A) 10 11 Assets 12 Cash and Short Term investments 13 Bands 14 Stock 15 Equity in Subsidiaries 16 Other Assets 17 Total Assets 18 19 B) 20 21 Liabilities 22 Claims and Claim Expenses 23 Unearned Premiums 24 Other Uabilities 25 Total Liabilities 25 27 C 28 29 Surplus 30 Protection of Policyholders 31 Protection of Customers of Subsidiaries 32 Catastrophe Reinsurance Assumed from Affiliates 33 Surplus 34 35 Total Liabilities and Surplus 35 2019 2020 Growth Rates 2021 2019 2020 Growth Rates 2021