The PW based relation for the incremental cash flow series to find i between the lower first cost alternative X and alternative Y has been developed 0 40,000 9000(PA,i ,10) 2000(PF,i ,10) Determine the highest MARR value for which Y is preferred over X Write the single cell spreadsheet function tha...

Solve for i by trial and erro ...

The PW-based relation for the incremental cash flow series to find i* between the lower first-cost alternative

Question:

The PW-based relation for the incremental cash flow series to find Δi* between the lower first-cost alternative X and alternative Y has been developed.
0 = − 40,000 + 9000(P∕A,Δi*,10) − 2000(P∕F,Δi*,10)

Determine the highest MARR value for which Y is preferred over X. Write the single-cell spreadsheet function that displays Δi*.

MARR
Minimum Acceptable Rate of Return (MARR), or hurdle rate is the minimum rate of return on a project a manager or company is willing to accept before starting a project, given its risk and the opportunity cost of forgoing other...

Fantastic news! We've Found the answer you've been seeking!