The Peach Company is thinking of building a new plant to put the peaches it grows...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Peach Company is thinking of building a new plant to put the peaches it grows into cans. The plant is expected to last for 20 years. Its initial cost is $20 million. This cost can be depreciated over the full 20-year life of the plant using straight line depreciation. It will require a major renovation which will cost $8 million in real terms after 10 years. This cost of renovation can be depreciated (again using straight line depreciation) over the remaining 10 years of the plant's life. The land the plant is built on could be rented out for $500,000 a year in nominal terms for twenty years. The salvage value of the plant at the end of the twenty years is $3.5 million in nominal terms. This salvage value is attributed to the original expenditure on the plant for tax purposes. There is no salvage value with regard to the renovation. The plant will be able to produce 50 million cans of peaches a year. The price of a can of peaches is currently $0.50. It is expected to grow at a rate of 3% per year in real terms for 6 years and then at 0% in real terms for the remainder of the plant's life. The firm expects to be able to sell all the cans of peaches it can produce. The peaches the firm puts in the cans are grown in the firm's own orchards. If the peaches were not canned they could be sold to supermarkets. The current price they could obtain per peach is $0.1. This price is expected to grow at a rate of 2% in real terms for 5 years and then at 1% in real terms for the next five years and finally at 0% in real terms for the remainder of the plant's life. Each can requires 2.5 peaches to fill it. The raw materials for the cans currently cost $0.05 per can. These costs are expected to remain constant in real terms. The labor required to operate the plant costs a total of $5 million dollars a year in real terms. Initially, the total working capital requirement is $10 million and this is expected to remain constant in real terms. The rate of inflation is expected to be 4% per year for the next four years and 3% per year for the remainder of the plant's life. The firm's total tax rate including local taxes is 38 per cent. The firm expects to make substantial profits on its other operations so that it can offset any losses on the peach canning plant for tax purposes. Its opportunity cost of capital for projects of this type is 14% in nominal terms. Construct two spreadsheets in EXCEL to find the NPV of the peach canning plant. One spreadsheet should be in nominal terms and the other should be in real terms. The value of the real and nominal NPVs should be the same. Should the firm build the plant? The Peach Company is thinking of building a new plant to put the peaches it grows into cans. The plant is expected to last for 20 years. Its initial cost is $20 million. This cost can be depreciated over the full 20-year life of the plant using straight line depreciation. It will require a major renovation which will cost $8 million in real terms after 10 years. This cost of renovation can be depreciated (again using straight line depreciation) over the remaining 10 years of the plant's life. The land the plant is built on could be rented out for $500,000 a year in nominal terms for twenty years. The salvage value of the plant at the end of the twenty years is $3.5 million in nominal terms. This salvage value is attributed to the original expenditure on the plant for tax purposes. There is no salvage value with regard to the renovation. The plant will be able to produce 50 million cans of peaches a year. The price of a can of peaches is currently $0.50. It is expected to grow at a rate of 3% per year in real terms for 6 years and then at 0% in real terms for the remainder of the plant's life. The firm expects to be able to sell all the cans of peaches it can produce. The peaches the firm puts in the cans are grown in the firm's own orchards. If the peaches were not canned they could be sold to supermarkets. The current price they could obtain per peach is $0.1. This price is expected to grow at a rate of 2% in real terms for 5 years and then at 1% in real terms for the next five years and finally at 0% in real terms for the remainder of the plant's life. Each can requires 2.5 peaches to fill it. The raw materials for the cans currently cost $0.05 per can. These costs are expected to remain constant in real terms. The labor required to operate the plant costs a total of $5 million dollars a year in real terms. Initially, the total working capital requirement is $10 million and this is expected to remain constant in real terms. The rate of inflation is expected to be 4% per year for the next four years and 3% per year for the remainder of the plant's life. The firm's total tax rate including local taxes is 38 per cent. The firm expects to make substantial profits on its other operations so that it can offset any losses on the peach canning plant for tax purposes. Its opportunity cost of capital for projects of this type is 14% in nominal terms. Construct two spreadsheets in EXCEL to find the NPV of the peach canning plant. One spreadsheet should be in nominal terms and the other should be in real terms. The value of the real and nominal NPVs should be the same. Should the firm build the plant?
Expert Answer:
Related Book For
Supply Chain Management Strategy Planning And Operation
ISBN: 9781292257891
7th Global Edition
Authors: Sunil Chopra
Posted Date:
Students also viewed these finance questions
-
Grocery run on the road trip is coming! Suppose the shape of the egg you wish to buy are ellipsoids with the volume formula Volume ryz where x, y, z are the radil of the item. Write a higher-order...
-
An article in the local newspaper stated that the county government had decided to condemn Palo Alto, Inc.'sdistributionwarehouse. Therefore, Palo Alto decided to sale its warehouse to obtain what it...
-
William Lake Forest Products (WLFP) is an integrated paper products firm. Planning for the period's activities begins with the wood lot. The maximum amount of raw wood that can be harvested during...
-
Determine the length of the hydrogen bonds between: TYR41H and GLU37O ALA39H and MET35O GLU38H and ILE34O THR36H and ARG32O ARG32H and TYR28O by using PyMOL And identify the residues located at...
-
In an ideal Brayton refrigeration cycle air enters the compressor at 18 lbf/in2 and 400oR. The compression ratio is 5, and air enters the turbine inlet at 600oR. The mass flow rate of air is 2...
-
MS Inc is preparing the feasibility of a new line of product to diversify its existing portfolio. The initial survey was conducted to examine the potential demand for the product. The survey required...
-
Lease payments, like depreciation, are deductible for tax purposes. If a 20 -year asset were depreciated over a 20 -year life, depreciation charges would be \(1 / 20\) per year (more if MACRS were...
-
Relevant and sunk costs Don Baxter's 6-year-old Impala requires repairs estimated at $5,400 to make it roadworthy again. His friend Aaron Bloom suggested that he buy a 6-year-old Ford Escort instead...
-
Find the volume of a frustum of a right circular cone with height 10, lower base radius 33 and top radius 19. Volume = D
-
Problem 1-42 (LO 1-3, LO 1-4) (Algo) Melinda invests $260,000 in a City of Heflin bond that pays 6.5 percent interest. Alternatively, Melinda could have invested the $260,000 in a bond recently...
-
Enterprise Resource Planning software (ERP) Question 11 options: integrates data and provide managers with reports that highlight the interdependence of different business activities. is used only by...
-
There is an ideal dipole located at the origin and aligned along the positive y direction. By "ideal," we mean that it is described exactly by the electric potential V = p cos 2 Note that, in this...
-
Required Information [The following information applies to the questions displayed below.] Victory Company uses weighted average process costing. The company has two production processes. Conversion...
-
What does a SWOT analysis of Panera Bread reveal about the overall attractiveness of its situation? Does the company have any core competencies or distinctive competencies? Select one of the...
-
A fundamental difference between healthcare business models and other sectors of the US economy is that a. Health care is a heavily regulated industry b. Healthcare costs are soaring but so are...
-
Forecast Sales Volume and Sales Budget For 2018, Raphael Frame Company prepared the sales budget that follows. At the end of December 20YS, the following unit sales data were reported for the year:...
-
Explain the circumstances that could result in a long-term bank loan being shown in a statement of financial position as a current liability.
-
On September 1, 20x6, A Company purchased 100 percent of the voting stock of B Company for $480,000 in cash. The separate condensed balance sheets immediately after the purchase were as follows:...
-
Dale Company experiences heavy sales in the summer and early fall, after which time it has excess cash to invest until the next spring. On November 1, 20x6, the company invested $194,000 in U.S....
-
Scattergraph method Using the data in E4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2....
Study smarter with the SolutionInn App