Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 5R
a.
To determine
Prepare a chart with the given data and explain the objective of preparing the chart.
b.
To determine
Prepare a chart with the given data and explain the trend.
To determine
Prepare the analysis of aging
To determine
Prepare a 3-D column chart to show the total estimated uncollectible accounts expense.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Create a chart that would show the fluctuation of revenue throughout the month.
Put a note in the worksheet stating which day of the month has the highest sale
show the solution using excel
As the bookkeeper of a new start-up company, you are responsible for keeping the chart of accounts up to date. At the end of each year, you analyze the accounts to verify that each account should be active for acumulation of costs, revenues, and expenses.
In July, the accounts payable (A/P) clerk asked you to open an account named New Expenses. You know that an account name should be specific and well defined, and you're afraid the A/P clerk might charge some expenses to the account that are inappropriate.
Respond to the following in a minimum of 175 words:
*Why do you think the A/P clerk needs the New Expenses account?
* Who needs to know this information and what action should you consider?
As the bookkeeper of a new start-up company, you are responsible for keeping the chart of accounts up to date. At the end of each year, you analyze the accounts to verify that each account should be active for accumulation of costs, revenues, and expenses.
In July, the accounts payable (A/P) clerk asked you to open an account named New Expenses. You know that an account name should be specific and well defined, and you're afraid the A/P clerk might charge some expenses to the account that are inappropriate.
Why do you think the A/P clerk needs the New Expenses account?
Who needs to know this information and what action should you consider?
Chapter 6 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- 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.arrow_forwardIf a customer owed your company $100 on the first day of the month, then purchased $200 of goods on credit on the fifth and paid you $50 on fifteenth, the customers ending balance for the month would show a (debit or credit) of how much?arrow_forwardAfter all revenue and expenses have been closed at the end of the fiscal period ended December 31, Income Summary has a debit of 45,550 and a credit of 36,520. On the same date, D. Mau, Drawing has a debit balance of 12,000 and D. Mau, Capital had a beginning credit balance of 63,410. a. Journalize the entries to close the remaining temporary accounts. b. What is the new balance of D. Mau, Capital after closing the remaining temporary accounts? Show your calculations.arrow_forward
- The following information is for Bonnies Buds, a nursery and floral shop, for the month ended May 31, 2012: Click the Chart sheet tab on the FMERCH3 file. You will see a chart depicting the five-month trend in sales, gross profit, and net income. What favorable and unfavorable trends do you see in this month-to-month comparison? Comment on any unusual changes. When the assignment is complete, close the file without saving it again. Worksheet. Your boss would prefer to have the balance sheet shown before the income statement and the statement of retained earnings. Please make this change on the FMERCH3 file. Preview the printout to make sure that the worksheet will print neatly on two or three pages, and then print the worksheet. Save the completed file as FMERCHT. Chart. Using the FMERCH3 file, prepare a 3-D pie chart that shows the amount of each of the selling expenses in June. No Chart Data Table is needed. Select A57 to A62 as one range on the worksheet to be charted and then hold down the CTRL key and select E57 to E62 as the second range. Enter your name somewhere on the chart. Save the file again as FMERCH3. Select the chart and then print it out.arrow_forwardThe general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, 17,731. To test your model, use the following balances at August 31: Print the worksheet when done. Check figure: Total debits, 18,810. CHART (optional) Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.arrow_forwardThis is a continuation of the last problem i submitted to be ansewred. Just a heads up. The following events occur for Morris Engineering during 2021 and 2022, its first two years of operations. February 2, 2021 Provide services to customers on account for $38,000. July 23, 2021 Receive $27,000 from customers on account. December 31, 2021 Estimate that 25% of uncollected accounts will not be received. April 12, 2022 Provide services to customers on account for $51,000. June 28, 2022 Receive $6,000 from customers for services provided in 2021. September 13, 2022 Write off the remaining amounts owed from services provided in 2021. October 5, 2022 Receive $45,000 from customers for services provided in 2022. December 31, 2022 Estimate that 25% of uncollected accounts will not be received. Post transactions to the following accounts: Cash, Accounts Receivable, and Allowance for Uncollectible Accounts. The…arrow_forward
- After preparing and posting the closing entries for revenues and expenses, the income summary account has a debit balance of $28,000. The entry to close the income summary account will be: __ Debit owner Withdrawals $28,000; credit Income Summary $28,000. __ Debit Income Summary $28,000; credit Owner Withdrawals $28,000. __ Debit Income Summary $28,000; credit Owner Capital $28,000. __ Debit Owner Capital $28,000; credit Income Summary $28,000. __ Credit Owner Capital $28,000; debit Owner Withdrawals $28.000.arrow_forwardTake, for example, the following two accounts from an Adjusted Trial Balance: Accounts receivable (Dr. balance $12,000) and Fees earned (Cr. blanche $150,000). The amount in each account once the closing entries have been posted will be the following: Accounts receivable are those that have not been paid yet. $ Fees received in the amount of $arrow_forwardPost the journal entries for the transactions to the following t-accounts. Each of which started the month with a zero balance. *****the drop down options for the first column are: a., b(1), b(2), c(1), c(2), d., e., f., g., h., i. For columns 2 and 3 you input a number for column 4 the drop down options are: a., b(1), b(2), c(1), c(2), d., e., f., g., h., i. to clarify, column 1 starts at the top and ends with "ending balance" column 2 starts at the top and ends with "0" in the photos provided Please don't add numbers to columns 1 or 4 only the drop down letters. Thank you!arrow_forward
- Your company has loaned money to an outside entity. You earned the monthly interest on the loan but have not received the payment yet. The payment is expected to be received next month. To capture the interest expected to be received in the future, you have created account #901, Interest Receivable, in your chart of accounts and booked the journal entry to DR: Interest Receivable and CR: Interest Income. While the basic journal entry was correct, your manager is questioning how you set up this new account. What needs to be corrected in the chart of accounts shown below, and how would you fix it?arrow_forwardYour company has loaned money to an outside entity. You earned the monthly interest on the loan but have not received the payment yet. The payment is expected to be received next month. To capture the interest expected to be received in the future, you have created account #901, Interest Receivable, in your chart of accounts and booked the journal entry to DR: Interest Receivable and CR: Interest Income. While the basic journal entry was correct, your manager is questioning how you set up this new account. What needs to be corrected in the chart of accounts shown below, and how would you fix it? Teacher Feedback: Review the detail type and the account number.arrow_forwardStewart Company received utility bill for the current month of $900 and paid it. Which two accounts are affected? What kind of accounts are they? Do the account balances increase or decrease? Increase Decrease Increase Decrease Do we debit or credit the accounts? Debit Credit Debit Creditarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College