M N O Formula: Add Subtract, Multiply: Cell Referencing Student Work Area Required: Provide input into cols shaded in yellow in this template Use mathematical formulas with oel references to the Problem and work area as indicated. BE1.6 Using Excel to Determine Accounting Equation Amounts PROBLEM At the beginning of the year. Xullid, had the followng amounts on its statement of financial position. Use this information to answer each of the following independent questions 10 Beginning of year, total assets $ 720.000 11 Beginning of year, total abilities 420,000 12 11 16 15 10 17 a. Xul's total assets increased during the year and total abilities decreased in the following amounts Increase in assets $ 250,000 Decrease in abilities 80,000 What is the amount of shareholders' equity at the end of the veart 18 19 30 21 22 14 21 Shareholders' equity, beginning of year Shareholders' equity, end of year . During the year, Xul's total liabilities decreased. The company reported net income, sold additional shares, and did not declare any dividends during the year. Decrease in tablities $ 100.000 Net Income 90,000 Issuance of shares 125,000 What is the amount of total assets at the end of the year? Shareholders' equity, and of year Total abilities, and of your HE 15 Total assets, end of year c. Xul's total assets decreased during the year and shareholders' equity increased 41 Decrease in total assets Shareholders' equity increase $ 90,000 120.000 45 What is the amount of total lalities at the end of the year? Enter Answer Total assets, end of year + F G H K my wo your currar MOU WOUTUUvou Toompany reported net income, sold additional shares, and did not declare any dividends during the year. Decrease in liabilities Net income Issuance of shares $ 100,000 90,000 125,000 What is the amount of total assets at the end of the year? Shareholders' equity, end of year Total liabilities, end of year Total assets, end of year C. Xul's total assets decreased during the year and shareholders' equity increased. Decrease in total assets Shareholders' equity increase $ 90,000 120,000 What is the amount of total liabilities at the end of the year? Total assets, end of year Shareholders' equity, end of year Total liabilities, end of year