Consider two mutually exclusive alternative. Construction a choice table using PW for interest rate from 0% to 20%. If the minimum attractive rate of return is 8%, which alternative should be selected? Alternative A B Fist cost $2,000 $3,000 Uniform annual benefit $450 $600 Salvage Value $200 700 Useful life 6 years 6 years Hint: Equation: PW_A = 450(P/A, i, 6) + 200(P/F, i, 6) – 2000 PW_B = 600(P/A, i, 6) + 700(P/F, i, 6) – 3000 or Spreadsheet: PW_A = -PV(i, nper, pmt, fv) – 2000 = -PV(i, 6, 450, 200) - 2000 PW_B = -PV(i, nper, pmt, fv) – 3000 = -PV(i, 6, 600, 700) - 3000

Consider two mutually exclusive alternative. Construction a choice table using PW for interest rate from 0% to 20%. If the minimum attractive rate of return is 8%, which alternative should be selected? Alternative A B Fist cost $2,000 $3,000 Uniform annual benefit $450 $600 Salvage Value $200 700 Useful life 6 years 6 years Hint: Equation: PW_A = 450(P/A, i, 6) + 200(P/F, i, 6) – 2000 PW_B = 600(P/A, i, 6) + 700(P/F, i, 6) – 3000 or Spreadsheet: PW_A = -PV(i, nper, pmt, fv) – 2000 = -PV(i, 6, 450, 200) - 2000 PW_B = -PV(i, nper, pmt, fv) – 3000 = -PV(i, 6, 600, 700) - 3000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 9EB: If you invest $15,000 today, how much will you have in (for further instructions on future value in...

See similar textbooks

Similar questions

Given the financial data in the table below for two mutually exclusive alternatives, determine the value "X" for the two alternatives to be equally attractive. Use an interest rate of 10% per year. Initial cost $2,500 $4,000 Annual benefit 500 600 Life You do not need to interpolate, just answer the closest n that surrounds your number. For example between year so and so.
Consider the following two investment alternatives. Determine the range of investment costs for Alternative B (i.e., min. value < X
Which is the better option if the interest rate is r=0.07 (r=7%)? Show all work used to arrive at your answer. a. Option I: Receive $510 today at time t=0. b. Option II: Receive $1000 at time t=10. Show work on both options!
j. Find the PV and the FV of an investment that makes the following end-of-year payments. The interest rate is 8%. Year 1 $100, Year 2 $200, Year 3 $400 Year Payment 1 100 2 200 3 400 Rate 8% To find the PV, use the NPV function: Pv= $581.59 Year Payment x (1+ I)^(N- t) = FV 1 100 2 200 3 400
Part B: Solve the following excersises: 1) Consider the following timeline where the firm requires the annuity to provide a minimum return of.....%. (write any number for interest rate): Project A End of Yoar -50,000 15,000 15,000 15,000 15,000 Calculate Future Value (FV) using two methods (Timeline and Equation) and compare the answers.
Which is the better option if the interest rate is r=0.10 (r=10%)? Show all work used to arrive at your answer. a. Option I: Receive $1000 today at time t=0. b. Option II: Receive $1615 at time t=5.
Find the PV and FV of an investment that makes the following end-of-year payments. The interest rate is 8%. Year Payment 1 100 2 200 3 400 Rate = 8% To find the PV, use the NPV function: PV = Year Payment x (1 + I )^(N-t) = FV1 100 1.17 116.64 2 200 1.08 216.00 3 400 1.00 400.00 Sum = ?PV = ?FV of PV = ?
If you invest $15,000 today, how much will you have in (for further instructions on future value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
Suppose you are offered a project with the following payments: Year Cash Flows 0 $ 9,800 1 −5,300 2 −4,000 3 −3,100 4 −1,700 a. What is the IRR of this offer? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. If the appropriate discount rate is 15 percent, should you accept this offer? c. If the appropriate discount rate is 21 percent, should you accept this offer? d-1. What is the NPV of the offer if the appropriate discount rate is 15 percent? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. d-2. What is the NPV of the offer if the appropriate discount rate is 21 percent? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.
2) Data for 2 alternatives are given below, determine the cost of alternative B so that the two alternatives will be equally desirable. Assume an interest rate of 15%. Use benefit cost ratio analysis Alternatives A B Cost P100KX Salvage Value 10k 16k Annual Benefit 28k 30k Life (years) 10 12
A defender and a challenger are considered in a replacement analysis. The following decision tree includes the data where FC: first cost, AB: annual benefit; C: Challenger and D: Defender. If annual compound interest rate is 10%, when must we replace the defender? Node no branch Cash flow FC=-45,000 $ Life=20 yrs AB= +8,500 $ FC=-10,000 $ Life=5 yrs AB= +4,500 $ FC=-10,000 $ Life=5 yrs 10 2 D 1D AB= +5,500 $ FC=-35,000 $ Life=15 yrs AB= +4,500 $ FC=-10,000 $ Life=5 yrs AB= +5,000 $ FC=-25,000 $ Life=10 yrs AB= +9,000 $ FC=-20,000 $ Life=5 yrs AB= +6,000 $ FC=-15,000 $ Life=5 yrs AB= +5,000 $ 20 3 1D 20 10 2 D
Which alternative should be selected using the incremental rate of return analysis, if MARR =11.0%? Do- nothing A B C D First Cost 0 $10,000 $4000 $10,000 $7000 Annual benefit 0 1,806 828 1,880 1,067 Life 10 Years ROR 12.5% 16.0% 13.5% 8.5% a. B, because its ROR is the highest b. Something other than C, because C costs the most initially c. C, because the C-B increment has a ROR of 11.78% and the A-B increment has a ROR of 10.5% d. C because C has the highest annual benefit