Ghost, Inc., has no debt outstanding and a total marketvalue of $185,000. Earnings before interest and taxes, EBIT, are projected to be $29,000 if economic conditions are mormal. If there is strong expansion in the economy, then the EBIT will be 30% higher. If there is a recession, then EBIT will 40% lower. The company is considering a $65,000 debt issue with a 7% interest rate. The proceeds will be used to repurchase shares of stock. There are currently 7,400 shares outstamding. Ignore taxes for this problem. Suppose the company has a market to book ratio of 1.0 and stock price remains constant.

c. calculate the non-operating terminal year cash flow.

d. calculate the project's payback period

e. calculate the project's IRR

g. Calculate the projects MIRR

Please use excel and show formulas. Thank you kindly.