Purchase Solution

Present Value: Millionaire

Not what you're looking for?

Ask Custom Question

Suppose an 18-year-old Soldier wishes to retire from the Army as a millionaire. She intends to contribute $10,000 to the Thrift Saving Plan (TSP) at the end of each year until she retires with $1,000,000 in that account. Would she meet her retirement goal if the Army retains her until she is at 60 years of age, assuming the TSP offer her a constant 5% annual rate of interest for her entire time of service?

Now, suppose that she would like to retire as soon as possible with $1,000,000 in her account. Assuming that nothing else changes, what is the earliest age that she can retire?


You have deposited an amount of money (PV) into an account that will earn 3% interest, compounded on an annual basis. Your goal is to have $10,000 at the end of a six-year period, how much money do you initially deposit?

Solve for PV.

Purchase this Solution

Solution Summary

This solution illustrates how to find the future value of an annuity using Excel functions, how to find the number of periods using these functions, and how to find the present value of a lump-sum using these functions.

Purchase this Solution

Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Basics of corporate finance

These questions will test you on your knowledge of finance.