Need help with excel functions please

$50 5% Build a flexible model to calculate the present value of receiving $50 for 8 years. Assume a discount rate of 5%. Assume cash flows start at time 6 Allow your model to accommodate up to 25 periods Cash Flow Discount Rate Periods Starting Period PV Threshold 8 6 $30 Your answer 16 Use your models to answer the following questions: What is the present value of receiving $1 for 25 years? What is the present value of all annuity cash flows? What is the sum of the years' digits occurring in year 14 or later? (Do not hard-code the 14 and note that 14 is equal to G3 + G4) Correct Answer $14.09 $253.20 234 17 18 Year Present Value of $1 Cash Flow Present Value of Cash Flow