Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

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.

problems:

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)

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927527

Have any Question? 


Related Questions in Basic Finance

1 what does it mean to say that a currency trades at a

1. What does it mean to say that a currency trades at a forward premium? 2. Explain how the law of one price establishes a relationship between changes in currency values and inflation rates. 3. Why does purchasing power ...

Suppose your firm is seeking a four year amortizing 290000

Suppose your firm is seeking a four year, amortizing $290,000 loan with annual payments and your bank is offering you the choice between a $299,500 loan with a $9,500 compensating balance and a $290,000 loan without a co ...

1 what is the general policy of life insurance companies

1. What is the general policy of life insurance companies toward mortgage lending? 2. Identify the basic responsibility of each of the following four banking regulators: the Federal Reserve Bank Board, the Office of Thri ...

Go to the library and find a research article in a

Go to the library and find a research article in a psychology journal that used analysis of variance. (This should not be difficult; ANOVA is perhaps the most commonly used analysis. If you have problems, try the journal ...

Explain the differences among the three means of

Explain the differences among the three means of terminating a futures contract: an offsetting trade, cash settlement, and delivery. How is a forward contract terminated? Explain the difference between hedge funds and fu ...

Suppose one year ago a swiss investor bought one year us

Suppose one year ago a Swiss investor bought one year U.S. Treasury bills at a price of $9,500 with a maturity value of $10,000. The exchange rate at that time was 1.420 Swiss francs per dollar. Today, at maturity, the i ...

1 what is meant by an agency cost or agency problem do

1. What is meant by an "agency cost" or "agency problem"? Do these interfere with shareholder wealth maximization? Why? What mechanisms minimize these costs/problems? 2. Are ethics critical to the financial manager's goa ...

1 suppose that after reading about a recent murder in your

1. Suppose that, after reading about a recent murder in your town, you want to learn more about what causes people to kill. You go to the library and check out a book written by an expert in the field. Explain which meth ...

1 when a doublet is added to a uniform stream so that the

1. When a doublet is added to a uniform stream so that the source part of the doublet faces the stream, a cylinder flow results. Plot the streamlines when the doublet is reversed so that the sink faces the stream. 2. A 2 ...

1 how do the various labor standards promulgated by

1. How do the various labor standards promulgated by international organizations affect the MNE? 2. How do EU directives (such as those developed in the area of HR) impact member states and MNEs? 3. How do US extraterrit ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen