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:
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...
-
For each of the cases shown in the following table, use the capital asset pricing model to find the requiredreturn. Risk-free ratc, RF Market Casc Beta, b 1.30 0.90 0.20 1.00 0.60 rcturn, 5% 8% 13 12...
-
Suppose that T : Rn Rn is a linear transformation and suppose that v is a vector such that T(v) 0 but T2 = T o T). Prove that v and T(v) are linearly independent.
-
Canterbury Corporation has 20,000 shares of its $100 par value, 7 percent cumulative preferred stock outstanding, and 100,000 shares of its $1 par value common stock outstanding. In Canterburys first...
-
1. Identify the ethical culture problem at Texaco in the mid-1990s. 2. Based on the facts in the case and what you have learned in this chapter, evaluate the culture change effort that is under way....
-
I need help answering this question. The 1 , 5 0 0 accounts receivable of DEF Company have a total book value of $ 3 0 , 0 0 0 . Bob Smith, Certified Public Accountant ( CPA ) , has selected and...
-
Murl Plastics Ltd purchased a new machine one year ago at a cost of 60,000. Although the machine operates well, the managing director (MD) wondered if the company should replace it with a new...
-
Why does the text argue that judicial vigilance is necessary in the context of bureaucratic governance?
-
2. Rose Co, bad 3,000 units in work in process at April 1, 2018, which were 60% completed as to conversion cost, During April, 10,000 units was completed. At April 30, 4,000 units remained in work in...
-
Find two positive numbers with product 484 and whose sum is a minimum. Enter your answers in increasing order. First number: Number Second Number: Number
-
Describe a business transaction and how you identify it . What are the different types of accounts a company uses? Discuss one type of account with examples.
-
We notice that you have some experience with SQL Server 2014 DBMS. How would go about creating a SQL Server maintenance job? (provide a summary of the process) What are some of the steps in the...
-
Discuss the Corporate Social Performance (CSP) for Dairy Queen Inc, and a mom-and-pop ice cream shop. What are these companies doing to be socially responsible?
-
List 2 things the manager could have done better to run the meeting more efficiently
-
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?
-
What are the main tasks of the board of directors? R1
-
Identify four ways in which the independence of an auditor of a large listed company may be strengthened. E1
-
Why have institutional shareholders become more active in corporate governance issues in recent years? R4
Study smarter with the SolutionInn App