please do in Excel if possible. Thanks

The managing director of family owned business, Cando Franchise Ltd, believes that the business could earn an additional $800,000 in profit before interest and taxes each year by expanding its range of products. However, the business needs an extra $4 million for growth and this amount cannot be raised by the family. The managing director wishes to retain family control of the firm, but with no choice he has to consider issuing securities to outsiders. He is considering three alternatives financing plans. Plan A is to borrow at 11% over five years Plan B is to issue 100,000 ordinary shares at $40 each. Plan C is to issue 40,000 non-voting preference shares at $100 each, with each share entitled to an annual preference dividend of $8.80. Cando Franchise Ltd has 500,000 ordinary shares issued. All three plans will raise the required amount, $4 million The income tax rate is 30%. The managing director of family owned business, Cando Franchise Ltd, believes that the business could earn an additional $800,000 in profit before interest and taxes each year by expanding its range of products. However, the business needs an extra $4 million for growth and this amount cannot be raised by the family. The managing director wishes to retain family control of the firm, but with no choice he has to consider issuing securities to outsiders. He is considering three alternatives financing plans. Plan A is to borrow at 11% over five years Plan B is to issue 100,000 ordinary shares at $40 each. Plan C is to issue 40,000 non-voting preference shares at $100 each, with each share entitled to an annual preference dividend of $8.80. Cando Franchise Ltd has 500,000 ordinary shares issued. All three plans will raise the required amount, $4 million The income tax rate is 30%