The president of the retailer Prime Products has just approached the company's bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June. during which the loan will be used:
a. On April 1. the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000. of which $120,000 will be collected during April and $16,000 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:
April May June Sales (all on account) $ 300,000 $ 400,000 $ 250,000 Merchandise purchases $ 210,000 $ 160,000 $ 130,000 Payroll $ 20,000 $ 20,000 $ 18,000 Lease payments $ 22,000 $ 22,000 $ 22,000 Advertising $ 60,000 $ 60,000 $ 50,000 Equipment purchases $ 65,000 Depreciation $ 15,000 $ 15,000 $ 15,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 $140,000. d. In preparing the cash budget, assume that the $30,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200.
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.
Figure below illustrates the outer housing of a rotor assembly, of which a production volume of 100,000 is required. The assembly is designed to spin at a high speed duri...May 10 2020
Mr. Milquetoast admires Warren Buffet and believes that Berkshire Hathaway is a good investment. He wants to invest $100,000, but hesitates because Berkshire Hathaway has...May 01 2020
What impact do Hofstede’s five dimensions of cross-cultural differences have on a cross-cultural negotiation? You recently negotiated your first team negotiation, and it...Nov 26 2019
How do eating disorders affect a woman’s ability to parent? 7. The ethical issues associated with compulsory treatment. 8. Prevention of eating disorders or weight rel...Mar 14 2020
The Denver Corporation has forecast the following sales for the first seven months of the year:Monthly material purchases are set equal to 30 percent of forecasted sales ...Apr 24 2020
In the Module One overview and resources, you learned that the field of cognitive psychology examines human thought processes through a variety of research techniques. Th...May 02 2020
The market basket used to calculate the CPI in Aquilonia is 4 loaves of bread, 6 gallons of milk, 2 shirts and 2 pants. In 2005, bread cost $1.00 per loaf, milk cost $1.5...Jun 15 2018
Sodium metal reacts with water in a single-displacement reaction. Which of the following best describes the identity of the products of this reaction?A)NaH(aq) and O2g)D...Feb 15 2020
1. Evaluate the validity of the following claim: The increasing wage gap between highly educated and less-educated workers will itself generate shifts in the U.S. labor m...May 11 2020
Medicare ComponentsList and discuss the four (4) parts of medical coverage provided by Medicare.include specific details of what kind of medical services are provided und...Aug 11 2020