Question

In: Finance

How can you determine the unknown number of periods when you know the present and future...

  1. How can you determine the unknown number of periods when you know the present and future values – single amount or annuity – and the applicable rate of interest?

Solutions

Expert Solution

We can calculate the unknown number of periods using the excel sheet calculator given the details of present and future value and the applicable interest rate as follows:

The NPER function can be used to find the unknown number of periods as follows:

= NPER(rate,pmt,-pv,-fv)

For example we can take the annuity payment and Investment present and future values in below sheet

Formulas used in the excel sheet are:

Using the above examples we can figure out how to calculate the time period using the given values.

Hope I am able to solve your concern. If you are satisfied hit a thumbs up !!


Related Solutions

As you increase the number of periods (t), what happens to the future value of a...
As you increase the number of periods (t), what happens to the future value of a single cash flow? What happens to the present value? Assume that the interest rate (r) remains constant. As you increase the interest rate (r), what happens to the future value of a single cash flow.   What happens to the present value? Assume that the number of periods (t) remains constant. Explain your reasoning.
Why we cannot use different compounding periods when comparing alternatives in the present or future worth...
Why we cannot use different compounding periods when comparing alternatives in the present or future worth methods? Give an example of how different compounding periods will affect the selection of an alternative.
Why we cannot use different compounding periods when comparing alternatives in the present or future worth...
Why we cannot use different compounding periods when comparing alternatives in the present or future worth methods? Give an example of how different compounding periods will affect the selection of an alternative
Present Value for Various Compounding Periods Find the present value of $575 due in the future...
Present Value for Various Compounding Periods Find the present value of $575 due in the future under each of the following conditions. Do not round intermediate calculations. Round your answers to the nearest cent. 9% nominal rate, semiannual compounding, discounted back 5 years. $   9% nominal rate, quarterly compounding, discounted back 5 years. $   9% nominal rate, monthly compounding, discounted back 1 year. $  
You are being asked to determine if there is any oxygen present in an unknown mixture...
You are being asked to determine if there is any oxygen present in an unknown mixture of gas. You know that when oxygen is made to glow by placing a large potential difference across it, it will produce light most brightly at the following wavelengths (in nanometers): 408, 419, 441, and 465. You use a strong power supply to make a sample of this gas mixture glow then use a spectroscope to split the light into its components. The spectroscope...
Determine the future value and the present value of the following single amounts: Future and Present...
Determine the future value and the present value of the following single amounts: Future and Present Values item Invested Amount Interest Rate Percentage No. of Periods 1 15,000.00 6 12 2 20,000.00 8 10 3 30,000.00 12 20 4 50,000.00 4 12
Ramesh lives two periods. His earnings in the present are 100; in the future they are...
Ramesh lives two periods. His earnings in the present are 100; in the future they are 75.6. The interest rate is 8 percent. (a) Suppose that Ramesh's earnings are subject to a 25 percent tax. Suppose also that interest earnings are taxed at the same rate and interest paid is tax deductible. Using our life-cycle model, show that this tax generates an excess burden. (b) Suppose now that interest payments are not tax deductible. Does this tax generate an excess...
Part 5: Relation between Future Value and Number of Periods In this part, you need to...
Part 5: Relation between Future Value and Number of Periods In this part, you need to examine the relation between the future value and the number of periods.   For a present value of $5,000, create a table that shows the FV at 0%, 5%, and 10% for 0, 2, 4, 6, 8, and 10 years. (7 Points) In a single graph (scatter plot with straight lines and markers), graph the table above with years on the horizontal axis and FV...
Describe how you can determine if the gene is interrupted and, if so, the number of...
Describe how you can determine if the gene is interrupted and, if so, the number of interruptions by restriction endonuclease analysis and Southern analysis.
Recall the basic model of consumption choice. There are two periods: present and future. Assume households...
Recall the basic model of consumption choice. There are two periods: present and future. Assume households have the following lifetime utility: u(c) + βu(c f ) where u(c) = √ c, the discount rate β < 1 (i.e., the rate at which households discount utility from future consumption). Assume also that households start with no initial wealth, a = 0, but receive income today, y, and income tomorrow, y f . The interest rate, r, is equal to 4%. Assume...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT