StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Accounting and Finance will send you fquestions file - Essay Example

Cite this document
Summary
The cash flow during year 3 is £ 60,000. Therefore calculation will be:
The table above is showing present value of estimated…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.2% of users find it useful
Accounting and Finance will send you fquestions file
Read Text Preview

Extract of sample "Accounting and Finance will send you fquestions file"

ACCOUNTING QUESTIONS ACCOUNTING QUESTIONS ANSWERS Task two Calculation of the cash flow for each ofthe five yearsAnnual cash flowyear 0-100,000year 120,000year 240,000year 360,000year 460,000year 540,000Calculation of Cash Flows:Sale price per unit = £ 12Variable Cost per unit = £ 8Contribution = £ 4Cash flow of 1st Year = £ 4 * 5,000 = £ 20,000Cash flow of 2nd Year = £ 4 * 10,000 = £ 40,000Cash flow of 3rd Year = £ 4 * 15,000 = £ 60,000Cash flow of 4th Year = £ 4 * 15,000 = £ 60,000Cash flow of 5th Year = £ 4 * 5,000 = £ 20,000In 5th year, there is termination value of machine which is £20,000, therefore there is additional cash flow of £20,000 during 5th year. 2. Using the investment appraisal methods to calculate the ARR, Payback, NPV and IRR2.

1 Calculation of Accounting Rate of Return (ARR)Accounting Rate of Return = Average Annual Cash Flow / Average Investment = [£ 24,000 / £ 60,000] *100 = 40%Average Investment = Cost of Machine + Disposal Value / by twoTotal Cash Flow during useful life of machine = £ 200,000Average annual cash flow = £ 200,000 / 5 = £ 40,000Average Investment = £ 100,000 + £20,000/2Average Investment = £ 60,0002.2 Calculating the paybackInitial Investment100,000 Accumulative Cash FlowCash Flow Year 120,000 20,000 Cash Flow Year 240,000 60,000 Cash Flow Year 360,000 120,000 The Accumulative cash flow up to year 2 is £ 60,000, initial investment required is £ 100,000 thus cash flow required during year 2 is £ 40,000.

The cash flow during year 3 is £ 60,000. Therefore calculation will be:Cash flow required during year 3 = £ 60,000Time required to generate required amount =£ 40,000 / £ 60,000 =0.67 years i.e. 8 months (0.67 * 12)Therefore, the machine will take two years and 8 months to generate cash flow of amount equal to initial investment i.e. £ 100,000.2.3 Calculating the NPVYearsNet Cash FlowsPV0(100,000)120,000 17,860240,000 31,880360,000 42,720460,000 38,160540,000 22,680Total153,3000 Sum of PV 1-5Yrs based on COC = £153,3000Initial Investment required to get machine operational = £100,000Net Present Value = £153,3000 - £100,000 = £ 53,300Therefore, the Net Present Value calculated is £ 53,300, which is highly positive. 2.4 Calculating the Internal Rate of Return:YearsNet Cash Flows0(100,000)120,000 240,000 360,000 460,000 540,000 The IRR calculated through MS Excel is 29.16%. Calculations based on Trial & Error method is summarized as shown belowYearsNet Cash FlowsPV @ 25%PV @ 30%PV @ 28%PV @ 29%120,00016,00015,38515,62515,504240,00025,60023,66924,41424,037360,00030,72027,31028,61027,950460,00024,57621,00822,35221,667540,00013,10710,77311,64211,197Total110,00398,144102,643100,355The table above is showing present value of estimated cash flows at different rates while it is clear that present value of estimate cash flows at 29 percent and 30 percent are respectively nearest greater and less to initial investment therefore the IRR will lie between 30% and 29%.

Exact value will be calculated through interpolation, as below. Present Value of Estimated Cash Flows @ 30% = £98,144Present Value of Estimated Cash Flows @ 29Nd% = £100,355Initial Investment = £100,000Internal Rate of Return = 29% + (100,000 – 98,144) / 100,000 = 29% + 0.1656 = 29.165Therefore, the IRR calculated through Trial & Error method is 29.165% approximately at which the present value of estimated cash flows is £99,996 which is approximately equal to initial investment i.e. £100,0003.

Advising the client to either accept or reject the projectThe customer should take the project because the payback period is two years and eight months, besides, the IRR calculated through Trial & Error method is 29.165% approximately at which the present value of estimated cash flows is £99,996 that gives an approximately equal to initial investment i.e. £100,000. Task three1. Cash budget for the months of august to November 2014Pedrosa PlcCash BudgetFor the period from August 2014 to November 2014Opening Cash BalanceAugustSepOctNov15,40037,24043,39048,930Sales67,65060,40058,50055,500Cash Sales27,06024,16023,40022,2001 Month39,18040,59036,24035,100Rent Income9,0009,0009,0009,000Cash Receipt75,24073,75068,64066,300Net Cash Inflow90,640110,990112,030115,230YPurchases33,60032,60034,75035,650Cash Payments35,40033,60032,60034,750Wages18,00018,00018,00019,080Dividend16,000 Machine  12,5006,250Cash Payments53,40067,60063,10060,080     Ending Cash Balance37,24043,39048,93055,150The ending cash balance during month of August is £37,240 while the expected cash balance during September is £43,390.

Similarly the expected cash balance during October and November are £48,930 and £55,150 respectively as shown in the table above.2. Benefits of the budget to a business Organisations need budget to help in the evaluation of its performance. Without a financial planning that makes use of the budget, they would not be in a position to assess their progress and institute appropriate measures. Besides, they need budgeting for efficient coordination of the organisational activities. The budget acts like a blueprint that provides the roadmap and the expectation of the activities like sales, expenditures, and other costs.

