Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
thumb_up100%
Chapter 22, Problem 2R
Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.
Illustrate the effects of accepting the note from Valley Designs on the accounts and financial statements of Bork Furniture Company.
Financial Statement Effects
Balance Sheet
Assets
=
Liabilities
+
Stockholders' Equity
+
=
+
Apr. 20.
fill in the blank 5
fill in the blank 6
fill in the blank 7
fill in the blank 8
Statement of Cash Flows
Income Statement
fill in the blank 10
fill in the blank 12
b. Determine the due date of the note.
c. Determine the maturity value of the note. To simplify, use 360 days per year to compute interest.$fill in the blank 14
d. Illustrate the effects of receiving payment of the note from Valley Designs at its maturity on the accounts and financial statements of Bork Furniture Company.
Financial Statement Effects
Balance Sheet
Assets
=
Liabilities
+
Stockholders' Equity
+
=
+
Aug. 18.
fill in the blank 19
fill in the blank…
Based on the provided information in the attached image, please calculate the following simpe equations; (It's super simple, just tiny simple mathematical calculations that should take only 2 minutes, I'm just lost with the wording...)
Average collection period, =
Days to sell inventory, =
Accounts payable payment period, =
Amborse's cash-to-cash cycle, =
The company's bank loan =
Chapter 22 Solutions
Excel Applications for Accounting Principles
Ch. 22 - Ranger Industries has provided the following...Ch. 22 - Open the file MASTER from the website for this...Ch. 22 - Review the completed master budget and answer the...Ch. 22 - Suppose the company has to revise its estimates...Ch. 22 - Suppose the company has just the opposite news and...Ch. 22 - Prob. 6R
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
- The 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_forwardKelly Jones and Tami Crawford borrowed $30,000 on a 7-month, 9% note from Gem State Bank to open their business, Crane’s Coffee House. The money was borrowed on June 1, 2022, and the note matures January 1, 2023. Correct answer iconYour answer is correct. Prepare the entry to record the receipt of the funds from the loan. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit June 1 enter an account title to record the receipt of the funds from the loan on June 1 enter a debit amount enter a credit amount enter an account title to record the receipt of the funds from the loan on June 1 enter a debit amount enter a credit amount eTextbook and Media List of Accounts Partially correct answer iconYour answer is partially correct. Prepare the entry to accrue the interest on June 30. (Credit account titles…arrow_forwardPlease help with this question: Open, post to and balance the debtors control account in the general ledger of Towel Talk for February 2021. (Round off to the nearest rand) The pictures provided are of best quality and the format in which the answer should be done has been attached . god bless youarrow_forward
- Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars.arrow_forwardYou must show all of your work for each problem. Make sure your workflows logically and solutions are identified clearly. If any problems involving writing, please use complete sentences. Writing Off a Large Uncollectable Receivable: Concept Connection 1. Canaday Ltd. has the following receivables balances ($M): Gross accounts receivable $175 Bad-debt reserve (3) Net accounts receivable $172 Two years ago a customer was approved for an unusually large credit sale of $7M over the objections of the credit and collections department. Shortly after the sale, the customer’s business began to deteriorate due to an unexpected recession. To date, it has paid only $2M against the order despite the fact that it has consumed all of the material purchased. The collections department has worked diligently to collect the remaining $5M without success. The customer filed for bankruptcy this morning with essentially no assets to pay a large number of creditors. Evaluate the…arrow_forward1. When a customer’s deposit is recorded using the Make Deposits window, Quickbooks creates a behind the scenes journal entry that will do what? A. Credit cash and debit checking B. Credit checking and debit undeposited funds C. Debit Checking and credit undeposited funds D. Debit cash and credit checking 2. How can you move your Quickbooks desktop company file, with all of your data, to a new computer? A. Create a portable file and restore it to a new system B. Condense the data file on the old computer to the drive space. Back up the file and then restored the condense data file to the new computer C. Install Quickbooks on the new computer, back up your computer file on the old computer and restore the file to the new system D. Export your company file to excel from the old computer, then copy this file over to your new computer.arrow_forward
- The following information has been presented to you for 2018 by Wonder Projects Limited: September October November Rand Rand Rand Cash revenue 200 000 220 000 240 000 Credit revenue 120 000 180 000 190 000 Purchases (all credit) 130 000 140 000 120 000 Additional information: Collection of credit revenue: 50% in the month of invoice 30% one month after invoice 15% two months after invoice and the balance written off as irrecoverable. Purchases are on credit and are paid for one month after the purchase, less 5% Rent income amounts to R10 000 per The rent will increase by 8% on 1 October 2018. A fixed deposit of R150 000 will mature on 31 October 2018. Interest of R15 000 will also be received on this A new computer will be purchased on 3 September 2018 for R25 000 Salaries amount to R20 000 per A 10% increase will take effect on 1 October 2018. The owner is expected to take R5 000 cash from the business on 20 October…arrow_forwardKelly Jones and Tami Crawford borrowed $33,000 on a 7-month, 6% note from Gem State Bank to open their business, Crane’s Coffee House. The money was borrowed on June 1, 2022, and the note matures January 1, 2023. Prepare the entry to record the receipt of the funds from the loan. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit June 1 enter an account title to record the receipt of the funds from the loan on June 1 enter a debit amount enter a credit amount enter an account title to record the receipt of the funds from the loan on June 1 enter a debit amount enter a credit amount eTextbook and Media List of Accounts Prepare the entry to accrue the interest on June 30. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)…arrow_forwardSupposed that you have a business, and you are going to prepare checks for thefollowing: (You can create your own check or simply download a blank check) 150,000 payable to Ronald James Abad for the consultation fee. 65, 350.90 for the payment equipment purchased from Abenson ApplianceStorearrow_forward
- Kelly Jones and Tami Crawford borrowed $30,000 on a 7-month, 9% note from Gem State Bank to open their business, Crane’s Coffee House. The money was borrowed on June 1, 2022, and the note matures January 1, 2023. Prepare the entry to record the receipt of the funds from the loan. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit June 1 enter an account title to record the receipt of the funds from the loan on June 1 enter a debit amount enter a credit amount enter an account title to record the receipt of the funds from the loan on June 1 enter a debit amount enter a credit amount eTextbook and Media List of Accounts Prepare the entry to accrue the interest on June 30. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and…arrow_forwardAs the Loans Manager at First Union Bank, you are evaluating Woodlawn Racetrack for a potential loan. An examination of the Notes to the Financial Statements indicate restricted cash at year-end amounts to $100,000. Explain as comprehensively as possible how you would use this information in evaluating Woodlawn’s liquidityarrow_forwardThe accompanying table, Data table Date Deposit (Withdrawal) Date Deposit (Withdrawal) 1/1/20 $8,000 1/1/22 $3,272 1/1/21 $(6,540) 1/1/23 $5,255 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) , shows a series of transactions in a savings account. The account pays 5% simple interest, and the account owner withdraws interest as soon as it is paid. Calculate the following: a. The account balance at the end of each year. (Assume that the account balance at December 31, 2019, is zero.) b. The interest earned each year. c. The true rate of interest that the investor earns in this account. Question content area bottom Part 1 a. The account balance at the end of 2020 is $8,0008,000. (Round to the nearest dollar.) Part 2 The account balance at the end of 2021 is $1,9531,953. (Round to the nearest dollar.)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
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License