enter excel formula along with the answers

1. Calculate the value of the investment. 35.. FILE HOME Calculating Annuity Present Value - Excel FORMULAS DATA REVIEW INSERT PAGE LAYOUT VIEW Sign in Paste Calibri - 11 AA BIU. A. Font = BE Alignment Number Conditional Format as Cell Formatting Table Styles - Styles Cells Clipboard An investment offers $6,100 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? 6.100 Payment per year # of years Required rate of return # of years # of years Complete the following analysis. Do not hard code values in your calculations. Your answers should be positive. Value today with 15 years payments Value today with 40 years payments Value today with 75 years payments 20 Value today of perpetuity Sheet1- - E U -- READY Attempt(s) + 100% Show Me Hint