The beginning assets are 720000

File Home Insert Page Layout Formulas Data fax |? A IQ AutoSum Recently Financial Logical Text Date & Lookup Used Time - Referend Insert Function Function Library E10 720000 F D Formula: Add Subtract, Multiply; Cell Referencing 2 BE16 Using Excel to Determine Accounting Equation Amounts 5 PROBLEM 5 At the beginning of the year, Xul Ltd. had the following amounts on its statement of financial position. Use this information to answer each of the following independent Beginning of year, total assets Beginning of year, total liabilities 720000 4,20,000 0 1 2 3 4. 15 16 7 18 19 20 21 22 23 24 25 26 27 28 G H 3 K M Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work area as indicated. a. Xul's total assets increased during the year and total liabilities decreased in the following amounts. Increase in assets Decrease in liabilities $ 2,50,000 80,000 What is the amount of shareholders' equity at the end of the year? Shareholders' equity, beginning of year Shareholders' equity, end of year b. 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 liabilities Net income Issuance of shares $ 1,00,000 90,000 1.25.000 o TIT H J K L Shareholders' equity, beginning of year Shareholders' equity, end of year b. 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 liabilities Net income Issuance of shares $ 1,00,000 90,000 1,25,000 What is the amount of total assets at the end of the 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? H J Net income Issuance of shares K 90,000 1,25,000 What is the amount of total assets at the end of the 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 1,20,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