Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you analyzed a $40k investment using a 7% discount rate, 2% inflation rate, and 3% reinvestment rate and got the following results in Excel.

image text in transcribed
image text in transcribed
image text in transcribed
Suppose you analyzed a $40k investment using a 7% discount rate, 2% inflation rate, and 3% reinvestment rate and got the following results in Excel. Year ON $40k Investment Net Revenues Costs Return SO $40,000 -$40,000 $500 $0 $500 $2,000 $0 $2,000 $5,000 $0 $5,000 $6,500 $0 $6,500 $47,500 SO $47,500 $61,500 $40,000 $21,500 PV of Returns -$40,000 $458 $1,679 $3,846 $4,581 $30,674 $1,239 FV of Returns $46,371 $563 $2,185 $5,305 $6,695 $47,500 $15,877 3 4 5 Total What is the sum of the Future Values of POSITIVE returns to the investment (this is the numerator inside the root function in the MIRR formula) QUESTION 8 What is the sum of the Present Values of all NEGATIVE returns (this is the denominator in the MIRR formula)? Enter your answer as a positive number. QUESTION 9 What is the Future Value of the $5000 return earned in Year 3 if it can be reinvested at 3%? What is the MIRR of this investment? Enter your answer as a percent to one decimal place (e.ge 10.5%)

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

Internal Revenue Service Status Of GAO Financial Audit And Related Financial Management Recommendations

Authors: Government Accountability Office

1st Edition

1492351571, 978-1492351573

More Books

Students also viewed these Accounting questions