Project 1Calculations must be done in Excel

Polycorp is considering an investment in new plant of $3 million.The project will be partially financed by a loan of $2 million, which will be repaid over five years in equal annual end of year instalments at a rate of 6.5 percent pa.The rest of the project will be financed by equity. Assume straight-line depreciation over a five-year life, and no taxes. The project's cash flows before loan repayments and interest are in the table below. Cost of capital is 12.30% pa (the required rate of return on the project). A salvage value of $190,000 is expected at the end of year five and isnot includedin the cash flows for year five below.

Year. Year One. Year Two. Year Three. Year Four. Year Five

Net Flows Cash. 850,000. 970,000 881,500 934,530 945,000

You are required to calculate:

(1)The amount of the annual loan repayment and produce a repayment schedule.

(2)NPV of the project (to the nearest dollar)

(3)IRR of the project (as a percentage to two decimal places)

(4)AE, the annual equivalent for the project (AE or EAV) (to the nearest dollar)

(5)PB, the payback and discounted payback in years (to one decimal place)

(6)ARR, the accounting rate of return (gross and net) (to two decimal places)

(7)PI (present value index or profitability index) (to two decimal places)

(8)Is the project acceptable? You must provide a decision or explanation for each of the methods in parts (2) to (7). Why or why not (provide a full explanation)? Also, a brief explanation of your treatment of Salvage Value and Loan Repayments is required.