/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 32 Calculating a Bid Price Your com... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Calculating a Bid Price Your company has been approached to bid on a contract to sell 9,000 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost \(\$ 3.2\) million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of \(\mathbf{\$ 7 5 , 0 0 0}\) to be returned at the end of the project, and the equipment can be sold for \(\$ 200,000\) at the end of production. Fixed costs are \(\$ 600,000\) per year, and variable costs are \(\$ 165\) per unit. In addition to the contract, you feel your company can sell \(4,000,12,000,14,000\), and 7,000 additional units to companies in other countries over the next four years, respectively, at a price of \(\$ 275\). This price is fixed. The tax rate is 40 percent, and the required return is 13 percent. Additionally, the president of the company will undertake the project only if it has an NPV of \(\$ 100,000\). What bid price should you set for the contract?

Short Answer

Expert verified
To calculate the bid price for the contract, we first calculated the initial investment cost, annual costs, depreciation, and after-tax cash flows. We then derived expressions for cash flows as a function of the bid price and used the desired NPV of \(100,000\) to create an NPV expression in terms of the bid price. Solving this equation for 'P' gave us the bid price that should be set for the contract.

Step by step solution

01

Determine the initial investment cost

The initial investment cost includes the cost of equipment and the net working capital. The cost of the equipment is \(\$3.2\) million, and the net working capital required is \(\$75,000\). Therefore, the initial investment cost is: Initial investment = Equipment cost + Net working capital Initial investment = \(3,200,000 + 75,000 = \)3,275,000
02

Calculate the annual fixed and variable costs

The fixed costs are given as \(\$600,000\) per year. The variable cost per unit is \(\$165\). To find the total variable cost per year, we need to multiply the variable cost per unit by the total number of units sold, including the additional units sold to other countries: Year 1: Total units = 9,000 (contract) + 4,000 (additional) Year 2: Total units = 9,000 + 12,000 Year 3: Total units = 9,000 + 14,000 Year 4: Total units = 9,000 + 7,000 Total variable costs for each year are: Year 1: \(\$165 * 13,000\) Year 2: \(\$165 * 21,000\) Year 3: \(\$165 * 23,000\) Year 4: \(\$165 * 16,000\)
03

Calculate annual depreciation

Depreciation is calculated on a straight-line basis to a zero salvage value over four years. Annual depreciation = (Equipment cost - 0) ÷ 4 Annual depreciation = \(3,200,000 ÷ 4 = \$800,000\)
04

Calculate the after-tax cash flows

For each year, we need to find the after-tax cash flow as follows: 1. Calculate Earnings Before Interest and Taxes (EBIT) = (Revenues - Costs - Depreciation) 2. Calculate Taxes = EBIT * Tax rate 3. After-tax cash flow = EBIT - Taxes + Depreciation The bid price will be used to calculate the revenues from the contract. We will calculate the cash flow expression in terms of the bid price later.
05

Calculate the salvage value

At the end of four years, the equipment can be sold for \(\$200,000\). The salvage value is given as: Salvage value = \(\$200,000 * (1 - 0.4)\) (Since 40% tax on the gain due to salvage value) Salvage value = \(\$120,000\)
06

Calculate cash flow expression in terms of bid price

Let the bid price be denoted as 'P'. The revenue from the contract for each year would be 9,000 * P. Adding the sales from additional units, we get the total revenue per year: Year 1: 9,000P + 4,000 * 275 Year 2: 9,000P + 12,000 * 275 Year 3: 9,000P + 14,000 * 275 Year 4: 9,000P + 7,000 * 275 Now, we can calculate the cash flow expression for each year in terms of bid price 'P'.
07

Calculate the net present value expression in terms of bid price

