Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2022/08/62fe0e1be66b4_1660816888823.jpg)
Transcribed Image Text:
Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September 2019, produce an Account Analysis Statement (Note: Please calculate Collected Balances required) Item - Services Performed Account Maintenance Debits-paper Debits electronic Credits electronic Addenda Records Processed Controlled Disbursements Items Paid Paid Item Reject Teller Cash Float Paid Item Images Wholesale Lockbox Monthly Maintenance Standard Items Deposit Tickets Data Capture Document Images Wire Transfers Domestic Wires - Out Domestic Wires - In International Wires - Out International Wires - In Info Services - Maintenance Info Services - Data Transfers Number 3 3,589 395 5,829 3,102 8,150 355 1,088 8,099 2 9,875 20 125,847 984 125 12 78 45 1 87,459 Cost or Unit Price $25.00 $0.23 $0.20 $0.15 $0.45 $0.12 $1.00 $0.55 $0.25 $100 $0.50 $1.50 $0.005 $0.65 $15.00 $10.00 $25.00 $15.00 $150.00 $0.002 In addition for the month in question, the company had an Average Ledger Balance of $8,653,976, with Deposit Float of $928,237. You may assume an ECR of 2.5% and Reserve Requirement of 10%. 1. Determine: (1) The Collected Balance, (2) the service charge for each item and the total service charge for the month, (3) the overall required collected balance and the required collected balance for each of the items above. 2. Provide the balance summary : Ledger balance, float, collected balance, reserve requirement, available balance, available required, and the net available balance. 3. Provide the earning credit summary : Available balance for earnings credit, earnings credit allowance, charge for services, net service credit. 4. Is it a surplus earnings credits or deficit balance that must be charged to the account for the month? Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September 2019, produce an Account Analysis Statement (Note: Please calculate Collected Balances required) Item - Services Performed Account Maintenance Debits-paper Debits electronic Credits electronic Addenda Records Processed Controlled Disbursements Items Paid Paid Item Reject Teller Cash Float Paid Item Images Wholesale Lockbox Monthly Maintenance Standard Items Deposit Tickets Data Capture Document Images Wire Transfers Domestic Wires - Out Domestic Wires - In International Wires - Out International Wires - In Info Services - Maintenance Info Services - Data Transfers Number 3 3,589 395 5,829 3,102 8,150 355 1,088 8,099 2 9,875 20 125,847 984 125 12 78 45 1 87,459 Cost or Unit Price $25.00 $0.23 $0.20 $0.15 $0.45 $0.12 $1.00 $0.55 $0.25 $100 $0.50 $1.50 $0.005 $0.65 $15.00 $10.00 $25.00 $15.00 $150.00 $0.002 In addition for the month in question, the company had an Average Ledger Balance of $8,653,976, with Deposit Float of $928,237. You may assume an ECR of 2.5% and Reserve Requirement of 10%. 1. Determine: (1) The Collected Balance, (2) the service charge for each item and the total service charge for the month, (3) the overall required collected balance and the required collected balance for each of the items above. 2. Provide the balance summary : Ledger balance, float, collected balance, reserve requirement, available balance, available required, and the net available balance. 3. Provide the earning credit summary : Available balance for earnings credit, earnings credit allowance, charge for services, net service credit. 4. Is it a surplus earnings credits or deficit balance that must be charged to the account for the month?
Expert Answer:
Answer rating: 100% (QA)
To complete this exercise we have to follow a few steps Lets start by calculating the service charge for each item and the total service charge for th... View the full answer
Related Book For
Fundamentals of Investments Valuation and Management
ISBN: 978-0077283292
5th edition
Authors: Bradford D. Jordan, Thomas W. Miller
Posted Date:
Students also viewed these finance questions
-
Given the information below for Pamplin Inc.,: a. How much is the firm's net working capital, and what is the debt ratio for 2014 and 2015? b. Complete a common-sized income statement, a common-sized...
-
Given the information below for Knapp Inc.: a. How much is the firms net working capital and what is the debt ratio? b. Complete a common-sized income statement, a common-sized balance sheet, and a...
-
Given the information below for Seger Corporation, compute the expected share price at the end of 2008 using price ratioanalysis. Year Price EPS CFPS SPS 2003 94.50 4.34 7.27 52.60 2005 $99.10 5.22...
-
840N with Two cables AB and AC are acting on the pole with forces FAB = 420N and FAC parameters defining the attachment points shown in the table. We want to write the vector FAB in cartesian vector...
-
The unadjusted trial balance for Veda's Video Arcade at its fiscal year end of May 31, 2017, is as follows: Additional information: 1. On May 31, 2017, Veda's Video Arcade had earned but not...
-
What is the difference between the secondary market in mortgages and the secondary market in mortgage- backed securities? Appendix
-
E 6-10 Inventory items of parent capitalized by subsidiary Pop Industries manufactures heavy equipment used in construction and excavation. On January 3, 2016, Pop sold a piece of equipment from its...
-
On July 1, 2015, Ashlock Chemical Company issued $4,000,000, 10%, 10 year bonds at $4,543,627. This price resulted in an 8% effective-interest rate on the bonds. Ashlock uses the effective-interest...
-
Keller Company makes two models of battery-operated boats, the Sandy Beach and the Rocky River. Basic production information follows: Sandy Beach Rocky River Direct materials cost per unit $ 19.70 $...
-
Paper purchased 12,000 of Sands 30,000 shares on 10/1/20X0 for $36,000. At 1/1/20X0, Sand had Common Stock of $30,000 and Retained Earnings of $50,000. During the 12 months ended 12/31/20X0, Sand...
-
IN Sage Accounting Phoebe's Photo STudio how do I do transaction #11. HOw do I enter a purchase Invoice?
-
Dr. Stanley and his staff are attempting to utilize effective ways to both increase the revenue for the practice and allow patients to schedule visits without a lengthy delay. Which of the following...
-
An epidemiologist plans to conduct a survey to estimate the percentage of women who give birth. How many women must be surveyed in order to be 95% confident that the estimated percentage is in error...
-
Centurion Inc. manufactures lighting equipment. It consists of several operating divisions within its business. Division A has decided to go outside the company to purchase materials since Division B...
-
Meta has also reduced its operations, and instead focused on retaining wealth for research and development, as well as increasing shareholder returns...What does this mean for the company's future?
-
Please answer the following question short and simple: Tom Anderson is the controller for Morningside Medical Clinic. At the end of each month, the financial management system used by Morningside...
-
George Jeffers manages a company producing men's suits, offering both made - to - order and standard suits in retail stores. The provided table is a forecasted income statement for March. George has...
-
Determine by direct integration the values of x for the two volumes obtained by passing a vertical cutting plane through the given shape of Fig. 5.21. The cutting plane is parallel to the base of the...
-
Refer to Table 1.1 for large-stock and T-bill returns for the period 1973-1977: a. Calculate the observed risk premium in each year for the common stocks. b. Calculate the average returns and the...
-
What is the intrinsic value of a put option? How do we interpret this value?
-
In the previous problem, assume the company has 95 million shares of stock outstanding and a PE ratio of 16. What was net income for the most recent four quarters?
-
Give some examples of resources that may be required for an IT project? AppendixLO1
-
What is a risk? Provide an example of a project risk. AppendixLO1
-
What is a stakeholder? AppendixLO1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App