This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Fisher model: o Rnominal = (1 + Rinflation) x (1 + Rreal) 1 Yield questions: o =RATE (nper, pmt based on $1000 par value, PV -$1250 price, FV $1000 par) How to set up GoalSeek in Excel: o Set up uneven flow chart in Excel o Enter in all cash flows (including payback at end) o In PV of CFs column for each row do: CF/ (1 + $x$%)^period Leave out per. 0 Do GoalSeek for $x$% cell...
View Full Document