To find the net present value (NPV) expression as a function of bid price 'P', we need to discount the cash flows of each year using the required rate of return (13%). The desired NPV of the project is given as \(\$100,000\). Let CF1, CF2, CF3, and CF4 be the after-tax cash flows in year 1, 2, 3, and 4. The NPV can be computed as follows: \(NPV(P) = -3,275,000 + \frac{CF1}{(1+0.13)^1} + \frac{CF2}{(1+0.13)^2} + \frac{CF3}{(1+0.13)^3} + \frac{CF4}{(1+0.13)^4})
08

Solve for the bid price 'P'

Equating the desired NPV of \(100,000\) to the NPV expression in terms of 'P' calculated in Step 6, we can solve for the bid price 'P'. Solve the following equation for 'P': $100,000 = -3,275,000 + \frac{CF1}{(1+0.13)^1} + \frac{CF2}{(1+0.13)^2} + \frac{CF3}{(1+0.13)^3} + \frac{CF4}{(1+0.13)^4} Once you find the value of 'P', you have the bid price that should be set for the contract.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Net Present Value (NPV)
Net Present Value (NPV) is a fundamental concept in finance that helps in determining the value of money over time. It allows businesses to assess the profitability of an investment by considering the time value of money, which acknowledges that a dollar today is worth more than a dollar in the future. NPV is calculated by subtracting the initial investment from the sum of all future cash flows, discounted to their present value. This involves using a discount rate, which is usually the company's required rate of return or cost of capital. An NPV greater than zero suggests that the investment should yield a return above the required rate, making it a worthwhile venture. Conversely, an NPV less than zero implies that the investment would not meet the desired return threshold.
Depreciation
Depreciation accounts for the gradual wear and tear or obsolescence of tangible assets over their useful lives. It represents a non-cash expense, reducing the reported earnings while understanding that assets lose value over time. A popular method of calculating depreciation is the straight-line method, which spreads the cost of the asset evenly over its useful life. Depreciation is essential in cash flow analysis because it impacts tax obligations - reducing taxable income - and subsequently, the after-tax cash flow, even though it does not involve actual cash outflow.
Cash Flow Analysis
Cash flow analysis examines the inflows and outflows of cash over a specific period. It's essential for assessing the liquidity and long-term solvency of a project or a company. The analysis helps to determine whether a company can maintain and grow its operations or whether it might struggle to cover its expenses. In capital budgeting, forecasting future cash flows and considering the timing of these flows is crucial, as it affects the project's NPV and overall financial health. Components such as revenue from sales, operating costs, taxes, changes in working capital, and capital expenditures all play critical roles in this analysis.
Capital Budgeting
Capital budgeting involves evaluating and selecting long-term investments that align with a company's strategic objectives, such as purchasing new equipment, entering new markets, or launching new products. It requires managers to determine the best projects to invest in, considering the potential risks and returns. Techniques like NPV, Internal Rate of Return (IRR), and Payback Period are commonly used in capital budgeting to ensure that a project promises adequate returns compared to its cost. Proper capital budgeting ensures that the company's funds are allocated efficiently, contributing to its growth and success.
Investment Appraisal
Investment appraisal is synonymous with capital budgeting and involves assessing the merits of investment opportunities. The goal is to weigh the expected benefits against the costs of investments, looking to maximize profitability. Appraisal methods include qualitative assessments—like strategic fit and risk analysis—and quantitative analyses, such as NPV, IRR, and Return on Investment (ROI). For a company considering an investment, such as bidding on a contract for producing goods, careful investment appraisal ensures that the project chosen is not only viable but also contributes positively to the company's value.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Calculating NPV and IRR for a Replacement A firm is considering an investment in a new machine with a price of \(\$ 12\) million to replace its existing machine. The current machine has a book value of \(\$ 4\) million and a market value of \(\$ 3\) million. The new machine is expected to have a fouryear life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save \(\$ 4.5\) million in operating costs each year over the next four years. Both machines will have no salvage value in four years. If the firm purchases the new machine, it will also need an investment of \(\$ 250,000\) in net working capital. The required return on the investment is 10 percent, and the tax rate is 39 percent. What are the NPV and IRR of the decision to replace the old machine?

