Computer question NSJCT is considering a project t...
Computer question NSJCT is considering a project that requires initial investment of €150,000 in new machinery. The project will be shut down at the end of four years. The following is the projected cash flow from the project: Year 1 2 3 4 Sales €120,000 €120,000 €140,000 €140,000 Operating expenses €40,000 €40,000 €50,000 €50,000 The firm can raise funds at 8% and its tax rate is 45%. In Lesson 5 when depreciation was first introduced, it was mentioned that the different methods of depreciation for tax purposes will result in different tax shields. In this exercise, you will examine the effects of this difference. In part (a) you will calculate the after-tax cash flows that would occur if straight-line depreciation were an allowable expense for tax purposes. You will compare this to the cash flows in part (b) where a declining balance method is used. You will use the same worksheet for both parts. a. Assume that the proposed machinery is to be depreciated over four years on a straight-line basis, with no salvage value at the end of the four years. For this part, assume that the depreciation expense can be deducted from income to calculate the net tax for NSJCT. Use Excel file I-FN1L6Q1 to compute the net present value and the internal rate of return for this project over four years. b. Assume depreciation for tax purposes is to be taken using the declining-balance method at the rate of 20% for capital cost allowance. For this part, assume the machinery will have a salvage value of €30,000 at the end of year 4, and that the asset class to which it belongs will not be left empty by the sale of the machinery at that time, and that the half year rule does not apply to the salvage value. Use Excel file I-FN1L6Q1 to compute the net present value and the internal rate of return for this project. Also compute the net cash flow from this project for each of the four years. Compare the results from parts (a) and (b) and comment on the difference.