Pre-Knowledge Assesment


ACTG 381
Pre-requisite Knowledge Assessment
Winter 2021
Purpose of the Assessment: This take home assessment has been designed as a review of the pre-requisite accounting knowledge necessary to be successful in ACTG 381. This assessment focuses on recording basic accounting transactions/journal entries, understanding T accounts, and creating a set of financial statements. It is also intended as an opportunity to practice using basic Excel functions. The accounting issues included in this assessment are assumed to have been covered in your prerequisite financial accounting course. If you need a reference, you could refer to the textbook from your pre-requisite accounting course, WileyPlus Chapter 0, Chapter 3 in the textbook for this class, or the ACTG 381 Boot Camp on your D2L page.
Possible Points: 25 points; 20 for accounting accuracy and 5 for appropriate Excel technique (i.e., internal referencing among spreadsheets, auto-sum, dr/cr control total, formatting).
Due Date: Your Excel file should be turned in to D2L Assignments by 10pm on Saturday, January 9th. Late assignments will receive a score of zero as the solution will be posted on D2L by 11pm the same evening. If you are unfamiliar with D2L, please refer to
Background: Nguyen Service Corporation (Nguyen) was founded in 2012 by Judy and Julie Nguyen. The company repairs espresso machines and grinders for coffee shops and other types of clients. Judy and Julie decided to start the company when they realized it was the perfect way to combine their love of coffee and mechanical systems. Nguyen employs a few field technicians and sales people as well as an MBA, Darrell Johnson. To date Darrell has been doing all the accounting for the company. In January 2020, Nguyen hires you as an accounting intern.
Darrell Johnson has just provided you with the attached beginning balances for 2020. Assume this trial balance has been correctly prepared. Use the balances in the 1-1-20 Trial Balance tab as your beginning balances for all T-Accounts. This should be completed through the use of Excel formulas rather than retyping the numbers in the T-accounts. See the Beginning Balance in the Cash T-account for an example. Nguyen’s year end is December 31st.
(A) Using the Excel General Journal spreadsheet in this file, record the 2020 transactions listed below AND the necessary year end adjusting journal entries. Label the transactions in numeric sequence corresponding to the numbers below. Each of the transactions below requires a journal entry. Note that there is a debit and credit control total at the top of the general journal so that you can check after each entry to see if you are in balance.
1. Issued an additional 100,000 shares of common stock on January 2. The stock was sold for $200,000, which equals the par value of the stock.
2. Purchased equipment for $24,000 cash on January 3.
3. Received cash payment of $12,000 for outstanding accounts receivable on January 5.
4. Provided services on account to clients for $16,000 on February 10.
5. Received bill and paid utilities of $15,000 on Feburary 28.
6. On March 23, provided services for clients, for which $20,000 was collected in cash and $44,000 was billed to the clients.
7. Paid employee salaries of $46,500 on April 2.
8. Collected $51,200 on outstanding accounts receivable on April 15.
9. Incurred legal fees of $13,000 on May 24, but did not pay for these services.
10. Declared and paid dividends to stockholders of $22,000 on June 10.
11. Paid $45,000 for a three-year insurance policy on July 6 with coverage beginning on October 1.
12. Collected $63,000 on July 20 for services to be provided over the coming year.
13. Paid $8,000 on August 15 related to legal fees incurred on May 24.
14. Sold land with cost of $100,000 for $88,000 cash on September 25.
15. Paid $2,500 in interest costs related to the Long Term Notes Payable on November 15.
Darrell also provided you the following information that she thought may be helpful in preparing the year-end financial statements.
16. Nguyen received a information from a field technician indicating that services amounting to $5,800 had been provided that need to be billed to customers and recorded.
17. Nguyen depreciates its equipment at a rate of $6,000 per year. Depreciation expense has not been recorded as of December 31.
18. Nguyen has incurred salaries of $15,600 at the end of the year. The next payroll date is January 2 of the following year. (Ignore payroll taxes and withholdings)
19. For the service revenue collected on July 20 (#12 above), Nguyen estimated that 60% of the amount collected in advance had been earned by the end of the year.
20. As of December 31, Nguyen has not recorded any insurance expense for the year. The only insurance policy it owns is the one purchased in #11 above.
Note: Do not prepare the closing journal entries at this point! Closing journal entries should be prepared as part of step C below.
(B)   “Post” journal entries 1-20 from the General Journal to the Excel spreadsheet of T-accounts in this file. All necessary T-accounts have been provided. This should be completed through the use of Excel formulas rather than retyping the numbers in your T-accounts. Please also place the number of each transaction next to each journal entry (see transaction ‘1’ in the Excel T-Account sheet for an example) and be sure to create formulas so that each T-account automatically calculates its ending balance (see the Cash and Common Stock t-accounts for examples of both a debit and credit account formula). TIP: Set up your spreadsheet to have debit and credit control totals so that you can check after each entry to see if you are in balance.
(C)   In Excel, prepare a balance sheet as of 12/31/20 and a SINGLE-STEP income statement for the year ended 12/31/20. This should be completed through the use of Excel referencing formulas rather than retyping the ending balances from your T-accounts in the financial statements. (Note that at this point your balance sheet will be out of balance because Retained Earnings hasn’t yet been updated!) After you have prepared your balance sheet and income statement, prepare closing entries in the General Journal but do not post them to the T-accounts so that the pre-closing ending balances continue to flow to the Income Statement using the Excel referencing formulas. Then the final Net Income amount from your Income Statement should be referenced using Excel formulas to the Statement of Retained Earnings. Once reconciled, your ending Retained Earnings balance should be referenced using Excel formulas back to your 12/31/20 Balance Sheet. You do NOT need to prepare a Statement of Shareholders’ Equity or Statement of Cash Flows. Income taxes should be ignored.

Trial Balance 1-1-20

Unadjusted Trial Balance
General Ledger Account Name1/1/20
DebitCreditNote: All the accounts in this trial balance
Cash54,150will be used. No additional accounts are needed.
Accounts Receivable18,000
Prepaid Insurance0
Accum Depreciation12,000
Accounts Payable2,150
Unearned Service Revenue0
Salaries Payable0
Long Term Notes Payable25,000
Common Stock60,000
Retained Earnings125,000
Service Revenue
Loss on Sale of Land
Depreciation Expense
Insurance Expense
Legal Fees Expense
Interest Expense
Salaries Expense
Utilities Expense
Total224,150224,1500.00Control totals

General Journal

Nguyen Service Corporation
General Journal
200,000200,000(Control totals)
Common Stock200,000
To record issuance of common stock.


Nguyen Services CorporationNAME:
DR total
CR total
CashAccounts ReceivablePrepaid Insurance
EquipmentAccum DepreciationLand
Accounts PayableUnearned Service RevenueSalaries Payable
Long Term Notes PayableCommon StockRetained Earnings
DividendsService RevenueLoss on Sale of Land
Salaries ExpenseLegal Fees ExpenseInterest Expense
Insurance ExpenseDepreciation ExpenseUtilities Expense

Income Statement

Student Name:
Nguyen Service Corporation
Income Statement or Profit and Loss Statement
For the Year Ended 12/31/20
Revenues and Gains
Service Revenue$ – 01 pt
Total Revenues
Expenses and Losses
1 pt
1 pt
1 pt
1 pt
1 pt
1 pt
1 pt
Total Expenses
Check Figure
Net Income$ 9,250
Total 8 pts

Balance Sheet

Student Name:
Nguyen Service Corporation
Balance Sheet
December 31, 2020
Cash$ 254,1501 pt
1 pt
1 pt
Total Current Assets
1 pt
1 pt
Total Assets
1 pt
1 pt
1 pt
Total Current Liabilities
1 pt
Total Liabilities
Stockholders’ Equity
1 pt
Retained Earnings125,0001 ptThis should be referenced from the Stmt of Retained Earnings
Total Stockholders’ Equity1 pt
Total Liabilities and Stockholders’ Equity
Total 12 pts
Note: Prepaid Insurance can be shown as all CA or split between CA and LT
Check FigureTotal Assets445,200

Statement of Retained Earnings

Student Name:
Nguyen Service Corporation
Statement of Retained Earnings
For the Year Ended December 31, 2020
Beginning Retained Earnings$ 125,000
Net Income– 0
Less: Dividends– 0
Ending Retained Earnings$ 125,000
Note: Per instruction C, to calculate Ending Retained Earnings you should
use Excel formulas to pull values in from the appropriate T accounts.
Ending Retained Earnings calculated here should flow into the 12/31
Balance Sheet.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Writall
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Thank you!
Customer 455509, May 26th, 2023
Public Relations (PR)
Thank you
Customer 454893, September 9th, 2022
Social Work and Human Services
Customer 453933, October 27th, 2020
I got an A thanks.
Customer 453877, October 30th, 2020
Health Care
Thank you very much :)
Customer 455247, February 6th, 2022
IT, Web
Good job
Customer 455223, December 21st, 2021
Very Well structured essay and On-time!
Customer 455059, November 3rd, 2021
Absolutely incredible service. Thank you
Customer 454925, May 15th, 2022
Business Studies
Excellent work
Customer 454241, November 28th, 2020
Greater than anticipated. Thanks for the start.
Customer 454569, November 8th, 2020
thank you custom scholars. you are awesome
Customer 454893, January 30th, 2022
I've used this service 3 times and this was by far the best paper I've received. Awesome job by the writer. Thank you for the assistance!
Customer 455113, November 22nd, 2021
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live Chat+1(978) 822-0999EmailWhatsApp