Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. your father is 50 years old and will retire in 10

Your father is 50 years old and will retire in 10 years. He expects to live...

90.2K

Verified Solution

Question

Finance

Your father is 50 years old and will retire in 10 years. He expectsto live for 25 years after he retires, until he is 85. He wants afixed retirement income that has the same purchasing power at thetime he retires as $60,000 has today. (The real value of hisretirement income will decline annually after he retires.) Hisretirement income will begin the day he retires, 10 years fromtoday, at which time he will receive 24 additional annual payments.Annual inflation is expected to be 4%. He currently has $140,000saved, and he expects to earn 7% annually on his savings. The datahas been collected in the Microsoft Excel Online file below. Openthe spreadsheet and perform the required analysis to answer thequestion below.

How much must he save during each of the next 10 years(end-of-year deposits) to meet his retirement goal? Do not roundyour intermediate calculations. Round your answer to the nearestcent.

Answer & Explanation Solved by verified expert
3.6 Ratings (528 Votes)
Money does not have the same value in Time o and Time 1 1000 today has more worth and purchasing power than 1000 after 10 years This is mainly due to inflationary effectHence to maintain the current expenditure levels in future years you need to have a higher principal base Solution Input Data Current Age 50 Years Input Data    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A recent study found that 61 children who watched a commercial for potato chips featuring a...

Basic Math
Q

In the New Keynesian Macroeconomics business cycles are driven by demand shocks, while in the New...

Economics
Q

Which ecosystem profile below has the greatest biodiversity? A.) An area with 250 birds of...

Biology
Q

An image of the species of trees and the percentage of trees found in two...

Biology
Q

The half life of a radioactive nucleus is 50 days. The time interval (t2-t?) between...

Physics
Q

6) From an airplane flying at a constant altitude over the ocean, the angle of...

Basic Math
Q

Step 3 our goal is to maximize the area A where A w 44w and...

Calculus
Q

A Plus taxi service charges 6 initially and 2 per mile Luxury taxi service charges...

Algebra
Q

d. 66. The objectives of internal control are to a. control the internal organization of...

Accounting
Q

The initial post should be 200-500 words and is expected to be substantive, scholarly, and...

Accounting
Q

What will treating a capital expenditure as an immediate do to expense, equity and assets?...

Accounting
Q

On November 1 ATD enters a 1-year contract to provide security for CorpCo's warehouses for...

Accounting