Question

Asked Mar 25, 2019

35 views

I now have $16,000 in the bank earning interest of 1.00% per month. I need $26,000 to make a down payment on a house. I can save an additional $100 per month. How long will it take me to accumulate the $26,000? (Do not round intermediate calculations. (Round your answer to 2 decimal places.)

1 Rating

Step 1

**Calculation of Duration of the Investment:**

The Duration of the Investment can be calculated using a excel function =NPER, which denotes the number of periods of any investment. **The excel spreadsheet with excel function is shown below:**

Step 2

**The excel spreadsheet workings are shown below:**

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: The credit card with the transactions described in the popup below uses the average daily balance me...

A: Credit CardIt is a card issued to customers for making payment towards goods and services. These car...

Q: Suppose a security follows a geometric Brownian motion with interest rate r=0.01, volatility paramet...

A: The formula I have for simlating the prices have mu and sigma, but no r (Interest rate). Please repo...

Q: Your firm has a risk-free investment opportunity where it can invest $160,000 today and receive $170...

A: Calculation of Interest Rate of the Project:The Interest Rate of the Project can be calculated using...

Q: Insigne Corporation is considering two investment projects (projects A and project B) that are mutua...

A: We have the following data regarding outflows and inflows for the two projects:

Q: Ms. Cristiana Piccini is valuing an investment that pays her $27,000 per year for the first ten year...

A: Calculation of Value of Investment: Excel Spreadsheet:

Q: Hot Bagels Inc. has been experiencing declining earnings but has just announced a 50 percent salary ...

A: Calculating the number of directors can be elected by the dissident stockholders with proxies they n...

Q: a.If US$1 = C$1.1277, and if the bank in Canada charges 0.9% commission to buy or sell currencies, h...

A: You have posted many unrelated questions. I will address first three of them. Please post the blance...

Q: The prices of a certain security follow a geometric Brownian motion with parameters mu=.12 and sigma...

A: The question has two parts:The probability that a call option will get exercised in 4 months - this ...

Q: Bill Clinton reportedly was paid $10 million to write his book My Life. Suppose the book took three ...

A: All financials below are in $ mn.Part (a)Speaking fees, F = 8 per year for N = 3 yearscost of capita...