As a first step we need to find the future value of all the positive cash flows at the end of the terminal year i.e. at the end of year 3. Future value of a cash flow occurring at any time t, at the end of year n will be given by FV = Ct x (1 + r)n - t where r is the reinvestment rate.
In our case, n = terminal year = 3
r = 8%
Hence, FV = Ct x (1 + 8%)3 - t = Ct x 1.083 - t
Please see the table below:
Year, t | Cash flows | Reinvestment period | Future Value |
3 - t | FV = Ct x 1.083 - t | ||
1 | 400,000 | 2 | 466,560 |
2 | 500,000 | 1 | 540,000 |
3 | 700,000 | 0 | 700,000 |
Total | 1,706,560 |
Cash flows in year 3 = Project cash flows + salvage value = 600,000 + 100,000 = 700,000
Initial investment = 800,000
Hence, ERR will be given by the formula:
FV = Initial investment x (1 + ERR)n
Or, 1,706,560 = 800,000 x (1 + ERR)3
Hence, ERR = (1,706,560 / 800,000)1/3 - 1 = 28.73%
Since ERR > opportunity cost of capital of 15%, hence the
project should be accepted.
please solve in the word format Answer the question. Calculate the rate of return of the...
please solve in word format Answer the question. Consider the three mutually exclusive alternatives below. Determine which alternative is preferable at an interest rate of 10% per year. Assume all of these projects are repeating perpetually, Alternative A B C Capital investment $400,000 $100,000 $150,000 Annual expense $189,000 $94,500 $134,000 Annual revenue $309,000 $204,500 $300,000 Salvage value $65,000 $50,000 $100,000 Life, years | 24 36 12 1 i FBI , O EE % 5 % Solution: AW(M) - -400,000 (A/P,...
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,300,000. Given the discount rate and the future cash flow of each project in the following table, what are the IRRs and MIRRs of the three projects for Quark Industries? What is the IRR for project M? Project N $800,000 Project M Project O Cash Flow Year 1 $600,000 $1,200,000 $1,000,000 Year 2 $600,000 $800,000 $600,000 $800,000 $800,000...
solve in word format Answer the question. onsider the three mutually exclusive alternatives below. Determine which alternative is preferable at an terest rate of 10% per year. Assume all of these projects are repeating perpetually. Alternative A B C Capital investment $400,000 $100,000 $150,000 Annual expense $189,000 $94,500 $134,000 $309,000 $204,500 $300,000 $50,000 $100,000 Annual revenue Salvage value Life, years $65,000 24 36 12 X E B I i Fr
P9-13 (similar to) Question Help • Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $1,900,000. Given the discount rate and the future cash flow of each project in the following table, , what are the IRRs and MIRRs of the three projects for Quark Industries? What is the IRR for project M? 0 Data Table % (Round to two decimal places.) (Click on the following icon...
Internal rate of return and modified internal rate of return. Lepton Industries has three potential projects, all with an initial cost of $1,700,000. Given the discount rate and the future cash flows of each project, what are the IRRs and MIRRs of the three projects for Lepton Industries? Cash Flow Project Q Project R Project S Year 1 $400,000 $600,000 $900,000 Year 2 $400,000 $600,000 $700,000 Year 3 $400,000 $600,000 $500,000 Year 4 $400,000 $600,000 $300,000 Year 5 $400,000...
please solve in word format instead of excel Answer the question. $100,000 was deposited in a savings account 8 years ago, and the account earned interest at the rate of 10% per year. Assuming the end-of-the-year convention, what is the amount of equal annual withdrawals that can be made to completely deplete the fund 15 years from now if the first withdrawal will be made one year from today? I B Fi Initial Deposit $100,000,00 (P)
Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of S1,800,000. Given the discount rate and the future cash flow of each project, what are the IRRs and MIRRs of the three projects for Quark Industries? Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate $500,000 $500,000 $500,000 $500,000 $500,000 7% S600,000 S600,000 S600,000 S600,000 S600,000 13% $1.000,000 $800,000 $600,000 $400,000 $200,000 16%
2. Internal rate of return (IRR) Aa Aa E The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider the case of Pellegrini Southern Inc.: Pellegrini Southern Inc. is evaluating a proposed capital budgeting project (project Sigma) that will require an initial investment of $800,000. Pellegrini Southern Inc. has been basing capital budgeting decisions on a project's NPV; however, its new CFO...
Payback, Accounting Rate of Return, Net Present Value, Internal Rate of Return Follow the format shown in Exhibit 123.1 and Exhibit 128.2 as you complete the requirement below. Blaylock Company wants to buy a numerically controlled (NC) machine to be used in producing specially machined parts for manufacturers of trenching machines. The outlay required is $ 730,671. The NC equipment will last five years with no expected salvage value. The expected after-tax cash flows associated with the project follow: Year...
please solve this question in word format Answer the question. Miner's Mexican Grill Inc. plans to open its 100th restaurant by the end of next year. The new restaurant will require an initial investment of $300,000 and an annual operating cost of $31,000. It will be liquidated after 12 years. The company also estimates that the new restaurant will bring in revenue of $91,000 each year. The company's minimum attractive rate of return is 20%. a. Calculate the (simple) payback...