Given data below Answer the questions. Function: PMT; Cell Referencing Using Excel to Determine a Payment Amount

Given data below Answer the questions.

Transcribed Image Text:

Function: PMT; Cell Referencing Using Excel to Determine a Payment Amount PROBLEM Maria Alvarez is investing in a fund that earns interest compounded annually. She would like to withdraw each amounts at the end of each year. Information concerning the investment is provided here. Amount of investment Annual interest rate $ 300,000 Term of investment in years 4% 20 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Use the PMT function to determine the amount Maria can withdraw at the end of each of the next 20 years. Display your answer as a positive amount. Payment amount Function: PMT; Cell Referencing Using Excel to Determine a Payment Amount PROBLEM Maria Alvarez is investing in a fund that earns interest compounded annually. She would like to withdraw each amounts at the end of each year. Information concerning the investment is provided here. Amount of investment Annual interest rate $ 300,000 Term of investment in years 4% 20 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Use the PMT function to determine the amount Maria can withdraw at the end of each of the next 20 years. Display your answer as a positive amount. Payment amount