Reference no: EM131658975

Question: Adrian Fudge of the Fudge Corporation forecast the firm's financing needs quarter (October through December) following observations relative to pk and disbursements:

• Interest on a $75,000 bank note (due next March) at an 8 percent annual rate is payable in December for the three-month period just ended.

• The firm follows a policy of pE dividends.

• Actual historical and future pr as follows:

        Historical Sales                            Predicted sales

August            $150,000             October           $200,000

September         175,000             November          220,000

                                               December          180,000

                                               January             200,000

• The firm has a monthly rental expense of $ 5,000.

• Wages and salaries for the com estimated at $25,000 per month.

• Of the firm's sales, 25 percent i the month of the sale, 35 percE after the sale, and the remainin months after the sale.

• Merchandise is purchased one sales month and is paid for in t sold. Purchases equal 75 perc€ firm's cost of goods sold is alsc sales.

• Tax prepayments are made qua payment of $10,000 in October

• Utility costs for the firm average 3 percent of sales and are paid in the month they are incurred.

• Depreciation expense is $20,000 annually.

Question 1 Prepare a monthly cash budget for the three-month period ending in December.

Question 2 If the firm's beginning cash balance for the budget period is $7,000, and this is its desired minimum balance, determine when and how much the firm will need to borrow during the budget period The firm has a $50,000 line of credit with its bank, with interest (10 percent annual rate) paid monthly. For example, interest on a loan taken out at the end of September would be paid at the end of October and every month thereafter so long as the loan was outstanding.