Question

In: Accounting

Atlantic Glass Company makes custom, luxury shower door glass enclosures for new construction homes and bathroom...

Atlantic Glass Company makes custom, luxury shower door glass enclosures for new construction homes and bathroom remodeling projects. Recently they have received a significant number of inquiries from home builders and contractors about a new glass door design that includes both glass and iron in the shower enclosure materials.

Atlantic Glass’s current production facilities do not have the machinery or space to produce such a specialty, multi material enclosure so the company has turned down these potential orders. The sales department is frustrated by this and tells the CEO that this new product is in high demand and that it could be a significant source of growth for the company. The CEO agrees, and as a next step, launches two initiatives:

1. A customer research study to measure the potential size of the market for this specialty product within Atlantic’s addressable market geography. For this study, Atlantic will need to hire an outside consulting firm and pay them $500,000

2. A capital budgeting analysis to evaluate the potential investment merits (if any) of manufacturing and selling this specialty product line for the next 5 years.

The consulting firm’s findings confirm the sales department’s instincts. It is estimated that, at a selling price of $9,995 per unit, the company could sell 1,500 units in year one of production and that unit volume would grow by 10.0% per year in years 2-5. However, it is also estimated that the new enclosures would cannibalize existing product sales and result in $2 million of erosion costs per year on a pre-tax basis.

The manufacturing department estimates that, in order to produce the specialty enclosures, a $10 million investment in new fixed assets would be required to expand production capacity and capabilities. These fixed assets would be depreciated on a straight line basis over the 5 year estimated life of the project. The salvage value of these fixed assets is estimated to be $3 million at the termination of the project. It is also estimated that the shower enclosures could be produced at a variable cost per unit of $5,000.

Fixed SG&A expenses for the project are expected to be $3.2 million per year. It is also expected that the project will require operating capital investments in years 1-5 equal to 3.0% of product revenue. Atlantic expects to recoup all of its operating capital investment at the termination of the project.

Atlantic currently has a stock price of $22.50 per share and 18.4 million shares of common stock outstanding. The firm has a $50 million term loan outstanding at an interest rate of 4.25% and $200 million in outstanding senior bonds at a 6.50% interest rate. Current risk free rates are 2.40% and the expected equity market risk premium is 6.00%. Atlantic has a beta of 1.83. The company has a 30.00% tax rate.

Part 1. Using an excel spreadsheet, please build a 5 year incremental cash flow projection for the contemplated shower enclosure project. Based on the projections please determine the following.

  1. What is the project’s expected NPV?
  2. What is the project’s expected IRR?
  3. What is the project’s expected payback period?
  4. What is the project’s expected profitability index? (2 decimal places)

Part 2. Assuming the project has no working capital requirements and that the salvage value of assets is zero, what is the annual sales unit quantity required to break-even on a financial/NPV basis?

Solutions

Expert Solution

First we need to calculate weighted average cost of capital
- Cost of Equity
= Risk free rate + Beta(Expected market risk premium)
= 2.40% + 1.83(6.00%)
13.38%
Cost of Term Loan = 4.25%
Cost of Bonds = 6.50%
Capital Structure
Particulars Amount Weight Cost WACC
Equity 414                  0.62 13.38% 8.34%
Term Loan 50                  0.08 4.25% 0.32%
Bonds 200                  0.30 6.50% 1.96%
664 10.62%
So, Cost of capital will be considered at 10.62%
Year Unit Sales Sale price Variable Cost Per Unit Sales VC
A B C D (A*B) E (A*C)
1                   1,500                9,995                                    5,000                                          1,49,92,500                 75,00,000
2                   1,650                9,995                                    5,000                                          1,64,91,750                 82,50,000
3                   1,815                9,995                                    5,000                                          1,81,40,925                 90,75,000
4                   1,997                9,995                                    5,000                                          1,99,55,018                 99,82,500
5                   2,196                9,995                                    5,000                                          2,19,50,519              1,09,80,750
Year Opportunity Cost SG&A Expense Depreciation PBT Tax
F G H ((100-3)/5) I J (I*30%)
1           20,00,000        32,00,000                                          19                                              54,92,481                 16,47,744
2           20,00,000        32,00,000                                          19                                              62,41,731                 18,72,519
3           20,00,000        32,00,000                                          19                                              70,65,906                 21,19,772
4           20,00,000        32,00,000                                          19                                              79,72,498                 23,91,749
5           20,00,000        32,00,000                                          19                                              89,69,750                 26,90,925
Year PAT Operating Capital Requirement Operating Capital Withdrawal Net Cash Flow PV Factor PV of Cash Flow Cumulative
K L M N(K+H-L+M) O P
1           38,44,736          4,49,775                                           -                                                33,94,981                                  1                 30,69,042            30,69,042
2           43,69,211              44,978                                           -                                                43,24,253                                  1                 35,33,802            66,02,844
3           49,46,134              49,475                                           -                                                48,96,678                                  1                 36,17,413         1,02,20,257
4           55,80,749              54,423                                           -                                                55,26,345                                  1                 36,90,626         1,39,10,883
5           62,78,825              59,865                              6,58,516                                              68,77,495                                  1                 41,52,005         1,80,62,888
Total             1,80,62,888
So, Projects NPV is :
Total Net present value of cash flow                        1,80,62,888
Less: Initial Investment                        1,00,00,000
NPV                           80,62,888
IRR:
Year Net Cash Flow PV Cash Flow
0      -1,00,00,000 -1,00,00,000
1           33,94,981        30,69,042
2           43,24,253        35,33,802
3           48,96,678        36,17,413
4           55,26,345        36,90,626
5           68,77,495        41,52,005
IRR 35% 22%
Project expected Pay back as follows:
= 2 years + (3397156.31/10220256.78)
= 2.33 years
Project expeted profitability index is Present value of Cash flow/Initial Investment
i.e. 18062888/10000000 which is 1.81

