Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve without the use of excel by discounting the cash flows by-hand. Find the FV of $10,000 33 years in the future if the

Please solve without the use of excel by discounting the cash flows "by-hand".

  1. Find the FV of $10,000 33 years in the future if the opportunity cost rate is 8% (use Excel formulas and basic PV/FV techniques).
  1. Find the PV of $1,000,000 to be delivered in 16 years if the opportunity cost rate is 7% (use Excel formulas and basic PV/FV techniques).
  1. Would you prefer the following (you can use just formulas for this problem):
  1. An ordinary annuity where you receive $500 each year for 20 years if the opportunity cost is 6%
  2. An annuity due where you receive $480 each year for 20 years if the opportunity cost rate is 5.9%
  1. What is the net present value of the following stream of cash flows assuming the opportunity cost rate is 12%? Solve NPV using each cash flow and the NPV function in Excel (use Excel formulas and basic PV/FV techniques).

Year 0: -$10,000

Year 1: $4,000

Year 2: -$2,000

Year 3: $5,000

Year 4: $3,000

Year 5: $6,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alan J. Marcus, Alex Kane

6th Edition

0072861789, 9780072861785

Students also viewed these Finance questions

Question

9. How are they similar to you? (specifically)

Answered: 1 week ago

Question

13. What are their tastes? (refined, middle class, or subsistence)

Answered: 1 week ago