b. Total liabilities decreased during the year. The company incurred a loss, and Freda made an additional investment and made no withdrawals. Decrease in liabilities What is the amount of total assets at the end of the year? Owner's equity, end of year Total liabilities, end of year Total assets, end of year c. Total assets increased and total liabilities decreased. There were no additional owner's investments, and Freda made a withdrawal. Increase in total assets Decrease in liabilities Withdrawal during the year What is the amount of profit or loss for the year? Total assets, end of year Liabilities, end of year Owner's equity, end of year Student Work Area Using Excel to Determine Accounting Equation Amounts PROBLEM 6 Zahara Company is owned by Freda Zahara. Answer each 7 of the following independent questions assuming the 8 following amounts at the beginning of the year. 9 10. Beginning of year, total assets Beginning of year, total liabilities 12 13 14 15 16 17 18 19. 20 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. During the year, total assets increased and total liabilities decreased in the following amounts. Increase in assets Decrease in liabilities $130,000 80,000 What is the amount of owners' equity at the end of the year? Owner's equity, beginning of vear Owner's equity, end of year