IT Skills For Finance Professionals Assignment Example | Topics and Well Written Essays - 1000 words

IT Skills For Finance Professionals - Assignment Example in that location 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 app expiryix. 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 instrument 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 motiveless 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 Re payment 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 plan 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 expect to contribute significantly to cash inflows and along with continuing growth in sales could place the connection 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 oneself 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 juicy 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