Question: How to solve these on excel using (I,N,PMT,PV,FV) format. - How much do you need to save every six months if you already have $3,000

How to solve these on excel using (I,N,PMT,PV,FV) format.

- How much do you need to save every six months if you already have $3,000 but you need $20,000 in 2 years? You can earn an annual rate of return of 8%.

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!

PLEASE JUST SHOW ME HOW TO SOLVE #3 USING A BAII CALCULATOR IF YOU DO NOT HAVE A BAII PLUS CALCULATOR, DO NOT SOLVE AND LET ANOTHER EXPERT WHO HAS A BAII SOLVE THIS PROBLEMS I WANT THE ANSWERS IN...

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

JUST ANSWER THE FIRST PAGE: ALL INFO ARE ALREADY GIVEN PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by making yearly payments of P50,...

TO BE ANSWERED: All of theinfos are already given below just answer the first photo PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by...

Discussion 6 Annuities For this discussion task, we are going to use the attached excel template to calculate five annuity value questions. We are going to use your age for a few of the calculations....

1. Find a company that file for Chapter 11 bankruptcy in the last 10 years. Explain the circumstances that cause the firm to file and what the result was. Be sure to include all relevant financials....

i am taking Cooperate finance which is FIN222 can help me to answer.. ? Tutorial 1 Topic 1 Chapter 1 4. What are the main advantages and disadvantages of organising a firm as a corporation? 6. You...

i need all Journal entries for chapter 4 only see the file Instructions City of Bingham Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting for Governmental & Nonprofit Entities...

How do differences in expense recognition and industry characteristics affect financial performance measures?

You have been hired as a consultant for Peters Inc., manufacturer of computers. The company projects unit sales for a new quantic computer as follows: Year Unit Sales 1 100,000 2 120,000 3 130,000 4...

Short and long positions in the futures markets refer to the length of time before the contracts' delivery dates. Question content area bottom Part 1 True False

Rick Pines and Joe Lopez are the plant managers for High Mountain Lumber's particle board division. High Mountain Lumber has adopted a just-in-time management philosophy. Each plant combines wood...