User Account

All Pages

Create a spreadsheet to compute the npv and payback period

Assignment Help Accounting Basics
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

Reviews

Write a Review

Accounting Basics Questions & Answers

  Identification method of costing inventory

Ted's Used Cars uses the specific identification method of costing inventory. During March, Ted purchased three cars for $6,000, $7,500, and $9,750, respectively. During March, two cars are sold for $9,000 each.

  Find the amount of depreciation expense for 2003 would be

A factory machine was purchased for $25,000 on January 1, 2003. It was estimated that it would have a $5,000 salvage value at the end of its 5-year useful life.

  Suburban lifestyles roi residual income

Suburban Lifestyles, Inc. has manufactured prefabricated houses for over 20 years. The houses are constructed in sections to be assembled on customers' lots. Suburban Lifestyles expanded into the precut housing market when it acquired Fairmont Com..

  Reduce goal incongruence

What is goal incongruence? How can using the metric "return on investment" for performance evaluation lead to goal incongruence?

  Verizon phone company an american firm is estimating their

verizon phone company an american firm is estimating their profit in germany for next year. they are predicting sales

  Unrealized holding gain on securities

On January 2, 2010, it purchased for cash $25,300 of equity securities that it classified as available-for-sale. It received cash dividends of $4,070 during the year on these securities. In addition, it has an unrealized holding gain on these secu..

  Sarah basis in the stock

Sarah transfers property with an $80,000 adjusted basis and a $100,000 FMV to Super Corporation in a Sec. 351 transaction. Sarah receives stock with an $85,000 FMV and a short-term note with a $15,000 FMV. Sarah's basis in the stock is:

  What is the rate of return on project

The Wine Press is considering a project which has an initial cash requirement of $187,400. The project will yield cash flows of $2,832 monthly for 84 months. What is the rate of return on this project?

  Find more recent information on larger or well known company

Select a publicly traded company that trades on the New York Stock Exchange (NYSE) or on the NASDAQ to analyze. Please note that it is usually easier to find more recent information on larger or well known companies.

  Accounts payable computer systems basics

Hannah Company maintains two separate accounts payable computer systems. One is known to all the users, and is used to process payments to vendors.

  Describe what is meant by professor millers the cruelest

explain what is meant by professor millers the cruelest corruption of darwins theories in the carrie buck

  What was the net or cash cost for the merchandise

The Tan Company purchased merchandise inventory on account with a list price of $5,000 and credit terms of 1/20, n/45. What was the net or cash cost for the merchandise?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd