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

Why do we often want to create the correct preload in the

Why do we often want to create the correct preload in the bolts when we assemble a joint? Under what conditions is correct preload relatively unimportant? Name at least three factors that can increase the stress in previ ...

1 what is liquidity risk how do banks manage liquidity

1. What is liquidity risk? How do banks manage liquidity risk? 2. What is credit risk? How do banks manage credit risk? 3. What is interest-rate risk? How do banks manage interest-rate risk? 4. What is the difference bet ...

1 how is the national guard deployed to assist in response

1. How is the National Guard deployed to assist in response to a disaster? 2. What is the role of first responders when a routine " minor disaster " occurs in a local community? 3. What drives the actions of local first ...

Starz inc pays a constant dividend of 16 for next 18 years

STARZ INC pays a constant dividend of $16 for next 18 years then will stop paying dividends forever. If investors require a return of 8.3% on this stock, what is the value of the STARZ stock? Write in the value with two ...

1 how is hr at pliva aligned with the corporate strategy2

1. How is HR at Pliva aligned with the corporate strategy? 2. How does the bonus formula at Pliva support the balanced scorecard efforts? 3. What is the impact of the Barr acquisition of Pliva on the strategic planning a ...

A firm has a debt-to-equity ratio of 062 its cost of equity

A firm has a debt-to-equity ratio of 0.62. It's cost of equity is 20%, and it's cost of debt is 15%. If the corporate tax rate is 34%, what would it's cost of equity be if the firm was all equity financed? (Answer in dec ...

Explain why option traders often use spreads instead of

Explain why option traders often use spreads instead of simple long or short options and combined positions of options and stock ? Suppose that an option trader has a call bull spread. The stock price has risen substanti ...

1 describe and contrast the role of rfdc and rfid for

1. Describe and contrast the role of RFDC and RFID for logistics and supply chain applications. 2. Discuss the relative benefits of software purchase, use of third-party providers, and use of application service provider ...

1 why is variance reduction important to logistical

1. Why is variance reduction important to logistical integration? Illustrate in terms of logistical operations. 2. What is the meaning of the phrase cradle-to-cradle logistics? Discuss the operational differences of orig ...

The yield to maturity on 1-year zero-coupon bonds is

The yield to maturity on 1-year zero-coupon bonds is currently 6%; the YTM on 2-year zeros is 7%. The Treasury plans to issue a 2-year maturity coupon bond, paying coupons once per year with a coupon rate of 8.5%. The fa ...

  • 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