Can someone pleas assist me.For the highlighted questions,in the attachment, I am looking to see the answers in an excel worksheet with the formulas built in.

ROBERT BALIK AND CAROL KIEFER ARE SENIOR VICE-PRESIDENTS OF THE MUTUAL OF CHICAGO INSURANCE COMPANY. THEY ARE CO-DIRECTORS OF THE COMPANY'S PENSION FUND MANAGEMENT DIVISION, WITH BALIK HAVING RESPONSIBILITY FOR FIXED INCOME SECURITIES (PRIMARILY BONDS) AND KIEFER BEING RESPONSIBLE FOR EQUITY INVESTMENTS. A MAJOR NEW CLIENT, THE CALIFORNIA LEAGUE OF CITIES, HAS REQUESTED THAT MUTUAL OF CHICAGO PRESENT AN INVESTMENT SEMINAR TO THE MAYORS OF THE REPRESENTED CITIES, AND BALIK AND KIEFER, WHO WILL MAKE THE ACTUAL PRESENTATION, HAVE ASKED YOU TO HELP THEM. TO ILLUSTRATE THE COMMON STOCK VALUATION PROCESS, BALIK AND KIEFER HAVE ASKED YOU TO ANALYZE THE BON TEMPS COMPANY, AN EMPLOYMENT AGENCY THAT SUPPLIES WORD PROCESSOR OPERATORS AND COMPUTER PROGRAMMERS TO BUSINESSES WITH TEMPORARILY HEAVY WORKLOADS. A. DESCRIBE BRIEFLY YOU ARE TO ANSWER THE FOLLOWING QUESTIONS. THE LEGAL RIGHTS AND PRIVILEGES OF COMMON STOCKHOLDERS. B. 2. WHAT IS A CONSTANT GROWTH STOCK? HOW ARE CONSTANT GROWTH STOCKS VALUED? B. 3. WHAT HAPPENS IF A COMPANY HAS A CONSTANT g THAT EXCEEDS ITS k s? WILL MANY STOCKS HAVE EXPECTED g > k s IN THE SHORT RUN (THAT IS, FOR THE NEXT FEW YEARS)? D. IN THE LONG RUN (THAT IS, FOREVER)? ASSUME TEMPS THAT BON IS A CONSTANT GROWTH COMPANY WHOSE LAST DIVIDEND (D0, WHICH WAS PAID YESTERDAY) WAS $2.00 AND WHOSE DIVIDEND IS EXPECTED TO GROW INDEFINITELY AT A 6 PERCENT RATE. 1. WHAT IS THE FIRM'S EXPECTED DIVIDEND STREAM OVER THE NEXT 3 YEARS? 2. WHAT IS THE FIRM'S CURRENT STOCK PRICE? 3. WHAT IS THE STOCK'S EXPECTED VALUE ONE YEAR FROM NOW? 4. WHAT ARE THE EXPECTED DIVIDEND YIELD, THE CAPITAL GAINS YIELD, AND THE TOTAL RETURN DURING THE FIRST YEAR? E. NOW ASSUME THAT THE STOCK IS CURRENTLY SELLING AT $30.29. WHAT IS THE EXPECTED RATE OF RETURN ON THE STOCK? F. WHAT WOULD THE STOCK PRICE BE IF ITS DIVIDENDS WERE EXPECTED TO HAVE ZERO GROWTH? G. NOW ASSUME THAT BON TEMPS IS EXPECTED TO EXPERIENCE SUPERNORMAL GROWTH OF 30 PERCENT FOR THE NEXT 3 YEARS, THEN TO RETURN TO ITS LONG-RUN CONSTANT GROWTH RATE OF 6 PERCENT. VALUE UNDER THESE CONDITIONS? WHAT IS ITS EXPECTED DIVIDEND YIELD AND CAPITAL GAINS YIELD IN YEAR 1? H. WHAT IS THE STOCK'S YEAR 4? SUPPOSE BON TEMPS IS EXPECTED TO EXPERIENCE ZERO GROWTH DURING THE FIRST 3 YEARS AND THEN TO RESUME ITS STEADY-STATE GROWTH OF 6 PERCENT IN THE FOURTH YEAR. WHAT IS THE STOCK'S VALUE NOW? WHAT IS ITS EXPECTED DIVIDEND YIELD AND ITS CAPITAL GAINS YIELD IN YEAR 1? YEAR 4? I. FINALLY, ASSUME THAT BON TEMPS' EARNINGS AND DIVIDENDS ARE EXPECTED TO DECLINE BY A CONSTANT 6 PERCENT PER YEAR, THAT IS, g = -6%. WHY WOULD ANYONE BE WILLING TO BUY SUCH A STOCK, AND AT WHAT PRICE SHOULD IT SELL? EACH YEAR? WHAT WOULD BE THE DIVIDEND YIELD AND CAPITAL GAINS YIELD IN