Question: solve using excel step by step 2.7 Calculate the future worth of 20 annual $2,000 deposits in a savings account that earns 9% (compounded annually).

solve using excel step by step

2.7 Calculate the future worth of 20 annual $2,000 deposits in a savings account that earns 9% (compounded annually). Assume that all deposits are made at the beginning of each year, (a) $126,005 (6) $111529 (c) $113,529 (d)$92,037

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!

solve using excel step by step 5.4 Calculate the future worth of 15 annual $3,000 deposits in a savings account that earns 9% compounded monthly. Assume that all deposits are made at the heginning of...

Time Value Assignment Fall 2019 1. Assume that this year, the average wedding cost $25,000. Assuming 4% inflation, what will it cost in 30 years? 2. At what rate must money be invested to double the...

3.1 3.2 3.3 A machine shop intends to set aside a portion of their profits each year in order to purchase a $50,000 turret lathe in 8 years. If the savings fund earns 7.75% compounded annually, what...

5. Mary needs $750 a year for 3 Years to buy textbooks. She will start university in 1 year. Her savings account pays 4%:'3 compounded annually. How much needs to be in her account now to pay For the...

Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters. Q1 $240Q2 $250 Q3 $205 Q4 $350 ? Sales for the 1st quarter next year are projected to be $230.? Accounts...

How long must one wait (to the nearest year) for an initial investment of $1,000 to triple in value if the investment earns 8% compounded annually? The attached questions needs to be answered in...

Please use the attached file. Thank you 1. ?/1 pointsBerrFinMath1 2.1.001. Find the simple interest on the loan. $1400 at 7% for 10 years. Show My Work (Optional) 2. ?/1 pointsBerrFinMath1 2.1.003....

1. (TCO 1) Which aspect of financial planning deals with the purchase of long-term growth funds such as stocks? (Points : 4) Borrowing Spending Managing risk Investing Retirement and estate planning...

ASSIGNMENT #1 The purpose of this assignment is to solidify your understanding on the applications of the time value of money. The scores of this assignment will help in assessing the following...

Please Use Excel Functions to solve for questions a-g, please show equations/excel functions used to solve.. When you start your first job after graduating from ohia State on January 1st, 2023, you...

An atomic spectrum contains a line with a wavelength centered at 488nm. Careful measurements show the line is really spread out between 487and 489 nm. Estimate the lifetime of the excited state that...

Under what conditions is a dual extension strategy advisable? When is product invention more appropriate?

How are the following carried out in the fixed asset system: authorization, supervision, independent verification?

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...