Answers - The Most Trusted Place for Answering Life's Questions

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

AllQ&AStudy Guides

Best answer

MIRR=(sqrt(FVCF/I)^n)-1 MIRR - modified internal rate of return FVCF - future value of a cash flow I - Investment n - number of periods of the cash flow

Q: How do you calculate MIRR?

This answer is:

Related answers

MIRR=(sqrt(FVCF/I)^n)-1 MIRR - modified internal rate of return FVCF - future value of a cash flow I - Investment n - number of periods of the cash flow

View page

The MIRR function returns the modified internal rate of return for a series of cash flows. The internal rate of return is calculated by using both the cost of the investment and the interest received by reinvesting the cash. The cash flows must occur at regular intervals, but do not have to be the same amounts for each interval.

MIRR(range,finance_rate,reinvestment_rate)

range = range of cells that represent the series of cash flows

finance_rate = interest rate that you pay on the cash flow amounts

reinvestment_rate = interest rate that you receive on the cash flow amounts as they are reinvested

View page

A capital budget includes a payback period, the net present value, and the internal rate of return. It may also include a modified internal rate of return.

View page

Money deposited in an interest bearing account has a rate of return. the institution will take that money and reinvest it so they can make money off of it as well.

This rate of return on the internal investment is the internal rate of return, which is usually higher than that paid to the original investor.

View page

Internal Rate of Return

View page

Featured study guide

📓

See all Study Guides

✍️

Create a Study Guide

Search results

Trending Questions

A blank reaction is a reaction in which energy is absorbed? What did Robert ELee's parents do for a job? What is an oxgoad? What kind of food do you feed bettas in a community tank? Spirilla are bacteria that can cause? Can you adopt a deceased child? What idiom means to act while conditions are favourable? Is math a noun in sentence during math class Justin sneezed? What trick should you teach a dog after sit? What events happened during cubism in 1907? A job worth doing is worth doing well? What happened in Saxony Germany in 1517? What are the possible temperatures of a surface current? What are the first multiples of 13? How many min are in 8 hours? Does plastic wrap help lose arm fat? How much does it cost to replace the struts on a Ford Focus? When is the last time Easter fell on April 11th as of 2011? When is Aria Montgomery's birthday? Which element of the Personnel Security Program involves evaluating the information contained in reports of personnel security investigations (PSIs) and other source documents?

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.