Internal Rate of Return Method This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Qpen spreadsheet

Determine the internal rate of return for the proposal.

$\%$ Internal Rate of Return Method

The internal rate of return method is used by Royston Construction Co$.$ in analyzing

a capital expenditure proposal. The following data is provided:

REQUIRED:

Determine the internal rate of return for the proposal.

Using formulas and cell references from the problem data, perform the required analysis.

Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv$2$

for grading.