Question: When using EXCEL to find the future value of $2,000 invested in an account that would earn interest of 7.5% for 18 years, the correct

When using EXCEL to find the future value of $2,000 invested in an account that would earn interest of 7.5% for 18 years, the correct entry would be

=FV(.075,18,0,-1,000).

=FV(7.5,18,0,1,000).

=PV(.075,18,0,-1,000).

=FV(7.5,18,0,-1,000).

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!

Q:

14. [-/4 Points] DETAILS HARMATHAP12 1.6.040. Complete the problem by using the accompanying gure, which shows a supply function and a demand function. (Assume price is measured in dollars.) p 40 30...

Q:

I saw your answers for somebody else's homework and I was wondering if you could explain me how to calculate (no excel please) the IRR and provide an explanation. I have a financial calculator, but...

Q:

Assume that Google invests $2.42 billion in capital expenditures, including $1.08 billion related to manufacturing capacity. Assume that these projects have a seven-year life and that management...

Q:

MGMT 640 Midterm Exam Ques. 1) Which of the following is not an advantage of the corporate form of business organization? a. Sell debt or equity in public capital markets b. Owners have limited...

Q:

Directions for Problem #4 in Excel The goal of this problem is to have you: Use Excel to generate the future value of each of the various investments made over the course of the 25 years. Use Excel...

Q:

Essay Assignment (40 points) Your Assignment is to write an essay discussing the financing of a new car for your business. The price of the used car is $22,500. Sales tax on this car is 9% of the...

Q:

HellonDr.Ramsey Can you assist me with my discussion please, Min 150 words due Friday. Basic Time Value of Money It is a common fact that many lottery winners are ?broke? sooner than later. If you...

Q:

Good Morning Dr.Ramsey Please assist me with my discussion this week ( min 150 words). Advanced Time Value of Money An advertised monthly lending rate of 0.9% is about 11% per year. This difference...

Q:

P11 rest to follow, thanks. If possible, due within 72 hours. Practical 11 - step by step please 1. A R1 000 is deposited inh a bank in May and withdrawn in October the same year. Find the future...

Q:

Practical 11 - step by step please 1. A R1 000 is deposited inh a bank in May and withdrawn in October the same year. Find the future value if the interest rate is 10% simple interest. 2.. An amount...

Q:

The following forecasts were made for a firm with net operating assets of $1.135 million and net financial obligations of $720 million at the end of 2005 (in millions of dollars): The required return...

Q:

Describe the techniques you would use to discover a clients career identity and relevant environmental information about a client to help clarify the clients goal or problem. Identify models you...

Q:

Select the best answer. Assume that Nolanville's fiscal year ends on December 3 1 . Nolanville's payroll for one of its departments is $ 1 5 , 0 0 0 per week. It pays its employees on the Thursday of...

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

Distinguish between primary and secondary information sources. Give an example of each. (Objective 3)

Q:

Mary Lous Family Cooking has been operating for 25 years. Several chain restaurants have moved into the area resulting in a highly competitive market.Mary Lous currently owes an $18,750 balance for...

Q:

While working as part of a research team, one of your coworkers tells you that failing to cite sources doesnt constitute plagiarism if youre writing an internal report. Do you agree or disagree? Why?...