Question

In: Finance

Michelle O’Sullivan is a financial analyst at the Drill Corporation, a company who manufacture drilling equipment...

Michelle O’Sullivan is a financial analyst at the Drill Corporation, a company who manufacture drilling equipment used across the construction industry.

Drill Corporation are doing some analysis around potentially tendering for a contract to supply the government with pneumatic drills used in road construction. The tender call requires the supply of 10,000 drills per year over a 10-year period.

In the first round of analysis, Michelle assumes that each drill will be sold at a fixed price of $1,700 (which would remain static for the duration of the project). In order to meet the production targets in the tender, an initial capital investment of $15m would be required. This $15m would consist of the purchase of specialist production machinery, which would subsequently be depreciated on a straight-line basis over the 10 years of the project. Subsequent to completion of the project it is estimated that the (gross) salvage value of the machinery would be $500k.

Ongoing project expenses are assumed to be $12m per year in year 1 and are forecast to increase at the rate of inflation, currently 2% per annum. It is assumed that Drill Corporation invests 20% of subsequent year expenses (production expenses i.e. not relating to depreciation) in raw materials and inventories combined. It is also assumed that the government pays in arrears for the drills such that in any year receivables are around 1/12 of yearly revenue.

Drill Corporation pays tax at 35%. The discount rate for the project is 10%.

Should Drill Corp tender for the contract at the fixed price of $1,700 per drill? How might changes in the input parameters to the valuation model change that decision?

Expert Solution

The cash flows and NPV of the project are calculated as below :

Cash outflow in year 0 = capital investment + change in working capital

Cash inflows in years 1 to 9 = OCF - change in working capital (where OCF = income after tax + depreciation)

Cash inflow in year 10 = OCF - change in working capital + after-tax salvage value

Cash inflow in year 11 = change in working capital (recovery of final year revenue arrears)

NPV is calculated using NPV function in Excel :

NPV of the project is $7,287,365

Drill Corp should tender because the NPV is positive

If the sales price is reduced to $9,000, NPV is -$2,765,892. Drill Corp should not tender

If the discount rate is increased to 20%, NPV is -$666,157. Drill Corp should not tender

jeff jeffy answered 2 years ago

You are financial analyst for a company that is considering supplementing their business of workout equipment...

You are financial analyst for a company that is considering supplementing their business of workout equipment production and sales with a new product line of supplements. This is a brand new type of venture that comes with considerable risk. You have been given the following details: • The project timeline is infinite (meaning the plan is to have the product line forever), but you are going to model the first 5 years specifically. Following that, you may assume NCFs will...

Sheridan Company and Concord Company both manufacture school science equipment. The following financial information is for...

Sheridan Company and Concord Company both manufacture school science equipment. The following financial information is for three years ended December 31 (in thousands): Sheridan Company 2021 2020 2019 Net sales $557.0 $524.6 $472.0 Profit 21.7 20.7 19.2 Total assets 698.7 670.7 600.7 Concord Company 2021 2020 2019 Net sales $1,750.7 $1,586.7 $1,472.8 Profit 96.7 85.7 78.7 Total assets 1,528.7 1,418.7 1,323.7 (a) Calculate the asset turnover and return on assets ratios for both companies for 2020 and 2021. (Round answers...

1. The financial statements of Michelle Company included these items. &nbs

1. The financial statements of Michelle Company included these items. Marketing costs P128, 000 Direct labor costs P320, 000 Administrative costs P94, 000 Direct materials used P385, 000 Fixed factory overhead costs P285, 000 Variable factory overhead costs P175, 000 Prime cost Conversion cost Total product cost Total period cost 2. The following data are available for Smith Corporation for the year ending December 31, 2009 January 1 December 31 Inventories Materials ...

Wilma Brinton is a new financial analyst at Dorrington Corporation, a company that had grown steadily...

Wilma Brinton is a new financial analyst at Dorrington Corporation, a company that had grown steadily over the past 30 years and has now matured, being well known and highly respected. Brinton’s first task is to explain the concept of weighted average cost of capital to new members of the Board of Directors. Dorrington’s balance sheet is summarized below. Assets Liabilities and net worth Working capital $200 Bank loan $120 Plant and equipment 360 Long-term debt 80 Other assets 40...

BBK Company bought an equipment to manufacture machine parts for Rs 5,600,000. The equipment was expected...

BBK Company bought an equipment to manufacture machine parts for Rs 5,600,000. The equipment was expected to be useful for 5 years and an estimated residual value of Rs 280,000. The equipment is expected to manufacture 350,000 parts. It manufactured 105,000 parts in year 1; 84,000 in year 2; 21,000 in year 3; 112,000 in year 4 and 28,000 parts in year 5. Required: Compute the depreciation expense for each year under the following methods: (a) Straight-line;(b)Written-down-value;(c)Productionunits

Bernardo Bellotto is a financial analyst with Canal Financial Planning Inc who specializes in designing retirement...

Bernardo Bellotto is a financial analyst with Canal Financial Planning Inc who specializes in designing retirement income portfolios for retirees using corporate bonds. He has just completed a consultation with a client who expects to have $750,000 in liquid assets to invest when she retires next month. Bernardo and his client agreed to consider upcoming bond issues from the following six companies: Company Return (%) Years to Maturity Rating Acme Chemical 8.25 11 1-Excellent Bravo Films 9.00 10 3-Good Canada...

Rainbow Company, a medium-sized company specialized in the manufacture and distribution of equipment for babies and...

Rainbow Company, a medium-sized company specialized in the manufacture and distribution of equipment for babies and small children, is evaluating a new capital expenditure project. In a joint venture with another separate company it has invented a remote controlled pushchair, one of the first of its kind on the market. It has been unable to obtain a patent for the invention, but is sure that it will monopolize the market for the first three years. After this, it expects to...

As a financial analyst, you must evaluate a proposed project to produce printer cartridges. The equipment...

As a financial analyst, you must evaluate a proposed project to produce printer cartridges. The equipment would cost $55,000, plus $10,000 for installation. Annual sales would be 4,000 units at a price of $50 per cartridge, and the project's life would be 3 years. Current assets would increase by $5,000 and payables by $3,000. At the end of 3 years, the equipment could be sold for $10,000. Depreciation would be based on the MACRS 3-year class; so the applicable rates...

You work as a financial analyst in Rio Co. Mr Jackson is a new client who...

You work as a financial analyst in Rio Co. Mr Jackson is a new client who is interested to invest for his future. He wants some help in terms of personal financing. He is risk-taker, 35 year old, and has 25 years to retirement. Explain to him what are the main processes of personal finance planning? Considering the characteristics of Mr Jackson, what are your suggestion as investments options for investment in money market and capital market?

You are called in as a financial analyst to appraise the bonds of Merck & Company,...

You are called in as a financial analyst to appraise the bonds of Merck & Company, Inc. The $1,000 par value bonds have a quoted annual interest rate of 5.4%, which is paid semiannually. The yield to maturity on the bonds is 6.4% annual interest. There are 25 years to maturity Compute the price of the bonds based on semiannual analysis.