Question
In: Finance
How can you determine the unknown number of periods when you know the present and future...
- 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 !!
jeff jeffy answered 1 year agoRelated 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
Latest Questions
- Parallel Arrays This question is in MindTap Cengage Summary In this lab, you use what you...
- 5. You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella...
- JAVA Write a test program that prompts the user to enter a series of integers and...
- (2) Cite an example on how organizations like Google, Facebook, Youtube etc collect data for image...
- The legal landscape is perpetually changing. Psychologists must remain abreast of these changes to avoid potentially...
- We are evaluating a project that costs $1.68 million, has a six-year life, and has no...
- In C++ Having call-by-reference allows one to use storeback parameters, i.e., parameters whose values are transmitted...
ADVERTISEMENT