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

You are the owner of a large data-services firm and are deciding on the purchase of...

Free

50.1K

Verified Solution

Question

Finance

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.

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% peryear.

a. Using a 70/30 debt-to-equity ratio, what is the NPV of thisproject?

i. (hint) calculate the yearly payment using excel function“PMT”

b. How does the NPV of this project change if a larger portionis financed through equity (e.g. debt-to-equity ratio of 60/40)?Why?

Answer & Explanation Solved by verified expert
3.6 Ratings (643 Votes)

Per yr earning        233,300.00
Annual rate 4%
One time outflow    3,000,000.00
Financed by: (70/30)
Debt    2,100,000.00 PMT (70/30 Debt-equity ratio) -311,908 ($311,908.45)
Equity        900,000.00
Case 2: Financed by: (60/40) PMT 60/40 Debt-equity ratio) -267350.0977 ($267,350.10)
Debt    1,800,000.00
Equity    1,200,000.00
Case 1 Year Cashflows Case 2 Year Cashflows
0 -900000 0    (1,200,000.00)
1 -78608.4473 1 -34050.09768
2 -78608.4473 2 -34050.09768
3 -78608.4473 3 -34050.09768
4 -78608.4473 4 -34050.09768
5 -78608.4473 5 -34050.09768
6 -78608.4473 6 -34050.09768
7 -78608.4473 7 -34050.09768
8 -78608.4473 8 -34050.09768
9 233,300 9 233,300
10 233,300 10 233,300
11 233,300 11 233,300
12 233,300 12 233,300
13 233,300 13 233,300
14 233,300 14 233,300
15 233,300 15 233,300
NPV ($919,651.91) NPV ($1,208,512.35)
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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

The following information was extracted from the accounting records of Belle Mare Limited Statement of Comprehensive Income...

Basic Math
1.2K views

PLEASE USE RULES OF ADDITION OF PROBABILITY /MDPART 1: Create a context: Introduce a real-world business situation...

Physics
1.2K views

Problem (M-33). You are given a crystal of strontium at room temperture, or 300K. Draw the...

Biology
1.2K views

Ih which area of the diagram is most of Earth s phosphorus stor CVDL X...

Physics
1.2K views

7 A thin lens placed 30cm after an object form an image 25cm after it...

Geometry
1.2K views

Enter the letter for the function graphed below a y x 5 b y x...

Basic Math
1.2K views

If a certain number is added to the numerator and denominator of 7/11 the result...

Basic Math
1.2K views

Use algebra to find the intersection point of the graphs of the given equations.2x -...

Accounting
1.2K views

Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the companys accountant...

Accounting
1.2K views

The Beach Hut sells hot dogs for $2 each. The costs associated with each hot...

Accounting
1.2K views

Chuck Wagon Grills, Inc., makes a single producta handmade specialty barbecue grill that it sells...

Accounting
1.2K views

Thermal Rising, Incorporated, makes paragliders for sale through specialty sporting goods stores. The company has...