Question: a. Using the data in the income statement and the balance sheet that follow, compute the companys average collection period (ACP) in days. Use a

a. Using the data in the income statement and the balance sheet that follow, compute the company€™s average collection period (ACP) in days. Use a 365-day year when calculating sales per day.

b. Compute the cost, as a percent, that the company is paying for not taking the suppliers€™ discounts. (The suppliers€™ terms are 2/10, net 60; but note from the bottom of the balance sheet that Fresh & Fruity has been taking 67 days to pay its suppliers).

c. Assume Alice Plummer€™s first initiative to offer a 10 percent discount was implemented, and the company€™s average collection period dropped to 32 days. If net sales per day remained the same, as Alice expects, what would be the new accounts receivable balance? How much cash was freed up by the reduction in accounts receivable? What is the new accounts payable balance if the money is used to pay off suppliers?

d. As a result of Alice€™s first initiative described in part c, Fresh & Fruity is able to take advantage of the 2 percent discount on one-third of its purchases (see the income statement). What will be the cash discount figure on the income statement? What effect does this have on net income (after taxes)? The simplest way to get this figure is to multiply the cash discount figure by (1 €“ Tax rate) and add this figure to the net income after tax figure on the income statement. Also what is the effect on the return-on-sales ratio shown toward the bottom of the balance sheet? Consider the effect on the return-on-equity ratio as well.

e. Alice€™s second initiative calls for Fresh & Fruity to obtain a bank loan of a sufficient size to enable the company to take all suppliers€™ discounts. What is the minimum size of this loan? To take all suppliers€™ discounts, the average payment period must be 10 days, and net purchases will be Purchases €“ (Purchases from Figure 1 × .02). Assume all this happens, and solve the following formula for the new accounts payable balance, using:

Accounts payable = Average payment period × Purchase per day*

Now compare the accounts payable you just solved with the new accounts payable balance you found in part c. The difference is the size of the loan that is required.

f. Assume Fresh & Fruity obtains an 8 percent loan for one year in the amount you solved in part e, and it reduces its accounts payable balance accordingly. Now the company is taking 2 percent discounts on all purchases and paying 8 percent a year on the loan balance. What is the net gain from taking the discounts and paying the interest on a before-tax basis? (on an after tax basis?)

g. (Optional)   Suppose the 8 percent loan that Fresh & Fruity obtained was a discount loan, and the bank further required a 20 percent compensating balance of the full loan amount. What is the annual rate of interest to Fresh & Fruity? How does this compare to your answer in question b for the cost of not taking a cash discount?

Fresh & Fruity Foods is a mail-order company operating out of a winery near Summerland, British Columbia. The company specializes in sending British Columbian specialties to catalogue customers nationwide. Sales are seasonal, with most occurring in November and December-when people select Fresh & Fruity's Famous Fruit Fantasy boxes as Christmas gifts. Although seasonal, the company's sales are fairly predictable, because the bulk of Fresh & Fruity's customers are regulars who purchase year after year. The company has also managed to smooth out its sales somewhat by offering incentives, such as the Fruit of the Month Club, which encourages customers to buy throughout the year.

The nature of the mail-order business is such that most of Fresh & Fruity's sales are on credit; therefore, the company has historically had a high accounts receivable balance relative to sales. It has also historically been short of cash; forcing it to delay payments to suppliers as long as possible (its average time to pay accounts in 2015 was 67 days). In January 2016, Tom Appleby and Alice Plummer, the president and treasurer of Fresh & Fruity, respectively, were discussing the cash flow problem over lunch. "You know, Tom," Alice said as she sliced a piece of avocado, "I was reading the other day about a company called Kringle's Candles & Ornaments, and it occurred to me that we're a lot like them. Most of our assets are current ones, like their accounts receivable and inventory, and over half of ours are financed just like theirs, by current liabilities-that is, accounts payable."
She paused for a sip of chardonnay, and continued, 