Related Solutions

Insight Glass Company             Insight Glass makes sliding glass doors for two local construction companies and...
Insight Glass Company             Insight Glass makes sliding glass doors for two local construction companies and wants to prepare a master budget for the next month of operation, June 2014.             The sales department estimates that it can sell 180 doors in June. Each door retails for $1,100. In order to avoid delays in shipping, management wants to maintain ending inventory each month equal to 10% of the estimated unit sales in that month. Beginning inventory of finished doors is...
Suppose we learn that the price elasticity of demand for luxury custom homes is -2.13, but...
Suppose we learn that the price elasticity of demand for luxury custom homes is -2.13, but for ordinary track homes it is -0.67. Interpret these elasticities, providing descriptions that an average person can understand. In addition, explain why a taxing authority might want to understand the elasticity concept when deciding whether or not to place a higher tax on luxury homes than on ordinary homes.
C. Shattered Glass Company makes custom order ornate glass vases. The company uses a job-order cost...
C. Shattered Glass Company makes custom order ornate glass vases. The company uses a job-order cost system and predetermined overhead rates to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Fabrication Department is based on machine hours, and the rate in the Finishing Department is based on direct labor hours. At the beginning of the year, the company’s management made the following estimates for the year: Department Fabrication Finishing Machine hours 79,000 25,000 Direct labor hours...
Willingham Construction is in the business of building high-priced, custom, single-family homes. The company, headquartered in...
Willingham Construction is in the business of building high-priced, custom, single-family homes. The company, headquartered in Anaheim, California, operates throughout the Southern California area. The construction period for the average home built by Willingham is six months, although some homes have taken as long as nine months. You have just been hired by Willingham as the assistant controller and one of your first tasks is to evaluate the company’s revenue recognition policy. The company presently recognizes revenue upon completion for...
Deanna's Draperies makes custom draperies for homes and businesses. The company uses a traditional overhead application...
Deanna's Draperies makes custom draperies for homes and businesses. The company uses a traditional overhead application system basing it on the total yards of fabric used. The company wishes to use an activity-based costing system. Deanna's has provided the following data concerning its annual overhead costs and its activity cost pools. PLEASE HELP ME UNDERSTAND THIS! THANKS Overhead Costs: Indirect Labor and Materials $240,000 Other Indirect Costs 160,000 Total Overhead Costs $400,000 Distribution of Resource Consumption: Activity Cost Pool Production...
Pane of Glass Inc. produces custom glasswork for high-end homes and buildings. The following cost data...
Pane of Glass Inc. produces custom glasswork for high-end homes and buildings. The following cost data relate to the company’s labour costs. Units Produced Labour Cost July 400 $15,000 August 300 13,000 September 320 13,200 October 350 13,800 November 420 16,000 December 410 14,800 Required: Using the high-low method, estimate the cost formula (write it in y=mx+b format). Using your answer from part a.) above, assuming in the following month the company expects to make 250 units, what will be...
Pane of Glass Inc. produces custom glasswork for high-end homes and buildings. The following cost data...
Pane of Glass Inc. produces custom glasswork for high-end homes and buildings. The following cost data relate to the company’s labour costs. Units Produced Labour Cost July 400 $15,000 August 300 13,000 September 320 13,200 October 350 13,800 November 420 16,000 December 410 14,800 Required: Using the scattergraph method, estimate the cost formula. Using the least squares regression method, estimate the cost formula. Are there any factors other than the number of units produced that may contribute to a variation...
SeeClear Windows makes windows for use in homes and commercial buildings. The standards for glass thickness...
SeeClear Windows makes windows for use in homes and commercial buildings. The standards for glass thickness call for the glass to average 0.375 inches with a standard deviation equal to 0.050 inches. 90% of the standard glasses will have a thickness between what two values symmetrically distributed around the mean?(round to 3 decimal digits, e.g. 0.123) 1.The smaller number is ? 2.The Larger number is? 3. Suppose we randomly select 64 pieces of windows, what is the mean thickness of...
All Clear Windows makes windows for use in homes and commercial buildings. The standards for glass...
All Clear Windows makes windows for use in homes and commercial buildings. The standards for glass thickness call for the glass to average 0.375 inches with a standard deviation of 0.050 inches. Let x̄ represent the mean thickness of 50 randomly selected windows. Please answer A-C (a) Can we use a normal distribution to calculate probabilities of x̄? Explain (b) Describe the mean (center) and standard error (spread) of the sampling distribution of x̄. (c) Suppose a random sample of...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $...
Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $ 24,640. Each project will last for 3 years and produce the following net annual cash flows. Year AA BB CC 1 $ 7,840 $ 11,200 $ 14,560 2 10,080 11,200 13,440 3 13,440 11,200 12,320 Total $ 31,360 $ 33,600 $ 40,320 The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT