An investment offers $$3,850$ per year for $15$ years, with the first payment

$2$

occurring one year from now. If the required return is $6$ percent, what is the value of the investment? What would the value be if the payments occurred for $40$ years? For $75$ years? Forever?

$3$

$4$ Input area:

$5$

$6$ Payment per year

$7$ Number of years

$8$ Required rate of return

$9$ Number of years

$10$

Number of years

$$3,850$

$15$

$6\%$

$40$

$75$

Please Provide excel equations.