Calculate N for the anuity: N= ? I= 10 PV= -200 PMT= 75 FV= 1700

Question

Question

Calculate N for the anuity:

N= ?

I= 10

PV= -200

PMT= 75

FV= 1700

Answer 1

Answer #1

Function Arguments ? x NPER = 0.1 € -75 ! Rate 10% Pmt -75 PV -200 FV 1700 Type of 1 1 = -200 = 1700 = 9.939980398 Returns th

Hence, N will be 9.94 or 10 years

*Please rate thumbs up

Answer 2

Similar Homework Help Questions

Find the present value of anuity: N= 5 I= 4 PV=? PMT= 50 FV= 15

Find the present value of anuity: N= 5 I= 4 PV=? PMT= 50 FV= 15
Find the rate of return for a falling anuity: N= 10 I=? PV= -500 PMT= 110...

Find the rate of return for a falling anuity: N= 10 I=? PV= -500 PMT= 110 FV= 0
Please show your work: list out the N, I/Y, PV, PMT, and FV with correct signs....

Please show your work: list out the N, I/Y, PV, PMT, and FV with correct signs. 2. Moon has been investing $2,500 quarterly for the past 10 years in an equity mutual fund. How much is the fund worth now assuming she has earned 8.5% compounded quarterly on her investment? I/Y PV PMT FV

Use the future value formula to find the indicated value. fv 5,000 i= 0.05 pmt=200 n=?

Use the future value formula to find the indicated value. fv 5,000 i= 0.05 pmt=200 n=?
use the future value formula to find the indicated value FV=2,000, i=0.02, PMT=$200, n=?

use the future value formula to find the indicated value FV=2,000, i=0.02, PMT=$200, n=?
Please verify using a financial calculator [N, I/TR, PMT, PV, FV] values ans explain any discrepancies...

Please verify using a financial calculator [N, I/TR, PMT, PV, FV] values ans explain any discrepancies _________________________ question: You have won the church spring raffle. You are presented with three price choices, and you must pick the best one. The discount rate if 8%. Choice 1 = $4,800 payment one year from now; Choice 2 = 5 payments of $1,200 starting at the end of this year; Choice 3 = $1,000 payment today and $4,500 at the end of year...

Question 1: payment frequency = weekly P/Y=52, C/Y=2, I/Y=3.75, PV=383427, FV=0. Step 1: Calculate PMT. Step...

Question 1: payment frequency = weekly P/Y=52, C/Y=2, I/Y=3.75, PV=383427, FV=0. Step 1: Calculate PMT. Step 2: Calculate N(number of periods) Step 3: Calculate AMORT =N / (P/Y)
Problem 1.10 INPUT PV= $ 6,000.00 FV= $ 10,000.00 RATE= ? TIME= 5 PMT= 0 OUTPUT RATE= #NUM!...

Problem 1.10 INPUT PV= $ 6,000.00 FV= $ 10,000.00 RATE= ? TIME= 5 PMT= 0 OUTPUT RATE= #NUM! Problem 1.13 INPUT PV= $ 30.00 FV= $ 60.00 RATE= 7% TIME= ? PMT= 0 OUTPUT TIME= 　 Problem 1.17 INPUT PV= $ - FV= $ 120,000.00 RATE= 5% TIME= 18 PMT= 0 OUTPUT PMT= 　 On the Excel, Is there any order to put first? for example, =Rate(-PV,FV,TIME,PMT) Like that kind of order? I put this way, but it shows up like that (#NUM!) Also, PMT order, Time order...
Just need to know the N, I/YR, PV, PMT, and FV values for each problem to...

Just need to know the N, I/YR, PV, PMT, and FV values for each problem to input into financial calculator. Please specify the periods per year and if need to set in Beg or End. -2 choices when you win lotto: receive $400,000 at the beginning of each year for the next 30 years, or you can receive a lump sum of $6,000,000 now. Your opportunity cost (the rate of return you can earn on any investments you make) is...

Which Excel function is used to calculate the amount of each annuity payment? FV NPV PMT...

Which Excel function is used to calculate the amount of each annuity payment? FV NPV PMT PV Which fields are required to calculate the rate of return (RATE) for a present value calculation in Excel? Nper, PMT, and NPV Nper, PMT, and PV Type, PMT, and FV PMT, Type, and NPV