Question

In: Economics

Consider the following three mutually exclusive investment project alternatives (A, B, C). Use the annual worth...

Consider the following three mutually exclusive investment project alternatives (A, B, C). Use the annual worth analysis (AW) to determine the best investment alternative assuming MARR=15%.

Project name:                                        A                    B                    C

Cash Flow (Year 0):                                    -200,000        -300,000        -400,000

Cash Flow (Year 1-N)                     +150,000       +180,000       +150,000

Salvage value at year N:                +30,000         +50,000          +60,000

Project Life (N):                                    2 years         3 years          6 years

Solutions

Expert Solution

AW of alternative A = -200,000(A/P, 15%, 2) + 150,000 + 30,000(A/F, 15%, 2)

                               = -200,000(0.6151) + 150,000 + 30,000(0.4651)

                               = -123,020 + 150,000 + 13,953

                               = $40,933

AW of alternative B = -300,000(A/P, 15%, 3) + 180,000 + 50,000(A/F, 15%, 3)

                               = -300,000(0.4380) + 180,000 + 50,000(0.2880)

                               = -131,400 + 180,000 + 14,400

                               = $63,000

AW of alternative C = -400,000(A/P, 15%, 6) + 150,000 + 60,000(A/F, 15%, 6)

                               = -400,000(0.2642) + 150,000 + 60,000(0.1142)

                               = -105,680 + 150,000 + 6,852

                               = $51,172

Since the AW of alternative B is highest, therefore, alternative B is the best investment alternative.


Related Solutions

There are three mutually exclusive alternatives, as vendors to outsource a project, with the following cash...
There are three mutually exclusive alternatives, as vendors to outsource a project, with the following cash flow and useful life. Which of these three alternatives would you recommend to be selected? The MARR is 10% per year. Vendor 1 Vendor 2 Vendor 3 First Cost $60,000 $35,000 $25,000 Annual operating and maintenance cost $3,000 every 4 years $1,000 per year $2,000 in yr 1 and it increases by $200 every year thereafter Salvage value $10,000 $4,000 $3,000 Useful life, years...
Consider the following two mutually exclusive cost alternatives: Alternative A Alternative B Capital Investment $8,000 $16,000...
Consider the following two mutually exclusive cost alternatives: Alternative A Alternative B Capital Investment $8,000 $16,000 Annual Expenses $3,500 $3,400 Useful life 8 years 12 years Market value at the end of useful life 0 $3,000 Given MARR is 10% per year, answer the following: Assuming Repeatability applies, determine which alternatives should be selected. b. For a study period of 12 years, and assuming repeatability does not hold for the Alternative A consider there will be an annual contracting cost...
Consider the following investment alternatives: Investment Rate Compounding A 6.25% Annual B 6.10% Daily C 6.125%...
Consider the following investment alternatives: Investment Rate Compounding A 6.25% Annual B 6.10% Daily C 6.125% Quarterly D 6.15% Fortnightly E 6.120% Monthly Which alternative offers you the highest effective rate of return?     a.   Investment E     b.   Investment C     c.   Investment D     d.   Investment A     e.   Investment B
Projects T and Q are mutually-exclusive investment alternatives, Each project requires a net investment of $20,000,...
Projects T and Q are mutually-exclusive investment alternatives, Each project requires a net investment of $20,000, followed by a series of positive net cash flows. Both projects have a useful life equal to 10 years. Project T has an NPV of $36,000 at a 0% discount rate, while project Q has an NPV of $30,000 at 0%. Furthermore, at a discount rate of 15 percent, the two projects have identical positive NPVs. Given this, which of the following statements is...
TRUE or FALSE? 1. When evaluating mutually exclusive Annual Worth Alternatives choose the Shortest Life Cycle...
TRUE or FALSE? 1. When evaluating mutually exclusive Annual Worth Alternatives choose the Shortest Life Cycle for the evaluation. 2. Depreciation is treated as an expense but is not a Cash Flow. 3. Straight Line depreciation is no longer used by U. S. corporations for IRS tax purposes. 4. Double declining balance is 2X the Straight Line portions of depreciation. 5. Replacement Analyses uses equivalent uniform annual costs to compare the defender versus the challenger(s). 6. The Cash Flow Approach...
Given the financial data for four mutually exclusive alternatives in the table below, A B C...
Given the financial data for four mutually exclusive alternatives in the table below, A B C D First cost $18,000 $40,000 $21,200 45,000 O &M Cost/ year 2,600 5,000 3,900 11,000 Benefit/year 7,500 16,000 11,500 25,000 Salvage value 2,000 6,000 6,000 12,000 Life in years                                4 Use a Rate of Return Analysis to solve for the following: Which alternative should be chosen using an MARR of 9%? Mathematical solution Create a choice table from 0 – 25%. Create a...
You are considering the following three projects. A & B are mutually exclusive while C is...
You are considering the following three projects. A & B are mutually exclusive while C is independent. Question: On one graph, plot the NPV profile for Both projects, A&B. please show how on excel Following are their expected cash flows year project A Project B Project C 0 -60,000.00 -40,000.00 -20,000.00 1 0 40,000.00 35,000.00 2                    82,000.00                    40,000.00                     30,000.00 3                    60,000.00                    20,000.00                        2,000.00 4 20,000.00 10,000.00 -40,000.00
Given the following two mutually exclusive project, calculate the equivalent annual annuity for Project B. Assume...
Given the following two mutually exclusive project, calculate the equivalent annual annuity for Project B. Assume a required rate of return of 12%. (Round to 2 decimals) Year Project A Project B 0 -500 -600 1 320 300 2 320 300 3 320 300 4 300
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are given below. The study period is 30 years and the​ firm's MARR is 17% per year. Assume repeatability and reinvestment of positive cash balances at 17​% per year. a. What is the simple payback period for Alternative​ 1? b. What is the annual worth of Alternative​ 2? c. What is the IRR of the incremental cash flows of Alternative 2 compared to Alternative​ 1?...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are...
Three mutually exclusive investment alternatives are being considered. The estimated cash flows for each alternative are given below. The study period is 30 years and the​ firm's MARR is 10​% per year. Assume repeatability and reinvestment of positive cash balances at 10​% per year. a. What is the simple payback period for Alternative​ 1? b. What is the annual worth of Alternative​ 2? c. What is the IRR of the incremental cash flows of Alternative 2 compared to Alternative​ 1?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT