Question

In: Accounting

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 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

1).

Payback Period = $250000 / $58000 = 4.31 years

2).

Accounting rate of return
Based on Initial Investment = ($58000 - $25000) / $250000 x 100 = 13.20%
Based on Average Investment = $33000 / $125000* x 100 = 26.40%
* Average Investment for 1st year = (0+250000) / 2

3). & 5).

4).

Year Cash Flows PV @ 12% PV Cumulative PV
0 -250000 1 -250000 -250000.00
1 58000 0.8929 51785.71 -198214.29
2 58000 0.7972 46237.24 -151977.04
3 58000 0.7118 41283.25 -110693.79
4 58000 0.6355 36860.05 -73833.74
5 58000 0.5674 32910.76 -40922.98
6 58000 0.5066 29384.61 -11538.38
7 58000 0.4523 26236.25 14697.88
8 58000 0.4039 23425.23 38123.11
9 58000 0.3606 20915.38 59038.49
10 58000 0.3220 18674.45 77712.94


Discounted Pay Back Period = 6 + 11538.38/26236.25 = 6.44 years

_____________________________________________

If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU*************


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 $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...
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...
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
Equipment is purchased for $ 250,000 in year 0 and is expected to sell for $...
Equipment is purchased for $ 250,000 in year 0 and is expected to sell for $ 25,000 after 5 years of use. Suppose the company estimates income and expenses of the equipment for the following first year of operation: Income $ 600,000, Expenses $ 260,000, Depreciation $ 45,000. If the company pays taxes at a rate of 35%, what is the after-tax cash flow for the first year? 
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...
6-10 A company purchased factory equipment for $250,000. It is estimated that the equipment will have...
6-10 A company purchased factory equipment for $250,000. It is estimated that the equipment will have a $25,000 salvage value at the end of its estimated 5-year useful life. If the company uses the double-declining-balance method of depreciation, the amount of annual depreciation recorded for the second year after purchase would be $100,000 $60,000 $90,000 $43,200 The maturity value of a $30,000, 8%, 3-month note receivable is $30,600 $30,240 $32,400 $30,200 The following totals for the month of April were...
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT