Using Excel to Determine Accounting Equation

Amounts

PROBLEM

Zahara Company is owned by Freda Zahara. Answer

each of the following independent questions assuming

the following amounts at the beginning of the year.

Beginning of year, total assets

Beginning of year, total liabilities

$$850,000$

$550,000$

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$.$ 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 year

Owner's equity, end of year