1. According to the Seton Hall Career Center (https://www.shu.edu/career-center/career-outcomes.cfm), finance majors that graduated from the Stillman School of Business in 2017 earned an average salary of $58,718 per year their first year after graduation. Assume that is the salary that you will earn following graduation at your first job when you graduate. Further assume that you stay at that job for your entire career and earn a 3% raise each year. If you start working when you are 20 years old, how much money will you earn per year when you are 60 (40 years later)?

PV = $58,718 FV = ? FV = PV(1 + r)^t

R = .03 = 58,716(1 + 0.03)⁴⁰

T = 40 FV = $191,533.81

2. According to financial planners, the average retiree requires approximately 70% of their last years working salary (answer to #1) each year to live comfortably in retirement. Assume that you want to earn a fixed amount of interest each year in retirement. Your goal is to spend only the interest and still live comfortably. And, you want to earn the interest forever so that what remains can be passed onto your children, donated your favorite charity, or donated in honor of your favorite finance professor. That is, you want to earn a fixed amount, each year, for an indefinite amount of time. If you retire at 60 and can earn a 5% return, how much must you have saved to earn the required amount of interest?

PV = 191,533.81 191,533.81 x .7 = 134,073.67

R = 0.05 Amount saved = 134,073.67 .05 = $2,681,473.40

3. If you die when you are 90 years old, how much money will be left to bequeath?

$2,681,473.40

4. What if instead of saving for someone else, you expect to live until you are 90 years old at which point you plan to have no money left at all. If you can earn 5% per year, how much must you have saved up at 60 to earn a 70% of your pre-retirement salary (answer to #1) each year until you are 90?

t = 30 R = .05 PV = ? Excel Function PV =$2,061,040.93

CF = 134,073.67 FV = 0 =PV(0.05,30,134073.67,0)

5. Assuming the latter scenario (you plan to leave nothing to your heirs - question #4), how much of the principle amount of money that you saved do you still have left after 5 years? Hint: Treat this like an amortizing loan. The amount that you saved is like the loan amount and the payments are the amount that you use each year to spend on expenses.

Excel Function FV =FV(0.05,5,-134073.67,2061040.93) = $1,889,626.88

6. Suppose that instead of being responsible, you spend $175,000 per year. How long will it be until you are broke?

7. Again, assuming that you plan to leave your heirs nothing, how much will you have to put away each year if you start saving when you are 20 years old? What if you start saving when you are 30?

I need the solution for numbers 6 and 7