John Would Like to Establish a Retirement Plan That Returns

question 45

Essay

John would like to establish a retirement plan that returns an amount of $100,000 after a period of 20 years from now. Build a spreadsheet model to calculate the amount John must contribute at the end of each year towards his retirement fund, assuming an annual interest rate of 6%.
Use the Excel function
=PMT(rate, nper, pv, fv, type)
The arguments of this function are
rate = the interest rate for the loan
nper = the total number of payments
pv = present value (the amount borrowed which is 0 in this case)
fv = future value (in the formula, indicate this value as negative as the future value command assumes a stream of payments not deposits)
type = payment type (0 = end of period, 1 = beginning of the period)
Also, construct a one-way table with interest rate as the column variable and the amount contributed at the end of each year as the output. Vary the interest rate from 4% to 7% in increments of 0.5%.

---

Definitions:

Top-Down Processing

An information processing approach where perception begins with the brain, applying what it knows or expects to perceive and interpret the information from that top-level down.

Corrective Eye Surgery

Surgical procedures that aim to correct vision problems, such as nearsightedness, farsightedness, or astigmatism, to reduce dependency on glasses or contact lenses.

Visually Distinguish

The ability to identify and differentiate objects or elements based on visual cues and characteristics.

Immanuel Kant

An 18th-century German philosopher known for his critical philosophy, especially his critique of pure reason and moral philosophy.