3 Xfx =FV( B D E F 4 Function: FV; Cell Referencing Using Excel to Determine...

Transcribed Image Text:

3 Xfx =FV( B D E F 4 Function: FV; Cell Referencing Using Excel to Determine the Amount of an Investment PROBLEM 5 Adams Inc. will deposit money into a fund at the end of 6 each year beginning December 31, 2025. Information 7 concerning the investment is provided here. 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. 8 9 Amount to be deposited $ 30,000 10 Interest rate on fund 6% 11 Number of annual deposits 8 12 13 14 15 16 17 18 19 20 21 29 31 36 2222222235335 33 24 K Use the FV function to determent the amount that will be in the fund immediately after the last deposit. Display your answer as a positive amount. Amount in fund after last deposit FV I FV(rate, nper, pmt, [pv]. [type]) Description Returns the future value of an investment based on periodic, constant payments and a constant interest rate Example FV(0.06/12, 10, -200, -500, 1) rate is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR nper is the total number of payment periods in the investment pmt is the payment made each period; it cannot change over the life of the investment [pv] is the present value, or the lump-sum amount that a series of future payments is worth now. If omitted. Pv = 0 [type] is a value representing the timing of payment: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted Learn more about FV Give feedback 3 Xfx =FV( B D E F 4 Function: FV; Cell Referencing Using Excel to Determine the Amount of an Investment PROBLEM 5 Adams Inc. will deposit money into a fund at the end of 6 each year beginning December 31, 2025. Information 7 concerning the investment is provided here. 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. 8 9 Amount to be deposited $ 30,000 10 Interest rate on fund 6% 11 Number of annual deposits 8 12 13 14 15 16 17 18 19 20 21 29 31 36 2222222235335 33 24 K Use the FV function to determent the amount that will be in the fund immediately after the last deposit. Display your answer as a positive amount. Amount in fund after last deposit FV I FV(rate, nper, pmt, [pv]. [type]) Description Returns the future value of an investment based on periodic, constant payments and a constant interest rate Example FV(0.06/12, 10, -200, -500, 1) rate is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR nper is the total number of payment periods in the investment pmt is the payment made each period; it cannot change over the life of the investment [pv] is the present value, or the lump-sum amount that a series of future payments is worth now. If omitted. Pv = 0 [type] is a value representing the timing of payment: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted Learn more about FV Give feedback