Question: please i need help with question 2 using excel and the formulas to get the answers 2. Retirement Savings (20 points) You plan to retire

please i need help with question 2 using excel and the formulas to get the answers

2. Retirement Savings (20 points) You plan to retire in exactly 22 years. a. Suppose you save $500 per month. Assume that your account earns interest monthly at an 8.0% annual rate, compounded monthly. How much will have in 22 years...? Round to nearest dollar. you b. You goal is to create a fund that will allow you to receive $7,000 at the end of each month for 25 years after retirement. You believe you will be able to earn 5% per year, compounded monthly during the 25-year retirement period. How large a fund will you need when you retire te provide the 25-year, $7,000 per month retirement annuity? (round to nearest dollar) c. How much is $7,000 received 22 years from now worth in today's dollars if inflation is 2% per year? (round to nearest dollar)

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!

please i need help with question 1 using excel and the formulas to get the answers 1. Stock Pricing (20 points) Copper Communications has just paid a dividend of $2.97 and is projected to pay a...

Please answer question #6 in it's entirety :) Thank you. Finance 221 Time Value of Money Excel Project Compass Submission Due by 11:59 PM, Tuesday, Feb. 9 Please use Excel financial functions or...

please help with all parts of questions 1-8 from creating the balance sheet and income statement... to calculating the ratios, interpreting those ratios , and whether or not she can achieve her...

Pretty simple just answer the questions below its only 2 of them attached are the reference materials you'll need to site apa style format from Chapter 11: 11.2 #2 (p. 276) Also answer this question...

Answers needed for #3-4, 9, 11, 13-17, 19-22, 29-32, 35-37, 40 FI 3300 - CORPORATION FINANCE Take-Home Problem Set Three (THPS-3) Fall 2015 Directions: This problem set covers chapters 6 and 7 in the...

please i need help with 1 and 2 using excel and know what formulas to use for those problems so that im able to see hos you got the answers i am stuck! please show work 1. Stock Pricing (20 points)...

Hello please answer to the following question. good luck 29. Annuities. You can buy a car that is advertised for $24,000 on the following terms: (a) pay $24,000 and receive a $2,000 rebate from the...

ASSIGNMENT ONE: FINANCIAL STATEMENTS & GOALS (Fall 2021) Due Date: November 10, 2021; assignments will be submitted electronically in D2L by midnight. One submission per team (of 2 and no more)....

Written in Java. Please help. Any information would be greatly appreciated. Even shelling of the code would be beneficial if you cannot understand the whole thing. Thank you!!!!!!!!!!!!!!!!!! Example...

i have stared my assignment and I now find myself stuck ! Please any help would be appreciated. i am attatching screen shots of the word doc as well as all relitive exel documentation X X MATH215_App...

Adapted from Luyben and Luyben (1997). (a) Calculate the gain of an orifice plate and differential pressure transmitter for flow rates of 10, 50, 75 and 90% of full scale, (b) Calculate the gains of...

Refer to the six situations in Exercise 7-44. Required: For each situation, identify the possible root cause(s) of the activity cost (such as plant layout, process design, and product design)....

4 Sprouts Ltd wishes to change its name to Greenstuff Ltd and trade under the name of Brassica Wholefoods. What steps must be taken to achieve this result? (The Institute of Company Accountants)

To become a more value - driven organization, Heisley University is holding regular coffee - hour discussions with its students and surveying its graduates regarding students' educational needs and...

What is your least favorite U.S. dialect? Why?

You are a member of a sales team that is opening accounts in Egypt. You are to send a representative from your company to Egypt meet with the Egyptian company counterpart and begin a marketing...

There is a debate across the country as to whether Ebonics and Spanglish are valid languages. Some argue that they are legitimate languages. Others argue that they are slang or jargon used by groups...