Skip to content

πŸ™‹ Student Q&A (Lecture 6)

Click here to learn about timestamps and my process for answering questions. Section agendas can be found here. Email office hour questions to rob.mgmte2000@gmail.com . PS1Q2=β€œQuestion 2 of Problem Set 1”

πŸ“… Questions covered Saturday, Mar 8

πŸ•£ covered very near to end of recording
❔ prevailing interest rate in 4c?

βœ” It just refers to the interest rate mentioned earlier in the problem.

πŸ•£
❔ when would we need Excel to calculate i?

βœ” covered during section

πŸ“… Questions covered Sun, Mar 9

πŸ•£ 12:53
❔ If he asks for NPV, how do you solve it? How to use the formula?

βœ”
For a PV or NPV question, you always

  1. come up with a timeline of the cash flows and then
  2. drop the cash flows into the equation.

✏️ Suppose that your long lost aunt has gifted you some money. You will receive $20,000 in one year and $10,000 in 3 years. What is the PV of this gift? Assume that you keep most of your assets are in a money market mutual fund that earns 4% per year.

βœ” Step 1: Timeline

tCF
1$20,000
2$0
3$10,000
Step 2: Formula
If your alternative/default investment is earning 4% per year, then you can use 4% as your discount rate. Therefore i=4%.
PV=$20,000(1+4%)1+$0(1+4%)2+$10,000(1+4%)3PV=\frac{\$20,000}{(1+4\%)^1} + \frac{\$0}{(1+4\%)^2} + \frac{\$10,000}{(1+4\%)^3}

πŸ•£
❔ Is β€œin one year” equivalent to β€œat the end of the current year?” Is β€œat the beginning of this year” equivalent to β€œnow?”

βœ” Yes and yes.

πŸ•£
❔ You are evaluating an investment that requires an upfront payment of 50,000todayβˆ—βˆ—.Inreturn,youwillreceiveβˆ—βˆ—50,000 today**. In return, you will receive **12,000 at the beginning of each year for the next 5 years. If the discount rate is 6%, what is the present value of this investment? Should you proceed with this investment? Show your calculations.

βœ” We’re going to use the two steps from above. Step1: Timeline:

TCash InFlowCash Outflows
012,000 (1st year)50,000
112,000 (2nd year)
212,000 (3rd year)
312,000 (4th year)
412,000 (5th year)
5
PVInflows=$12,000(1+6%)0+$12,000(1+6%)1+$12,000(1+6%)2+$12,000(1+6%)3+$12,000(1+6%)4PVInflows = \frac{\$12,000}{(1+6\%)^0} + \frac{\$12,000}{(1+6\%)^1} + \frac{\$12,000}{(1+6\%)^2} + \frac{\$12,000}{(1+6\%)^3} + \frac{\$12,000}{(1+6\%)^4} PVOutflows=$50,000(1+6%)0PV Outflows = \frac{\$50,000}{(1+6\%)^0} NPV=PVInflowsβˆ’PVOutflows=$12,000(1+6%)0+$12,000(1+6%)1+$12,000(1+6%)2+$12,000(1+6%)3+$12,000(1+6%)4βˆ’$50,000(1+6%)0NPV = PV Inflows - PV Outflows = \frac{\$12,000}{(1+6\%)^0} + \frac{\$12,000}{(1+6\%)^1} + \frac{\$12,000}{(1+6\%)^2} + \frac{\$12,000}{(1+6\%)^3} + \frac{\$12,000}{(1+6\%)^4} - \frac{\$50,000}{(1+6\%)^0}

Shortcut:

TCash InFlowCash OutflowsNet Cashflows
Inflows - Outflows
012,000 (1st year)50,000-38,000
112,000 (2nd year)12,000
212,000 (3rd year)12,000
312,000 (4th year)12,000
412,000 (5th year)12,000
5
NPV=βˆ’$38,000+$12,0001.06+$12,0001.062+$12,0001.063+$12,0001.064=$3581.26NPV = -\$38,000 + \frac{\$12,000}{1.06} + \frac{\$12,000}{1.06^2} + \frac{\$12,000}{1.06^3} + \frac{\$12,000}{1.06^4} = \$3581.26
=20000/(1+4%)^1 + 0/(1+4%)^2 +10000/(1+4%)^3
=20000/(1+4%)1 +10000/(1+4%)3
=-38+12/1.06 + 12/1.06^2 + 12/1.06^3 + 12/1.06^4

Questions covered Mon, Mar 10

πŸ•£ 7:44pm
❔ If we are trying to decide whether to take on a project or not, do we have to answer the question with both NPV and IRR or is it sufficient to answer it with just one or the other?

βœ” Either the NPV or IRR rule is sufficient to answer a given question. They will typically have exactly the same answer. Note that there are subtle differences. See the slides that we coverd in the recording.

πŸ•£ 7:50pm
❔ Would studying mostly the problem sets be mostly sufficient or will it be very important to expand beyond that?

βœ” Not quite. The problem sets aren’t comprehensive, but the slides are comprehensive. There are also additional practice problems on my website.