Purchase Solution

# Calculating Present Values and Multiple Cash Flows

Not what you're looking for?

1. Calculating Present Values: For each of the following compute the present value. Answer in Excel.

Present Value____Years____Interest Rate____Future Value
?_______________6__________7%_________\$13,827
?_______________9__________15__________\$43,852
?_______________19_________11__________\$725,380
?_______________23_________18__________\$590,710

2. Calculating Interest Rates: Solve for the unknown interest rate in each of the following: Answer in Excel
Present Value____Years____Interest Rate____Future Value
\$__ 242___________4__________?_________\$_____307
\$__ 410___________8__________?_______________896
\$51,700__________16__________?__________\$162,181
\$18,750__________27__________?__________\$483,500

3. Calculating the Number of Periods: Solve for the unknown number of years in each of the following: Answer in Excel
Present Value____Years____Interest Rate____Future Value
\$___625__________?___________9%_______\$__1,284
\$___810__________?__________11_________\$__4,341
\$18,400___________?_________17__________\$402,662
\$21,500___________?__________8__________\$173,439

4. Present Value and Multiple Cash Flows: Farley Company has identified an investment project with the following cash flows. Answer in Excel
Year________Cash Flow
__1_________\$960
__2_________\$840
__3_________ \$935
__4________\$1,350

a. If the discount rate is 10 percent, what is the present value of these cash flows?
b. What is the present value at 18 present?
c. At 24 percent?

5. Present Value and Multiple Cash Flows: Investment X offers to pay you \$4,500 per year for nine years, whereas Investment Y offers to pay you \$7,000 per year for five years.
a. Which of these cash flow streams has the higher present value if the discount rate 5 percent? Explain.
b. If the discount rate is 22 percent?

##### Solution Summary

Your tutorial is in excel, attached using the PV, RATE, NPER, NPV functions.

Solution provided by:
###### Education
• BSc, University of Virginia
• MSc, University of Virginia
• PhD, Georgia State University
###### Recent Feedback
• "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
• "Thank, this is more clear to me now."
• "Awesome job! "
• "ty"
• "Great Analysis, thank you so much"

##### Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Importance of Critical Thinking

##### Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

##### Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

##### IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)