Function: SUM; Formulas: Subtract; Cell Referencing Using Excel to Prepare Financial Statements

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Input mathematical

formulas with cell references to the Problem area in the Data worksheet or to the student work

area in this worksheet as indicated.

a$.$ Prepare an income statement. List expense accounts alphabetically. Display all values as

positive amounts.

Oliver Co$.$

Income Statement

For the Year Ended December $31,2025$

$/$

Using Excel to Prepare Financial Statements

PROBLEM

The adjusted trial balance of Oliver Co$.$ as of December $31,2025,$ contains the

following.

Student Information

This is a multi$-$sheet worksheet exercises. For each financial statement on

subsequent worksheets, input mathematical formulas with cell references

to the Problem area in this Data worksheet, or to the student work area

of another worksheet as indicated.

Prepare financial statements for Oliver Corporation on the following

respective worksheets.