Question

In: Finance

Jack Tar, CFO of Sheetbend & Halyard, Inc., opened the company confidential envelope. It contained a...

Jack Tar, CFO of Sheetbend & Halyard, Inc., opened the company confidential envelope. It contained a draft of a competitive bid for a contract to supply duffel canvas to the Canadian Armed Forces. The cover memo from Sheetbend’s CEO asked Mr. Tar to review the bid before it was submitted. The bid and its supporting documents had been prepared by Sheetbend’s sales staff. It called for Sheetbend to supply 100,000 yards of duffel canvas per year for 5 years. The proposed selling price was fixed at $30 per yard.

The cost of goods will increase for this this project is 70% in the first year followed by 73%, 76%, 78.74% and 82% in years 2 through 5.Company tax rate is 35% Mr. Tar was not usually involved in sales, but this bid was unusual in at least two respects. First, if accepted by the forces, it would commit Sheetbend to a fixed-price, long-term contract. Second, producing the duffel canvas would require an investment of $1.5 million to purchase machinery and to refurbish Sheetbend’s plant in Saint John, New Brunswick. Mr. Tar set to work and by the end of the week had collected the following facts and assumptions:

• The plant in Saint John was built in the early 1900s and is now idle. The plant was fully depreciated on Sheetbend’s books, except for the purchase cost of the land (in 1947) of $10,000. • Now that the land was valuable shorefront property, Mr. Tar thought the land and the idle plant could be sold, immediately or in the future, for $600,000.

• Refurbishing the plant would cost $500,000. This investment would be depreciated for tax purposes in an asset class that has a CCA rate of 5%. • The new machinery would cost $1 million. This investment could be depreciated in an asset class that has a CCA rate of 30%.

• Working capital requirement is 10% of sales • The refurbished plant and new machinery would last for many years. However, the remaining market for duffel canvas was small, and it was not clear that additional orders could be obtained once the Forces contract was finished. The machinery was custom-built and could be used only for duffel canvas. Its second-hand value at the end of 5 years was probably zero.

1) Armed with this information, construct a spreadsheet/table to calculate the NPV of the duffel canvas project, assuming that Sheetbend’s bid would be accepted by the Forces. Should Mr. Tar recommend submitting the bid to the Forces at the proposed price of $30 per yard? The discount rate for this project is 12%.

2) He had just finished debugging the spreadsheet when another confidential envelope arrived from Sheetbend’s CEO. It contained a firm offer from a New Brunswick real estate developer to purchase Sheetbend’s Saint John land and plant for $1.5 million in cash. Which offer would you except 5 marks

Show all calculations and rationale . Use the Cheat Sheet NPV Analysis as a template for this analysis Hint Think of the three areas that have to be examined

1. Cash flow from investments in plant and equipment – capital investment.

2. Cash flow from investment in working capital 3. Cash flow from operations

Solutions

Expert Solution

Present value (PV)of Cash Flow=(Cash Flow)/((1+i)^N)
i=discount Rate=12%=0.12, N=year of Cash Flow
N Year 0 1 2 3 4 5
INITIAL CASH FLOW:
S Cost of machinery ($1,000,000)
T Cost of refurbishing the plant ($500,000)
U Opportunity cost of not selling the plant ($600,000)
V=S+T+U Total Initial Cash Flow ($2,100,000)
ANNUAL OPERATING CASH FLOW
A=100000*30 Sales Revenue $3,000,000 $3,000,000 $3,000,000 $3,000,000 $3,000,000
B Cost of goods $2,100,000 $2,190,000 $2,280,000 $2,362,200 $2,460,000
C=A-B Contribution Margin(Before tax) $900,000 $810,000 $720,000 $637,800 $540,000
Tax Rate=0.35 D=C*(1-0.35) After tax Contribution Margin $585,000 $526,500 $468,000 $414,570 $351,000
DEPRECIATION TAX SHIELD
Machinery (30% CCA)
E Book Balance at the beginning o the year $1,000,000 $700,000 $490,000 $343,000 $240,100
F=E*0.3 Depreciation $300,000 $210,000 $147,000 $102,900 $72,030
G=E-F Book Value at the end of the year $700,000 $490,000 $343,000 $240,100 $168,070
Tax Rate=35% H=F*0.35 Depreciation tax shield $105,000 $73,500 $51,450 $36,015 $25,211
Refurbishing the Plant(5% CCA)
I Book Balance at the beginning o the year $500,000 $475,000 $451,250 $428,688 $407,253
J=I*0.05 Depreciation $25,000 $23,750 $22,563 $21,434 $20,363
K=I-J Book Value at the end of the year $475,000 $451,250 $428,688 $407,253 $386,890
Tax Rate=35% L=J*0.35 Depreciation tax shield $8,750 $8,313 $7,897 $7,502 $7,127
M=H+L Total Depreciation tax shield $113,750 $81,813 $59,347 $43,517 $32,337
O=0.1*A Working capital Requirement ($300,000)
P Release of Working Capital $300,000
X=V+D+L+O+P Net After Tax Cash Flow ($2,400,000) $698,750 $608,313 $527,347 $458,087 $683,337 SUM
Y=X/(1.12^N) PV of Net After Tax Cash Flow ($2,400,000) $        623,884 $          484,943 $         375,355 $        291,123 $           387,744 ($236,951)
Net Present value(NPV) ($236,951)
2) New Offer for Land and Plant $1,500,000
Increase in Opportunity Cost of not selling the plant $900,000 (1500000-600000)
Revised net Present value ($1,136,951) -1136951
In either case NPV is negative
The Cash offer of $1500000 should be accepted

Related Solutions

Jack Tar, CFO of Sheetbend & Halyard, Inc., opened the company confidential envelope. It contained a...
Jack Tar, CFO of Sheetbend & Halyard, Inc., opened the company confidential envelope. It contained a draft of a competitive bid for a contract to supply duffel canvas to the U.S. Navy. The cover memo from Sheetbend?s CEO asked Mr. Tar to review the bid before it was submitted. The bid and its supporting documents had been prepared by Sheetbend?s sales staff. It called for Sheetbend to supply 100,000 yards of duffel canvas per year for 5 years. The proposed...
Jack, a geologist, opened a business organized as a C corporation called Geo-Jack (GJ) in January...
Jack, a geologist, opened a business organized as a C corporation called Geo-Jack (GJ) in January of this year. Jack is the sole shareholder. Assume GJ reports on a calendar year and uses the accrual method of accounting. For each item below, indicate its effect on Jack’s taxable income and you must clearly indicate whether it is positive or negative. In January, GJ rented a small business office about 12 miles from Jack’s home. GJ paid $14,000, which represented a...
Jack, a geologist, opened a business organized as a C corporation called Geo-Jack (GJ) in January...
Jack, a geologist, opened a business organized as a C corporation called Geo-Jack (GJ) in January of this year. Jack is the sole shareholder. Assume GJ reports on a calendar year and uses the accrual method of accounting. For each item below, indicate its effect on Jack’s taxable income and you must clearly indicate whether it is positive or negative. In an attempt to get his name and new business recognized, GJ paid $9,000 for a one-page ad in the...
Jack Thyme opened Thyme Company, a veterinary business on August 1, 2017. On August 31, the...
Jack Thyme opened Thyme Company, a veterinary business on August 1, 2017. On August 31, the balance sheet showed Cash $9,000; Accounts Receivable $1,700; Supplies $600; Equipment $5,000; Accounts Payable $3,600; Common Stock $10,000; and Retained Earnings $2,700. During September, the following transactions occurred. Sept. 2 Paid $3,400 cash for accounts payable due. 5 Received $1,200 from customers in payment of accounts receivable. 8 Purchased additional office equipment for $5,100, paying $1,000 in cash and the balance on account. 13...
Jack is thinking about buying shares in ABC Car Company, Inc. However, Jack can’t decide if...
Jack is thinking about buying shares in ABC Car Company, Inc. However, Jack can’t decide if he should buy shares of common stock or shares of preferred stock. What are some of the things he should consider in order to help him determine the type of share he should buy?
The Master (Static) budget for Jack Daniels Inc. is presented below. For June, Jack Daniels Inc....
The Master (Static) budget for Jack Daniels Inc. is presented below. For June, Jack Daniels Inc. manufactured and sold 920 units for $835. During this month the company incurred $460,000 total variable expenses and $180,000 total fixed expenses. Required Prepare a flexible budget performance report for June including all variances.          Master (Static) Budget Units 1,000 Sales $800,000 Variable costs 450,000 Contribution margin $350,000 Fixed costs 150,000 Operating income $200,000 Jack Daniels Inc. used 3,450 pounds of aluminum in June to...
You are the CFO of Thunderduck Energy, Inc, a public company that specializes in the exploration...
You are the CFO of Thunderduck Energy, Inc, a public company that specializes in the exploration and development of natural gas. It's near year-end, and you have been in several meetings with management to discuss the end of year net income projections. The company’s employees receive a bonus if the company’s net income in the current year exceeds the net income from the past year. For the current year, the earnings have not been as strong as expected and net...
You are the CFO of Thunderduck Energy, Inc, a public company that specializes in the exploration...
You are the CFO of Thunderduck Energy, Inc, a public company that specializes in the exploration and development of natural gas. It's near year-end, and you have been in several meetings with management to discuss the end of year net income projections. The company’s employees receive a bonus if the company’s net income in the current year exceeds the net income from the past year. For the current year, the earnings have not been as strong as expected and net...
Part A) The CFO of Jack McCoy Legal Advisors is continually receiving capital funding requests from...
Part A) The CFO of Jack McCoy Legal Advisors is continually receiving capital funding requests from its division managers. These requests are seeking funding for positive net present value projects. The CFO continues to deny all funding requests due to the financial situation of the company. Apparently, the company is: 1. operating at the accounting break-even point. 2. operating at the financial break-even point. 3. facing hard rationing. 4. operating with zero leverage. 5. operating at maximum capacity. Part B)...
ack, a geologist, opened a business organized as a C corporation called Geo-Jack (GJ) in January...
ack, a geologist, opened a business organized as a C corporation called Geo-Jack (GJ) in January of this year. Jack is the sole shareholder. Assume GJ reports on a calendar year and uses the accrual method of accounting. For each item below, indicate its effect on Jack’s taxable income and you must clearly indicate whether it is positive or negative. (0.5 points each, 4 points total) In January, GJ rented a small business office about 12 miles from Jack’s home....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT