Question
In: Finance
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.)
Solutions
Expert Solution
| Year | Cash flow | ||||||||
| 0 | $ -2,26,550 | ||||||||
| 1 | $ 64,750 | ||||||||
| 2 | $ 64,750 | ||||||||
| 3 | $ 64,750 | ||||||||
| 4 | $ 64,750 | ||||||||
| 5 | $ 64,750 | ||||||||
| 6 | $ 64,750 | ||||||||
| Finance rate | 12% | ||||||||
| reinvestment rate | 12% | ||||||||
| MIRR | = | =mirr(Cash flows, finance rate, reinvestment rate) | |||||||
| = | =mirr(D2:D8,D10,D11) | ||||||||
| = | 15.1% | ||||||||
jeff jeffy answered 1 year agoRelated Solutions
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.)
Management of Sunland Home Furnishings is considering acquiring a new machine that can create customized window...
Management of Sunland Home Furnishings is considering acquiring
a new machine that can create customized window treatments. The
equipment will cost $213,550 and will generate cash flows of
$76,750 over each of the next six years. If the cost of capital is
14 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.)
MIRR
%
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella Co.,...
- Parallel Arrays This question is in MindTap Cengage Summary In this lab, you use what you...
- 5. You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella...
- JAVA Write a test program that prompts the user to enter a series of integers and...
- (2) Cite an example on how organizations like Google, Facebook, Youtube etc collect data for image...
- The legal landscape is perpetually changing. Psychologists must remain abreast of these changes to avoid potentially...
- We are evaluating a project that costs $1.68 million, has a six-year life, and has no...
ADVERTISEMENT