Question: please show your work and formula on excel You are now 25 years old. You would like to retire when you are 65 years old.

please show your work and formula on excel

  1. You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

please show your work and formula on excel You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You...

Q:

QUESTION 1 You decide that you want to save 2,168,419 dollars for retirement. Assuming that you are 25 years old today, will retire at the age of 65, and can earn a 6 percent annual interest rate on...

Q:

1 You decide that you want to save 2,168,419 dollars for retirement. Assuming that you are 25 years old today, will retire at the age of 65, and can earn a 6 percent annual interest rate on your...

Q:

This is about reviewing final for finance I. It is more related to Bond. Show EVERY Step and ALL decimals on the calculation screen. MUSY ONLY use given formulas.( DO NOT accept other types of...

Q:

question 5 only. please show all work and formula used. please don't use excel to solve. 1. What are the two sources of investment returns? Which kinds of investment returns have potential tax...

Q:

Hi guys all the math is confusing me, please help :) Question One: You have just started a new job and your employer has enrolled you in KiwiSaver. This is the first time you have been enrolled in...

Q:

Need help fidguring out the formula for B 1 3 , my current formula is = PV ( B 1 1 , B 6 , - B 7 * B 8 ) and that's now correct. Also need help with B 1 4 , Current formula is = PMT ( B 1 1 , B 6 , 0...

Q:

Answer question 6 only. Please show all work and formula used and please dont use excel to solve. 1. What are the two sources of investment returns? Which kinds of investment returns have potential...

Q:

please show work to explain! thank you! 4. (12 points)(a) A 25 year old college graduate opens an IRA account with $1200 at the end of the first year and continues to deposit $1200 into the account...

Q:

Please show ALL work with calculations in excel!!! Will like for correct answer! Due to the increasing energy costs in the US , Jackie Moora is anxious. The old machine her company has been using to...

Q:

A 85.0-kg person stands on one leg and of the weight is supported by the upper leg connecting the knee and hip jointthe femur. Assuming the femur is 0.650 m long and has a radius of 2.00 cm, by how...

Q:

Jim Johansen noticed that a corporation he is considering investing in is about to pay a quarterly dividend. The record date is Thursday, April 20, 2017. In order for Jim to receive this quarterly...

Q:

Bramble Company has the following securities in its portfolio on December 3 1 , 2 0 2 5 . None of these investments are accounted for under the equity method. \ table [ [ Investments , Cost,Fair...

Q:

Most _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ systems have the capability of performing simulations to answer a variety of what if questions so they can gain a better appreciation of available options and...

Q:

What are three disadvantages of a civil service system?

Q:

How is it possible that employee referral programs, which often include the payment of signing bonuses and finders fees, can often generate the lowest cost-per-hire of all recruiting practices?

Q:

What are three advantages of a civil service system?