Question: Help me with the MIRR using spreadsheet please, thanks very much! 0=-17782.04 + 6500/1 +MIRR + 7700/(1+MIRR)^2 + 7300/(1+MIRR)^3 + 6100/(1+MIRR)^4 0=-17573.22 + 6500/1+MIRR +

Help me with the MIRR using spreadsheet please, thanks very much!

0=-17782.04 + 6500/1 +MIRR + 7700/(1+MIRR)^2 + 7300/(1+MIRR)^3 + 6100/(1+MIRR)^4

0=-17573.22 + 6500/1+MIRR + 7700/(1+MIRR)^2 + 7300/(1+MIRR)^3 + 6100/(1+MIRR)^4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Excel Online Structured Activity: Capital budgeting criteria A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0...

Q:

I've already wrote down the equation, and please help me with the MIRR calculations ONLY in discounting approach using spreadsheet in exact percentage. The equation I wrote is correct, I just don't...

Q:

Estimate the projects operating cash flows. (Hint: Again use Table 1 as a guide.) What are the projects NPV, IRR, modified IRR (MIRR), and payback? Should the project be undertaken? [Remember: The...

Q:

Solo Corp. is evaluating a project with the following cash flows: 40 Year AWNO Cash Flow -$29,200 11,400 14,100 16,000 13,100 -9.600 The company uses an interest rate of 9 percent on all of its...

Q:

I've already wrote down the equation, and please help me with the MIRR calculations using spreadsheet. Here is the cash flow provided. Thank you very much for your help in advance! I really...

Q:

Meadville Widgets is considering the purchase of a fully automated widget finishing machine to replace an older but still functioning but more labor intensive model. The machine being replaced was...

Q:

Question Help Bookmatch 10-15 (book/static) (MIRR calculation) Calculate the MIRR given the following cash flows, . if the appropriate required rate of return is 10 percent (use this as the...

Q:

Finance question! help plz Problem 12-11 MIRR and NPV Your company is considering two mutually exclusive projects, X and Y, whose costs and cash flows are shown below: Year Y -$5,000 -$5,000 1 1000...

Q:

I've already wrote down the equation, and please help me with the MIRR calculations in discounting approach using spreadsheet in exact percentage. Here is the cash flow provided. Thank you very much...

Q:

I've already wrote down the equation, and please help me with the MIRR calculations using spreadsheet. Here is the cash flow provided. Thank you very much for your help in advance! I really...

Q:

1. What is an IPO? What is meant by going public? By going private? 2. a. What information is contained in a registration statement under the 1933 Act? b. What role in the registration process is...

Q:

Maximize Profit = =SUMPRODUCT(C2:D2,C8:D8) Constraints: Manufacturing time: SUMPRODUCT(C2:D2,C5:D5) = 1520 23mm Valve: C2 = 300 29mm Valve: D2 = 600 On Solving: 23mm Valve 29mm Valve Number 275 600...

Q:

BE13.2 (LO 1) (Classify activities.) Classify each of the transactions listed in BE13.1 as an operating (O), investing (I), financing (F), or significant noncash investing and financing (NC) activity...

Q:

(1) A solid and liquid has the density of 2800 and 1000 kg/m respectively and the liquid viscosity is 0.001 Pa:s, the value of the function Ph is 2.87x104 m?, determine the value for Qh, and write...

Q:

1. Assume that a hypothetical economy with an MPC of .8 is experiencing severe recession. By how much would government spending have to rise to shift the aggregate demand curve rightward by $25...

Q:

3. (For students who were assigned Chapter 31) Assume that, without taxes, the consumption schedule for an economy is as shown below: LO33.1 a. Graph this consumption schedule. What is the size of...

Q:

5. Refer to the table for Waxwania in problem 4. Suppose that Waxwania is producing $600 of real GDP, whereas the potential real GDP (or full-employment real GDP) is $700. How large is its budget...