Please answer the following questions. Show all your formulas to be eligible for partial credit. And remember that when you use the perpetuity formula. the formula automatically present values the perpetuity one period, so if you use the perpetuity formula in year It'. the result is as of the beginning of year T and not the end. To make it easier for your l have prepared the template below for your use. if you wish to use it. The parts you need to put your formulas in are in yellow. If you have any questions, let me know. Week 3 temglate-lxls Problem 1 - Sensitivities Your manager has asked you to value Ted Enterprises, a potential acquisition. To make your life easier. your manager gave you some of the numbers in the template shown above. Your managerwants you to value Ted and show your results in a matrix that has: discount rates of 8%. 9%, and ll]% along the vertical long tem"l growth rates of 3%, 3.5%, and 4% along the horizontal Note that your manager wants the dollar price per share, so you must calculate the dollar value of the equity and then divide by the number of shares outstanding