Create a spreadsheet to compute the npv and payback period

Reference no: EM13483873

Create a spreadsheet to compute the NPV and payback period to assist with a purchase decision. Use to results to answer questions about your findings.

Scenario: Amazon.com is planning to purchase a new bar-coding machine for one of its warehouses. You have been asked to prepare a simple analysis to determine whether Amazon should purchase the machine. The bar coding machine costs $60,000. It has a 5 year economic life and an estimated residual value of $10,000. The estimated annual net cash flow from the machine is $16,000. Amazon.com's required rate of return is 16%.

Once the spreadsheet is completed answer the following questions:

1. What is the machine's NPV?

2. What is the machine's payback period?

3. Should Amazon.com purchase the machine? Why or why not?

Reference no: EM13483873

Questions Cloud

The probabilities of their outcomes are 20 40 and 40 : a project has the following projected outcomes in dollars 200 320 and 510. the probabilities of their outcomes are 20

Prepare the following budgets for march 2012a revenues : budgetschedulesforamanufacturer.logospecialtiesmanufacturesamongotherthingswoolen blankets for the athletic teams of

How does using options differ from using forward or : how does using options differ from using forward or futures contracts and what is the difference between options on

Prepare a monthly flexible budget for the product showing : office plus sells its main product ergonomic mouse pads for 12 each. its variable cost is 5.20 per pad. fixed costs

Create a spreadsheet to compute the npv and payback period : create a spreadsheet to compute the npv and payback period to assist with a purchase decision. use to results to answer

Included in the cost of factory supplies are obsolete items : maddox specialty company a division of lost world inc. manufactures three models of gear shift components for bicycles

Johnson inc is a manufacturer of lead crystal glasses : johnson inc. is a manufacturer of lead crystal glasses. the standard materials quantity is 0.8 pound per glass at a

The us treasury bill is yielding 28 percent and the return : phillips equipment has 80000 bonds outstanding that are selling at par. bonds with similar characteristics are

What would be the cost of retained earnings equity for : what would be the cost of retained earnings equity for tangshan mining if the expected return on u.s. treasury bills

User Account

All Pages