Q1: Given the following information:
div0 current dividend	0.5
g1 super growth rate	0.12
n1 super growth years	4
g2 normal growth rate	0.03
p0 current share price	75
Equity required rate of return	0.6

(a)USING VBA, Write a function called Value to use Gordon Two-Stage Growth Model formula to calculate the fair valuation of the share. You should solve for the fair valuation of the share

(b)USING VBA. Write another function called Advice to compare the fair market price with the current trading price, if the fair price is higher, return Yes, otherwise, return No.