Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 6, Problem 4R
Erase the aging information for October and enter the following information for November 30, 2012:
Save the results as AGING4. Print the worksheet. Has the estimated total uncollectible accounts increased or decreased in November? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
differentiate temporary account from permanent account and give example of it.Based on your understanding why it is important to close all temporary accounts at the end of the piscal year?
Please answer both questions
You are at the end of the month, and you have to reset the temporary accounts prior to the new period
starting. You must do the closing entries in order to complete this. Please close the appropriate accounts
using the journal and ledgers again. Make sure to do a post-closing trial balance to ensure you are still in
balance after the closing is finished. Continue to use the Excel templates provided.
Account
Debit
Cash
Accounts Receivable
Equipment
Accumulated Depreciation
Inventory
Accounts Payable
common stock
COGS
Sales
Sales returns
Sales Discounts
Rent Expense
Electric Expense
Depreciation
Shipping Expense
Act. #
100640.00
3000.00
10100.00
850.00
750
500.00
60.00
2000.00
100.00
210.00
200.00
Credit
210.00
11700.00
100000.00
6500.00
Chapter 6 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- I see the end portion. But it doesn't provide how they came up with that answer. Like the journal entries for each year showing all the purchases, adjustments, end of year, etc. Could you break it down by year showing how each one was obtained?arrow_forward2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for cach age category, using the Excel IF and AND FUNCTIONS (fx) to determine wh customer amount belongs. The IF statement may include the following arguments: ,>=, <=, Excel AND FUNCTION (fx).arrow_forwardNote: You must complete parts 1, 2, and 3 before completing part 4 of this comprehensive problem. Based on the following selected data, journalize the adjusting entries as of December 31 of the current year: If an amount box does not require an entry, leave it blank. If no entry is required, select "No Entry Required" from the dropdown and leave the amount boxes blank. a. Estimated uncollectible accounts at December 31, $16,000, based on an aging of accounts receivable. The balance of Allowance for Doubtful Accounts at December 31 was $2,000 (debit). Description Debit Credit b. The physical inventory on December 31 indicated an inventory shrinkage of $3,300. Description Debit Credit c. Prepaid insurance expired during the year, $22,820. Description Debit Credit d. Office supplies used during the year, $3,920. Description Debit Creditarrow_forward
- Match each situation below to two applicable reasons that require an adjustment to be made. A. Revenue has been generated. B. Expense has been incurred. C. Liability has been incurred. D. Liability has been fulfilled. E. Asset has been acquired. F. Asset has been used up. Situation Reasons 1. IBM completed a consulting project for the CDC to simulate the spread of contagious viruses and will be paid next month. 2. This month Apple, Inc., redeemed iTunes gift cards that had been issued last month. 3. Schutt Sports used up some of the benefits of its football helmet manufacturing equipment. 4. Procter & Gamble received a bill for this month's advertising services, which it will pay next month.arrow_forwardPlease assist with question 3arrow_forwardPlease write a general journal and general ledger (date, description, account#, debit, credit).arrow_forward
- Using the ending balances shown in the Partial Adjusted Trial Balance listed below, what is the total dollar ($) balance for the accounts that have a normal credit balance? Fill in the blank with your calculated number. DO NOT include commas, $ signs, period, decimal points, etc., just enter the raw number. Webcourses will add commas to your answer automatically. For example, if you calculated the answer to be $24,123, you would only input: 24123 Partial Adjusted Trial Balance December 31, 20xx Accounts Normal Balance Cash 10,000 Accounts Receivable 5,000 Inventory 150,000 Sales Tax Payable 50,000 Accounts Payable 1,000 Deferred Revenue 10,000 Current Portion Long-term Debt 10,000 Long-term Debt Common Stock 50,000 25,000 Treasury Stock Retained Earnings 3,000 50,000 Dividends 5,000 20,000 Service Revenue Cost of Good Sold 5,000 Rent Expense 5.000 ASUS 13 f4 f5 f6 f7 E3 X f9 f10 f11 4. 5 6 9. C8 图 %24arrow_forwardIf necessary, record year-end adjusting entries for uncollectible accounts.Prepare the aging schedule for the following accounts receivable: Ageing classification (numbers of due days) Balance sheet as at 31 December Estimate of the percentage of the account that is uncollectible 0-30 days $120,000 1% 31-60 days 80,100 2 % 61-90 days 21,000 11% 91- 120 days 9,000 23% Más de 120 days 15,300 65% Total accounts receivable $245,400arrow_forwardI added all the items and got an incorrect for the totals on the spreadsheet and partical complete. I'm not sure what else I'm missing. Please helparrow_forward
- Please answer E4.12 #1-3. Where it says instructions and then instructions for parts a and b. Only part a needs to be done for E4.12 1-3, so part b can be ignored. Thanks.arrow_forwardPrepare the general journal entries to record the accounts receivable 'write-offs' and the 'write-off recoveries' for 2023. Label Debit accounts with "Dr" and Credit accounts with "Cr". For example: (Dr) Asset $XXXXX, (Cr) Revenues $XXXXX. Ignore GST & narrationsarrow_forwardThe fiscal year-end for Mason's Landscaping and Snow Removal is December 31. Record the adjusting entries for December 31, 2014. Hint: It is helpful to record the original transactions (or account balances) in your own rough notes as part of your analysis and calculations of year-end adjusting entries. T-accounts can be very useful for doing this. However, the only entries that should be recorded in the journal for this assignment are the December 31 adjusting entries. The accounts in Mason's ledger are: Bank Accounts Receivable Supplies Prepaid Insurance Prepaid Rent Truck Assignment 1 - Adjusting Entries Accounts Payable Unearned Service Fees Bank Loan B. Mason, Capital B. Mason, Drawings Service Fees Earned Rent Expense Insurance Expense Supplies Expense Office Expense Maintenance Expense Truck Expense Interest Expense 1. On July 1, 2014, a customer signed a contract and agreed to pay $840 for 12 months of landscaping and snow removal services. 2. The balance in the Supplies account…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Accounts Receivable and Accounts Payable; Author: The Finance Storyteller;https://www.youtube.com/watch?v=x_aUWbQa878;License: Standard Youtube License