To determine Using the FV (Future Value) function in Excel, determine: a. Balance in account after 25 years with monthly deposits of $100 and an APR of 4% b. If APR in part (a) is doubled, is the balance double, more than double or less than double the balance in part (a)? c. If number of years in part (a) is doubled, is the balance double, more than double or less than double the balance in part (a)? Explanation Given: $100 is deposited every month for 25 years with an APR of 4% Calculation: In order to find the amount of balance in accounts refer to the explanation: a. Type ‘= FV’ in excel. Type the rate as 4%, nper is the total number of payment periods and pmt is the payment made in each period. The payment made in each period will be entered as negative number. In this case payment made per year will be $100 x 12 , which is equal to $1200. It will look as under: = FV (4%,25, -1200) After entering pmt, press enter. The answer will be equal to $49975. b. Type ‘= FV’ in excel. Type the rate as 8%, nper is the total number of payment periods and pmt is the payment made in each period. The payment made in each period will be entered as negative number...

Using and Understanding Mathematics: A Quantitative Reasoning Approach plus NEW MyMathLab with Pearson eText -- Access Card Package (6th Edition) (Bennett Science & Math Titles)

6th Edition

ISBN: 9780321923219

Author: Jeffrey O. Bennett, William L. Briggs

Publisher: PEARSON

See similar textbooks

Concept explainers

Unitary Method

The word “unitary” comes from the word “unit”, which means a single and complete entity. In this method, we find the value of a unit product from the given number of products, and then we solve for the other number of products.

Speed, Time, and Distance

Imagine you and 3 of your friends are planning to go to the playground at 6 in the evening. Your house is one mile away from the playground and one of your friends named Jim must start at 5 pm to reach the playground by walk. The other two friends are 3 …

Profit and Loss

The amount earned or lost on the sale of one or more items is referred to as the profit or loss on that item.

Units and Measurements

Measurements and comparisons are the foundation of science and engineering. We, therefore, need rules that tell us how things are measured and compared. For these measurements and comparisons, we perform certain experiments, and we will need the experime…

Videos

Question

Chapter 4.C, Problem 77E

To determine

Using the FV (Future Value) function in Excel, determine:

a. Balance in account after 25 years with monthly deposits of $100 and an APR of 4%

b. If APR in part (a) is doubled, is the balance double, more than double or less than double the balance in part (a)?

c. If number of years in part (a) is doubled, is the balance double, more than double or less than double the balance in part (a)?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 4.C, Problem 76E

Chapter 4.C, Problem 78E

Students have asked these similar questions

1.2.4. (-) Let G be a graph. For v € V(G) and e = E(G), describe the adjacency and incidence matrices of G-v and G-e in terms of the corresponding matrices for G.

1.2.6. (-) In the graph below (the paw), find all the maximal paths, maximal cliques, and maximal independent sets. Also find all the maximum paths, maximum cliques, and maximum independent sets.

@if {fx. KG A} is collection of Countin uous function on a to Polgical Which separates Points Srem closed set then the toplogy onx is the weak toplogy induced by the Map fx. Prove that using dief speParts Point 1 B closed and x&B in X then Sor some kεA fx (X) fx (B). + space

Chapter 4 Solutions

Using and Understanding Mathematics: A Quantitative Reasoning Approach plus NEW MyMathLab with Pearson eText -- Access Card Package (6th Edition) (Bennett Science & Math Titles)

Ch. 4.A - By evaluating your monthly budget, you can learn...Ch. 4.A - The two things you must keep track of in order to...Ch. 4.A - A negative monthly cash flow means that Your...Ch. 4.A - When you are making your monthly budget, what...Ch. 4.A - For the average person, the single biggest...Ch. 4.A - According to Figure 4.1, which of the following...Ch. 4.A - Which of the following in necessary if you want to...Ch. 4.A - Prob. 8QQ Ch. 4.A - Prob. 9QQ Ch. 4.A - According to data from the National Center for...

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.