John Stewart has recently joined ABC in the capacity of an investment advisor. As a way toattract additional clients, John has asked for your help in preparing some educational material fora seminar taking place later this month.He has asked you put together a report on the following investments and calculate the returns ofthese investments (including dollar values and percentages) to illustrate how they work.Assignment1. Perform the 5 calculations listed below:oShow all of your work as well as any formulas that you used.oIf you used MS Excel to arrive at your answers, then you must provide anexplanation of your methodology.A stock that does not pay a dividend of which you buy 100 shares for $25.00 pershare and sell the 100 shares for $27.50 per share a year later. You pay the $50.00commission when you sell the securities.A 5-year bond that you purchase for $1,000 pays a 6% yearly rate. It is paidsemiannually, and you hold the bond until maturity.The current yield on a bond that is priced at $89 has a 6% coupon.The yield-to-maturity (YTM) on a 7.25% ($1,000 par value) bond that has 10years remaining to maturity, currently trading in the market at $825.The holding period return (HPR) for 1,000 shares of a no-load mutual fundcurrently selling at an NAV of $11, purchased a year ago at an NAV of $10.50 pershare, including $300 of distributed investment income dividends and capitalgains dividends of $350.2. Next, answer the following questions:oExplain systematic and unsystematic (also known as nonsystematic) risk.oWhat are the different types of investments a person can make?oExplain a stock’s beta coefficient and how it ties into systematic versusunsystematic risk.oWhat are the differences between the various types of bonds?oWhat do bond ratings indicate, and what 2 major agencies are in charge ofassigning these ratings?3. Compile your calculations, MS Excel tables and explanations (if applicable), and yourresponses to the 5 points above into a single Word document.