How much would you be willing to pay for this investment if you required a 8 percent rate of return? $   If the payments were received at the beginning of each year, what would you be willing to pay for this investment?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Mitchell Investments has offered you the following investment opportunity:

  • $7,000 at the end of each year for the first 7 years, plus
  • $6,000 at the end of each year from years 8 through 14, plus
  • $3,000 at the end of each year from years 15 through 21.

Use Table II and Table IV or a financial calculator to answer the questions. Round your answers to the nearest dollar.

 

  1. How much would you be willing to pay for this investment if you required a 8 percent rate of return?
    $  

  2. If the payments were received at the beginning of each year, what would you be willing to pay for this investment?
    $  

### Educational Explanation of Time Value Formulas

#### Overview:

This Excel sheet demonstrates formulas related to the Time Value of Money, specifically focusing on the Present Value Interest Factor (PVIF) and the Present Value Interest Factor of Annuity (PVIFA).

#### Table II: Present Value Interest Factor (PVIF)

- **Formula**: 
  \[
  \text{PVIF} = \frac{1}{(1+i)^n}
  \]

- **Columns**:
  - **Interest**: The interest rate denoted as \( i \).
  - **Periods**: The number of periods denoted as \( n \).
  - **Factor**: The result of the PVIF calculation. Currently set to "1".

#### Table IV: Present Value Interest Factor of Annuity (PVIFA)

- **Formula**: 
  \[
  \text{PVIFA} = \frac{1 - \frac{1}{(1+i)^n}}{i}
  \]

- **Columns**:
  - **Interest**: The interest rate \( i \).
  - **Periods**: The number of periods \( n \).
  - **Num**: The numerator part of the formula.
  - **Denom**: The denominator which is the interest rate \( i \).
  - **Factor**: Shows "#DIV/0!" error indicating a division by zero, as the interest rate field is not populated.

### Notes:

1. **PVIF**: Helps in determining the current value of a sum that will be received in the future.
2. **PVIFA**: Useful for calculating the present value of a series of annuities.
3. **Data Entry**: Users must input the interest rate and the number of periods to calculate the factors accurately.
4. **Error Handling**: Ensure interest rate is not zero to avoid "#DIV/0!" errors in PVIFA calculations.
Transcribed Image Text:### Educational Explanation of Time Value Formulas #### Overview: This Excel sheet demonstrates formulas related to the Time Value of Money, specifically focusing on the Present Value Interest Factor (PVIF) and the Present Value Interest Factor of Annuity (PVIFA). #### Table II: Present Value Interest Factor (PVIF) - **Formula**: \[ \text{PVIF} = \frac{1}{(1+i)^n} \] - **Columns**: - **Interest**: The interest rate denoted as \( i \). - **Periods**: The number of periods denoted as \( n \). - **Factor**: The result of the PVIF calculation. Currently set to "1". #### Table IV: Present Value Interest Factor of Annuity (PVIFA) - **Formula**: \[ \text{PVIFA} = \frac{1 - \frac{1}{(1+i)^n}}{i} \] - **Columns**: - **Interest**: The interest rate \( i \). - **Periods**: The number of periods \( n \). - **Num**: The numerator part of the formula. - **Denom**: The denominator which is the interest rate \( i \). - **Factor**: Shows "#DIV/0!" error indicating a division by zero, as the interest rate field is not populated. ### Notes: 1. **PVIF**: Helps in determining the current value of a sum that will be received in the future. 2. **PVIFA**: Useful for calculating the present value of a series of annuities. 3. **Data Entry**: Users must input the interest rate and the number of periods to calculate the factors accurately. 4. **Error Handling**: Ensure interest rate is not zero to avoid "#DIV/0!" errors in PVIFA calculations.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Present Value
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education