Question: Can you write a formula that will work for this. It has to be a excel written formula. Annual deposit= D6 Number of years= D7

Can you write a formula that will work for this. It has to be a excel written formula.

Annual deposit= D6

Number of years= D7

Interest rate on annuity= D8

Number of years= D9

E F G H I A If you deposit $4,000 at the end of each of the next 20 years into an account paying 9.7 percent interest, how much money will you have in the account in 20 years? How much will you have if you make deposits for 40 years? 4,000 20 Annual deposit Number of years Interest rate on annuity Number of years 9.7% 40 12 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 13 14 Future value for 20 years 15 16 Future value for 40 years 17

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!

2.5 points eBook Print References All answers must be entered as a formula. Click OK to begin. OK ? x WOHS, FILE HOME Calculating annuity values - Excel FORMULAS DATA REVIEW - 2 Sign In INSERTPAGE...

Problem 5-41 a. Find the FV of $1,800 invested to earn 127. after 7 years. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = N = Formula: FV =...

File Home Insert Page Layout Formulas Data Review View Help Tell me PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Prote H A1 -...

The student number is same as the amount borrowed is $776655,1.Use Excel fomular to fill up the empty space and show the steps that how to use excel fomular to calculate: 2.finish question a and b...

Chapter 9 - Financial Functions in Excel Use the RATE, NPER, PMT, PV and FV functions to answer the following. Remember the following important subtleties: RATE = periodic rate; you must divide the...

Your 25-year-old client wants to retire when he is 60 years old, and have a retirement income equivalent to $5,000 per month in todays dollars. We cannot be sure of how long we live after retirement,...

Build a Model 11/26/2018 Chapter: 4 Time Value of Money Problem: 35 a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by...

a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5...

a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard, fx. Inputs: PV = 1000 I/YR = 10% N =...

Valtec Company has three manufacturing divisions (listed below). Each division has its own job order costing system and forecasts the following manufacturing costs for the upcoming year: The...

An 820-turn wire coil of resistance 24.0 ? is placed on top of a 12 500-turn, 7.00-cm-long solenoid, as in figure. Both coil and solenoid have cross-sectional areas of 1.00 x 10 ?4 m 2 . (a) How long...

Quad Enterprises is considering a new three - year expansion project that requires an initial foced asset investment of $ 2 . 9 million. The foxed asset will be depreciated straight - line to zero...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

1. Outline the listening process and styles of listening

4. Explain key barriers to competent intercultural communication