Must show all work (how did you get the numbers)

Madison & Chris, a local bridal shop, is considering moving from their current rental location by purchasing a new storefront property in the middle of the suburban shopping mall. Management estimates that the move would increase current yearly pre-tax cash inflows by $80,000 per year. Purchasing the new property would cost $500,000. Management expects to remain at the new site for the next 15 years and uses the straight-line depreciation method. At the end of 15 years, they expect the property will only be worth $50,000 because it will be torn down for redevelopment. Madison & Chris can obtain the necessary funds for the project from several sources. The following list details the percentage of the funds provided and the rates of return required by each capital source. Bank Loan: New owner investment: Bond issuance: 50% of funds, 10% interest rate 30% of funds, 8% return expected 20% of funds, 6% bond interest stipulated The company pays a marginal tax rate of 30%. Judging by the Excess Present Value Index, does the proposed relocation at least meet the company's Weighted Average Cost of Capital? Use a financial calculator to compute Present Value of the future cash flows