Question

A power company is planning to replace a 23 years old thermal power generator with a...

A power company is planning to replace a 23 years old thermal power generator with a capacity of 200 MW, with a new generator with a capacity of 600 MW. 23 years ago the cost index was 171 and it is 286 now. If the cost of 200 MW generator was $350 million 23 years ago and the cost of 600 MW generator is $1912 million today, what is the cost capacity factor?

IN EXCEL PLZ!!

Business   Economics   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

By hand (to demonstrate the solution)

Let Cost capacity factor be x, then

Price of 600MW capacity today = (Index today/ Index in past) * (capicity today / past capacity )^ cost capacity factor * Price of past capacity

Putting values in above equation

1912m = (286 / 171) * (600 / 200)^x * 350m

1912 = (1.6725146) * (3)^x * 350

3^x = 1912 / (350 *1.6725146) = 3.266253785

taking log both sides

x = log 3.266253785 / log 3 = 1.077 ~ 1.08

By Excel

Past Capacity (MW) 200
Capacity today (MW) 600
Price in past (m) 350
Price today (m) 1912
index today 286
index in past 171
Cost capacity factor 1.08

Showing formula in excel

Past Capacity (MW) 200
Capacity today (MW) 600
Price in past (m) 350
Price today (m) 1912
index today 286
index in past 171
Cost capacity factor =LOG(C28/(C27*(C29/C30)))/LOG(C26/C25)
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A power company is planning to replace a 39 years old thermal power generator with a...
A power company is planning to replace a 39 years old thermal power generator with a capacity of 370 MW, with a new generator with a capacity of 740 MW. 39 years ago the cost index was 156 and it is 394 now. If the cost of 370 MW generator was $411 million 39 years ago and the cost of 740 MW generator is $1549 million today, what is the cost capacity factor?
2. A German company is planning to replace the old machine for a new one. The...
2. A German company is planning to replace the old machine for a new one. The new machine will cost Euro 4 million, the old one can not be sold. The new machine will be used for 20 years, then it can be sold for 25% of the purchase price. Each year the company will save Euro 450,000 on the production costs, but the maintenance costs will be higher too: Euro 40,000 per year. In year 10, a special maintenance...
B. A regional electric utility currently relies on natural gas for power generation. It has 200...
B. A regional electric utility currently relies on natural gas for power generation. It has 200 Mw of natural gas capacity that is running on an average of 30 percent efficiency. It is studying options for supplying additional power to its customers. It has all of the following options: Coal:   A 50 megawatt (Mw) coal plant with a capital cost of $50 million and operating costs of $5 million per year plus the cost of coal. The coal plant would...
Polly Peyrotte started designing and decorating fine china plates more than 100 years ago. As her...
Polly Peyrotte started designing and decorating fine china plates more than 100 years ago. As her artistry caught on, she became famous. She also turned out to have considerable business skills. She grew her design studio into what today is Polly Plates, Inc. (PPI), with $36 million in annual revenue. Polly’s daughters and granddaughters became involved in the business after Polly’s retirement and hired talented designers who could carry on Polly’s tradition of beautiful plates. In recent years, however, fewer...
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...
  The following balance sheet and income statement should be used for questions #1 through #6: Kuipers,...
  The following balance sheet and income statement should be used for questions #1 through #6: Kuipers, Inc. 2001 Income Statement (OMR in millions) Net sales 9,625 Less: Cost of goods sold 5,225 Less: Depreciation 1,890 Earnings before interest and taxes 2,510 Less: Interest paid 850 Taxable income 1,660 Less: Taxes 581 Net income 1,079 Addition to retained earnings 679 Dividends paid 400 Kuipers, Inc. 12/31/00 and 12/31/01 Balance Sheet (in OMR, in millions) 2000 2001 2000 2001 Cash 1,455 260...
Case Abstract: Company ABC, an AE, constructor and construction management firm, recently assigned Bob Ironside to...
Case Abstract: Company ABC, an AE, constructor and construction management firm, recently assigned Bob Ironside to turn a major coal fired generating station project around. Currently at 36 percent construction completion, the project is shifting from an emphasis on civil and structural work to bulk production. Cooperation of the owner, the multi-prime contractors, and strong labor unions is cach vital for performance improvement. The analysis of this project involves: 1) identification of significant external influences on the project organization, 2)...
QUESTION 1 All of the followings are the rights and privileges of a Common Stockholders EXCEPTING:...
QUESTION 1 All of the followings are the rights and privileges of a Common Stockholders EXCEPTING: a. Voting/Proxy Rights b. Right to Dividends c. Residual Right d. Pre-emptive Right e. Right to Interest Payments 10 points    QUESTION 2 Your best friend's parents want to buy a home in the Worcester County, but they don’t know the exact amount of money that they can afford to borrow. They can afford monthly payments of $ 1,800. A friendly bank in Worcester...
CASE: Sharesies: NZ investment platform Everyday investment company Sharesies was launched in February 2017, after conducting...
CASE: Sharesies: NZ investment platform Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT