ZuoTi.Pro
Question

The syntax of the Excel function that returns the number of periods for an investment based on a periodic, constant payments at a certain rate of interest is:

A. NPER (rate, pmt, pv, [fv], [type])

B. NPV(rate, value1, [value2]...)

C. TIMEVALUE (time_text)

D. LOOKUP(look_value, lookup_vector, [result_vector])

Which of the arguments in the function to solve for number of periods are relevant and required?

Check all that apply.

-value1

-fv

-pmt

-look_value

-pv

Suppose you get a job offer from one of your dream companies and they are paying you within the range you would want your salary to be. Lets take this amount to be $45,000 per year. You are confident that working in this company would help you grow and charter a career path that you would like to pursue. You are curious to know that if your salary increases at the rate of 9.0% per year, how many years would it take to double your salary?

$45,000 9.0% 2 3 4 5 Salary Growth rate Future salary Calculate number of years N 6 In addition to your dream job, suppose yo

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

A. NPER (rate, pmt, pv, [fv], [type])

This is the function used to calculate the number of periods for an investment based on a periodic, constant payments at a certain rate of interest

The relevant and required arguments are rate, pmt and pv

The number of years taken for salary to double from $45,000 to $90,000 is 8.04 years

fxNPER(9%,0,-45000,90000) A76 D A 8.04 76

0 0
Add a comment
Know the answer?
Add Answer to:
The syntax of the Excel function that returns the number of periods for an investment based...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Problem 3: How many years will it take for an intial investment of $2000, earning 5.4%...

    Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...

  • An investment adviser has promised to double your money. If the interest rate is 7% a...

    An investment adviser has promised to double your money. If the interest rate is 7% a year, how many years will she take to do so? We have entered the data vou need in cells H9 to HI1: Present value (PV) Future value (FV) Interest rate (r) 1 2 0,06 You can use the present value formula to value an annuity You can either find the answer by taking logs of the present value formula or you can use Excel's...

  • You want to save $8500 to take your dream vacation. You plan to save $2500 a...

    You want to save $8500 to take your dream vacation. You plan to save $2500 a year in an account that pays 2.75% interest. How many years will it take to save enough money to travel? You currently have $0 in your dream vacation fund. Show each variable and the corresponding value (NPER, Rate, FV, PV, PMT, TYPE). Calculate percentage out to 2 decimal places.

  • You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...

    You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000 per year for 30 years? To help you in your decision, estimate the present value of the second option assuming constant annual interest rates of 6%, 8%, and 10%. Expound on your decision within a text box. (You may use the built-in PV function within Excel) Loans: where: and, interest due at the end of each month A = payment P = principal (amount...

  • You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

    You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

  • Use the PMT function in Excel to compute the monthly payment on a $328000 business loan...

    Use the PMT function in Excel to compute the monthly payment on a $328000 business loan at an annual interest rate of 7.15% over 20 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type) Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($)

  • Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's...

    Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's degree program, when you turn 31 years old. At the end of each working year for 34 years, you put an additional $5,000 into an IRA a. Assuming you earn an annual compounded rate of 7.5 percent on the Rift and the IRA investments, how much would be available when you retire at age 65? b. If you hope to draw money out of...

  • In this part, calculate the number of periods. Use the Excel Nper function to compute the...

    In this part, calculate the number of periods. Use the Excel Nper function to compute the number of periods. You expect to receive $30,000 at graduation. You plan on investing it at 4 percent until you have $130,000. How long will you wait from now? (6 Points) Calculate the number of periods in the table below using the Excel Nper function. (6 Points) Present Value Interest Rate Future Value Years $190 7% $870 ? $2,175 11% $3,590 ? $47,850 10%...

  • Cri computer Problem 5: You are buying a car. The one you have choosen to purchase...

    Cri computer Problem 5: You are buying a car. The one you have choosen to purchase is going to cost you $32,985. Your car salesman has told you that you can purchase this vehicle for $525 per month for 72 months. What interest rate will you be paying? Note: For a loan the price is listed Because the bank gives you the money in FV is 0, because the loan will be paid off NPER 1/Y (Rate) PV PMT FV...

  • Show all work please. Assume a large health system has just approved a $355,000 annual (per...

    Show all work please. Assume a large health system has just approved a $355,000 annual (per year) bonus to retain its top cardiac surgeon. Assume that $355,000 will be paid to the surgeon as a bonus at the end of each year that he stays, up to ten years. The healthcare system wants to invest a lump sum now in order to have enough money to cover the bonuses over the ten-year period. Assume the healthcare system can earn a...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT