Hudak Company requires a minimum cash balance of S4,000. When the company expect

ID: 2600378 • Letter: H

Question

Hudak Company requires a minimum cash balance of S4,000. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed om the previous month's principal balance is paid on the first o the month at 8% per year. The company has already completed the budgeting process or the first quarter or cash receipts and cash payments or all expenses except interest (click the icon to view the completed budget information.) Hudak does not have any outstanding debt on January 1. Complete the cash budget for the first quarter for Hudak Company. Round interest expense to the nearest whole dollar Cash Budget For the Three Months Ended March 31 January February March Total 12,000 89,000 101000 4000 4000 Beginning cash balance Cash receipts Cash available Cash payments: 4,000 18,500 22,500 28,500 42,000 All expenses except interest 40,000 34,000 31,000 105,000 Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: 40,000 (4,000) (4,000) (4,000) (4,000) Borrowing Principal repayments Total effects of financing

Explanation / Answer

January

February

March

Total

Beginning Cash Balance

4,000

12,000

Cash Receipts

18,500

28,500

42,000

89,000

Cash Available

22,500

32,500

46,000

101,000

Cash Payments:

All Expenses except interest

40,000

34,000

31,000

105,000

Interest

143

181

324

Total Cash Payments

40,000

34,143

31,181

105,324

Ending Cash Balance before

Financing

(17,500)

(1,643)

14,819

(4,324)

Minimum Cash Balance Desired

(4,000)

Projected Cash Excess (Deficiency)

(21,500)

(5,643)

10,819

(16,324)

Financing:

Borrowing

21,500

5,643

27,143

Principal Payments

(10,819)

Total effects of Financing

21,500

5,643

(10,819)

16,324

It is mentioned that the company will raise the exact amount of deficiency at the beginning of next month so any deficiency in January will be raised on 1st of February and any excess cash will be used to repay the principal amount.

Interest = Amount raised * Rate * Month

Interest due in Feb. = 21,500(Raised) * 8% * 1/12 months

=$143

Interest Due in March = 27,143(21,500+5,643) * 8% * 1/12 months

= $181

If you have any doubt please feel free to reach me.

Thank you