Cell Referencing
Using Excel to Record Transactions
PROBLEM
Vaughn Enterprises has the transactions presented in the adjacent work
area during August of the current year.
Student Work Area
Required: Provide input into the shaded answer cells in this template. Use cell references to the Problem
area or work area as indicated.
Journalize the transactions for Vaughn Enterprises that follow.
Aug. 1
Issues shares of common stock to investors in exchange for cash.
$ 65,400
Debit
Credit
Cash
Common Stock
Aug. 4
Pays insurance in advance.
$
2,100
Number of months covered by the insurance
3
Debit
Credit
Prepaid Insurance
Cash
Aug. 16
Receives cash from clients for services rendered.
S
45,600
Debit
Credit
Cash
Service Revenue
Aug. 27
Pays the secretary salary.
$
2,680
Debit
Credit
Salaries and Wages Expense
Cash