Construct a data table in excel that will show lindsay

Assignment Help Financial Management

Reference no: EM131970510

Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure she is financially sound in 30 years, so she plans to invest the same amount into a retirement account at the end of every year for the next 30 years.

(a) Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return.

(b) If Lindsay invests $15,000 at return of 6%, what would be the balance at the end of 20th year in the account? If required, round your answers to two decimal places.

Reference no: EM131970510

Questions Cloud

Find the levered value of the firm : All else equal if corporate taxes are cut by the current administration and congress what happens to the WACC, Value of the levered firm?

How effect of falsifying inventory records lead to downfall : It was amazing to read how the effect of falsifying inventory records lead to the downfall of the company and the imprisonment of its founder.

How much money willan employee have at retirement : An employee contributes $20,000 to a 401(k) plan each year, and the company matches 25% of this annually. Equity funds are earning 10%, bond funds 4%.

What is the probability that there is exactly one oil : Assume such occurrences during each time period follow a Poisson distribution with ? proportional to the length of time.

Construct a data table in excel that will show lindsay : Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return.

At what price per jar would project npv equal zero : At what price per jar would project NPV equal zero? (Enter your answer in dollars not in millions. Do not round intermediate calculations).

What amount is deductible for renee : Renee paid $4,000 in mortgage interest on a $110,000 mortgage that was taken out when she bought her home several year ago. What amount is deductible for Renee?

Explain the impact and smoothing treatment : The link below provides details of an article covering "Janitor's Insurance", the questionable practice followed by some corporations in which they take out.

What is the provision for income tax expense : Relix, Inc., is a domestic corporation. Relix reported two permanent. What is the provision for income tax expense? Both dollar amount and percentage.

User Account

All Pages