Question

In: Finance

Jones Enterprises is looking at a project with the following forecasted sales: first year sales quantity...

  1. Jones Enterprises is looking at a project with the following forecasted sales: first year sales quantity 30,000 with an annual growth rate of 3.2% over the next ten years.

The sales price per unit is $42.50 and will grow at 2.25% per year.

The production costs are expected to be 50% of the current year’s sales price.

The manufacturing equipment to aid this project will have a total cost of $3,000,000.

It will be depreciated using MACRS and has a seven-year MACRS life classification.

Fixed cost are $400,000 per year.

Jones has a tax rate of 30%.

  1. Prepare an Excel worksheet for the 10 year projects Operating Cash Flows.
  2. What is the NPV and IRR of this project if the equipment can be sold for $140,000 at the end of the ten-year project and the cost of capital is 8.5%
  3. Should the project be accepted or rejected?

Solutions

Expert Solution


Related Solutions

Jones Enterprises is looking at a project with the following forecasted sales: first year sales quantity...
Jones Enterprises is looking at a project with the following forecasted sales: first year sales quantity 30,000 with an annual growth rate of 3.2% over the next ten years. The sales price per unit is $42.50 and will grow at 2.25% per year. The production costs are expected to be 50% of the current year’s sales price. The manufacturing equipment to aid this project will have a total cost of $3,000,000. It will be depreciated using MACRS and has a...
Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity...
Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 35,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at ​$42.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of ​$2,500,000. It will be depreciated...
Miglietti Restaurants is looking at a project with the following forecasted? sales: ? first-year sales quantity...
Miglietti Restaurants is looking at a project with the following forecasted? sales: ? first-year sales quantity of 33,000?, with an annual growth rate of 4.00?% over the next ten years. The sales price per unit will start at $43.00 and will grow at 2.00% per year. The production costs are expected to be 55?% of the current? year's sales price. The manufacturing equipment to aid this project will have a total cost? (including installation) of 2,300,000. It will be depreciated...
Miglietti Restaurants is looking at a project with the following forecasted? sales: ? first-year sales quantity...
Miglietti Restaurants is looking at a project with the following forecasted? sales: ? first-year sales quantity of 31,000?, with an annual growth rate of 2.00?% over the next ten years. The sales price per unit will start at $42 and will grow at 4.50?% per year. The production costs are expected to be 55?% of the current? year's sales price. The manufacturing equipment to aid this project will have a total cost? (including installation) of $2,400,000.?? It will be depreciated...
Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity...
Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 35,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at $44.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of $2,300,000. It will be depreciated...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 36,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at ​$45.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of ​$2,400,000. It will be...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 33,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at ​$43.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of $2,300,000. It will be...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 31,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at ​$43.00 and will grow at 2.00 % per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of $2,400,000. It will...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 32,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at $42.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of $2,200,000. It will be...
NPV. Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV. Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 33,000​,with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at $44.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of $2,200,000. It will be depreciated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT