a. On April 1, the start of the loan period, the cash balance will be $41,800....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a. On April 1, the start of the loan period, the cash balance will be $41,800. Accounts receivable on April 1 will total $182,000, of which $156,000 will be collected during April and $20,800 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April $ 316,000 $ 214,000 $ 34,200 $ 31,600 $ 74,000 50 $ 31,000 May $575,000 $ 193,000 $ 34,200 $ 31,600 $ 74,000 $0 $ 31,000 June $ 264,000 $ 151,500 $ 27,300 $31,600 $ 43,000 $ 70,500 $ 31,000 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $175,000. d. In preparing the cash budget, assume that the $73,000 loan will be made in April and repaid in June. Interest on the loan will total $1,080. Required: 1. Calculate the expected cash collections for April, May, and June, and for the three months in total. 2. Prepare a cash budget, by month and in total, for the three-month period. Beginning cash balance. Add receipts: Collections from customers Total cash available Less cash disbursements: Merchandise purchases Payroll Lease payments Advertising Equipment purchases Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Prime Products Cash Budget April May June Quarter a. On April 1, the start of the loan period, the cash balance will be $41,800. Accounts receivable on April 1 will total $182,000, of which $156,000 will be collected during April and $20,800 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April $ 316,000 $ 214,000 $ 34,200 $ 31,600 $ 74,000 50 $ 31,000 May $575,000 $ 193,000 $ 34,200 $ 31,600 $ 74,000 $0 $ 31,000 June $ 264,000 $ 151,500 $ 27,300 $31,600 $ 43,000 $ 70,500 $ 31,000 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $175,000. d. In preparing the cash budget, assume that the $73,000 loan will be made in April and repaid in June. Interest on the loan will total $1,080. Required: 1. Calculate the expected cash collections for April, May, and June, and for the three months in total. 2. Prepare a cash budget, by month and in total, for the three-month period. Beginning cash balance. Add receipts: Collections from customers Total cash available Less cash disbursements: Merchandise purchases Payroll Lease payments Advertising Equipment purchases Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Prime Products Cash Budget April May June Quarter
Expert Answer:
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these accounting questions
-
David Suker, the inventory manager for a marketing research company, wants to study the use of supplies within the different company departments. Suker has heard that his friend, Ephanor, has...
-
A landing gear manufacturer has the following MPS for one of its items (shaft housing), as well as the accompanying product structure. The resource profile for the frame is as follows: Determine the...
-
The intermediate gear B rotates with an angular velocity of 20 rad/s clockwise. Knowing that the outer gear C is stationary, determine (a) The angular velocity of the inner gear A, (b) The angular...
-
I recently heard my neighbor discussing how one of our other neighbors lost his job. My neighbor assumed that the person who lost his job was probably lazy or not smart enough for the job, without...
-
What are various ways to obtain respondents for online surveys?
-
A control chart for the number of nonconforming piston rings is maintained on a forging process with np = 16.0. A sample of size 100 is taken each day and analyzed. (a) What is the probability that a...
-
The minimum number of degrees of freedom for any system is (a) 0 (b) 1 (c) 2 (d) 3 .
-
Hahn Manufacturing purchases a key component of one of its products from a local supplier. The current purchase price is $1,500 per unit. Efforts to standardize parts succeeded to the point that this...
-
Vernon Company reported the following operating results for two consecutive years: Required Compute each income statement component for each of the two years as a percentage of sales. (Percentages...
-
Journalize all these transactions into a general ledger. Transactions May 1 Purchased merchandise from Keys Wholesale on account for $735.30, Invoice No 91 Dated May 1, terms 2/10, n30 May 2...
-
Harry has assessable income of $200,000, John has assessable income of $60,000 and Simy has assessable income of $40,000. They have deductible expenses of $10,000 and no tax offsets. They are...
-
Give three possible causes of a favourable direct labour rate variance.
-
What are the limitations of line item budgets?
-
Trade creditors at the start of January are \( 12,500\). They are all paid during January. During the month, goods costing \( 18,000\) are purchased, and at the end of January there is an amount of...
-
How does budgeting help the management function of planning?
-
Explain the nature and purpose of planning, programming budgeting systems (PPBS).
-
When two companies form a joint venture and each company owns exactly 50% of the joint venture: Multiple Choice the cost method is used. the equity method is used and line-by-line consolidation is...
-
Given find the value of k. es 1 e kx dx = 1 4'
-
What is ADO.NET, and what two new features make it important for application development?
-
What is a Web application server, and how does it work from a database perspective?
-
What is physical independence?
-
A scientist wants to determine whether people who live in places with high levels of air pollution get more colds than people in areas with little air pollution. Do you think it is possible to design...
-
Draw a simple random sample of eight animals from the list of 40 animals in the table. Exercises 2124 refer to the population of animals in the following table. The population is divided into four...
-
Your school colors In Exercises 1524, determine whether the data described are qualitative or quantitative.
Study smarter with the SolutionInn App