Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel-Based Assignment #1: Transactions and Financial Statements Download and save file with naming convention EBA1 - Last Name, First Name - Transactions and Financial
Excel-Based Assignment #1: Transactions and Financial Statements Download and save file with naming convention "EBA1 - Last Name, First Name - Transactions and Financial Statements", so mine would be "EBA1-Viers, Gary - Transactions and Financial Statements". This helps me alphabetize and locate your assignment easily. Complete the following Excel-Based Assignment and submit to viersg@uw.edu no later than 1:00 pm on Monday, October 17th. LATE ASSIGNMENTS NOT ACCEPTED. 100 points possible; Perform all tasks as required below, Le cell referencing between Excel tabs, proper account names, etc. Listed below are the transactions of Yasunari Kawabeta, D.D.S, for the month of September Sept 1 Kawabata begins practice as a dontist, invests $20,000 cash, and issues 2,000 shares of $10 par stock 2 Pfrom Genel 4 Pays rent for clice space, 5830 for the month 4 Employs a record 5 Purchases dentalsuppe for cash, 5842 Receives cash of $1,000 from parents for services performed 10 Pays miscanus office xpenses, 543) 14 $3,120 for services pr 18 Pays Green Jacket Co. on account 33 603 1 Payof$3,000 20 Receives $500 from parents on account $2,110 for services performed for $17,280 30 Pays the following expenses in cash sales and wages $1,000), mecneous office expenses $65. 30 Dental pad during September, $390. 30 Depreciation of dents equipment purdissed on September 2 Instructions 1. Crema entries for the above y Use proper account names listed below (part) Enter the transactions shown shown in apporti general ledger accounts (un accounts] Use the following leciger accounts: Cash, Accounts Receivable, Supplies, Equipment, Accumulated Depreciation-Equipment Accounts Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Rent Expense, Office Experse S and Wages Exo, Supples Expense, Depreciation Expers, and Income Summary Record depreciation using a 5-year te on the equipment the straight-line method, and no salvage value. Do not use drawing account Use cell referencing from the Journal entries (Part 1) Into the Ledger (part a &d) for full credit; do not "hard-key" in account entries b. Prepare a vial balance Use cell referencing from Ledger (part &d) to Trial Balance (part) for full credit, do not hard-key" Ledger totals c. Prepare an income statement, a retained earnings statement, and an unclass fed balance shoot Use cell referencing from Trial Balance (part by to Financial Statements (part c) for full credit; do not hard-key" Trial Balance totale d. Close the edger Use cell referencing from temporary hominal Leriger accounts to Income Summary account (part a &d for full credit, do not "hard-key" totals e. Prepare a post-closing trial balance Use cell referencing from Income Summary & Dividends accounts (parta & d) to Post-Closing Trial Balance (parte) for full credit, do not "hard-key" totals
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started