24 Feb Develop a monthly cash budget for Bluffton Pharmacy for the upcoming year
Case Study: Bluffton Pharmacy, Part 2
How should the owners of a small pharmacy create a cash flow forecast for their business?
It has been a little more than two years since Angela Crawford and Martin Rodriguez purchased the Bluffton Pharmacy from Frank White, the previous owner and founder, who had started the pharmacy in 1969. Although Crawford and Rodriguez have prepared budgets for Bluffton Pharmacy and have analyzed their financial statements using ratio analysis, they have not created a cash flow forecast. During a recent meeting, their banker explained the importance of reliable cash flow forecasts, telling them that banks traditionally are “cash flow lenders.” Bankers appreciate strong balance sheets and income statements, but they are most interested in a company’s cash flow because they know that positive cash flow is required to repay a loan.
Crawford and Rodriguez expect sales to increase 4.5 percent next year, to $2,504,368. Credit sales account for 79 percent of total sales, and the company’s collection pattern for credit sales is 11 percent in the same month in which the sale is generated, 63.5 percent in the first month after the sale is generated, and 22 percent in the second month after the sale is generated. The pharmacy’s cost of goods sold is 77.4 percent, and vendors grant “net 30” credit terms, which means the pharmacy pays for the goods it purchases every month in the following month. Crawford and Rodriguez have been working with their accountant to develop estimates for their expenses for the upcoming year (see the accompanying table on page 783).
Actual sales for the last two months, November and December, were $272,357 and $315,458. The company’s cash balance as of January 1 is $74,473. The interest rate on Bluffton Pharmacy’s current line of credit is 8.25%, and whatever the pharmacy borrows must be repaid the following month (with interest), even if it must borrow again in that month. The entrepreneurs have established a minimum cash balance of $15,000.
Questions
1) Develop a monthly cash budget for Bluffton Pharmacy for the upcoming year.
2) What recommendations can you offer Angela Crawford and Martin Rodriguez to improve their pharmacy’s cash flow?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.