Nick, age 30, is starting his savings plan this year by putting away $2,900.00 at the end of every year until he reaches age 65. He will deposit this money at his local savings and loan at an interest rate of 6%. The future value annuity interest factor is 111.4348. You can also use the excel future value (FV) function to solve this problem. =FV(rate,nper,pmt,[pv],[type]) • rate: The interest rate per period. This input is required. • nper: The total number of payment periods. This input is required. • pmt: The constant payment made in each period. This input is required if pmt is omitted. • pv: The present value or lump-sum amount. This input is required if pmt is omitted. • type: A 0 or 1 depending on if payments are due at the beginning or end of the period. This input is optional and 0 will be used if it is omitted. Based on the information provided, by the time Nick turns 65, he will have .
Nick, age 30, is starting his savings plan this year by putting away $2,900.00 at the end of every year until he reaches age 65. He will deposit this money at his local savings and loan at an interest rate of 6%. The future value annuity interest factor is 111.4348. You can also use the excel future value (FV) function to solve this problem. =FV(rate,nper,pmt,[pv],[type]) • rate: The interest rate per period. This input is required. • nper: The total number of payment periods. This input is required. • pmt: The constant payment made in each period. This input is required if pmt is omitted. • pv: The present value or lump-sum amount. This input is required if pmt is omitted. • type: A 0 or 1 depending on if payments are due at the beginning or end of the period. This input is optional and 0 will be used if it is omitted. Based on the information provided, by the time Nick turns 65, he will have .
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Nick, age 30, is starting his savings plan this year by putting away $2,900.00 at the end of every year until he reaches age 65. He will deposit this money at his local savings and loan at an interest rate of 6%.
The future value annuity interest factor is 111.4348.
You can also use the excel future value (FV) function to solve this problem.
=FV(rate,nper,pmt,[pv],[type])
• | rate: The interest rate per period. This input is required. |
• | nper: The total number of payment periods. This input is required. |
• | pmt: The constant payment made in each period. This input is required if pmt is omitted. |
• | pv: The present value or lump-sum amount. This input is required if pmt is omitted. |
• | type: A 0 or 1 depending on if payments are due at the beginning or end of the period. This input is optional and 0 will be used if it is omitted. |
Based on the information provided, by the time Nick turns 65, he will have
.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education