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

If the rate of return on the sampp 500 index was 23 for

If the rate of return on the S&P 500 index was 23% for 2009, and the risk-free rate at the end of 2009 was 1%, calculate the equity risk premium for 2009. Recalculate the equity risk premium using 1981 data, when the ris ...

Problema manager checked production records and found that

Problem A manager checked production records and found that a worker produced 195 units while working 50 hours. In the previous week, the same worker produced 144 units while working 40 hours. a. Compute Current period p ...

Forecasting interest rates based on prevailing

Forecasting Interest Rates Based on Prevailing Conditions : Consider the prevailing conditions for inflation (including oil prices), the economy, the budget deficit, and the Fed's monetary policy that could affect intere ...

If you have a portfolio with a market value of 1000000 and

If you have a portfolio with a market value of $1,000,000 and a beta (measured against the S&P 500) of 0.7, then if the market rises by 9.6 percent, what value would you expect your portfolio to have?

True or falsetrue or false dividends are irrelevanttrue or

True or False True or False: Dividends are irrelevant True or False: Dividend policy is irrelevant It is important to understand that the only thing that can make dividend policy relevant is if there is some market imper ...

Pam and mark are considering jobs where they will be paid

Pam and Mark are considering jobs where they will be paid strictly on commissions. The commissions is expected to be 5% on all sales of house water filters they close. Pam's goal is to earn a gross salary of $65,000 a ye ...

Assume the likelihood that any chemical experiment is

Assume the likelihood that any chemical experiment is successfully performed is 0.87. We randomly selected three chemical experiments in three different labs. 1) What is the probability that all three experiments are suc ...

Consumer financial protection bureau as a result of the

Consumer Financial Protection Bureau: As a result of the Financial Reform Act of 2010, the Consumer Financial Protection Bureau was established and housed within the Federal Reserve. Explain the role of this bureau.

There are three well-diversified portfolios a b and c with

There are three well-diversified portfolios A, B and C with alphas of 0.0132, 0.0289 and 0.0579, respectively, and betas of 1.27, 1.15 and 1.50, respectively. The risk-free rate is 4.7% p.a., the market risk premium is 8 ...

Assignment lasa 1-the time value of moneymary has been

Assignment: LASA 1-The Time Value of Money Mary has been working for a university for almost 25 years and is now approaching retirement. She wants to address several financial issues before her retirement and has asked y ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate