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...
-
Which of these two, a product audit (such as the Audits and Surveys National Market Audit) or a store audit (such as the Nielsen Retail Index), would be more suitable for the following products: (a)...
-
Develop a single spreadsheet that allows you to calculate F|P and P|F factors. For each cell where the calculation is performed, place above it a small control panel that allows you to enter whatever...
-
Daphne Brown-Wright worked as a teacher for East St. Louis School District 189 from 1975 until 1998 and then returned as an administrator from 2002 until 2012, thus serving the District for 33...
-
Forten Company, a merchandiser, recently completed its calendar- year 2013 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from...
-
1. An object of mass of 4 kg is resting at a height of 2 m and then falls to the ground. a. Model the energy of the object-Earth system with Energy Bar Charts when at the initial height and ground...
-
Suppose that instead of funding the $300 million investment in 8 percent British loans with CDs issued in the United Kingdom, the FI manager hedges the foreign exchange risk on the British loans by...
-
You want to buy a house in 7 years and expect to need $30000 for a down payment. If you have $10000 to invest, how much interest do you have to earn (compounded annually) to reach your goal? (Enter...
-
Q1. What is the definition of a worker according to the labour law? What are the Main criteria for assessing a worker? Can a shop manager be defined as a worker in the eyes of the law and why?...
-
Charlie and Lucy owned a sports equipment company together. In 2023 they had $50,000 in sales, $28,000 in expenses, $15,000 in cash, and $1,800 in equipment. How much was their net income for 2023?...
-
The following balance sheet ( BS ) and income statement ( IS ) are available for Little Bit Inc. Prepare a statement of cash flows ( CF ) for 2 0 2 1 : Balance Sheet December 3 1 , 2 0 2 1 2 0 2 0...
-
Topic area: Internal Fit-Out works (partition systems, ceiling systems and internal fixtures and finishes. The context of the investigation is commercial building construction. Specifically cairns...
-
Based on the below data from Lancaster Holdings (in millions USD), calculate its Free Cash Flow to Equity as of 2016 Balance Sheet Assets Income Statement 2016 2015 2016 2015 Cash $30 $15 Sales $900...
-
3. A rocker mechanism is as shown in Figure Q3. The data pertaining to the mechanism is as follows: AB = CD = BG = 30 mm 60 mm 50 mm BC = NAB = TCD = giving details of any assumptions made. 180 mm...
-
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?
-
Ask older friends or relatives about the cost of specific items (e.g., a gallon of gas, a cup of coffee, etc.) during their youth. Also inquire bout their average wages in the past. Compare the...
-
Develop and solve a future-value, a present-value, a future value of an annuity, and a present value of an annuity problem. Establish the three known variables in each problem and solve for the...
-
What do you understand by a bank lending policy in the context of a monetary policy?
Study smarter with the SolutionInn App