Comprehensive Project Part 1 - Chapters 1-3 solution in excel format
Chapters 1–3
In this project, you will use skills and procedures presented in Chapters 1–3 together as you complete journal entries and financial statements for NJW Corp. Follow all instructions and use the approaches presented in the chapters to create the journal entries and statements in good form. Submit your work per your instructor’s directions.
NJW Corp., located in Milwaukee, WI, repairs collectible toys, including model trains and cars for collectors of all ages. The company is owned and operated by Molly Spencer. As of August 31, 2026, the company had these account balances:
Account
Balance
Cash
$46,200
Accounts Receivable
$7,500
Supplies
$3,400
Furniture
$11,000
Equipment
$4,000
Accounts Payable
$26,300
Interest Payable
$1,200
Molly Spencer, Capital
$?????
ÂÂ
In September, the company had these transactions:
September 1, 2026:    Provided repair services on account, $5,000.
September 3, 2026:    Purchased supplies on account, $1,300.
September 4, 2026:    Sold all the company’s equipment for $4,000 cash.
September 6, 2026:    Earned and received interest revenue, $300.
September 8, 2026:    Purchased furniture for $3,000 cash.
September 12, 2026:  Paid auto expense of $900.
September 15, 2026:  Molly Spencer withdrew $2,500 cash.
September 18, 2026:  Paid interest on account, $800.
September 20, 2026:  Paid creditor on account, $1,000.
September 25, 2026:  Received cash on account, $5,700.
September 29, 2026:  Paid utilities expense of $500.
September 30, 2026:  Determined that supplies on hand totaled $3,700.
Project Requirements
Requirement #1.   Record journal entries for NJW Corp., ensuring each is recorded in proper form, including date and explanation. (Chapter 1)
Requirement #2.   Create an income statement, statement of owner’s equity, and balance sheet for NJW Corp. (Hint: You may want to use T-accounts to update the balances needed to create the statements, which can also be done in Excel!) (Chapter 2)
 Requirement #3.   Use the indirect method to create a statement of cash flows for NJW Corp. (Chapter 3)