TheOilMan LLP is a master limited liability partnership that engage in oil extraction. It will pay an annual dividend of $4.60 a share next year. After that, the dividend is expected to decline by 10% a year for 4 years. The partnership expects to pay a $8 a share liquidating dividend in year 6. After that, the company will cease operations. What is the current value per share at a discount rate of 12.5 percent?

Please do in Excel and show formulas. Thank you.