Reference no: EM1346748
Pistachio, Inc. is thinking of building a bakery to introduce French cookies, so-called macarons, to the Newark market. A preliminary marketing study, which cost $75,000 and which was completed last year, showed a significant demand for macarons in the Newark area. The bakery is expected to last for 25 years. Its initial cost is $175,000. This cost can be depreciated over 15 years using straight line depreciation. The salvage value of the equipment in the bakery after 15 years is $20,000 in real terms. After 15 years the bakery can be renovated. The cost of renovation will be $50,000 in real terms and can be depreciated (again using straight line depreciation) over the remaining 10 years of the bakery's life. The salvage value of the equipment after the remaining 10 years will be $10,000 in real terms. The land the bakery is built on could be rented out for $12,500 a year in real terms for 25 years.
The bakery will be able to produce 75,000 macarons a year. The price of a macaron is currently $1.55. It is expected to grow at a rate of 5% per year in real terms for the first 2 years, then at 2% per year in real terms for 4 years and finally stays the same in real terms thereafter for the remainder of the bakery's life. Pistachio, Inc. expects to be able to sell all the macarons that it can produce. The basic ingredients for a macaron currently (t = 0) cost $0.25. These costs are expected to grow by 1% in real terms through the lifetime of the project. The labor required to operate the bakery is expected to cost a total of $45,000 dollars in nominal terms in t = 1 and this is expected to increase at 4% in real terms thereafter. There is no working capital requirement. The rate of inflation is expected to be 3% per year for the remainder of the bakery's life. The firm's total tax rate including local taxes is 36 percent. Pistachio, Inc. expects to make substantial profits on its other products so that it can offset any losses on the bakery for tax purposes. Its opportunity cost of capital for projects of this type is 11% in nominal terms.
Questions:
1. Construct two spreadsheets in EXCEL to find the NPV of the macarons project. One spreadsheet should be in nominal terms and one spreadsheet should be in real terms. The two spreadsheets should give the same value for the NPV. Should the firm build the bakery or not?
2. Do a sensitivity analysis by varying by plus and minus 10% the
a) initial labor cost (holding everything else constant)
b) initial cost per macaron (holding everything else constant)
c) quantity sold (holding everything else constant)
d) price per macaron (holding everything else constant)
|
Analyze case study and answer
: assignment on operations management subject need to be solved. the assignment is to analyze case study and answer some question about it. both case study and the questions, the report is 5-7 pages (double space).
|
|
Determine the firm''s free cash flow and calculate the liquid
: determine the firm's free cash flow and calculate the liquidity, activity, debt, profitability, and market ratios for Jaedan industries. Perform a DuPont analysis and compare the firm to the industry ratios (see last table in this sequence). Highligh..
|
|
Explaining bgpv4 router receives update
: Suppose a BGPv4 router receives update for prefix P which indicates AS1 is next hop.
|
|
Probable held that the statute of frauds
: The memo limited the terms of the agreement however was not signed by either party. Drury directed Young a copy for his records. Later Drury inscribed Young a letter stating he would not sell the tomatoes as agreed.
|
|
Find the npv of the project
: Pistachio, Corporation is planning of building a bakery to introduce French cookies, to the Newark area. A beginning marketing study, which cost dollar 75,000 & which was finished last year,
|
|
What control unit would you indorse in establishing
: What control unit would you indorse in establishing sales territories for each of the subsequent companies? Describe why you pick the control unit for each.
|
|
Compare as well as contrast the structured interview
: Compare as well as contrast the structured interview, situational interview and behavioural interview. Determine which kind of interview would be more beneficial when interviewing applicants. Support your selection.
|
|
Swap driven financing the defining features of interest
: Describe why corporations engage in swap-driven financing, and describe the defining features of an interest rate and currency swap. Why may a corporation prefer one kind of swap contract over another?
|
|
Determination of projects net present value
: If a project's expenditure is 15 million dollar, can you determine the projects net present value if capital is 5 percent, 10%, 15 percent at 1year $5,000,000, 2year $10,000,000.
|