Create a spreadsheet to compute the npv and payback period, Ask an Expert

Accounting

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?

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M9799049

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - havel and petra are married will file a joint

Question - Havel and Petra are married, will file a joint tax return, and meet the requirements to file form 1040EZ. Havel has w-2 income of $40,000 and Petra has w-2 income of $44,542. Use the appropriate Tax Tables and ...

Question - loan amortization bankrate has a financial

Question - Loan Amortization. Bankrate, has a financial calculator that will prepare an amortization table based on your inputs. First, find the APR quoted on the website for a 30-year fixed rate mortgage. You want to bu ...

Question - maxwell corporation has income per books before

Question - Maxwell Corporation has income per books before tax of $400,000. Included in the income per books is $8,000 interest income from tax-exempt municipal bonds. In computing income per books, Maxwell deducted $22, ...

Question - on december 31 2016 green company finished

Question - On December 31, 2016, Green Company finished consultation services and accepted in exchange a promissory note with a face value of $770,000, a due date of December 31, 2019, and a stated rate of 5%, with inter ...

Question - this year major healy paid 40000 of interest on

Question - This year, Major Healy paid $40,000 of interest on a mortgage on his home (he borrowed $800,000 to buy the residence in 2015; $900,000 original purchase price and value at purchase), $6,000 of interest on a $1 ...

Question - a company incurred the following transactions

Question - A company incurred the following transactions: 1. Wages of $2,650 accrued at the end of the prior fiscal period were paid this fiscal period. 2. Real estate taxes of $7,100 applicable to the current period hav ...

Question - on january 1 2016 sinclair corp bought equipment

Question - On January 1, 2016, Sinclair Corp. bought equipment using a $10,000,000 zero-interest-bearing bond due on January 1, 2021. The prevailing rate of interest for a note like this on January 1, 2016 was 7%. What a ...

Question - metlock corporation traded a used truck cost

Question - Metlock Corporation traded a used truck (cost $28,400, accumulated depreciation $25,560) for a small computer with a fair value of $4,686. Metlock also paid $710 in the transaction. Calculate the journal entry ...

Taxation law assignment -in june 2016 tom had signed an

TAXATION LAW ASSIGNMENT - In June 2016 Tom had signed an agreement in Sydney with XYZ Ltd to act as the company's plantation manager in Brunei until June 2018. At the time of signing the agreement, Tom was advised that i ...

Question - overhead variances two- and three-variance

Question - Overhead Variances, Two- And Three-Variance Analyses Oerstman, Inc., uses a standard costing system and develops its overhead rates from the current annual budget. The budget is based on an expected annual out ...

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

Recent Questions

Ask Accounting Basics Expert