Intion: SUM; Formulas: Subtract; Cell Referencing

Student Information

ing Excel to Prepare Financial Statements

PROBLEM

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

$\backslash$table$[[$Oliver Co$.$ Adjusted Trial Balance December $31,2025],[$Cash $$,$$ $19,472,],[$Accounts Receivable,$6,920,],[$Prepaid Rent,$2,280,],[$Equipment$,18,050,],[$Accumulated Depreciation$-$Equipment,,$4,895],[$Notes Payable,,$5,700],[$Accounts Payable,,$5,472],[$Common stock,,$20,000],[$Retained Earnings,,$11,310],[$Dividends$,3,000,],[$Service Revenue,,$11,590],[$Salaries and Wages Expense,$6,840,],[$Rent Expense,$2,260,],[$Depreciation Expense,$145,],[$Interest Expense,$83,],[$Interest Payable,,$83],[,$$ $59,050,$$ $59,050]]$

Data

Income$\_$Stmt

Retained$\_$Earnings$\_$Stmt

Balance$\_$Sheet