Lancaster Company provides services in the retail flooring industry. The following information is available for 20x5:*Twenty percent of the firm's services are for cash and the remaining 80% are on account. Of the credit services, 40% are collected in the month that the service is provided, with the remaining 60% collected in the following month.*Services provided in January are expected to total $250,000 and grow at the rate of 5% per month thereafter.*January's cash collections are expected to be $240,400, and month-end receivables are forecast at $120,000.*Monthly cash operating costs and depreciation during the first quarter of the year are approximated at $250,000 and $15,000, respectively.*Lancaster's December 31, 20x4 balance sheet revealed accounts payable balances
of $28,000. This amount is related to the company's operating costs and is expected to grow to $36,000 by the end of 20x5's first quarter. All operating costs are paid within 30 days of incurrence.*Company policy requires that a $20,000 minimum cash balance be maintained, and Lancaster's 20x4 year-end balance sheet showed that the firm was in compliance with policy by having cash of $23,000.Required: A. Determine the sales revenue earned that will appear on the income statement for the quarter ended March 31, 20x5.B. Compute the company's first-quarter cash collections.C. Compute the cash balance that would appear on the March 31, 20x5 balance sheet.D. What are some possible actions the company could pursue if, at any time during the quarter, it finds that the cash balance has fallen below the stated minimum?
What will be an ideal response?
A. The income statement will report revenues earned of $788,125 [$250,000 + ($250,000 × 1.05 = $262,500) + ($262,500 × 1.05 = $275,625)].
B. Collections for the first quarter total $766,225 ($240,400 + $256,500 + $269,325):
| January: | ? | ? |
| Given | ? | $240,400 |
| February: | ? | ? |
| January receivables | $120,000 | ? |
| February cash services: $262,500 × 20% | 52,500 | ? |
| February credit services: $262,500 × 80% × 40% | 84,000 | $256,500 |
| March: | ? | ? |
| February credit services: $262,500 × 80% × 60% | $126,000 | ? |
| March cash services: $275,625 × 20% | 55,125 | ? |
| March credit services: $275,625 × 80% × 40% | 88,200 | $269,325 |
C. The ending cash balance is $47,225: $23,000 (January 1 balance) + $766,225 (collections) - $28,000 (December payables) - $750,000 (monthly cash expenses × 3) + $36,000 (March payables).
D. Several possible actions include securing a short-term loan or line of credit, working with clients in an attempt to accelerate inflows, and working with vendors to temporarily delay payments. The goal is to have added funds on hand so that operations continue smoothly and are not disrupted because of sporadic or ongoing shortages.
You might also like to view...
If the probability associated with the calculated or observed value of the test statistic (TS CAL) is greater than the level of significance (?), the null hypothesis is rejected
Indicate whether the statement is true or false
Tables are information displays organized by _______________
a. chronological order b. degree of importance c. topic d. rows and columns
A will can be partially revoked
Indicate whether the statement is true or false
Dynamic Inc., an advertising agency in Manhattan, receives compensation from its clients based on Dynamic's sales and market share performance. This is an example of a(n) ________ compensation system.
A. straight-fee B. objective-and-task C. cost-plus D. fixed-fee E. value-based