********** SOLVE USING EXCEL FORMULAS!!!*************** Given the following cash
ID: 2713376 • Letter: #
Question
**********SOLVE USING EXCEL FORMULAS!!!***************
Given the following cash flows:
**********SOLVE USING EXCEL FORMULAS!!!***************
What is the external rate of return if the external investment rate (epsilon)=10%
**********SOLVE USING EXCEL FORMULAS!!!***************
18.3% is the Answer
**********SOLVE USING EXCEL FORMULAS!!!***************
YOU MUST SOLVE USING PV, FV, RATE, IRR, etc. Please solve using the formulas. DO NOT USE PVF or FVF as they are from an OUTSIDE SOURCE and NOT in EXCEL.
Year Revenue Expenses 0 -$15,000 1-5 $10,000 -$3,000Explanation / Answer
The question is about calculation of MIRR.
MIRR=[( FV of positive cash flows,investment rate)/ (PV of negative cash flow at finance rate)]^(1/n) -1
FV of positive cash flows,investment rate:
=FV(10%,4,,7000,0)+FV(10%,3,,7000,0)+FV(10%,2,,7000,0)+FV(10%,1,,7000,0)+FV(10%,0,,7000,0)
=42,736
PV of negative cash flow at finance rate= 15,000
MIRR=(42736/15000)^(1/5)-1=23.29%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.