Question

In: Accounting

Bob Jensen Inc. purchased a $750,000 machine to manufacture specialty taps for electrical equipment. Jensen expects...

Bob Jensen Inc. purchased a $750,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 $173,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: 1. The payback period, under the assumption that cash inflows occur evenly throughout the year. (Do not round intermediate calculations. Round your final answer to 1 decimal place.) 2. The accounting (book) rate of return based on (a) initial investment, and (b) average investment. (Round your final answers to 1 decimal place.) 3. The net present value (NPV) of the proposed investment under the assumption that cash inflows occur at year-end. (Do not round intermediate calculations. Round your final answer to nearest whole dollar amount.) 4. The present value payback period, in years, of the proposed investment under the assumption that cash inflows occur evenly throughout the year. (Note: because of this assumption, the present value calculations will be approximate, not exact.) To calculate present value amounts, use the appropriate factors from Appendix C, Table 1. (Do not round intermediate calculations. Round your final answer 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.)

Solutions

Expert Solution

Answer to question 1

Payback period    = Initial Investment / Net cash flow per period

   = $750,000 / $173,000

Payback period    = 4.3 years

Answer to question 2

Part (a) : Accounting rate of return (ARR) for initial investment

Particulars Amount ($)
Initial investment A 750,000
Net cash inflow B 173,000
ARR (B/A) 23.1%

Part (b) : Accounting rate of return (ARR) for average investment

Particulars Amount ($)
Initial investment A 750,000
Useful life of machine B 10-years
Depreciation per year (A/B)=C 75,000
Value of machine at the year end (A-C)=D 675,000
Average investment value [(A+D)/2]=E 712,500
Net cash inflow F 173,000
ARR (F/E) 24.3%

Answer to question 3

Net present value (NPV) = [Net Cash Flow / (1 + i)n] - Initial investment

where,

i = Discount rate

n = No. of years

NPV = [$173,000 / (1 + 0.12)10] - $750,000

= $977,489 - $750,000

NPV = $227,489

Answer to question 4

Present value payback period = Initial investment / Net Present Value

= $750,000 / $227,489

Present value payback period = 3.30 years


Related Solutions

Bob Jensen Inc. purchased a $300,000 machine to manufacture specialty taps for electrical equipment. Jensen expects...
Bob Jensen Inc. purchased a $300,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 $69,000 each...
Bob Jensen Inc. purchased a $700,000 machine to manufacture specialty taps for electrical equipment. Jensen expects...
Bob Jensen Inc. purchased a $700,000 machine to manufacture specialty taps for electrical equipment. Jensen expects to sell all it can manufacture in the next 10 years. The machine is expected to have a 10-year useful life with no salvage value. Jensen uses straight-line depreciation. Jensen uses a 10% discount rate in evaluating capital investments, the investment is subject to taxes, and the projected pretax operating cash inflows are as follows: Year Pretax Cash Inflow 1 $ 70,000 2 86,000...
Bob Jensen Inc. purchased a $480,000 machine to manufacture specialty taps for electrical equipment. Jensen expects...
Bob Jensen Inc. purchased a $480,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. Jensen uses a 8% discount rate in evaluating capital investments,...
Bob Jensen Inc. purchased a $250,000 machine to manufacture specialty taps for electrical equipment. Jensen expects...
Bob Jensen Inc. purchased a $250,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 $58,000 each...
Question 2 Olsen Inc. purchased a $450,000 machine to manufacture a specialty tap for electrical equipment....
Question 2 Olsen Inc. purchased a $450,000 machine to manufacture a specialty tap for electrical equipment. The tap is in high demand and Olsen can sell all that it could manufacture for the next 10 years. To encourage capital investments, the government exempts taxes on profits from new investments in this type of machinery. This legislation most likely will remain in effect in the foreseeable future. The equipment is expected to have 10 years of useful life and no salvage...
On January 1, 2015, Toshi Limited purchased a machine for $750,000. The machine was estimated to...
On January 1, 2015, Toshi Limited purchased a machine for $750,000. The machine was estimated to have a 20 year useful life with a residual value of $100,000. The company used the straight-line method to depreciate the machine. On December 31, 2019, the company sold the equipment for $600,000 cash Required Calculate the gain or loss on sale on the sale of the machine. Prepare the journal entry to recognize the sale of the machine. Requirement # 1 DATE ACCOUNT...
ABC Distribution Center Inc. purchased special handling equipment for beverage manufacture $20,000. The equipment may be...
ABC Distribution Center Inc. purchased special handling equipment for beverage manufacture $20,000. The equipment may be depreciated using the following three depreciation methods for 5 years with a salvage value of $5,000. Develop depreciation schedules for the three methods. Show detail of your set up with book value for each year. i. DDB ii. SOYD iii. MACRS
Jensen Company purchased a new machine on October 1, 2017, at a cost of $104,000. The...
Jensen Company purchased a new machine on October 1, 2017, at a cost of $104,000. The company estimated that the machine has a salvage value of $8,000. The machine is expected to be used for 80,000 working hours during its 8-year life. Instructions Compute depreciation using the following methods in the year indicated. (a)     Straight-line for 2017 and 2018, assuming a December 31 year-end. (b)     Declining-balance using double the straight-line rate for 2017 and 2018. (c)     Units-of-activity for 2017, assuming...
BBK Company bought an equipment to manufacture machine parts for Rs 5,600,000. The equipment was expected...
BBK Company bought an equipment to manufacture machine parts for Rs 5,600,000. The equipment was expected to be useful for 5 years and an estimated residual value of Rs 280,000. The equipment is expected to manufacture 350,000 parts. It manufactured 105,000 parts in year 1; 84,000 in year 2; 21,000 in year 3; 112,000 in year 4 and 28,000 parts in year 5. Required: Compute the depreciation expense for each year under the following methods: (a) Straight-line;(b)Written-down-value;(c)Productionunits
On January 1, 2010, the Felix Company purchased a machine to use in the manufacture of...
On January 1, 2010, the Felix Company purchased a machine to use in the manufacture of its product. The invoice cost of the machine was $260,000. At the time of acquisition, the machine had an original estimated useful life of 10 years and an estimated salvage value of $20,000. Annual depreciation was recorded at $24,000 per year. The machine was depreciated using the straight-line method. On August 1, 2015, Felix exchanged the old machine for a newer model. The new...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT