You are planning for an early retirement, so you decide to invest $5,000 per year, starting at age 23. You plan to retire when you accumulate $1,000,000. If the average rate of return on your investments is 8%, which formula in B4 will allow you to determine how many years you must invest?
a) =NPER(B3,-B2,0,B1)/23
b) =NPER(B3,-B2,0,B1)*23
c) =NPER(B3,-B2,0,B1)
d) =NPER(B1,-B3,0,B2)
c) =NPER(B3,-B2,0,B1)
You might also like to view...
The auditor's report specifically covers the statements and disclosures made by management in the "Management Discussion and Analysis" (MD&A) section of the annual report
a. True b. False Indicate whether the statement is true or false
In human resource forecasting, ______ is a statistical technique that identifies the relationship between a series of variable data points for use in forecasting future variables.
A. quantitative forecast B. regression analysis C. qualitative forecasting D. trend analysis
A __________ is a decision maker who would choose a guaranteed payoff over a lottery with a better expected payoff.
A. risk taker B. risk-neutral C. risk avoider D. risk-creator
The strictest definition of "disability" used in disability insurance products is the:
A) inability to engage in any occupation B) inability to make the same income earned before the onset of the disability C) inability to earn non-wage income D) inability to engage in one's regular occupation