Joan, the project manager, asks you to evaluate alternatives A and B on the basis of their PW values using a real interest rate of 10% per year and an inflation rate of 3% per year (a) without any adjustment for inflation, and (b) with inflation considered. Also, write the spreadsheet functions that will display the correct PW values. (c) Joan clearly wants alternative A to be selected. If inflation is steady at 3% per year, what real return i would machine A have to generate each year to make the choice between A and B indifferent? What is the required return with inflation considered?
(a) PWA = -31,000 – 28,000(P/A,10%,5) + 5000(P/F,10%,5)
= -31,000 – 28,000(3.7908) + 5000(0.6209)
= $-134,038
PWB = -48,000 – 19,000(P/A,10%,5) + 7000(P/F,10%,5)
= -48,000 – 19,000(3.7908) + 7000(0.6209)
= $-115,679
Select machine B
Spreadsheet function for PWA: = - PV(10%,5,-28000,5000) - 31000
PWB: = - PV(10%,5,-19000,7000) - 48000
(b) if = 0.10 + 0.03 + (0.10)(0.03) = 0.133 (13.3%)
PWA = -31,000 – 28,000(P/A,13.3%,5) + 5000(P/F,13.3%,5)
= -31,000 – 28,000(3.4916) + 5000(0.5356)
= $-126,087
PWB = -48,000 – 19,000(P/A,13.3%,5) + 7000(P/F,13.3%,5)
= -48,000 – 19,000(3.4916) + 7000(0.5356)
= $-110,591
Select machine B
Spreadsheet function for PWA: = - PV(13.3%,5,-28000,5000) - 31000
PWB: = - PV(13.3%,5,-19000,7000) – 48000
(b) Maintain i = 10% for B; use Goal Seek to force PW difference to be 0 while changing the i for A (cell F2).
A real i of 17.7% and an inflation-adjusted return of 21.2% are required for breakeven.
You might also like to view...
Find the numerical value of the following factors using (a) linear interpolation and (b) the appropriate formula.
1. (F?P,18%,33) 2. (A?G,12%,54)
What natural resources are usually considered renewable resources?
What will be an ideal response?
1/8 bend + 1/6 bend =
A. 90° B. 105° C. 112.5° D. 117°
Dimensions that require tolerances different from the general tolerances given in the title block must be specified on the dimension.
Answer the following statement true (T) or false (F)