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

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 3 181589 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 al lowed 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