Question
Bob Jensen Inc. purchased a $650,000 machine to manufacture specialty taps for electrical equipment. Jensen expects to sell all it can manufacture in the next
Bob Jensen Inc. purchased a $650,000 machine to manufacture specialty taps for electrical equipment. Jensen expects to sell all it can manufacture in the next 10 years. To encourage capital investments, the government has exempted taxes on profits from new investments. This legislation is to be in effect for the foreseeable future. The machine is expected to have a 10-year useful life with no salvage value. Jensen uses straight-line depreciation. The net cash inflow is expected to be $150,000 each year for 10 years. Jensen uses a 12% discount rate in evaluating capital investments. Assume, for simplicity, that MACRS depreciation rules do not apply.
Required:
Using Excel (including built-in functions for NPV, IRR, and MIRR), compute the following for the above-referenced investment:
2. The accounting (book) rate of return based on:
(a) initial investment
(b) average investment. (Round your final answers to 1 decimal place.)
5. The internal rate of return (IRR). (Do not round intermediate calculations. Round your final answer to 1 decimal place.)
6. The modified internal rate of return (MIRR). (Do not round intermediate calculations. Round your final answer to 1 decimal place.)(In conjunction with this requirement, you might want to consult either of the following two references: MIRR Function and/or IRR in Excel.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started