Question

In: Finance

Lasting Impressions (LI) Company is a medium-sized commercial printer of promotional advertising brochures, booklets, and other...

Lasting Impressions (LI) Company is a medium-sized commercial printer of promotional advertising brochures, booklets, and other direct-mail pieces. The firm’s major clients are ad agencies based in New York and Chicago. The typical job is characterized by high quality and production runs of more than 50,000 units. LI has not been able to compete effectively with larger printers because of its existing older, inefficient presses. The firm is currently having problems meeting run length requirements as well as meeting quality standards in a cost-effective manner. The general manager has proposed the purchase of one of two large, six-color presses designed for long, high-quality runs. The purchase of a new press would enable LI to reduce its cost of labor and therefore the price to the client, putting the firm in a more competitive position. The key financial characteristics of the old press and of the two proposed presses are summarized in what follows. Old press Originally purchased 3 years ago at an installed cost of $400,000, it is being depreciated under MACRS using a 5-year recovery period. The old press has a remaining economic life of 5 years. It can be sold today to net $420,000 before taxes; if it is retained, it can be sold to net $150,000 before taxes at the end of 5 years. Press A This highly automated press can be purchased for $830,000 and will require $40,000 in installation costs. It will be depreciated under MACRS using a 5-year recovery period. At the end of the 5 years, the machine could be sold to net $400,000 before taxes. If this machine is acquired, it is anticipated that the current account changes shown in the following table would result. Integrative Case 5 Cash (+) $ 25,400 Accounts receivable (+) 120,000 Inventories (-) 20,000 Accounts payable (+) 35,000 Press B This press is not as sophisticated as press A. It costs $640,000 and requires $20,000 in installation costs. It will be depreciated under MACRS using a 5-year recovery period. At the end of 5 years, it can be sold to net $330,000 before taxes. Acquisition of this press will have no effect on the firm’s net working capital investment. The firm estimates that its earnings before depreciation, interest, and taxes withthe old press and with press A or press B for each of the 5 years would be as shown in the table at the top of the next page. The firm is subject to a 40% tax rate. The firm’s cost of capital, r, applicable to the proposed replacement is 14%. Earnings before Depreciation, Interest, and Taxes for Lasting Impressions Company’s Presses Year - Old press - Press A - Press B 1- $120,000 - $250,000 - $210,000 2 - 120,000 - 270,000 - 210,000 3 - 120,000 - 300,000 - 210,000 4 - 120,000 - 330,000 - 210,000 5 - 120,000 - 370,000 - 210,000

TO DO

a. For each of the two proposed replacement presses, determine:

(1) Initial investment.

(2) Operating cash inflows. (Note: Be sure to consider the depreciation in year 6.)

(3) Terminal cash flow. (Note: This is at the end of year 5.)

b. Using the data developed in part a, find and depict on a time line the relevant cash flow stream associated with each of the two proposed replacement presses, assuming that each is terminated at the end of 5 years.

c. Using the data developed in part b, apply each of the following decision techniques:

(1) Payback period. (Note: For year 5, use only the operating cash inflows—that is, exclude terminal cash flow—when making this calculation.)

(2) Net present value (NPV).

(3) Internal rate of return (IRR).

Solutions

Expert Solution

DEPRECIATION OF OLD PRESS
Year From Date of Purchase 1 2 3 4 5 6
Year From Today 1 2 3 4 5
A Depreciation Rate 20.00% 32.00% 19.20% 11.52% 11.52% 0.00%
D1=400000*A Annual Depreciation expense $80,000 $128,000 $76,800 $46,080 $46,080 $0 $0 $0
Accumulated Depreciation $80,000 $208,000 $284,800 $330,880 $376,960 $376,960 $376,960 $376,960
Salvage Value $420,000 $150,000
Book Value today $92,160 (400000-284800)
Salvage Value today(Before tax) $420,000
Salvage gain $327,840
Tax on gain =40%*304800 $131,136
After tax salvage value today=420000-121920 $288,864
Salvage value (Before tax) at end of year 5 $150,000
After tax salvage value at end of year 5 $90,000 (150000*(1-0.4)
DEPRECIATION OF NEW PRESS A
Year(from today) 1 2 3 4 5
A Depreciation Rate 20.00% 32.00% 19.20% 11.52% 11.52%
D2=A*($830000+40000) Depreciation amount $174,000 $278,400 $167,040 $100,224 $100,224
Accumulated Depreciation $174,000 $452,400 $619,440 $719,664 $819,888
Book Value at end of year 5=870000-819000 $50,112
Before tax Salvage Value at end of year5 $400,000
Gain on Salvage $349,888
Tax on gain =40%*349888 $139,955
After Tax Salvage Value $260,045
After Tax Incremental Salvage Value $170,045 (260045-90000)
DEPRECIATION OF NEW PRESS B
Year(from today) 1 2 3 4 5
A Depreciation Rate 20.00% 32.00% 19.20% 11.52% 11.52%
D2=A*($640000+20000) Depreciation amount $132,000 $211,200 $126,720 $76,032 $76,032
Accumulated Depreciation $132,000 $343,200 $469,920 $545,952 $621,984
Book Value at end of year 5 $38,016
Before tax Salvage Value at end of year5 $330,000
Gain on Salvage $291,984
Tax on gain =40%*291984 $116,794
After Tax Salvage Value $213,206
After Tax Incremental Salvage Value $123,206 (213206-90000)
Present value of Cash Flow=(Cash Flow)/((1+i)^N)
i=discount Rate =Cost of capital =14%=0.14
N=Year of Cash Flow

Related Solutions

You work as a commercial loan officer in a local bank.  The president of a small-to-medium sized...
You work as a commercial loan officer in a local bank.  The president of a small-to-medium sized fast-food restaurant chain, with 250 employees in five locations, comes into your bank and asks for a business loan of $400,000 to help fund his expansion plans for building two additional restaurant locations Question(s): What would be your concerns as the loan officer? What questions would you ask and what financial documents might you request of him/her? Discusses differences between Accrual basis and Cash...
Rainbow Company, a medium-sized company specialized in the manufacture and distribution of equipment for babies and...
Rainbow Company, a medium-sized company specialized in the manufacture and distribution of equipment for babies and small children, is evaluating a new capital expenditure project. In a joint venture with another separate company it has invented a remote controlled pushchair, one of the first of its kind on the market. It has been unable to obtain a patent for the invention, but is sure that it will monopolize the market for the first three years. After this, it expects to...
a. An employee, Fred, working in the accounts office of a medium-sized company listed on the...
a. An employee, Fred, working in the accounts office of a medium-sized company listed on the Nairobi Stock Exchange, was working late one evening during the week. He realized he had left his pen in the boardroom at an earlier meeting and, given its value, went upstairs to look for it. As he approached the door he heard the following discussion: ‘Chief Executive: I am deeply concerned that if this fall in profit figures is disclosed in the next annual...
TeaLand S.A. is a London company that started as a medium-sized company. Its main activity is...
TeaLand S.A. is a London company that started as a medium-sized company. Its main activity is the commercialization of tea to various European countries. Currently they obtain tea from the main producing countries: China, India, Sri Lanka, Kenya, Indonesia and Turkey. They sell their tea in different ways: in bulk, in bags and cold tea as a soda. They not only sell to supermarkets, but also to companies and the hospitality and catering industries. They have been in the market...
A plc is a medium sized listed company. The results for 5 years to 31 December...
A plc is a medium sized listed company. The results for 5 years to 31 December 2019 are as follows: 2019 2018 2017 2016 2015 EPS (cents) 140 136 131 127 122 DPS (cents) 82 81 79 78 77 Dividends are paid on 31 December each year and the dividend shown as declared in a particular year would have been or will be paid on 31 December the following year. If the current dividend policy is maintained, the directors estimate...
Coral Ltd is a medium sized company based in NSW. It has had a number of...
Coral Ltd is a medium sized company based in NSW. It has had a number of years of relative success, but being conservative by nature, it has tended to serve the local market only. This market has shown signs of decline and the directors are now considering whether to expand the operation from its NSW base into Australian Territories. They are attempting to judge how successful this strategy will be over the next six months. Sales (20,000 units at $20...
On January 31, 2020, the manufacturing facility of a medium-sized company was severely damaged by an...
On January 31, 2020, the manufacturing facility of a medium-sized company was severely damaged by an accidental fire. As a result, the company's direct materials, work in process, and finished goods inventories were destroyed. The company did have access to certain incomplete accounting records, which revealed the following:1.Beginning inventories, January 1, 2020: Direct materials $32,000 Finished goods 30,000 Work in process 68,000 2.Key ratios for the month of January 2020: Gross profit = 20% of sales Prime costs = 70%...
Case Study 4 A relational database is to be designed for a medium sized Company dealing...
Case Study 4 A relational database is to be designed for a medium sized Company dealing with industrial applications of computers. The Company delivers various products to its customers ranging from a single application program through to complete installation of hardware with customized software. The Company employs various experts, consultants and supporting staff. All personnel are employed on long‐ term basis, i.e. there is no short‐term or temporary staff. Although the Company is somehow structured for administrative purposes (that is,...
Allison is the manager of the sales department of a medium sized household products company. She’s...
Allison is the manager of the sales department of a medium sized household products company. She’s begun to notice that Dave, a member of the team, has been turning in his reports late and that the quality of the reports has declined. She decides to call him into her office to discuss the issue. How might she use the description, specific and problem-oriented elementals of supportive communication to guide this discussion?
As the controller of a medium-sized financial services company, you take pride in the accounting and...
As the controller of a medium-sized financial services company, you take pride in the accounting and internal control systems you have developed for the company. You and your staff have kept up with changes in the accounting industry and been diligent in updating the systems to meet new accounting standards. Your outside auditor, which has been reviewing the company’s books for 15 years, routinely complimented you on your thorough procedures. The passage of the Sarbanes-Oxley Act, with its emphasis on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT