Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. problem set 1 you are the owner of a large data-se

Problem Set 1 You are the owner of a large data-services firm and are deciding on the...

50.1K

Verified Solution

Question

Finance

Problem Set 1

You are the owner of a large data-services firm and are decidingon the purchase of a new hardware cooling system that you expectwill yield $233,300 in cost-savings per year for the next 15 years.The installation of this cooling system will cost $3,000,000.

1. At face value, does this system seem profitable? By howmuch?

2. Assume that your company uses a discount rate of 6%.

a. What is the Net Present Value (NPV) of this project?

b. How does the NPV of this project change as you assume ahigher or lower discount rate? Why?

c. What is the IRR/ROI of this project? d. How much should theyearly cost-savings be in order to break even? i. (hint) usegoal-seek/what-if analysis

3. Suppose that you decide to finance the purchase of thissystem through a loan from the bank. The bank is willing to loanthis money over an 8 year term at an interest rate of 4% per year.a. Using a 70/30 debt-to-equity ratio, what is the NPV of thisproject? i. (hint) calculate the yearly payment using excelfunction “PMT” b. How does the NPV of this project change if alarger portion is financed through equity (e.g. debt-to-equityratio of 60/40)? Why?

Answer & Explanation Solved by verified expert
4.0 Ratings (614 Votes)
1At face value without using discount factors this system seemsprofitableaTotal cost savings 233300153499500bSystem cost3000000cabProfit4995002Net Present Value NPVRateDiscount rate6NperNumber of years15PmtAnnual    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A restaurant offers a 12 dinner special that has 4 choices for an appetizer 12...

Basic Math
Q

QUESTION 16 – COOLING TOWERS AND EVAPORATIVE CONDENSERS Water flows at 5000 kg/h and 40°C into...

Mechanical Engineering
Q

Number of defective monitors manufactured in day shift and afternoon shift is to be compared. A...

Basic Math
Q

You are working for the CFO of a small manufacturing company and are thinking about investing...

Finance
Q

A block is placed inside a horizontal hollow cylinder The cylinder is rotating with constant...

Physics
Q

12 3 Find the exact value of sin a B if sin a and sin...

Algebra
Q

Rowurbot develops collaborative robots (cobots) in Abbotsford, BC. Cobots are designed to work with humans...

Accounting
Q

Prepare a 1-2 page double spaced research paper discussing the pitfalls and challenges of financial...

Accounting
Q

a. $1,961,623 b. $980,207 c. $1,960,250 d. $1,960,815

Accounting
Q

Please help with the balance sheet ...

Accounting
Q

Which of the following is FALSE? Subprime mortgages are mortgages for which the borrower doesn't...

Finance
Q

QUESTION 26 An example of a taxonomy is: The EU classification system for sustainable activities...

Finance