Maktan Construct is considering an investment which costs $6,500 and has an estimated cash flows of $1,500, $1,800, $2,500, $1,920, $2,543 in years 1 to 5, with an IRR of 10%. Management intends to borrow the investment sum from Landi Bank, using the estimated cash flow from the project to finance the loan.

a. As a loan officer at Landi Bank, set up a loan table for Maktan with the details above. (use Excel work book) (10 marks).

b. After setting up the loan table, you noticed a miscalculation of Maktans IRR, set up another table to correct the internal rate of return for this investment. (10 Marks).

c. If Landi Bank charges 12% interest rate for its loans, construct a loan table detailing an equal value payment plan for Maktan, running for 5 years. (10 Marks).