Your financial advisor tells you $($investor$)$ that below hotel investment proposal is a good investment.

$$1,000,000$ investment now

a rate of $8\%$ for $10$ years

your minimum required rate is $8\%$

returning a lump sum total repayment of $$2,000,000$ at the end of the $10-$year period

Do you agree with the financial advisor that it is NOT a good investment? Or you don't agree with the financial advisor and think it is a good investment?

Explain with calculations $($Excel function$)$ to support your answer.