PLEASE show the steps in excel, thank you!An investment offers $$3,850$ per year for $15$ years, with the first payment

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?

Input area:

$($Use cells A$6$ to B$10$ from the given information to complete this question.Your annswers should be positive values.$)$

Value today for $15$ years of payments

Value today for $40$ years of payments

Value today for $75$ years of payments

Value today of perpetuity