Question 1the whitton co has an opportunity to purchase a

Reference no: EM13348253

Question 1:

The Whitton Co. has an opportunity to purchase a computer now for £18,000 that will yield annual net cash inflows of £10,000 for the next three years, after which its resale value could be zero. Whitton's cost of capital is 16% determine the net present value of the cash flows for the computer using spreadsheet formula.

Evaluate the IRR?

Formula for present value= +NPV (16%, C3:E3).

The cash flows are entered in columns C (Year 1) to E (Year 3).

Col A Col B Col C Col D Col E
Year 0 Year 1 Year 2 Year 3
Cash flows 10,000 10,000 10,000
Present value 22,459
Initial investment -18,000
NPV £ 4,459

To evaluate IRR using the spreadsheet function, a negative figure (the initial cash investment) have to be part of the range of values.
Formula for IRR = + IRR (B3:E3).

Year 0 Year 1 Year 2 Year 3
Cash flows - 18,000 10,000 10,000 10,000
IBR 31%

Question 2:

The selling price is expected to be £350 per ton for the first 3 months and £360 per ton thereafter. Variable costs per ton are shown as £100 in the first quarter, £120 in the second quarter, and £130 in the last two quarters; and salary and wages do not increase in the last two quarters. The rest of the assumptions are as listed on problem. What is the cumulative cash flow at the end of Quarter 4?

Reference no: EM13348253

Questions Cloud

Question 1a a lifting hoist chain that had been in use for : question 1a a lifting hoist chain that had been in use for an unknown number of years in a scrap metal yard broke and

Question 1ai define the term combustionii explain clearly : question 1ai define the term combustionii explain clearly using a suitable sketch the components and conditions

Question 1 a explain clearly the elements of the fire : question 1 a explain clearly the elements of the fire triangle and how they fit with each otherb describe the various

Question 1a identify the components of a fire triangleb : question 1a identify the components of a fire triangleb explain the condition required for combustion process to be

Question 1the whitton co has an opportunity to purchase a : question 1the whitton co. has an opportunity to purchase a computer now for pound18000 that will yield annual net cash

Question 1myriad solutions inc issued 10 bonds dated : question 1myriad solutions inc. issued 10 bonds dated january 1th with a face amount of 320 million on january 1 2013

Question 1the effect of a hazardous substance depends on : question 1the effect of a hazardous substance depends on the concentration of the substance that is present in the

Questionluke valued and sold at 210000 his original basis : questionluke valued and sold at 210000. his original basis in the land was 180000.for the land luke received 60000 in

Tiger computers inc of singapore is taking the purchase of : tiger computers inc. of singapore is taking the purchase of an automated etching machine for use in the production of

User Account

All Pages