Management of Sycamore Home Furnishings is considering acquiring a new machine that can create customized window...

Management of Sycamore Home Furnishings is considering acquiring a new machine that can create customized window treatments. The equipment will cost $263,400 and will generate cash flows of $85,000 over each of the next six years. If the cost of capital is 12 percent, what is the MIRR on this project? (Round intermediate calculations to 3 decimals and final answers to 1 decimal places, e.g. 15.5%. Do not round factor values.)

Solutions

Expert Solution

Modified Internal Rate of Return can be calculated as nth root of (Future cash flow /Out flow of the project) - 1

Out Flow of the project = $263,400

Future value of cash flows = $689,791.1 (Note 1)

n = number of periods = 6 years

MIRR = 6th root of ($688,791.1 / $263,400) - 1

= 6th root of 2.615 - 1

= 1.173758 - 1

= 17.38%

MIRR on this project = 17.4%

Note 1:
Year	Cash Flows	Interest rate @12% (1+12%)^n	Future Value
1	85000	1.762341683	149799
2	85000	1.57351936	133749.1
3	85000	1.404928	119418.9
4	85000	1.2544	106624
5	85000	1.12	95200
6	85000	1	85000
Future value of cash flows			689791.1

Y1: n= 5 for year 1 as cash flows earn interest for 5 years

Y2: n= 4 for year 2 as cash flows earn interest for 4 years

Y3: n= 3 for year 3 as cash flows earn interest for 3 years

Y4: n= 2 for year 4 as cash flows earn interest for 2 years

Y5: n= 1 for year 5 as cash flows earn interest for 1 years

Y6: n= 0 for year 6 as cash flows earn interest for 0 years

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Management of Wildhorse Home Furnishings is considering acquiring a new machine that can create customized window...

Management of Wildhorse Home Furnishings is considering acquiring a new machine that can create customized window treatments. The equipment will cost $226,550 and will generate cash flows of $64,750 over each of the next six years. If the cost of capital is 12 percent, what is the MIRR on this project? (Round intermediate calculations to 3 decimals and final answers to 1 decimal places, e.g. 15.5%. Do not round factor values.)

Tetley Company is considering acquiring a new machine. The machine would cost $120,000 and it would...

Tetley Company is considering acquiring a new machine. The machine would cost $120,000 and it would cost another $30,000 to modify the machine and get it installed and ready for operations. The machine falls into class 8 with a 20% CCA rate and it would be sold after 3 years for $50,000. The machine would require an immediate increase of $8,000 in operating net working capital. The balance of operating net working capital would remain unchanged during the project and...

Lessee Analysis Nico Engineering (NE), a small machine shop, is considering acquiring a new machine that...

Lessee Analysis Nico Engineering (NE), a small machine shop, is considering acquiring a new machine that costs $45,000. Arrangements can be made to lease the machine or to borrow the necessary funding and purchase the machine. The firm is in the 40% tax bracket. Lease: NE would obtain a 5-year lease from Shelly Worldwide (SW) financing house requiring annual beginning-of-year lease payments of $11,000. All maintenance costs would be paid (year-end) by the lessor, and insurance and other costs would...

A company's management is considering to buying a new machine. A new machine will cost $25,000....

A company's management is considering to buying a new machine. A new machine will cost $25,000. Annual operating and maintenance costs will be $8,000 in the first year, increasing by $400 each year. Assume the machine depreciates by $4,000 per year according to straight-line depreciation. Assume the machine can be re-sold at its book value at any time. a) Owning the proposed new machine for how many years will result in the minimum EAC if the interest rate is 8%?...

Mariposa Inc is considering improving its production process by acquiring a new machine. There are two...

Mariposa Inc is considering improving its production process by acquiring a new machine. There are two machines management is analyzing to determine which one it should purchase. The company requires a 14% rate of return and uses straight-line depreciation to a zero book value. Machine A has a cost of $290,000, annual operating costs of $8,000, and a 3-year life. Machine B costs $180,000, has annual operating costs of $12,000, and has a 2-year life. Whichever machine is purchased will...

You are considering the purchase of a new home offered at a price of $225,000. Create...

You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: You will be making a down payment of 20% on the home. The bank will offer you a loan at an annual interest...

You are considering the purchase of a new home offered at a price of $225,000. Create...

You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: You will be making a down payment of 20% on the home (refer to Table 2.5 for loan and lease terms). The bank...

The management of ABC Corporation is considering the purchase of a new machine costing $430,000. The...

The management of ABC Corporation is considering the purchase of a new machine costing $430,000. The company's desired rate of return is 10%. The present value factors for $1 at compound interest of 10% for 1 through 5 years are 0.909, 0.826, 0.751, 0.683, and 0.621, respectively. In addition to the foregoing information, use the following data in determining the acceptability in this situation by using the NPV methodology calculations Year Income from Operations Net Cash Flow 1 $100,000 $180,000...

The Management of Arnold Corporation is considering the purchase of a new machine costing $400,000. The...

The Management of Arnold Corporation is considering the purchase of a new machine costing $400,000. The residual value of the machine is estimated to be $0. The company’s desired rate of return is 8%. The estimated income and net cash flows associated with the investment are as follows: Year Operating Income Net Cash Flow 1 $100,000 $180,000 2 40,000 120,000 3 20,000 100,000 4 10,000 90,000 5 10,000 90,000 The payback period for this...

The management of Villa Corporation is considering the purchase of a new machine costing $300,000. The...

The management of Villa Corporation is considering the purchase of a new machine costing $300,000. The residual value for the machine is estimated to be $0. The company’s desired rate of return is 8%. Estimated income and cash flow date for the project are as follows: Year Operating Income Net Cash Flow 1 $60,000 $80,000 2 $60,000 $80,000 3 $60,000 $80,000 4 $60,000 $80,000 5 $60,000 $80,000 The present value index (rounded to two decimal places) for this investment is:...

Subjects