Question

In: Finance

Unilate Textiles is evaluating a new product, a silk/wool blended fabric. Assume that you were recently...

Unilate Textiles is evaluating a new product, a silk/wool blended fabric. Assume that you were recently hired as assistant to the director of capital budgeting, and you must evaluate the new project.

The fabric would be produced in an unused building adjacent to Unilate’s Southern Pines, North Carolina plant. Unilate owns the building, which is fully depreciated. The required equipment would cost $200,000, plus an additional $40,000 for shipping and installation. In addition, inventories would rise by $25,000, while accounts payable would go up by $5,000. All of these costs would be incurred at Year 0. By a special ruling, the machinery could be depreciated under the MACRS system as 3-year property. (See Table 10A.2 at the end of Chapter 10 for MACRS recovery allowance percentages.)

The project is expected to operate for four years, at which time it will be terminated. The cash inflows are assumed to begin one year after the project is undertaken, or at t = 1, and to continue out to t = 4. At the end of the project’s life (Year 4), the equipment is expected to have a salvage value of $25,000.

Unit sales are expected to total 100,000 five-yard textile rolls per year, and the expected sales price is $2 per roll. Cash operating costs for the project (total operating costs less depreciation) are expected to total 60% of dollar sales. Unilate’s marginal tax rate is 40%, and its required rate of return is 10%. Tentatively, the silk/wool blend fabric project is assumed to be of equal risk to Unilate’s other assets.

You have been asked to evaluate the project and to make a recommendation as to whether it should be accepted or rejected. To guide you in your analysis, your boss gave you the following set of tasks to complete:

Unilate’s Silk/Wool Fabric Project ($ Thousands)

      End of Year:                                         0                1                    2                3             4      

      Unit sales (Thousands)                                                                    100                                   

      Price/unit                                                              $ 2.00          $ 2.00                                      

      Total revenues                                                                                                $200.0                

      Costs excluding depreciation                                                   ($120.0)                                  

      Depreciation                                                                                                   ( 36.0)     ( 16.8)

        Total operating costs                                        ($199.2)        ($228.0)                                  

        Earnings before taxes (EBT)                                                                       $44.0

        Taxes                                                                 (     0.3)                                               25.3

        Net income                                                                                                  $26.4

      Depreciation                                                              79.2                                  36.0                

        Supplemental operating CF                                  $ 79.7                                             $ 54.7

      Equipment cost

      Installation

      Increase in inventory

      Increase in accounts payable

      Salvage value

      Tax on salvage value

      Return of net working capital                                                                                                     

      Cash flow timeline (net CF):             ($260.0)                                                               $ 89.7

      Cumulative CF for payback:               ( 260.0)       ( 180.3)                                               63.0

                            NPV =

                             IRR =

                    Payback =

Complete the table in the following order:

(1) Complete the unit sales, sales price, total revenues, and operating costs excluding depreciation lines.

(2) Complete the depreciation line.

(3) Now complete the table down to net income and then down to net operating cash flows.

(4) Now fill in the blanks under Year 0 and Year 4 for the initial investment outlay and the terminal cash flows and complete the cash flow time line (net CF). Discuss working capital. What would have happened if the machinery were sold for less than its book value?

Solutions

Expert Solution

Working Capital = 25000-5000 = 20000

If machinery was sold for less than its book value, then they would have got higher depreciation benefit in the last year, thereby reducing tax but salvage cashflows as well. At last overall NPV and IRR must had gone down


Related Solutions

   Unilate Textiles is evaluating a new product, a silk/wool blended fabric. Assume that you were...
   Unilate Textiles is evaluating a new product, a silk/wool blended fabric. Assume that you were recently hired as assistant to the director of capital budgeting, and you must evaluate the new project.    The fabric would be produced in an unused building adjacent to Unilate’s Southern Pines, North Carolina plant. Unilate owns the building, which is fully depreciated. The required equipment would cost $200,000, plus an additional $40,000 for shipping and installation. In addition, inventories would rise by $25,000,...
New Product Development Think of a new product you recently purchased or used, or an ad...
New Product Development Think of a new product you recently purchased or used, or an ad for a new product. Share with the class this new product idea; in addition to describing this new item indicate whether this new product is either additions to existing product lines or improvements or revisions of existing products. Do you believe your new product will be among the few new product ideas that are truly successful? Why or why not?
Assume that you were recently hired at Lilo Plc as a junior accountant and were asked...
Assume that you were recently hired at Lilo Plc as a junior accountant and were asked to help prepare the financial reports for the year ended 31 December 2019. In addition, the head of the accounting department wanted to assess your knowledge about the financial statements, hence, requested you to prepare a report. The company’s trial balance is shown below, together with the guide on the format and content of the report: Debit (£) Credit (£) Sales 72,813 Purchases 35,108...
You are evaluating a new product. In year 3 of your analysis, you are projecting pro...
You are evaluating a new product. In year 3 of your analysis, you are projecting pro forma sales of $5.8 million and cost of goods sold of $3.48. You will be depreciating a $1 million machine for 5 years using straight-line depreciation. Your tax rate is 38%. Finally, you expect working capital to increase from $190,000 in year 2 to $300,000 in year 3. What are your pro forma earnings for year 3? What are your pro forma free cash...
This chapter covers closing the books and the accounting cycle. Assume you were recently hired to...
This chapter covers closing the books and the accounting cycle. Assume you were recently hired to be a bookkeeper of a small business. You find that the company had never completed an accounting cycle or closed the books and there were no records of any procedures about month end processes. How would go about your first month end to ensure accurate financial statements? Be specific in the steps you would take using QBO and any other factors. Use complete sentences,...
Assume you are starting a new business involving the manufacture and sale of a new product....
Assume you are starting a new business involving the manufacture and sale of a new product. Raw materials costs are $45 per product. Direct labor costs are expected to be $26 per product, Manufacturing Overhead is expected to cost $16 per product. You expect to sell each product for $176. You plan to produce 110 products next month and expect to sell 85 products. During the second month, you plan to produce 130 products but expect sales in the month...
Assume you are starting a new business involving the manufacture and sale of a new product....
Assume you are starting a new business involving the manufacture and sale of a new product. Raw materials costs are $45 per product. Direct labor costs are expected to be $25 per product, Manufacturing Overhead is expected to cost $18 per product. You expect to sell each product for $172. You plan to produce 120 products next month and expect to sell 85 products. During the second month, you plan to produce 120 products but expect sales in the month...
Examine a product that has recently changed prices when you were at the grocery store in...
Examine a product that has recently changed prices when you were at the grocery store in the past week. Analyze one determinant of supply and demand that has created the price to increase or decrease in your example. How did the change in demand or supply affect the market price in your example? This assignment will require you to write an analysis with a minimum of 3-5 paragraphs in APA format. You will need to focus on your analysis and...
Assume of new product you will market. You should think of planning your own product make...
Assume of new product you will market. You should think of planning your own product make its design , packaging, write its brand name mark or logo, write its price and how did you price it, Write how you will promote it. Write how you will distribute it (through whom and which channel members will you select) And also how you select target audience or segments for which the product is designed.
New Product Analysis You have recently graduated with a BBA degree, and you have taken a...
New Product Analysis You have recently graduated with a BBA degree, and you have taken a job with a local manufacturing company. Your boss has asked you to analyze a potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the product's net present value and internal rate of return are and what...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT