Question

A consulting company plans to purchase a new computer network for $125,000 to save $35,000/year over...

A consulting company plans to purchase a new computer network for $125,000 to save $35,000/year over its projected 9 year life from doing all their CAD activities in house. At the end of its life, the salvage value of this system is estimated to be $12,500. What is the rate of return of this investment (I want the actual rate) and is it a good idea if the MARR = 8%/year?

Homework Answers

Answer #1
Year Cashflow Discount factor@ 8% PW Discount factor@ 30 % PW
0 -125000 1.00 -125000.00 1.00 -125000
1 35000 0.93 32407.41 0.77 26923.08
2 35000 0.86 30006.86 0.59 20710.06
3 35000 0.79 27784.13 0.46 15930.81
4 35000 0.74 25726.04 0.35 12254.47
5 35000 0.68 23820.41 0.27 9426.518
6 35000 0.63 22055.94 0.21 7251.167
7 35000 0.58 20422.16 0.16 5577.821
8 35000 0.54 18909.41 0.12 4290.632
9 47500 0.50 23761.83 0.09 4479.231
IRR 24.42% NPV1 99894.19 NPV2 -18156.2

R1 = 8%

R2= 30%

NPV1 = 99894.19

NPV2 = -18156.2

IRR = R1% + NPV1*(R2-R1)%/(NPV1-NPV2)

= 0.08 + 99894.19*(0.3-0.08)/(99894.19+18156.2)

= 0.08+0.1861

= 0.2661

= 26.61%

So the rate of return of the investment is 26.61 % and it is feasible as it is greater than MARR of 8%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Project Evaluation. Your firm is contemplating the purchase of a new $410,000 computer-based order entry system....
Project Evaluation. Your firm is contemplating the purchase of a new $410,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $30,000 at the end of that time. You will save $125,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $35,000 at the beginning of the project. Working capital will revert back to normal at the end of the...
5.30 A company needs to purchase a new machine to maintain its level of production. The...
5.30 A company needs to purchase a new machine to maintain its level of production. The company is considering three different machines. The costs, savings and service life related to each machine are listed in the table below. Machine A Machine B Machine C First Cost $37,500 $31,000 $35,000 Annual Savings $13,500 $12,000 $12,750 Annual Maintenance $3,000 the first year and increasing by $600 every year thereafter $2,500 $2,000 Salvage Value $5,000 $11,000 $13,000 Service Life 6 years 3 years...
7-22. A company is considering the purchase of a capital asset for $100,000. Installation charges needed...
7-22. A company is considering the purchase of a capital asset for $100,000. Installation charges needed to make the asset for serviceable will total $30,000. The asset will be depreciated over six years using the straight-line method and an estimated salvage value (SV6) of $10,000. The asset will be kept in service for six years, after which it will be sold for $20,000. During its useful life, it is estimated that the asset will produce annual revenues of $30,000. Operating...
Your firm is contemplating the purchase of a new $480,000 computer-based order entry system. The system...
Your firm is contemplating the purchase of a new $480,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $30,000 at the end of that time. You will be able to reduce working capital by $35,000 at the beginning of the project. Working capital will revert back to normal at the end of the project. Assume the tax rate is 35 percent. Requirement 1: Suppose your required return on...
The company has been growing steadily over the past 5 years, and the financials and future...
The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following: The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to small businesses in their local and regional area. NewForm employs 83 people, 61 of whom are IT professionals/ consultants. NewForm is struggling financially; it has not met its revenue projections in the last five quarters. NewForm has suffered excessive leadership turnover in the past three years. The original founders sold NewForm in 2015; one of them, James Stanton, remained on as CHRO but sold...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to small businesses in their local and regional area. NewForm employs 83 people, 61 of whom are IT professionals/ consultants. NewForm is struggling financially; it has not met its revenue projections in the last five quarters. NewForm has suffered excessive leadership turnover in the past three years. The original founders sold NewForm in 2015; one of them, James Stanton, remained on as CHRO but sold...
Question 5 A plant site donated by a township to a manufacturer that plans to open...
Question 5 A plant site donated by a township to a manufacturer that plans to open a new factory should be recorded on the manufacturer's books at ___________. Question 5 options: A. the nominal cost of taking title to it i B. Its fair value C. one dollar (since the site cost nothing but should be included in the balance sheet) D. the value assigned to it by the company's directors Question 6 Which of the following costs are capitalized...
Amazon CEO Jeff Bezos’ 2020 letter to shareholders details the company’s plans to combat the coronavirus...
Amazon CEO Jeff Bezos’ 2020 letter to shareholders details the company’s plans to combat the coronavirus Amazon CEO Jeff Bezos just published his annual letter to shareholders, and the efforts his company is taking to address the COVID-19 crisis were front and center. He outlined the company’s plans to build a lab to test employees and the social distancing measures its implemented in its facilities among other initiatives. Other than the coronavirus pandemic, Bezos also discussed the retail giant’s efforts...
Pandora is the Internet’s most successful subscription radio service. As of June 2013, it had over...
Pandora is the Internet’s most successful subscription radio service. As of June 2013, it had over 200 million registered users (140 million of which access the service via a mobile device) and over 70 million active listeners. Pandora now accounts for more than 70% of all Internet radio listening hours and a 7% share of total U.S. radio listening (both traditional and Internet). At Pandora, users select a genre of music based on a favorite musician, and a computer algorithm...