Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Social Security will give me the following amounts per year, depending on when I retire: Age 62 $28,680/yr till death Age 65 $35,304/yr till death,

 Social Security will give me the following amounts per year, depending on when I retire:

Age 62 $28,680/yr till death

Age 65 $35,304/yr till death, and no Social Security benefit before then.

Age 67 $40,740/yr till death, and no Social Security benefit before then.

Assume a conservative discount factor of 5%.

I expect to live to age 80.

I'm currently 60.

I make $75k a year and will continue to work until I begin to claim my social security benefit, at which point I will resign from MSU.

BTW - Social Security will allow me to earn $20k a year in employment income without penalizing my retirement benefit. This will be done by the beginning of the year I start social security and continue to do so until age 70.

Calculate the NPV for each of the three scenarios using an Excel worksheet. Pleaseprovide me with the formulas used at every step. When should I retire?

Also - what's the total amount I'd receive for each scenario without discounting? What lesson have you learned?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Scenario 1 Retiring at Age 62 Given information Annual Social Security benefit at age 62 28680 Expec... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions

Question

Name the three parts of the pharynx?

Answered: 1 week ago