1) Excel inc, is considering the investment in latest plant= $3 million. Project will be financed with the loan= $2,000,000 which will be repaid over next five years in equivalent annual end of year instalments at the rate of 6.5 percent pa. Suppose straight-line depreciation over the five-year life, and no taxes. Projects cash flows before loan repayments and interest are given in the table below. Cost of capital= 13.35% pa (necessary rate of return on the project). Salvage value= $200,000 is expected at the ending of year five and is included in = cash flows for year five below. Avoid taxes and inflation.

Year                 Cash Inflow
Year One            850,000
Year Two            900,000
Year Three          800,000
Year Four           900,000
Year Five            950,000

You are needed to compute:

(i) The annual loan repayment and a repayment schedule.

(ii) NPV of the project

(iii) the IRR of the project

(iv) AE, annual equal for the project(AE or EAV)

(v) PB, the payback in years (to one decimal place)

(vi) ARR, the accounting rate of return (gross)

(vii) PI (present value index or profitability index)

(viii) Is project acceptable? You should provide the decision for each of methods in parts (ii) to (vii). describe why or why not (give full description)?