Calculate the initial outlay and annual operating cash flow

Assignment Help Financial Management

Reference no: EM131962650

Ingersoll Bakery wants to introduce a new product, pepperoni bread. This product was test marketed six months ago at a cost of $1,500 with promising results. Ingersoll needs to buy a machine to produce this new product. The price of the machine is $13,000 and installation cost is $2,000. The machine will be depreciated using the straight-line method to a book value of $600 over the four-year life of the project. The machine has an expected salvage value of $800 at the end of its four-year life. To produce this new product Ingersoll will have to invest an additional $1,600 in net working capital. Current annual product sales are $45,000. Pepperoni bread sales are projected at $15,000, but $1,000 will be sales from customers who switched from other Ingersoll products. Cost of goods sold will increase by $4,000 and selling expense will increase by $2,000. The tax rate is 35% and the required rate of return is 12%.

1. Calculate the initial outlay, annual operating cash flow and terminal cash flows. Complete the table with the timeline and calculate the NPV and IRR of the project.

2. Create a Data Table that shows changes in NPV, when required rate changes (8%, 10%, 12%, 14%, 16%).

3. The required return is estimated 12% or 16%. Create combo box for the two different required returns.

4. The company expects the equipment to be actually sold for $800, $1,200 or $2,000 after 4 years. Create option buttons for the three different market values and group together the option buttons.

Reference no: EM131962650

Questions Cloud

How much is the principal repayment : How much of the third payment is interest and how much is the principal repayment?

Variable versus fixed cost-full-time equivalent calculations : Research and discuss the differences between variable and fixed costs and provide examples of both.

What was the annual increase in the value of the comic book : Assume that in 2015, the first edition of a comic book was sold at auction for $1,905,000. what was the annual increase in the value of the comic book?

The firm purchase without the current ratio : A firm as current assets of 5,652,540 and current ratio of 3.60. how much additional inventory can the firm purchase without the current ratio dropping below 2?

Calculate the initial outlay and annual operating cash flow : Calculate the initial outlay, annual operating cash flow and terminal cash flows. Complete the table with the timeline and calculate NPV and IRR of the project.

Using both capm and the constant-growth model : Compute the required return for each company using both CAPM and the constant-growth model.

How many years are there until the bond matures : Beam Inc. bonds are trading today for a price of $957.04. How many years are there until the bond matures?

Your expectations of exchange rate change : If you conduct speculative trade on expectations of exchange rate change and your expectations are correct, what will be your total profit, as measured in USD?

Calculating german-source taxable income : all of which had been deducted in calculating German-source taxable income.

User Account

All Pages