Submit an excel file for the given question , containing all the calculations.

JK Engineering wants to invest in $10,000,000 in a new project that will increase EBIT by 30% of the cost of the project. The P/ E ratio is 11.43 and the company has 7,000,000 shares outstanding. JK Engineering can either issue new bonds, new preferred shares, or new common shares to finance the project. The common share price is $5. The following information is provided: 1. Cakulate the increase in net income, EPS, share price for the 3 scenarios. (15 marks) 2. If the project lasts 7 years, what is the NVP per common share (based on earnings per share) assuming that the company will completely recuperate its investment in year 7 . Include all cash flows up to year 7 and disregard cash outflows after year 7 . Assume a WACC of 15\%. (15 marks) 3. Based on your calculation in 1 and 2, which security should the company issue? ( 5 marks)