Kilarny Company is considering investing in an annuity contract that will return an amount at the...

  

Transcribed Image Text:

Kilarny Company is considering investing in an annuity contract that will return an amount at the end of each year for 15 years. Annuity payment to be received Number of annuity payments Desired return $25 000 15 6% What amount should Kilarny Company pay for this investment to generate the desired return? Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. Show calculations using any of the following methods. a. Factor Table PV.2 (Display the factor with 5 decimals.) Annuity amount Present Value b. Financial calculator Fields 1 N PMT FV PV c. Excel's PV function Present value Factor Input Present Value Kilarny Company is considering investing in an annuity contract that will return an amount at the end of each year for 15 years. Annuity payment to be received Number of annuity payments Desired return $25 000 15 6% What amount should Kilarny Company pay for this investment to generate the desired return? Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. Show calculations using any of the following methods. a. Factor Table PV.2 (Display the factor with 5 decimals.) Annuity amount Present Value b. Financial calculator Fields 1 N PMT FV PV c. Excel's PV function Present value Factor Input Present Value