Question: The monthly saving P that has to be deposit in a saving account that pays an annual interest rate of r in order to save

The monthly saving P that has to be deposit in a saving account that pays an annual interest rate of r in order to save a total amount of F in N years can be calculated by the formula:
p = F(r/12)/(1+ r/12)12N - 1
Calculate the monthly saving that has to be deposit in order to save $100,000 in 5, 6, 7, 8, 9, and 10 years if the annual interest rate is 4.35%. Display the results in a two-column table where the first column is the number of years and the second column is the monthly deposit.

Step by Step Solution

★★★★★

3.38 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Script file clear clc format bank F100000 r435 years510 conv... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

652-B-F-F-M (634).docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

A year ago, you invested $10,000 in a saving account that pays an annual interest rate of 3%. What is your approximate annual real rate of return if the rate of inflation was 4% over the year?

Policymakers frequently search for ways to reduce consumption of gasoline. One straightforward option is to tax gasoline thereby encouraging consumers to drive less in their cars and switch to more...

Suppose you have $10,000 cash that you want to invest. Normally, you would deposit the money in a savings account that pays an annual interest rate of 6%. However, you are now considering the...

Write a MATLAB script to perform the following task: The monthly saving P that has to be deposit in a saving account that pays an annual interest rate of r in order to save a total amount of F in N...

Question 1: (1 point) 4B Homework Help Table Textbook Examples Textbook Homework Sections Tutorial Videos InterAct Math Practice Ex 1 (p. 199) (51-54) - Simple Interest Exercise 51 Calculate the...

ICA 4 Part 1 The monthly savings, P , that must be deposited into a savings account which pays an annual interest rate, r , in order to save a total amount of F in N years can be calculated by the...

Your brother has decided to ask you for advice about saving up for his teenager's college fund. He plans on withdrawing $15,000 at the end of year 5, $17,000 at the end of year 6, and $20,000 each at...

I was looking at the solution to the following question on this site. I could not understand why use 12 when working out the NPER. Since the monthly payments start 1 month after should you not use...

1. If you deposit $4000 into an account paying 6% annual interest compounded quarterly, how much money will be in the account after 5 years? 2. If you deposit $6500 into an account paying 8% annual...

I need help with these problems. The details are included in the attached files. Thank you Submit a spreadsheet displaying how the answers were calculated. Each problem should be answered on a...

The word counts of five essays are 501, 636, 546, 602, and 575. Use a sample size of 2. Find the mean and standard deviation of the population. List all samples (with replacement) of the given size...

The hydrogen atom's electron is in the third excited state, the energy of the photon required to liberate the electron and give it 3 eV kinetic energy is ..eV?

Senaraikan semua nilai integer yang memuaskan ketaksamaan linear 5 4 x - 3

Raider City has established a legally separate public financing corporation to issue debt for the citys capital projects. The corporations debt will be paid by the city. How should the public...

Suppose that a small firm could successfully shift to a just-in-time inventory systeman arrangement in which inventory is received just as it is needed. How would this affect the firms...

Even though the United States was founded on a free market philosophy, the varies levels of government have intervene into the marketplace on our behalf. Throughout our early history the national...

Women's Roles then and now. Script a conversation between two notable women from the 18th and 19 century on the roles women should play in society. Within the dialogue include: 1. Biographical...

the paulson company year end balance sheet is shown below. It's cost of common equity is 18%, it's before tax cost of debt is 12%, and it's marginal tax rate is 40%. Assume that the firms long term...

Question 3 [12 marks]: State with proper reasoning whether the following statements are TRUE or FALSE. 1. Suppose f(n)=n(1sinn) (defined over non-negative reals). Then f(n)/O(n). 2. Suppose...

If you can provide some explanation to the calculation (finance calculator if possible). It would be appreciated. Before Mrs. Smith arrives, you study her account file and notice she has different...