"They got around their cash flow problems by issuing long-term debt, which took the pressure off their current obligations. I've been looking at that for our company, too. But then I got to thinking, there's another way that's a good deal easier and would produce results just as quickly." "Oh? And what's that?" Tom replied, his interest captured.

"All we have to do," she said, "is to reduce our accounts receivable balance. That will help reduce our accounts payable balance, since, as our customers begin paying us earlier, we can, in turn, pay our suppliers earlier. If we could get enough customers to pay us right away, we could even pay some of the suppliers in time to take advantage of the 2 percent discount they offer for payments within 10 days." (Fresh & Fruity's suppliers operated on a 2/10, net 60 basis.) "That would increase our net income and free up even more cash to take advantage of even more discounts!" She looked excited at the prospect.
"Sounds great, but how do we get people to pay us earlier?" Tom inquired, doubtfully. "Easy," Alice continued. "Up to now we've been giving them incentives to pay later. Remember our 'Buy Now, No Payments for Two Months' program? Well, a lot of our customers use it, and it's caused our accounts receivable balance to run way up. So what we have to do now is give them incentives to pay earlier. What I propose is to cancel the buy now /pay later plan, and instead offer a 10 percent discount to everyone who pays with their order."

"But won't that cause our revenues to drop?" Tom asked, again still doubtful  "Yes, but the drop will be offset by even more new customers who will come in to take advantage of the discount. I figure the net effect on sales will be just about zero, but our accounts receivable balance could be cut in half! Now here's a kicker I just thought of. After we've reduced our accounts receivable balance as far as practical, I'd like to look into the possibility of reducing our accounts payable still further by replacing them with a bank loan. The effective rate of interest that we pay by not taking our suppliers' discounts is, after all, pretty high. So what I'd like to do is take out a loan once a year of a sufficient size that would enable us to take all the discounts our suppliers offer. The interest that we'll pay on the loan is bound to be less than what we pay in discounts lost-so we'll see another gain in earnings on our income statement. In fact, these two initiatives together might have a really significant impact!"
"You've convinced me," Tom said. "Let's go back to the office and run some figures to see what happens!".......................................

Fresh & Fruity Foods Inc. Income Statement For year ending December 31, 2015 Revenue from sales: $1,179,000 Gross sales

Fresh & Fruity Foods Inc. Balance Sheet As of December 31, 2015 Assets: Cash ... $ 3,560 Accounts receivable 209,686 Inv

Fresh & Fruity Foods Inc. Income Statement For year ending December 31, 2015 Revenue from sales: $1,179,000 Gross sales (credit).. .... Cost of goods sold: $ 141,000 Beginning inventory.. $969,000 Purchases..... Less: cash discounts ... Net purchases... Goods available for sale .. 969,000 1,110,000 Less: Ending inventory.. 79,557 1,030,443 148,557 Cost of goods sold. Gross profit...... Selling and administrative expenses.. Earnings before interest and tax Interest expense... 73,000 75,557 Earnings before tax 75,557 Income taxes @ 33% 24,934 50,623 ... Net income.... Fresh & Fruity Foods Inc. Balance Sheet As of December 31, 2015 Assets: Cash ... $ 3,560 Accounts receivable 209,686 Inventory...... 79,557 Total current assets $292,803 Property, plant, and equipment, net 11,430 Total assets.... $304,233 Liabilities and equity: Accounts payable....... $180,633 Notes payable (bank loans) Total current liabilities... $180,633 Long-term debt.. Total liabilities... 180,633 Common stock 96,600 Retained earnings.. 27,000 Total equity.... Total liabilities and equity.. 123,600 $304,233 Selected ratios: Return on sales.. 4.29% Return on equity. Inventory turnover. 40.96% 14.82 Receivables turnover. 5.62 Average payment period. 67

Step by Step Solution

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Average collection period Accounts receivable Average daily credit sales Accounts receivable 209686 Average daily credit sales 1179000 365 3230 Average collection period 209686 3230 6492 days b Cost ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Foundations Financial Management Questions!