Question: Please complete Excel doc up until year 40 (age 63) and answer the three questions at the end. At retirement (year 40) what is the

Please complete Excel doc up until year 40 (age 63) and answer the three questions at the end.

At retirement (year 40) what is the fund balance?
What is the total of your contributions?
How much did the fund earn?

Please show the whole Excel file! Thanks!!

Please complete Excel doc up until year 40 (age 63) and

answer the three questions at the end. At retirement (year 40) what

is the fund balance? What is the total of your contributions? How

Exercise: Assume you accept a job and commit to contributing $10,000 each year at the end of every year to a 401k retirement plan. Assume an average rate of return of 8% and you start at age 24 and would like to retire in 40 years. Complete the adjacent Excel sheet labeled "Computations" and answer the three questions. Enter your answers at the bottom of the adjacent sheet. 1) At retirement, what is the fund balance? 2) What is the total of your contributions? 3) How much did the fund earn? Assignment \# 1 Time Value of Money Example A B C E G

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 Accounting Questions!

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 provide detailed responses to the questions. Here are the instructions: Refer to theLucent Techologiesarticle. Then, in a Word document, answer the three questions in the reading (p. 3)....

as a 20 year old student, willing to retire at the age of 60. Answer the following questions. 1. How would you classify your familys overall financial situation? No savings and significant debt. No...

Before starting your assignment, please read the instructions carefully. First, it is required to answer the risk assessment questionnaire and to report your final result at the end of the summary...

iles from the Internet can contain viruses. Unless H51 X fx D E 5 Please complete Excel model parts shaded in yellow) and answer parts A B D E and E. Be sure to provide narrative in part + HINTS!...

Retirement Goal Plan Assignment 1 5 % Franca and Ed Diaz, both age 4 0 have come to see you, their financial planner to develop a retirement plan. Franca works full time at an Accounting Firm earning...

Retirement Goal Plan Assignment Madison and John Jones, both age 4 0 have come to see you, their financial planner to develop a retirement plan. Madison works full time at an Accounting Firm earning...

Please read through all the information on the "Rounds" documents and answer thoroughly the questions on "Capsim" document. Look through all the rounds documents to give thorough and precise answers....

homework help, how to solve the question of this excel ACCT 3350 - Winter 2016 Assignment #1 Due Date: Friday, Feb 5 by 11:30pm (This completed Excel file uploaded in Blackboard) Instructions: This...

also, you do not need the information of 1 & 2 to answer the following questions. The Goody Shop Ltd.'s unadjusted trial balance accounts and amounts (prior to recording any adjusting journal...

Summarize changes in self, environment, and other-oriented values?

Question 2.3 Consider two goods A and B that have the same supply curve and the same equilibrium price and quantity as shown in the following diagram. P DB DA Q (a) Explain why you can determine...

Ethical considerations in purpose and ESG Examine the ethical consideration associated with the blackrock organization's purpose driven initiatives . Discuss how ethical considerations are integrated...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

1. Develop a science for every job, which replaces the old rule-ofthumb method.

l. Discuss in one page the strengths and weaknesses of the arguments in terms of the major claims being made as well as the grounds and warrants the authors provide to support those claims.

3. Offer incentives so that workers behave in accordance with the principles of the science that has been developed.