Question: What do you plug into the excel function PV do get the PV interest and the PV Principal? ( don ' t know what goes

What do you plug into the excel function PV do get the PV interest and the PV Principal? (don't know what goes in Rate, NPER, etc.)
Information I have:
Face Value: 600,000
Stated Interest Rate: 6%
Effective Market Interest Rate: 8%
Life: 5 years

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:

10 points 9 003549 Betty deposits $200 at the beginning of each month into a bank account that pays 7.2% interest compounded monthly. At the end of 5 years, how much does she have in this account?...

Q:

Figure 3. GPA study data. You can download the GPAs spreadsheet and use it for the exercises. Step 1: Analyzing the Grades Sue thinks that students are more motivated to do well in their major...

Q:

Assistance needed on this question The top two are the instructions, the bottom is the excel sheet where the answers are inputed. Much love Part 1: Read the following information "JIN Corporation" is...

Q:

I will need to see your calculations (all work);just answers wont work. MUST Do on excel Chapter 4 - Problems 5, 11, 13, 15, &19 (Pages 119-120) Chapter 5 - Problems 2, 5, 10, 12, & 20 (Pages...

Q:

The goal of this project is to explore the topic of the time value of money. The project requires you to work in Excel with the provided spreadsheet. Be sure to fill in the yellow boxes in the Excel...

Q:

Laurman, Inc. is considering a new project and has provided the details of the project. The Controller has asked you to compute various capital budgeting methods to help aid in the decision to pursue...

Q:

\begin{tabular}{|c|c|c|} \hline Lauman, Inc, is considering the fol & & \\ \hline Required investment in equipment & $ & 2,205,000 \\ \hline Project life & & 7 \\ \hline Salvage value & & 225,000 \\...

Q:

Please type the formulas for the yellow ones. Thank You! -aurman, Inc. Is considering a new project and has provided the detalls of the project. The Controller has asked you to compute varlous...

Q:

Laur man is considering a new project and has provided the details of the project. The Controller has asked you to compute various capital budgeting methods to help aid in the decision to pursue the...

Q:

Include the button inputs please, thank you! Laurman, Inc is considering a new project and has provided the details of the project. The Controller has asked you to compute vartous capital budgeting...

Q:

You are comparing two annual salaries with equal present values. The discount rate applied is 7.25 percent. An annuity pays $2,500 on the first day of each year for 15 years. If paid at the end of...

Q:

The following data represent the ages of the winners of the Academy Award for Best Actor for the years 20042009. 004: Jamie Foxx ...........37 2005: Philip Seymour Hoffman .....38 2006: Forest...

Q:

Studies find that mutual funds with higher expense ratios, on average, earn higher returns than other mutual funds lower returns than other mutual funds returns equal to other mutual funds

Q:

Discuss the policy statement concept and identify three focus areas / procedures where a clearpolicy statement / operating procedure

Q:

9. Define impasse, mediation, and strike, and explain the techniques that are used to overcome an impasse. case, Congresshas done or not done? What laws would prevent the union from going on strike...

Q:

5. What does www.seiu.org/ tell you about this unions aims and how it intends to achieve them?

Q:

6. What actions might make employers lose elections?