StudentShare solutions
Triangle menu

IT Skills For Finance Professionals - Assignment Example

Nobody downloaded yet

Extract of sample
IT Skills For Finance Professionals

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 ...Show more


718739 CBud Part 1 Cash budgets are used to control and plan cash receipts and cash payments (Horngren et al 2011). They are used to prevent the holding of unnecessary idle cash as well as to prevent cash deficiencies and so keep cash balances in line with requirements (Horngren et al 2011)…
Author : jerrod68
IT Skills For Finance Professionals essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"IT Skills For Finance Professionals"
with a personal 20% discount.
Grab the best paper

Check these samples - they also fit your topic

However, it cannot be used for specific projects because each project has it own operating risk. b) Book weights should be used to calculate WACC because the market value is subjective and changes regularly. c) Current (marginal) cost rates should be used because WACC is used mainly to make investment decisions and these decisions depend on expected future cash flow from projects in relation to the cost of new capital.
2 pages (500 words) Assignment
In an organization the ability to repay the contractual obligations can be accessed through the Balance sheet, which is a statement of Assets and Liabilities of the firm as on a particular date. The Balance Sheet clearly shows the liquidity of the intermediary firm to meet its obligations.
9 pages (2250 words) Assignment
In order to conduct my comparison I will be comparing the figure for 2012 with 2011’s figures. As the UK supermarket sector standings show it is Tesco who have had the advantage over its competitors for the last decade (30.4% share, 3.3% sales rise in 2012) although in recent years this position is beginning to look less unassailable.
8 pages (2000 words) Assignment
The duration of $30 million loan is the weighted average of all the maturities of the bond. But since there is only a single payment for this loan, there would only be a single maturity and hence weighting is not required of its duration. This implies that its
3 pages (750 words) Assignment
If we never sell more than $1000000, the business will still be worth pursuing. The break even point would still be reached in this case and therefore, any sales below that would still do but not lower than $970000. In case, in order to stay on
3 pages (750 words) Assignment
I know that data storage is a hot area that is getting a lot of positive press coverage. I expect that I will be able to sell my shares for a gain of at least 7% within the next year. I am basing my investment strategy on the Firm Foundation
1 pages (250 words) Assignment
IT Skills For Finance Professionals - resit
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
4 pages (1000 words) Assignment
Careers in Finance
Management of available money at the company also form a vital part of cooperate finance career. Performance is vital in corporate finance career. Most companies have global operations that demand professionals to handle
4 pages (1000 words) Assignment
The formation of the company had a bearing from the situation of the American household finance. A reflection of the past scenario indicated that many families in America face financial challenges, and they need a business that offers financial
1 pages (250 words) Assignment
Hire a pro to write
a paper under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
Comments (0)
Click to create a comment
Contact Us