How much would you invest today in order to receive $30,000 in each of the following independent scenarios: 10 years at 9% 8 years at 12% 14 years at 15% 24 years at 10% Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto complete the following table: Present Value (PV) Rate Time (Years) Future Value (FV) A 9% 10 $30,000.00 B 12% 8 $30,000.00 C 15% 14 $30,000.00 D 10% 24 $30,000.00 PLEASE NOTE: All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67). Use the present value of $1 table in the Appendix B PV FV Tables downloadand verify that your answers above are correct: Future Value (FV) Rate Time (Years) FV Factor (from Table) Present Value (PV) A $30,000.00 9% 10 B $30,000.00 12% 8 C $30,000.00 15% 14 D $30,000.00 10% 24 PLEASE NOTE: All PV Factors will be rounded to three decimal places (i.e. 1.234). All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
How much would you invest today in order to receive $30,000 in each of the following independent scenarios: 10 years at 9% 8 years at 12% 14 years at 15% 24 years at 10% Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto complete the following table: Present Value (PV) Rate Time (Years) Future Value (FV) A 9% 10 $30,000.00 B 12% 8 $30,000.00 C 15% 14 $30,000.00 D 10% 24 $30,000.00 PLEASE NOTE: All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67). Use the present value of $1 table in the Appendix B PV FV Tables downloadand verify that your answers above are correct: Future Value (FV) Rate Time (Years) FV Factor (from Table) Present Value (PV) A $30,000.00 9% 10 B $30,000.00 12% 8 C $30,000.00 15% 14 D $30,000.00 10% 24 PLEASE NOTE: All PV Factors will be rounded to three decimal places (i.e. 1.234). All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 11EA: How much would you invest today in order to receive $30,000 in each of the following (for further...
Related questions
Question
How much would you invest today in order to receive $30,000 in each of the following independent scenarios:
- 10 years at 9%
- 8 years at 12%
- 14 years at 15%
- 24 years at 10%
Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto complete the following table:
| Present Value (PV) | Rate | Time (Years) | ||
| A | 9% | 10 | $30,000.00 | |
| B | 12% | 8 | $30,000.00 | |
| C | 15% | 14 | $30,000.00 | |
| D | 10% | 24 | $30,000.00 |
PLEASE NOTE: All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
Use the present value of $1 table in the Appendix B PV FV Tables downloadand verify that your answers above are correct:
| Future Value (FV) | Rate | Time (Years) | FV Factor (from Table) | Present Value (PV) | |
| A | $30,000.00 | 9% | 10 | ||
| B | $30,000.00 | 12% | 8 | ||
| C | $30,000.00 | 15% | 14 | ||
| D | $30,000.00 | 10% | 24 |
PLEASE NOTE: All PV Factors will be rounded to three decimal places (i.e. 1.234). All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 4 images
Knowledge Booster
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.Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College