When organisations do not use budgets to address these issues, they are at risk of running down the organisation because of unplanned activities that are likely to exceed the expectations. Budgeting helps organisations to take control of their finances, hence keeping focused on the goals they laid down when beginning the financial year. A budget helps the organisation plan savings and makes decisions in advance when expecting or not expecting any costs related to the activity of the organisation hence controlling debts (Young, 2003).2.1 What can be done to enhance budgeting process?

Budgeting process can be very challenging especially when there is poor communication between the team tasked with the making of decisions. Therefore, enhancing communication and reducing the number of people involved in the making of budget will help improve the process (Young, 2003). Besides, it is important to have time and iterate the budget because handling the process at the last minute may hamper the process. It is also crucial to have time to review and improve areas that may not represent the expectations of the organisation (Young, 2003).

BIBLIOGRAPHYYoung, R.D. (2003). Performance-Based Budget Systems - Public Policy & Practice, p. 12, available online from ww.iopa.sc.edu/ejournal/assets/performance%20based%20budgets.pdf [21st June 2015)

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Accounting and Finance will send you fquestions file Essay”, n.d.)
Accounting and Finance will send you fquestions file Essay. Retrieved from https://studentshare.org/finance-accounting/1698675-accounting-and-finance-will-send-you-fquestions-file
(Accounting and Finance Will Send You Fquestions File Essay)
Accounting and Finance Will Send You Fquestions File Essay. https://studentshare.org/finance-accounting/1698675-accounting-and-finance-will-send-you-fquestions-file.
“Accounting and Finance Will Send You Fquestions File Essay”, n.d. https://studentshare.org/finance-accounting/1698675-accounting-and-finance-will-send-you-fquestions-file.
  • Cited: 0 times

CHECK THESE SAMPLES OF Accounting and Finance will send you fquestions file

MBA 510 Problem Set I

What is the probability of selecting a female or an accounting major Which rule of addition did you apply250/500 = .... A recent article suggested that if you earn , 25, 000 a year today and the inflation rate continues at 3 percent per year, you'll need to make 33,598 in 10 years to have the same buying power.... you would need to make 44,771 if the inflation rate jumped to 6 percent.... A survey of undergraduate students in the School of Business at Northern University revealed the following regarding gender and majors of the students:MajorGender Accounting Management finance TotalMale 100 150 50 300Female 100 50 50 200Total 200 200 100 500a....
3 Pages (750 words) Essay

Management Principle of Nike

The researcher states that this essay is aimed to help us understand how a strategic objective could be attained through change in collective and individual behaviour of the employees of Nike, that is well-known worldwide sportswear corporation with headquarters in the US.... hellip; The researcher comments on various statements relating to “spend the company's money as if it were your own”, and “we want people to understand the thinking that lies behind it” as well as “finding out what other companies did in this are?...
14 Pages (3500 words) Essay

Dravid Luis and His Oppinions

This essay declares that the major ethical issue in this case is whether Dravid Luis will be doing or not doing what Jimmy Westfield wants regarding the documentation of the worth of the equipment which is at $3,500,000 following its net realizable value.... nbsp;… According to the study the options that are open for Dravid Luis are:  he can just follow the wish of Jimmy Westfield to record the value of the equipment using the net realizable value which is at $3,500,000....
8 Pages (2000 words) Essay

Harvard Style in Education

A cashiers, finance head and finance assistance have also become common support jobs.... Many colleges and universities are opening up on-campus finance offices.... These people are not actively involved in the preparation of goods or services that the organization is providing, but instead they have… the responsibility to provide services to direct labor or the organization's main functional departments in order to make sure that these functions are carried out without any hindrance or stoppage....
8 Pages (2000 words) Essay

Marks and Spencer Plc Financial Performance

This means that MKS needed to spend other expenses to finance some of its borrowing.... MKS is also obviously more profitable than GAP and Next in terms of the return on equity as per Table A below.... Such a show of superiority… A range of 24% to 42% return on equity definitely attracts investors in the last six years, as it would mean that for every £100 the investors expect returns of about £24 to £42....
9 Pages (2250 words) Essay

Employment Law

I know you are very much busy nowadays, but there is an important issue that needs your immediate attention.... John is working as supervisor of a team of five members in corporate accounting section of finance department.... Among the five members of the team of John are Mary and Michael, who are working as senior accounts In fact, corporate accounting team was among the top performing teams of the company.... Upon interviews with all team members and other team member of other concerned departmental teams, some important issues between the above mentioned three members of the corporate accounting team have been identified....
4 Pages (1000 words) Case Study

Budget Calculations within a Spreadsheet

The paper 'Budget Calculations within a Spreadsheet' focuses on a need to identify and discuss the problems within the business and provide well-reasoned recommendations.... An explanation of how the author has translated my recommendations into the figures used in your Cash Flow Forecast.... hellip; The breakeven turnover of JML for the previous year is L £ 691,500....
8 Pages (2000 words) Assignment

Fears of Debtors Filing Bankruptcy

hellip; Furthermore, I tackle the issues concerning the reasons why most debtors fear filing for bankruptcy and their thoughts and impression of what it entails to file for bankruptcy.... Normally the bankruptcy procedure will start with the person owing the debt; the debtor petitioning the bank to file for bankruptcy (Pelc, 91).... or example, you might take a loan in the bank for a particular purpose and you sign an agreement of repaying a certain amount of the loan every month or after a period of time, unfortunately, you lose your job that you were relying on to repay that particular loan....
6 Pages (1500 words) Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us