Question

In: Finance

Pinto Limited has recently been subject to significant competition from overseas manufacturers with much lower costs....

Pinto Limited has recently been subject to significant competition from overseas manufacturers with much lower costs. To combat this, Pinto is considering a project that will see it move into a new product market considered riskier than its current operations. The CEO has asked you to undertake a financial analysis of the proposed project and present your recommendations in a short memo. As part of your financial analysis you will calculate NPV, IRR, payback period, discounted payback period and profitability index. The project requires an upfront investment in plant and equipment of $15 million, which will be depreciated on a straight-line basis over the five-year life of the project. The equipment is not expected to have any significant salvage value at the end of its depreciable life. Pinto paid $25,000 in fees to consultants for a market analysis related to the project. This analysis predicted sales volume of 200,000 units in the first year, which would grow by 50% per year in years two and three, and fall by 50% in each remaining year as demand wanes. Selling price in the first year is expected to be $75 and grow by 3% each year after that. Pinto’s operations manager has estimated cost of goods sold for the project will equal 60% of sales revenues and selling, general and administrative expenses directly related to the project (excluding depreciation) will be $1 million in the first year and increase by 5% per year thereafter. The operations manager has not included in his estimates any cost for a project operations base because the plan is to use a building the company already owns. Currently Pinto rents this building to another company for $250,000 per year. The project will require an upfront investment in net working capital equal to 20% of the year 1 sales revenue forecast. This investment in working capital will be fully recovered at the end year 5. The company has a 10% weighted average cost of capital and is subject to a 30% tax rate.

Solutions

Expert Solution

Let us start with preparing a PnL estimate for the project. This is required to compute the taxes. The PnL would look like the below.

The cash flows will look like

Once we have all the cash flow projects, we can compute the required parameters.

Discounted      (18,025,000)           3,779,545           5,292,562           7,440,838           3,416,978           3,311,427

NPV is the sum of discounted cash flows. NPV = $ 5,216,350

IRR = 20.42% (IRR is the discount rate which makes NPV to be zero)

Payback period lies somewhere b/w 2 and 3 years

Total recovery after 2 years = 10,561,500

Total recovery after 3 years = 20,465,225

so, payback of $ 18,025,000 after 2.75 years

Payback period = 2.75 years

Discounted payback, we will use discounted cashflows to compute the payback period

Discounted payback period = 2.90 years


Related Solutions

Bonalli Shoe Company has been facing increased competition from overseas shoemak- ers. Its total assets and...
Bonalli Shoe Company has been facing increased competition from overseas shoemak- ers. Its total assets and stockholders’ equity at the beginning of 2010 were $690,000 and $590,000, respectively. A summary of the firm’s data for 2010 and 2011 follows.    2011 2010 Current Assets $200,000 $170,000 Total Assets 880,000 710,000 Current Liabilities 90,000 50,000 Long-term liabilities 150,000 50,000 Stockholders’ equity 640,000 610,000 Sales 1,200,000 1,050,000 Net Income 60,000 80,000 Required: Use (1) liquidity analysis and (2) profitability analysis to document...
Alomar Ltd. has been suffering the effects of strong price competition on a particular inventory item from an overseas company that has moved into Alomar’s Canadian...
Alomar Ltd. has been suffering the effects of strong price competition on a particular inventory item from an overseas company that has moved into Alomar’s Canadian market. At the end of 20X4, Alomar management decided that the carrying cost (at historical value) of its year end inventory was not recoverable and that Alomar would have to reduce its prices drastically to meet the competitor’s prices. Management estimated that inventory currently carried at $40,000 (at historical cost) will have a NRV...
The Internet’s effects on (lower) transaction costs and increased competition have been widely recognized. Innovative service...
The Internet’s effects on (lower) transaction costs and increased competition have been widely recognized. Innovative service providers such as amazon, eBay or search engines such as Google and Bing have lowered search costs in many markets. And while Internet services have made entry into many markets easier, concerns have recently emerged about competition in these Internet service markets themselves.(Justus Haucap & Ulrich Heimeshoff,2014) What are the economic characteristics of online markets? What implications if any do these characteristics have for...
3 ID Limited (ID) has recently been incorporated as a private limited company and carries on...
3 ID Limited (ID) has recently been incorporated as a private limited company and carries on fashion business. Donald is very experienced in this field and is employed by ID as an agent to purchase fashion clothes. Recently Donald has signed a contract with E Bop Limited (E Bop) for purchase of jewelry which has not been previously authorized by the company. Advise the legal position of ID, in particular the rights and liabilities it may have under the contract...
The following data has been extracted from the following budgets and standard costs of Storm Limited,...
The following data has been extracted from the following budgets and standard costs of Storm Limited, a company which manufactures and sells two products J & K. Storm cost and revenue                                                                       Per unit Item J K Selling Price        £45         £100 Direct materials costs        £10         £ 18 Direct wages costs (variable)        £ 4         £    6 Variable overhead cost        £ 2.50         £    3 Machine hours       2 hours      3 hours Fixed production...
3      ID Limited (ID) has recently been incorporated as a private limited company and carries on fashion...
3      ID Limited (ID) has recently been incorporated as a private limited company and carries on fashion business.  Donald is very experienced in this field and is employed by ID as an agent to purchase fashion clothes. Recently Donald has signed a contract with E Bop Limited (E Bop) for purchase of jewelry which has not been previously authorized by the company. Advise the legal position of ID, in particular the rights and liabilities it may have under the contract with E...
Operations Strategy at Woodbest Limited Until recently, Woodbest Limited has been the leading producer of wood...
Operations Strategy at Woodbest Limited Until recently, Woodbest Limited has been the leading producer of wood furniture in Malona city. Following the arrival of a major competitor in the city, Woodbest is seeking to explore innovative ways of maintaining its position in the market. In the meantime, it is relying on its competencies in the acquisition of materials, production, transportation of finished products and installations. The perfect coordination of these activities and its five-year maintenance-free policy for customers have so...
The official poverty line has been the subject of much debate over the last few decades....
The official poverty line has been the subject of much debate over the last few decades. On Google or another search engine, look up and read the work of Molly Orshansky. Her work focused on finding a measure of poverty that reflected a bundle of goods that people in different circumstances must be able to purchase. Describe the debate and the resulting system for setting the poverty thresholds. Should they be updated? If so, what would you recommend?
A highly debated subject in policy recently has been how to handle medical pricing (or medical...
A highly debated subject in policy recently has been how to handle medical pricing (or medical insurance coverage). What are various parts of the medical system and how price does discrimination occur? Explain what purpose it serves and what potential harm is done.
Until recently, Woodbest Limited has been the leading producer of wood furniture in Malona city. Following...
Until recently, Woodbest Limited has been the leading producer of wood furniture in Malona city. Following the arrival of a major competitor in the city, Woodbest is seeking to explore innovative ways of maintaining its position in the market. In the meantime, it is relying on its competencies in the acquisition of materials, production, transportation of finished products and installations. The perfect coordination of these activities and its five-year maintenance-free policy for customers have so far kept the company in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT