Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. You are financially advising a soccer player who has just been hired for the next 9 years with a fixed salary of $45,000,000 per

a. You are financially advising a soccer player who has just been hired for the next 9 years with a fixed salary of $45,000,000 per month. The player decides to save 30% of his salary and invest it in a fund that pays 1.81% per month for 9 years. When the player's contract runs out, he wants to retire from soccer and never play professionally again for the rest of his life. For this reason, he decides to invest the money he saved in life annuity insurance (perpetuity) that gives him a 1.5% return at the end of each month. The player (his client) asks him how much income will he have monthly after he retires from soccer?

b. Using the information from the previous exercise, suppose that now the player wants to have an income after his retirement from soccer that increases each month, so that it at least partially offsets the effect of inflation on his purchasing power. Said monthly increase rate must be equivalent to 4% per year. In that case, how much will his income be in the first month of retirement and how much will his income be in the last month of year 10 after his retirement from soccer? Compare with the income from the previous point and comment.

Please give answer in excel format/formulas. The b is important since i already have the answers for a but needed to include the question here for context.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Stock Market Trading For Beginners

Authors: Irvin Tarr

1st Edition

1491885327, 978-1491885321

More Books

Students also viewed these Finance questions