# Question 1: Complete Problem 14.1 on page 290 of the course text (solution is on page 523). Next, work the problem again using the following…

I have two questions in accounting. Can someone help me out? See belowQuestion 1:Complete Problem 14.1 on page 290 of the course text (solution is on page 523). Next, work the problem again using the following variables: project yield annual net cash inflows are \$10,500 for the next five years; interest rate of 16.5%, and the initial investment of \$33,000. Calculate the net present value of the cash flows and the IRR for the project using the Excel spreadsheet formula. Explain the concept of Net Present Value.Page 290Question 14.1The Whitton Co. has an opportunity to buy 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 would be zero. Whitton’s cost of capital is 16%Calculate the net present value of the cash flows for the computer using spreadsheet formula.What is the IRR?Solution for 14.1 (Page 523)Formula for present value= +NPV (16%, C3:E3). The cash flows are entered in columns C (Year 1) to E (Year 3). See Table S 14.1.Table S14.1Col EYear 310,00022,459-18,000£ 4,459To calculate IRR using the spreadsheet function, a negative figure (the initial cash investment) must be part of the range of values.Formula for IRR = + IRR (B3:E3). Year 310,00031%Question 2:Complete Problem 16.4 on page 329-330 of the course text (solution is on page 533-534 – Table S16.4). Next work the problem again using the following variables: The selling price is expected to be £350 per ton for the first three months and £360 per ton thereafter. Variable costs per ton are predicted 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 16.4. What is the cumulative cash flow at the end of Quarter 4? Be prepared to paste your worksheet for this problem into the OAESPage 329-330Problem 16.4Griffin Metals Co. has provided the following data:Anticipated volumes (assumes production equals sales each quarter):100,000 tonnes110,000 tonnes105,000 tonnes120,000 tonnesThe selling price is expected to be £300 per tonne for the first six months and £310 per tonne thereafter. Variable costs per tonne are predicted as £120 in the first quarter, £125 in the second and third quarter, and £130 in the fourth quarter.Fixed costs (in £ ‘000 per quarter) are estimated as follows:£3,000 for the first half year, increasing by 10 for the second half year£1,500£400£120£1,000£5,400£2,500 in the first and fourth quarters, £1,800 in the second and third quarters£600£6,500 in the first quarter, £2,000 in the second quarter, £1,000 in the third quarter and £9,000 in the fourth quarter.£10,000 in the third quarterand £3,000 in the fourth quarter.Griffin has asked you to produce a profit budget and a cash forecast for the year (in four quarters) using the above data.Solution for 16.4 (Pages 533-534)Total120,000310130Budget in £’000132,75054,47578,2756,0001,6004804,000Total21,6008,60054,8802,40020,99521,60042,595 18,59513,0001,095 1,095