4. Assuming the company maintains its target cash balance at $135,000, what sales growth rate would...

Transcribed Image Text:

4. Assuming the company maintains its target cash balance at $135,000, what sales growth rate would result in a zero need for short-term financing? To answer this question, you may need to set up a spreadsheet and use the "Solver" function. Since the only period in which there is borrowing is the third period, we can set the ending short-term debt in quarter 3 equal to zero and use Solver. Doing so, we find the necessary sales growth rate is 21 percent. 4. Assuming the company maintains its target cash balance at $135,000, what sales growth rate would result in a zero need for short-term financing? To answer this question, you may need to set up a spreadsheet and use the "Solver" function. Since the only period in which there is borrowing is the third period, we can set the ending short-term debt in quarter 3 equal to zero and use Solver. Doing so, we find the necessary sales growth rate is 21 percent.