IT Skills For Finance Professionals - Assignment Example

There are certain items that are not included in the cash budget although they used in the calculation of profits. They include deprecation and other expenses which do not include the movement of cash. The table below shows the cash budget for Classic Footballs Ltd. Calculations relating to this budget are shown in the appendix. Cash Budget for Classic Footballs Ltd for the Six Months Ending June 30, 2013   January February March April May June Total   ? ? ? ? ? ? ? Cash balance at beginning 0 50238 204198 426382 1046994 1762739 0 Add receipts:               Issue of shares 52500           52500 Grant     350,000 350000 350000 350000 1400000 Loan- Welch Dev Co.

  100,000         100000 Cash sales 175000 192500 210000 227500 271250 253750 1330000 Credit sales 302400 542640 593880 645120 741720 763980 3589740 Interest income   1457 5922 12365 30363 51119 101226 Total cash available 529900 886835 1364000 1661367 2440327 3181589 10064018                 Deduct disbursements               Machine   22000 22000 22000     66000 Sundry fixtures and fittings     18000       18000 Payment for Office Premises 100000 150000 100000       350000 Payment for Raw Materials 53249 112854 123498 134989 152425 159145 736161 Payment for Labour 190000 209000 228000 247000 294500 275500 1444000 Payment for Variable Overheads 67200 118720 129920 141120 162400 166880 786240 Rent and rates 68263 68262.9 68262.9 68262.9 68262.9 68262.9 409577.1 Light and Power     230387     230387 460774.

3 Delivery Van 950   17550       18500 Audi       1000     1000 Advertising   1800         1800 Total disbursements 479662 682637 937618 614372 677588 900175 4292052                 Excess/(deficiency) 50238 204198 426382 1046994 1762739 2281414 2281414                 Financing:               Overdraft 0 0 0 0 0 0 0 Repayment 0 0 0 0 0 0 0 Interest on overdraft 0 0 0 0 0 0 0 standard charge for exceeding O/D limit 0 0 0 0 0 0 0 Total effects of financing 0 0 0 0 0 0 0                 Cash balance at end 50238 204198 426382 1046994 1762739 2281414 2281414 The cash budget indicates that Classic Football Ltd will have excess funds available at the end of each of the first six months.

The schedule indicates that the cash balance for the first month is ?50,238 and that the receipt from the share issue (?52,500) has contributed significantly to the positive cash balance. If the enterprise grant is received as scheduled, it is expected to contribute significantly to cash inflows and along with continuing growth in sales could place the company in a comfortable cash position. Therefore, the company does not need to use the overdraft that is available in those months. However, this cash should not be allowed to lie idle.

It should be invested in order to earn additional income for the company. This could help set off interest cost and other charges which are expected from future overdraft that may become necessary if sales continue to fall. Part 2 In some months Classic Football Ltd will have a large overdraft balance. This is expected sometime after the full amount of the grant has been received. There are a number of ways that the company could restructure its activities. Some payments could be made earlier in the months that are expected to have high levels of surplus cash.

This will be best if the income to be received on any investment of excess cash is higher than the interest charges on overdraft balances. In order to deal with an overdraft balance the company could consider negotiating more favourable payment terms with suppliers. It could also seek to forego discounts on early payment to suppliers by paying at the end of the credit period since the discount that