Hello! I'm having some issue solving this homework problem and was hoping someone could help me solve this problem. Please provide step-by-step instructions for each part & solve within Excel, showing your formulas used

Note: Please do not attempt problem if you do not know how to solve/are unsure if your answer is correct/or if you cannot provide step-by-step instructions, or I will have to give your answer a thumbs down. I don't mean to be rude, I've just had some issues with incorrect answers/incomplete solutions previously, and I would really like to figure out how to solve these types of problems.

Thank you so much in advance if you are able to help me with this problem, I truly appreciate it!

A firm currently experiencing extraordinary growth of 30% per year, but the project responsible for this rapid growth will end in 4 years. Once this project ends the firm is anticipated to reinvest 20% of its earnings into perusing new projects averaging a 6% return for the indefinite future. If the last dividend paid by the firm was $3.50 and your required rate of return is 10%, how much should you be willing to pay for this stock? Answer is a whole number with no decimal places