Solution
(a)Cashbudgetnextyear(quarter-wise) (thousandsofrupees)
Particulars Quarter
1 2 3 4 Total
(A) Cash inflows:
Collection from debtors
(i) From prior quarter (1/3 of sales)3,0002,5003,5006,00015,000
(ii) From current quarter (2/3 of
sales)
5,0007,00012,0007,00031,000
Total 8,0009,50015,50013,00046,000
(B) Cash outflows:
Production costs 7,00010,0008,0008,50033,500
Selling, administrative and other costs1,0002,0002,9001,6007,500
Plant and other fixed assets
purchased
1001,1002,1002,1005,400
Total 8,10013,10013,00012,20046,400
(c) Surplus/(deficiency) (100)(3,600)2,500 800(400)
Beginning balance 650 550 500 500 650
Ending balance (indicated) 550(3,050)3,0001,300 250
Borrowings required
(deficiency + minimum cash required) 3,550 3,550
(Repayments) made
(balance –minimum cash required) (2,500)(800)(3,300)
Ending balance (actually now estimated) 550 500 500 500 500
(b)Loanoutstanding=Rs35,50,000–Rs33,00,000=Rs2,50,000.