Department of Finance Faculty of Business
Department of Finance Faculty of Business, Bentley University
MJP_TP2_Rev.1.1
Copyright Š 2018, Michael J. Page
Project Appraisal at Stoneville, Inc.
Since its founding in in 2005 in Moorhead, Stoneville, Inc. has established a significant reputation as a producer of quality faux gardening products. The Company operates within the greater FargoâMoorhead metropolitan area spanning the North DakotaâMinnesota border. Stoneville is still run by its founder and majority shareholder, Jack Sprat, who has established a significant reputation amongst the local business community for running the business using lean manufacturing techniques.
Products within the companyâs portfolio include such items as interlocking faux cobblestones for garden borders, artificial self-draining turf tiles for balconies and courtyards, faux rocks of various sizes that can be used as swimming pool surrounds to make swimming pools look more like natural ponds, and realistic predator birds designed to keep âbullyâ birds such as starlings, pigeons and English sparrows away.
Stoneville distributes its products through two channelsâa company owned website and in-store placement within a multi-state garden and home improvement retail chain, Builders Warehouse, Inc. The contractual relationship with Builders Warehouse requires that Stoneville place pre-agreed popular items on consignment at each of the chainâs hyper stores throughout Minnesota and North Dakota. Although this greatly increased the companyâs inventory and funding requirements, Jack continued to see the relationship as key to building awareness of the quality of his products.
Approximately 85% of Stoneville, Inc. sales come from in-store placement with the remainder ordered directly through the company website.
Conversation with the Founder and CEO
You have just begun the second week of your internship with Stoneville, Inc. when Mr Sprat calls you into his office.
Sprat: Good morning! As you are about to start your second week with us, I thought it would be a good idea for me to find out how things are going. As I indicated when I first offered you the position for the summer, I want to support your education by making sure that the tasks you fulfil while with us complement your studies as much as possible.
You: Good morning Mr Sprat. Thanks for taking the time to chat with me. My first week was fantastic and I have really enjoyed seeing how the production division works. Although we did spend time in my sophomore year learning about lean manufacturing, actually seeing how you have implemented it has really grounded what was previously a little theoretical for me. I have also greatly appreciated Ms Brews1 and her team. My parents had suggested that I may get a little friendly teasing when I arrivedâthey even warned me about being sent off to collect left-handed screwdriversâbut none of this happened. All of the team were very welcoming and open to answering my queries, no matter how silly they might have been.
Sprat: Iâm pleased to hear it. Does this mean that youâd like to continue working with Jane and the production department?
1 Ms Jane Brews is the vice president for production at Stoneville, Inc.
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 2 of 8
You: Now that you ask, although Iâd be happy to continue working with the production team, I am hoping to spent a little time in finance. As you are aware, I have decided to major in Finance & Accounting at the Offutt School of Business at Concordia College. It would be really helpful if I could spend a little time learning more about broader treasury aspects. I learned in my foundation principles of accounting and finance course that treasury is involved in ensuring that Stoneville maintains the needed liquidity, in developing the companyâs financial plans, and in looking into the financial rationale for its capital investment choices. Seeing how some of this is actually done would be fascinating for me!
Sprat: Wow, your timing is perfect! We have just had a request from Builders Warehouse to manufacture and supply rainwater capture barrels that resemble faux rocks. Recent media stories about possible drought conditions in North Dakota2 are raising concerns about increases to water tariffs in urban areas. This has resulted in a number of urban homeowners requesting rainwater capture barrels that can be attached to domestic downpipes and used to store roof runoff. The barrels currently available have a real industrial look to them and they certainly donât make for an attractive presence against the wall of a home. Central purchasing of Builders Warehouse, Inc. believe that a storage devise of up to fifty gallons that is designed to look like a large boulder would offer a popular alternative.
Claire, a bookkeeper in the finance department, has done an analysis for us using information that she obtained from our production group. Her analysis suggests that the investment will boost our earnings per share only marginally and achieve an internal rate of return that is less than our companyâs hurdle rate of 8% per annum. She suggests that we do not take on the project. Both I and William Blake, our vice president of finance, greatly respect Claireâs bookkeeping ability. Every year, our auditors comment on how easy it is for them to perform their due diligence thanks to Claireâs abilities and processes. However, even she would not claim to be an expert in capital budgeting. Perhaps you can look through what has been done with fresh college eyes? William and I are concerned that not investing in the project may adversely impact our relationship with Builders Warehouse. Even though the product will only represent an extremely small percentage of their revenue, our sense is that they see offering it as further evidence of the companyâs commitment to sustainability or good citizenship.
You: Gee, Mr Sprat, I would love to give this a go! We covered capital budgeting in our introductory course with the professor telling us about a whole host of doâs and donâts when undertaking a capital budgeting exercise.
Sprat: Terrific! I know that William would appreciate someone taking a second look at the value proposition before we commit. Iâll give him a call and say youâll be along tomorrow morning to collect any material he has, as well as the analysis done by Claire. Iâll also give Jane a call to ask her to release you from the production department from tomorrow to concentrate on this assignment.
You: Thank you Mr Sprat. I really appreciate this opportunity.
2 See: http://www.valleynewslive.com/content/news/Drought-conditions-create-difficulties-for-ND-farmers-ranchers-426368681.html and http://www.westfargopioneer.com/news/4306292-hay-lottery-planned-north-dakota-ranchers-struggling-drought, accessed February 9, 2018 at 2:14PM EST.
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 3 of 8
The Task at Hand
It is 10:00AM Tuesday morning and you are sitting in a small office allocated to you by William Blake. Lying on the desk in front of you is the material given to you by Mr Blake. Although the material is less than you expected, you do see some challenges ahead. You hope you are up to the assignment.
Mr Blake has asked you to review the materials and make any adjustments you consider appropriate before reaching a conclusion on whether the investment should be pursued. Although you gathered from your discussion with him that he was as keen as Mr Sprat that Stoneville make the right decision on this investment, you did get a reinforced sense of how respected Claire was. What would the implications be if you come to a recommendation that is contrary to her? How might you handle this? What about the relationship with Builders Warehouse, Inc.?
You have been asked to submit a written memorandum addressed to both Mr Sprat and Mr Blake motivating your caseâparticularly in areas where you believe that an alternative choice should be made concerning aspect that is material to the decisionâand to include any necessary spreadsheets as appendices to the document.
The material lying on the desk in front of you includes:
⢠Appendix 1: Email from Builders Warehouse requesting faux rock rainwater capture barrels ⢠Appendix 2: Production department estimates of requirements for production ⢠Appendix 3: Claireâs Analysis and conclusions
Memorandum Requirements
The memorandum that you need to submit must be concise and focused on key issues. It should be submitted as a single .PDF document that includes any necessary appendices. Remember that you need to impress Messrs Sprat and Blake with as parsimonious a report as is possible while ensuring that your arguments are well presented. The professionalism of presentation is also important. In particular, you need to:
⢠Begin with an executive summary that presents your overall recommendation and a brief motivation.
⢠Within the body of your report you need to include:
o More comprehensive justifications for your choices when developing your cash flow analysis. You need to justify where, and why, your analysis does not agree with choices made by Claire.
o The outcome of your sensitivity analyses and discuss how they support your ultimate recommendation. What if sales volumes are 5% lower than expected, or production costs are 5% higher? What will be the outcome if the ultimate retail price could be increased by 5% at existing volumes?
o An appendix that presents your comprehensive base-case cash flow analysisâlaying out the incremental cash flows for each quarterâand the final net present value etc.
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 4 of 8
Appendix 1: Email from Builders Warehouse requesting faux rock rainwater capture barrels
From: Olive Smith [[email protected]] Sent: Friday, February 09, 2018 5:52 PM To: Sprat, Jack Subject: Proposal for Faux Rainwater Barrels Dear Jack, I refer to our telephone conversation of last week. With the current drought concerns in Northern Dakota, Builders Warehouse anticipates significant demand from homeowners for low costs self-installation rainwater capture barrels. Preliminary market research has been undertaken by our marketing department using both focus group techniques and in-store surveys. The results confirm for us that barrels disguised as large boulders holding between twenty-five and fifty gallons of rainwater have particular appeal for urban home owners who want to maintain their gardens if expected water restrictions are instituted in the Moorhead-Fargo metropolitan area. Perhaps unsurprisingly given how many roof runoff drainpipes are front of property facing, concern for appearance remains high amongst even the most ardent gardeners. Given the good relationship we have with Stoneville, Inc. and the quality and consequent demand we face for your products that we stock, the Board of Builders Warehouse has charged me with asking if you would be prepared design and deliver to our stores faux rock barrels that can be easily installedâplacedâagainst property walls to allow a cut off drainpipe to flow directly into them. We would be looking for two barrel sizes, twenty-five and a fifty gallons that we believe will retail at $125 and $218.75 respectively. The terms of stocking would be exactly the same as with your other productsâon consignment with us keeping 20% of the retail price and remitting the remainder to you when you complete your quarterly restocking and submit your invoice through to us. As is standard with consignment arrangements, we require quarterly opening consignment inventory equal to 110% of expected quarterly sales except for the final quarter of the contract. Our expectation is that weâll sell 1,000 of the twenty-five gallon and 750 of the fifty gallon barrels per quarter over the first year, increasing by 10% for the next year before declining by 25% for the final year of sales and then ceasing when a major Minnesota dam project is completed that will be able to fully supply the Morehead-Fargo metropolis. Please feel free to call if you have any additional queries. We would like to sign a formal contract as soon as possible. Kind regards, Olive Olive Smith Vice President, Purchasing Builders Warehouse, Inc. 510 Center Ave, Moorhead, MN 56560 T: 218-299-1000 Ext. 1113 Email:Â [email protected]
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 5 of 8
Appendix 2: Production department estimates of requirements for production
Product Design:
Stoneville, Inc. subcontracted design team has developed the production plans for the twenty-five and fifty gallon faux rock rainwater barrels. Their design meets the companyâs lean manufacturing requirements with process flow requiring no retention of raw materials. Rather, on arrival, raw materials are fed directly into the production machinery to produce finished goods that can be transported relatively quickly to the retail client, Builders Warehouse, Inc.
The recently submitted invoice from the designer team is at the agreed fee of $35,000.
Production:
Production machinery needed to produce the barrels will be acquired at an all-in price of $600,000. The machinery will qualify for five-year modified accelerated cost recovery system (MACRS-5) depreciation and, if purchased, if will be in service in the 1st quarter. Consequently, the schedule for annual depreciation deductions is:
Year 1 2 3 4 5 6 Allowance 35.0% 26.0% 15.6% 11.01% 11.01% 1.38%
Stonevilleâs experience with machinery purchases suggests that its second-hand equipment can generally be disposed of after three or four years of use at 150% of its depreciated value. The company has a reputation for exemplary maintenance of it equipment and it can usually obtain manufacturer endorsement when looking to sell equipment that it no longer requires.
If Stoneville accepts the offer to supply the barrels to Builders Warehouse, Inc., the production facilities will be located in a building that the Company currently leases to a 3rd party at $24,000 per quarter payable in advance. Since the lease is about to expire, Stoneville can take back the building for its own use without incurring any lessor penalties for early termination of the lease.
Estimates of the production costs excluding production equipment depreciation (i.e. materials and labor) are 55% of the anticipated wholesale price. At todayâs prices, they are estimated at $55.00 and $96.25 for the twenty-five and fifty gallon barrels respectively. As with all raw materials purchasing, these costs presume Stoneville will pay cash and receive the maximum supplier discounts possible.
Given the expected size and weight of the barrels, shipping costs to the retail outlets of Builders Warehouse are estimated at 15% of the production costs, or $8.25 and $14.44 per barrel for the two respective sizes.
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 6 of 8
Appendix 3: Claireâs Analysis and conclusions
Recommendation:
My overall recommendation is that we do not invest in the project. I calculate the net present value of the three-year project at a negative $80,194 with a corresponding internal rate of return (IRR) of 3.59% per annum, significantly below our hurdle rate of 8% per annum. Additionally, although earnings for the first year are positive at $10,300 and we intend to finance the equipment purchase and working capital needed using debt and current cash balances, this only represents a 2.94c improvement in earnings per share given the 350,000 shares currently outstanding. This hardly seems worth the investment given the negative value indicators of NPV and IRR.
Assumptions and Calculations:
As you will see from the attached spreadsheet, I have undertaken a quarterly analysis over the three-year life of the project. Specific assumptions that I have made are:
Quarterly Income Statements:
⢠I presume that the volumes sold are as anticipated in the memorandum from Olive Smith of 1,000 and 750 units per quarter for the twenty-five and fifty gallon barrels respectively. First year retail selling prices of $125 and $218.75 respectively have been translated into $100 and $175 per barrel selling prices to Stoneville, Inc.
⢠Selling prices are escalated at our corporate assumed inflation rate of 1.5% per annum with the assumption that Builders Warehouse will adjust prices once per annum. This is consistent with their past practices.
⢠Cost of productionâexcluding depreciation of the production equipmentâand shipping costs are set at 40% of the anticipated wholesale price and 15% of the expected production cost respectively.
⢠The depreciation allowance per annum is based upon the required MACRS-5 schedule under the assumption the equipment is brought into service in the 1st quarter. The annual allowance is distributed equally across the four quarters of each year.
⢠As is common practice when monitoring divisional performance, I have allocated an overhead charge of 7.5% of project revenue even though we do not anticipate any incremental expenditure or investment needs in central administration.
⢠Because we need to recover our design investment, I have charged the $35,000 to the project. I presume that the taxation benefit will be realised in the first quarter even though we are already obligated to pay the invoice within the next few weeks.
⢠Finally, although we have enough cash on hand to fund our needed working capital investments, Stoneville, Inc. will need to arrange a medium term loan to fund the equipment purchase. Treasury has indicated that our banker is willing to extend the loan at an annual rate of 4.4% with interest payable quarterly in arrears.
Equipment and Working Capital Investments:
⢠As indicated above, the $600,000 capital investment is depreciated using the MACRS-5 schedule. ⢠No allowance is made to sell or scrap the equipment at the end of the project. This seems prudent,
particularly if any assumption of residual value on equipment makes a poor project look attractive. Our skill
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 7 of 8
is in faux garden product production and not in second-hand equipment sales. This suggests we should find value in our core operating business.
⢠From a working capital perspective, opening inventories for each quarterâexcluding the lastâis set equal to 110% of the production cost of the inventory that Builders Warehouse, Inc. expects to sell over the quarter. For the last quarter of planned sales, the inventory is set at 100% of the inventory that Builders Warehouse, Inc. expects to sell over the quarter as per our standard consignment agreements. Accounts receivable at the end of each quarter are set equal to the expected revenue to Stoneville for the quarter. Full recovery of accounts receivable is expected at the end of the three-year contract. Finally, all raw materials are purchased for cash so that we obtain maximum discounts and accounts payable are zero throughout the life of the project
Sensitivity Analysis:
⢠Given the negative outlook for the project at base assumptions, I have not undertaken a major sensitivity analysis. However, even if Builders Warehouse is prepared to consider increasing the initial retail price by 4.5% to $130.63 and $228.59 for the twenty-five and fifty gallon barrels respectively, this will only make the project marginally worth pursuing.
Assuming that our production and distribution costs remain the same, the incremental after tax contributions to Stoneville for the first year are:
25 gallon barrel: 80% ( $130.63 – $125.00 ) ( 1 â 0.21 ) = $3.56 per barrel 50 gallon barrel: 80% ( $228.59 – $218.75 ) ( 1 â 0.21 ) = $6.22 per barrel
This results in a final net present value of $6,110 and an internal rate of return of 8.33%. The impact on our first year earnings per share would be 12.34c.
MJP_TP2_Rev.1.1 Project Appraisal at Stoneville, Inc.
Page 8 of 8
N
o w Q 4
Q 1
Q 2
Q 3
Q 4
Q 1
Q 2
Q 3
Q 4
Q 1
Q 2
Q 3
Q 4
Pr o
fo rm
a P
ro je
c t I
nc o
m e
S ta
te m
e nt
s
R e
ve n
u e
23 1,
25 0
23 1,
25 0
23 1,
25 0
23 1,
25 0
25 8,
19 1
25 8,
19 1
25 8,
19 1
25 8,
19 1
19 6,
59 3
19 6,
59 3
19 6,
59 3
19 6,
59 3
C o
st o
f p ro
d u
c tio
n e
xc l.
d e
p re
c ia
tio n
c h
a rg
e s
(1 27
,1 88
) (1
27 ,1
88 )
(1 27
,1 88
) (1
27 ,1
88 )
(1 42
,0 05
) (1
42 ,0
05 )
(1 42
,0 05
) (1
42 ,0
05 )
(1 08
,1 26
) (1
08 ,1
26 )
(1 08
,1 26
) (1
08 ,1
26 )
Sh ip
p in
g c
o st
s (1
9, 07
8) (1
9, 07
8) (1
9, 07
8) (1
9, 07
8) (2
1, 30
1) (2
1, 30
1) (2
1, 30
1) (2
1, 30
1) (1
6, 21
9) (1
6, 21
9) (1
6, 21
9) (1
6, 21
9)
G ro
ss m
a rg
in 84
,9 84
84 ,9
84 84
,9 84
84 ,9
84 94
,8 85
94 ,8
85 94
,8 85
94 ,8
85 72
,2 48
72 ,2
48 72
,2 48
72 ,2
48
D e
p re
c ia
tio n
(5 2,
50 0)
(5 2,
50 0)
(5 2,
50 0)
(5 2,
50 0)
(3 9,
00 0)
(3 9,
00 0)
(3 9,
00 0)
(3 9,
00 0)
(2 3,
40 0)
(2 3,
40 0)
(2 3,
40 0)
(2 3,
40 0)
H e
a d
o ff
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
