Determine how much her investment be worth

Reference no: EM131926646

Question: Susie makes $1,900 per month and has an opportunity to save $100 per month at an APR of 3.25 in a 401K plan through work. She plans to retire in 40 years. If income taxes are at 20% for her:

a. If Susie's company offered a 50% matching, use Excel to determine how much her investment be worth in 40 years.

Write the Excel formula that gives its future value _____

Write the future value the formula gives: _____

b. How much would the company contribute to Susie's 401K over the 30 years?

c. How much more is in the account when Susie retires than how much she deposited?

Reference no: EM131926646

Questions Cloud

How do markets react to announcements of security issues : In his Pecking Order Theory, Stewart Myers argues that managers should consider the "cost" of obtaining various types of external financing in selecting.

Mechanism of a positive feedback mechanism : Discuss the basic mechanism of a positive feedback mechanism given stimulus A and response B.

Discuss the differences in physiology and how mammals : Discuss the differences in physiology and how mammals' characteristics aid in regulating metabolic activities as well as thermoregulation.

Write a python function that accepts the number of feet : Write a python function that accepts the number of feet and head as input as returns the number of rabbits and number of chickens.

Determine how much her investment be worth : Susie makes $1,900 per month and has an opportunity to save $100 per month at an APR of 3.25 in a 401K plan through work. She plans to retire in 40 years.

What lowest and highest value that computer can represent : what are the lowest value (negative number) and the highest value (positive number) that this computer can represent in each of the following representations?

Draw the profit and payoff function : The spot price on the S&P 500 is $20,000 and the 1-year future price is $20,609.09. The 1-year risk-free rate is 3% with continuous compounding.

Discuss the companys strength of brand : Discuss the company's strength of brand, cost leadership and access to technology or resources that can be protected.

Why financial markets are important to a healthy economy : Discuss why financial markets are important to a healthy economy and how they contribute to economic growth. Assume that you recently graduated with a degree.

User Account

All Pages