50.1K

Verified Solution

Link Copied!

I also need to use cell references and formulas in excel, so if you could include those, and preferably i would like the answer in the same "table" format

Prepare the income statement. Fill in the blue shaded areas using a formula that references the account balances at the end of the

month in the ENTERANSWERS$1$ tab.

$($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab or if you type the

D$12$:D$13|$ Expenses should be entered as positive numbers in the income statement.

Cell Hint:

HINTS Prepare the statement of owner's equity. Fill in the blue shaded areas using a formula that references the account balances at the end of the month

the ENTERANSWERS$1$ and the ENTERANSWERS$2$ tabs$.$

$($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab or if you type the num ENTERANSWERS$1$ and the ENTERANSWERS$3$ tabs$.$

$($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$pa:

Total Assets

$

Liabilities

Owner's Equity

Total Liabilities and Owner's Equity

$Prepare the statement of cash flows. Fill in the blue shaded areas using a formula that references the changes in the account balances $d$

transaction in the ENTERANSWERS$1$ tab. Be sure that the amount is entered as a negative number if it is an outflow.

Do not use an equal sign $(=)$ when entering a numeric value. Enter value in all answer boxes, even if answer is $0.$

$($Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab or if you ty

Cash Flows from operating activities:

Receipts:

HINTS

Cell Hint:

E$13$:E$24|$ Be sure that the amount is entered as a negative number if it is an outflow.

Show all imagesShow all images

Answer & Explanation Solved by verified expert

See Answer