The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 408 Weeks Ago, 3 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. The sales forecasts for the next five quarters are as follows:
Â
| Â | Quarter in Coming Year
 |
 | Following Year
 |
|||
| Â | First | Second | Third | Fourth | Â | First Quarter |
| Sales forecast | $492 | $480 | $456 | $660 | Â | $660 |
Â
|
The firm pays for its goods with a 1-month delay. Therefore, on average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. |
Â
|
Paymore%u2019s customers pay their bills with a 2-month delay. Therefore, on average, one-thirds of sales are collected in the quarter that they are sold, and two-third are collected in the following quarter. Assume that sales in the last quarter of the previous year were $456. |
Â
|
Paymore%u2019s labor and administrative expenses are $78 per quarter and that interest on long-term debt is $54 per quarter. |
| Â |
|
Suppose that cash balance at the start of the first quarter is $50 and its minimum acceptable cash balance is $40. |
Â
|
Now assume that Paymore can borrow up to $250 from a line of credit at an interest rate of 2% per quarter. Prepare a short-term financing plan. Refer Spreadsheet 19.3 (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) |
Â
| Â | Quarter
 |
|||
| Â | First | Second | Third | Fourth |
| A. Cash requirements | Â | Â | Â | Â |
| Cash required for operations | $ | $ | $ | $ |
| Interest on bank loan | Â | Â | Â | Â |
| Â | ||||
| Total cash required | $ | $ | $ | $ |
| B. Cash raised in quarter | Â | Â | Â | Â |
| Line of credit | Â | Â | Â | Â |
| Â | ||||
| Total cash raised | $ | $ | $ | $ |
| C. Repayments of bank loan | Â | Â | Â | Â |
| D. Addition to cash balances | Â | Â | Â | Â |
| E. Line of credit | Â | Â | Â | Â |
| Beginning of quarter | Â | Â | Â | Â |
| Â | ||||
| End of quarter | $ | $ | $ | $ |
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------