Replacement Decisions Suppose we are thinking about replacing an old computer with a new one. The old one cost us \(\$ 650,000\); the new one will cost \(\$ 780,000\). The new machine will be depreciated straight-line to zero over its five-year life. It will probably be worth about \(\$ 140,000\) after five years. The old computer is being depreciated at a rate of \(\$ 130,000\) per year. It will be completely written off in three years. If we don't replace it now, we will have to replace it in two years. We can sell it now for \(\$ 230,000\); in two years it will probably be worth \(\$ 90,000\). The new machine will save us \(\$ 125,000\) per year in operating costs. The tax rate is 38 percent, and the discount rate is 14 percent. 1\. Suppose we recognize that if we don't replace the computer now, we will be replacing it in two years. Should we replace now or should we wait? (Hint: What we effectively have here is a decision either to "invest" in the old computer-by not selling it-or to invest in the new one. Notice that the two investments have unequal lives.) 2\. Suppose we consider only whether we should replace the old computer now without worrying about what's going to happen in two years. What are the relevant cash flows? Should we replace it or not? (Hint: Consider the net change in the firm's aftertax cash flows if we do the replacement.)

Project Analysis Benson Enterprises is evaluating alternative uses for a three-story manufacturing and warehousing building that it has purchased for \(\$ 850,000\). The company can continue to rent the building to the present occupants for \(\$ 36,000\) per year. The present occupants have indicated an interest in staying in the building for at least another 15 years. Alternatively, the company could modify the existing structure to use for its own manufacturing and warehousing needs. Benson's production engineer feels the building could be adapted to handle one of two new product lines. The cost and revenue data for the two product alternatives are as follows: The building will be used for only 15 years for either product \(A\) or product \(B\). After 15 years the building will be too small for efficient production of either product line. At that time, Benson plans to rent the building to firms similar to the current occupants. To rent the building again, Benson will need to restore the building to its present layout. The estimated cash cost of restoring the building if product \(A\) has been undertaken is \(\$ \mathbf{2 9}, 000\). If product \(B\) has been manufactured, the cash cost will be \(\$ 35,000\). These cash costs can be deducted for tax purposes in the year the expenditures occur. Benson will depreciate the original building shell (purchased for \(\$ \mathbf{8 5 0 , 0 0 0}\) ) over a 30 -year life to zero, regardless of which alternative it chooses. The building modifications and equipment purchases for either product are estimated to have a 15-year life. They will be depreciated by the straight-line method. The firm's tax rate is 34 percent, and its required rate of return on such investments is 12 percent. For simplicity, assume all cash flows occur at the end of the year. The initial outlays for modifications and equipment will occur today (year 0 ), and the restoration outlays will occur at the end of year 15. Benson has other profitable ongoing operations that are sufficient to cover any losses. Which use of the building would you recommend to management?

Project Evaluation Dog Up! Franks is looking at a new sausage system with an installed cost of \(\$ 420,000\). This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for \(\$ 60,000\). The sausage system will save the firm \(\$ 135,000\) per year in pretax operating costs, and the system requires an initial investment in net working capital of \(\$ 28,000\). If the tax rate is 34 percent and the discount rate is 10 percent, what is the NPV of this project?

Calculating NPV Howell Petroleum is considering a new project that complements its existing business. The machine required for the project costs \(\$ 1.8\) million. The marketing department predicts that sales related to the project will be \(\$ 1.1\) million per year for the next four years, after which the market will cease to exist. The machine will be depreciated down to zero over its fouryear economic life using the straight-line method. Cost of goods sold and operating expenses related to the project are predicted to be 25 percent of sales. Howell also needs to add net working capital of \(\$ 150,000\) immediately. The additional net working capital will be recovered in full at the end of the project's life. The corporate tax rate is 35 percent. The required rate of return for Howell is 16 percent. Should Howell proceed with the project?

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.