Question

In: Finance

A basket of groceries increased at a rate of 4.28% a year, from $605 to $1000....

A basket of groceries increased at a rate of 4.28% a year, from $605 to $1000. what is the length of time over which the change in prive was measured.

explain

Solutions

Expert Solution

The time period is calculated using the NPER function as follows:

=NPER(rate,pmt,pv,fv)

=NPER(4.28%,0,-605,1000)

=11.99 years or 12(rounded off)

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Cigarettes/Day Death Rate/1000/Year due to CHF Males Death Rate/1000/Year due to CHF Females 0 0.01 0.008...
Cigarettes/Day Death Rate/1000/Year due to CHF Males Death Rate/1000/Year due to CHF Females 0 0.01 0.008 1-14 0.27 0.11 15-24 1.23 1.15 25+ 2.00 1.50 Your team would like to calculate the attributable risk or attributable proportion of CHF death rates due to smoking 1-14 and 15-24 cigarettes per day separately for males and females. Do you notice any differences within and between these groups in death rates due to CHF based on the different number of cigarettes smoked per...
Cigarettes/Day Death Rate/1000/Year due to CHF Males Death Rate/1000/Year due to CHF Females 0 0.01 0.008...
Cigarettes/Day Death Rate/1000/Year due to CHF Males Death Rate/1000/Year due to CHF Females 0 0.01 0.008 1-14 0.27 0.11 15-24 1.23 1.15 25+ 2.00 1.50 Your team would like to calculate the attributable risk or attributable proportion of CHF death rates due to smoking 1-14 and 15-24 cigarettes per day separately for males and females. Do you notice any differences within and between these groups in death rates due to CHF based on the different number of cigarettes smoked per...
trinity hs invested $8,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly...
trinity hs invested $8,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly for a term of eight years. 1. find the interest rate per conversion interval. 2. find the future value of the investment at the end of eight years. 3. find the total interest earned over the eight years. 4. set up the expression for finding an effective annual rate of 4.28% compounded quarterly and evaluate the expression.
Sarah has invested $7,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly...
Sarah has invested $7,800 in a savings certificate paying a guaranteed rate of 4.28% compounded quarterly for a term of eight years. Note this is a single payment. a. Find the interest rate per conversion interval. b. Find the future value of the investment at the end of eight years. . c. Find the total interest earned over the eight years. d. Set up the expression for finding the effective annual rate (EAR) of 4.28% compounded quarterly and evaluate the...
Andy borrows funds of $ 1000 with an interest rate of 12% per year with an...
Andy borrows funds of $ 1000 with an interest rate of 12% per year with an repayment period of 8 years and is repaid using the amortization method. a) After paying installments at the end of year 4, A intends to pay them off. How much money must be paid for the repayment? b) If after paying installments at the end of year 4, Andy requests that he be given an additional payment period of 6 years. i.e. the borrowing...
A. Bond Features Maturity (years) = 7 Face Value = $1,000 Starting Interest Rate 4.28% Coupon...
A. Bond Features Maturity (years) = 7 Face Value = $1,000 Starting Interest Rate 4.28% Coupon Rate = 4% Coupon dates (Annual) If interest rates change from 4.28% to 6.45% immediately after you buy the bond today (and stay at the new interest rate), what is the price effect in year 2 ? State your answer to the nearest penny (e.g., 48.45) If there is a loss, state your answer with a negative sign (e.g., -52.30) B. Assume you buy...
A computer game simulates drawing three coloured balls from a basket. The basket contains red balls...
A computer game simulates drawing three coloured balls from a basket. The basket contains red balls (colour #1), green balls (colour #2) and yellow balls (colour #3). If certain combinations of red, green and/or yellow appear, the player wins the game. The player wins if the first and third balls are the same colour, and the second ball is a different colour from the first and third, or all three balls are the same colour, or the first and second...
Suppose: 1) 1 year futures price=$1000, 2) interest rate = 0%, and 3)for K=$1000, the premium...
Suppose: 1) 1 year futures price=$1000, 2) interest rate = 0%, and 3)for K=$1000, the premium on a 1 year call (C) is $100 and on a 1year put (P) $150. a. Does put-call parity hold? If not, relative to each other which option is overpriced and which underpriced? b. Describe a profitable and risk free arbitrage, that is, what would you long today and what would you short? c. For your arbitrage described in question b. what are your...
Suppose the YTM is 5% for a 20-year $1000 bond with a 7% coupon rate and...
Suppose the YTM is 5% for a 20-year $1000 bond with a 7% coupon rate and annual coupon payments. Its bond price is $____. Instruction: Type ONLY your numerical answer in the unit of dollars, NO $ sign, NO comma, and round to one decimal place. E.g., if your answer is $7,001.56, should type ONLY the number 7001.6, NEITHER 7,001.6, $7001.6, $7,001.6, NOR 7002. Otherwise, Blackboard will treat it as a wrong answer.
A 5-year bond with a face value of $1000 has a coupon rate of 6%, with...
A 5-year bond with a face value of $1000 has a coupon rate of 6%, with semiannual payments. What is the coupon payment for this bond per 6-month period? A. $60 B. not enough information C. $30
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT