How much must be invested now to receive $30,000 for 10 years if the first $30,000 is received one year from now and the rate is 8%? Future Value PV FV Tables Factor Present Value PLEASE NOTE: All FV 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 whole dollars (i.e. $12,345). Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto prove your answer above: Using the appropriate EXCEL spreadsheet, the answer = PLEASE NOTE: The dollar amount will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
Q5: Solve the following two independent scenarios:
A. How much must be invested now to receive $30,000 for 10 years if the first $30,000 is received one year from now and the rate is 8%?
PV FV Tables Factor | ||
PLEASE NOTE: All FV 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 whole dollars (i.e. $12,345).
- Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto prove your answer above:
Using the appropriate EXCEL spreadsheet, the answer =
PLEASE NOTE: The dollar amount will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
B. Project A costs $5,000 and will generate annual after-tax net
Future Value | PV FV Tables Factor | |
PLEASE NOTE: All FV 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 whole dollars (i.e. $12,345).
- Use the appropriate EXCEL spreadsheet in the Chapter11 NPV
IRR Analysis.xlsx download to prove your answer above:
Using the appropriate EXCEL spreadsheet, the answer =
PLEASE NOTE: The dollar amount will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67).
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images