Compute the npv of the project

Reference no: EM131134290

MRE Sales is looking to acquire an ERP and has asked for your assistance. The company can purchase the system outright for $120,000 plus 5% sales tax, and delivery and install charges of $2,000. The ERP is expected to last 5 years and have a salvage value of $8,000. The company will use straight-line depreciation over the 5-year life. Its income tax rate is 40%. The company's cost of capital is 12%. The system is expected to bring annual benefits of $35,000 over the 5-year period. Showing all calculations in Excel:

a. Compute the NPV of the project

b. Compute its payback period

Reference no: EM131134290

Questions Cloud

What is stagflation : Describe a situation that could produce it. Could the situation you've described be avoided? Should it be avoided?

Provide more specific elaboration upon concept of operations : In this assignment, students are asked to provide more specific elaboration upon the specific area needing improvement that was identified in the Basic Plan assignment previously.

What is a dividend : "Dividends must be paid in cash." Do you agree? Explain.

Prepare an income statement for jasper for last year : Prepare an income statement for Jasper for last year. Calculate the percentage of sales for each line item on the income statement - What is the total maintenance cost incurred by Alisha last year

Compute the npv of the project : MRE Sales is looking to acquire an ERP and has asked for your assistance. The company can purchase the system outright for $120,000 plus 5% sales tax, and delivery and install charges of $2,000.

What was the total amount of dividends paid in 2007 : 1. A high percentage of Americans own stock in corporations. As a shareholder in a corporation, you will receive an annual report. One of the goals of this course is for you to learn how to navigate your way around an annual report.

A spreadsheet using excel or a similar program : Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9.

Explain the outcomes of a cooperative game : Explain what Bob's "tit-for-tat strategic behavior" would be if he wished to see the game.

Up of fixed expenses and variable expenses : 1. Since a budget is made up of fixed expenses and variable expenses, identify which of Shelby's expenses fall into each category. Then total each category and compare it to her monthly income to determine if she has a surplus or deficit.

User Account

All Pages