1 answer

5. Compare the following two alternatives by the IRR method, given MARR of 8%/year. Is the...

Question:

5. Compare the following two alternatives by the IRR method, given MARR of 8%/year. Is the incement in cost form A to B justi
5. Compare the following two alternatives by the IRR method, given MARR of 8%/year. Is the incement in cost form A to B justified? Alt. Construction cost | Benefits Styr | Salvage Service Life (yrs 510,000 145,000 10,000 775,000 155,000 20,000

Answers

IRR is the minimum rate of return acceptable from a project. It can be calculated with the use of IRR function/formula of EXCEL/Financial Calculator. The basic function/formula for calculating IRR is given as below:

NPV = 0 = Cash Flow Year 0 + Cash Flow Year 1/(1+IRR)^1 + Cash Flow Year 2/(1+IRR)^2 + Cash Flow Year 3/(1+IRR)^3 + Cash Flow Year 4/(1+IRR)^4 + Cash Flow Year 5/(1+IRR)^5 + Cash Flow Year 6/(1+IRR)^6 + Cash Flow Year 7/(1+IRR)^7 + Cash Flow Year 8/(1+IRR)^8 + Cash Flow Year 9/(1+IRR)^9

IRR is calculated with the use of EXCEL as below:

Year O Cash Flows Alternative A Alternative B -510000 -775000 145000 155000 145000 155000 145000 155000 145000 155000 145000

where

IRR (Alt. A) = IRR(B3:B14) = 26.29%

IRR (Alt. B) = IRR(C3:C15) = 17.04%

_____

Based on the above calculations, it can be concluded that the increment in cost from A to B is not justified.

It is because, even though both the alternatives provide IRR greater than MARR, IRR of alternative A is higher than that of alternative B.

.

Similar Solved Questions

1 answer
A rug company is holding a​ 2-week carpet sale at a local warehouse store. They plan...
A rug company is holding a​ 2-week carpet sale at a local warehouse store. They plan to sell carpets for $500 each. The company will purchase the carpets from a local distributor for $350 ​each, with the option to return any unsold units for a full refund. The warehouse offered two payme...
1 answer
What is the general solution of the differential equation # y'=y/x+xe^x #?
What is the general solution of the differential equation # y'=y/x+xe^x #?...
1 answer
When a running football player “throws” his right foot down and behind him, as in this...
When a running football player “throws” his right foot down and behind him, as in this sketch, what happens in reaction is: Group of answer choices The ground pushes up and forward. He begins to fall backward. The ground exerts no force on him. Counter-rotational torque applies....
1 answer
Required information The following information applies to the questions displayed below.) The partnership agreement of the...
Required information The following information applies to the questions displayed below.) The partnership agreement of the G&P general partnership states that Gary will receive a guaranteed payment of $17,400, and that Gary and Prudence will share the remaining profits or losses in a 45/55 ratio...
1 answer
The inverted track Twith freely floating cylinder C comprise a system which is designed to hold...
The inverted track Twith freely floating cylinder C comprise a system which is designed to hold paper or other thin materials P in place. The coefficient of static friction is μ for all interfaces. What minimum value of u ensures that the device will work no matter how heavy the supported materia...
1 answer
Optimization Problem
A cruise line offers a trip for $2000 per passenger. If at least 100 passengers sign up, the prices is reduced for all passengers by $10 for every additional passenger(beyond 100) who goes on the trip. The boat can accomodate250 passengers. What number of passengers maximizes the cruise line's t...
1 answer
7- By the end of the year CIMA entity had 100 units in warehouse of product...
7- By the end of the year CIMA entity had 100 units in warehouse of product X. Units are so far reported at total cost of $10,000. The selling price of the product has fallen to $110 per unit and cost to sell each unit is $25 per unit. Compute the value at which inventory should be reported in the s...
1 answer
Rational and irrational
Pi-2 number are irrational number or not ?...
1 answer
Find the displacement, average velocity, and average speed of the car in the figure below between...
Find the displacement, average velocity, and average speed of the car in the figure below between positions A and F. (Enter all distances in m, all velocities in m/s, and all times in s.) Acar moves back and forth wong ahe The care the right between positio Aan information about the moon of the bed ...
1 answer
In C Write a function that asks for the user's first, middle, and last names. The...
In C Write a function that asks for the user's first, middle, and last names. The names will be entered by the user on a single line and will be stored in three different C-strings. The program should then store, in a fourth array, the name arranged in the following manner: the last name follow...
1 answer
3.2) (10 points) Jane likes to have Tea (T) with Cookies (C). She always has 4...
3.2) (10 points) Jane likes to have Tea (T) with Cookies (C). She always has 4 cookies for every cup of tea. 3.2a) (points) Draw 2 indifference curves that describe her preferences with Cookies (C) on the horizontal axis and Tea (T) on the vertical axis. 3.2b) (3 points) What is her utility function...
1 answer
N (x 1023 nuclei) 15 (5 points) The plot at right represents the number of a...
N (x 1023 nuclei) 15 (5 points) The plot at right represents the number of a particular type of nuclei (N) present in a sample over time (t). The num- ber of nuclei will decrease according to the relationship N = Noe-t/r Approximate the values in the plot to find numerical val- ues for No and T. 10 ...
1 answer
Trident Repairs & Service UNADJUSTED TRIAL BALANCE November 30, 20Y3 ACCOUNT TITLE DEBIT CREDIT 1 Cash...
Trident Repairs & Service UNADJUSTED TRIAL BALANCE November 30, 20Y3 ACCOUNT TITLE DEBIT CREDIT 1 Cash 10,210.00 2 Accounts Receivable 67,660.00 3 Supplies 15,710.00 4 Equipment 111,420.00 5 Accounts Payable 15,920.00 6 Unearned Fees 17,840.00 7 Common Stock 8,500.00 8 Retained Earnings 109,130....
2 answers
What is "one of two numbers whose product is one"
What is "one of two numbers whose product is one". It's in a crossword, 21 letters, 4th letter is "T". Please help!...
1 answer
4) An RLC circuit consists of a resistor, a inductor, and a capacitor connected in series to an A...
4) An RLC circuit consists of a resistor, a inductor, and a capacitor connected in series to an AC voltage source with an RMS voltage of 59 volts. At half the resonant frequency, the phase angle is -35 degrees and the inductive reactance is 46 Ohms. What is the average dissipated power at twice the ...
1 answer
Tombro Industries is in the process of automating one of its plants and developing a flexible...
Tombro Industries is in the process of automating one of its plants and developing a flexible manufacturing system. The company is finding it necessary to make many changes in operating procedures. Progress has been slow, particularly in trying to develop new performance measures for the factory. In...
1 answer
A charge of +9 micro-coulombs is placed at the bottom left corner of a rectangle, a...
A charge of +9 micro-coulombs is placed at the bottom left corner of a rectangle, a charge of -9 micro-coulombs is placed at the top left corner of a rectangle, a charge of +8 micro-coulombs is placed at the bottom right corner of a rectangle, and a charge of +8 micro-coulombs is placed at the top r...
1 answer
What have you perceived to be the best staffing plan you have been a part of? What made it the best? What was the skill...
What have you perceived to be the best staffing plan you have been a part of? What made it the best? What was the skill mix? What was the care delivery model?...