custom writing services

Need help: Write an email to our support staff support@myprivatementor.com or


whatsapp us

order order
Average score 4.97 out of 5 based on 836 opinions

finance problem need help pro teacher

This case is intented for user Abhishek Jain,  since we agreed on it because it is a resit case. Others are welcome to solve it if Abhishek Jain cant help me. thank you.

 

Your consultancy work with CSR in case 1 has spread positive word of mouth for your business. As a consequence hereof, the company Electricity Conservation ltd has requested you to help them analyze which of two mutually exclusive projects to invest in. Below follow information about the two investment opportunities:

 

Investment A (the development of a decentralized heating system for buildings)

 

·         The initial cost for this investment is $1million

 

·         The yearly expenses for this investment is expected to be $10  000 (at the end of each year).

 

·         The investment is expected to generate revenues of $200 000 per year (at the end of each year) for the next 10 years.

 

·         The cost of capital for this investment project is expected to be 10%

 

Investment B (the development of a centralized heating system for buildings)

 

·         The initial cost for this investment is $0.5million

 

·         The yearly expenses for this investment is expected to be $7 000

 

·         The investment is expected to generate revenues of $175 000 per year (at the end of each year) for the next 10 years.

 

·         The cost of capital for this investment project is expected to be 8%

 

Investment C (the development of a manual heating system for buildings)

 

·         The initial cost for this investment is $0.2million

 

·         The yearly expenses for this investment is expected to be $5 000

 

·         The investment is expected to generate revenues of $80 000 per year (at the end of each year) for the next 10 years.

 

·         The cost of capital for this investment project is expected to be 7%.

 

 

Your task

 

Your task is to create a spreadsheet model (using Microsoft Excel) showing which investment to undertake. The client more specifically wants you to show the following in your spreadsheet model:

 

a)      Show, by using the incremental IRR rule for investment A and B above, in a graph, how sensitive the choice of one project over the other is to changes in discount rate of either project. (NPV on Y-axis, discount rate on x-axis).

 

 

b)      Now assume that Electricity Conservation ltd. has in total 20 scientists available to develop either of the three heating systems (investments A, B or C). However, the company has just realized they can bundle each of the three heating systems for a single building (customization). For instance, for a single building they can develop a solution 20% based on a manual heating system, 30% on a centrally based one and 50% of a decentralized one.  Developing the complete manual system (investment C) requires using 12 scientists for a year, developing the complete centralized system requires using 8 scientists for a year, and finally developing the complete decentralized system requires using all 20 scientists for a year. Based on number of scientists (and assume scientists are divisible in fractions and over the year) as a resource constraint develop a profitability index (using NPV) to show whether the company ought to invest in either investment A, investment B, investment C or a combination of them (A,B,C). hence, which alternative yields highest value in terms of NPV?

 

c)       Now assume that investments A, B and C are mutually exclusive. Hence, you choose either of them. Assume that for investment C a real option has arisen. If the economy turns out to be good (25% probability) you will be able to generate revenues equal to$150 000 per year from year 2016 and onwards. If the economy turns out to be bad, then the opportunity will not be given.  All else equal, according to the NPV rule should Electricity Conservation ltd now choose investment project C or not?

 

Finally, since the company wants to be able to use this spreadsheet in the future as well you need to use cell references in the formulas (for a, b and c above).

 

 

 

 

 

 

NEED TO MAKE AN ORDER? HERE IS HOW IT WORKS

order-process

Need an answer from similar question?Click here and get a solution now

order You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. banner We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school
Undergrad.(yrs 1-2)
Undergrad.(yrs 3-4)
Master’s
Doctoral
$10 / page
$10/ page
$12/ page
$15 / page
$17/ page

Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written? Myprivatementor.com  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at myprivatementor.com  for guaranteed  high grades. order download

we offer gifts to our paper help customersPayment Methods

you can request our services and pay via paypal

we offer gifts to our paper help customersOur Guarantees

  1. Zero plagiarism.
  2. 100% confidentiality.
  3. FREE Reference page
  4. High Quality papers
  5. 24/7 Customer support

Our Testimonials Testimonials

I ordered a 7 page college essay and was delivered on time. Thank you guys I will definitely order again!

9.5
, FL

Our statisticsOur Statistics

  • Orders Completed todate 72387

  • Number of writers 500

  • Satisfied customers 99.7%

  • Returning customers 92.3%

  • Orders placed today 87