Question

P9-13 (similar to) Question Help • Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $1,900,000. Given the discount rate and the future cash flow of each project in the following table, , what are the IRRs and MIRRs of the three projects for Quark Industries? What is the IRR for project M? 0 Data Table % (Round to two decimal places.) (Click on the following icon in order to copy its contents into a spreadsheet.) Cash Flow Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate Project M $500,000 $500,000 $500,000 $500,000 $500,000 9% Project N $600,000 $600,000 $600,000 $600,000 $600,000 12% Project O $1,000,000 $800,000 $600,000 $400,000 $200,000 17% Print Done Enter your answer in the answer box and then click Check Answer.

Answer 1

Σ AutoSum : A Times New Roi V 14 VAA BIU - - A === S ab Wrap Text E Merge & Center - Accounting r.% , Paste E E 99 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter - Select Editing Clipboard 5 Font Alignment Number Cells Ideas B23 Year Annual cash flow (S) -19,00,000 5,00,000 5,00,000 5,00,000 5,00,000 5,00,000 Internal rate of return (IRR) for the Project-M = 9.91%

fx 6 ? A É Q @ - Calculate Now Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & Used Time Reference Trig Function Library Watch More Functions Define Name Define Name * Use in Formula Name Manager a Create from Selection Defined Names - Trace Precedents A Show Formulas - Trace Dependents Error Checking Remove Arrows Ox) Evaluate Formula Formula Auditing Window Calculation Calculate Sheet Options Calculation B10 IRR(B3:B8) Year Annual cash flow (S) 1 2 30 4 1 5 2 6 3 7 4 -1900000 500000 =+B4 =+B5 =+B6 =+B7 85 10 Internal rate of return (IRR) for the Project-M = =IRR(B3:38) 13 14