TECO, has been tasked with evaluating two designs for the new plant with a 10-year horizon. Interest is 7.69%, compounded monthly. Design 1: This design will cost $110 million initially. First-year annual operating costs will be $2.8 million and costs will increase each year by $38,000. This design will produce electricity worth $8.7 million in revenue the first year and will increase in revenue by 9% each year thereafter. Design 2: This design will cost $97 million initially. First-year annual operating costs will be $8 million and costs will increase each year by $35,000. This design will produce electricity worth $9.7 million in revenue the first year and will increase in revenue by 9% each year thereafter. Use EXCEL to answer the following questions: uestion A Conduct Present Worth Analysis (Chapter 5). What is the monetary value of the Net Present Worth of Design 1? You must use EXCEL Block function(s) to answer the question. Enter your answer in US ollars rounded to 2 decimal places. Do NOT enter any spaces, commas, or dollar sign ($), Just enter the

TECO, has been tasked with evaluating two designs for the new plant with a 10-year horizon. Interest is 7.69%, compounded monthly. Design 1: This design will cost $110 million initially. First-year annual operating costs will be $2.8 million and costs will increase each year by $38,000. This design will produce electricity worth $8.7 million in revenue the first year and will increase in revenue by 9% each year thereafter. Design 2: This design will cost $97 million initially. First-year annual operating costs will be $8 million and costs will increase each year by $35,000. This design will produce electricity worth $9.7 million in revenue the first year and will increase in revenue by 9% each year thereafter. Use EXCEL to answer the following questions: uestion A Conduct Present Worth Analysis (Chapter 5). What is the monetary value of the Net Present Worth of Design 1? You must use EXCEL Block function(s) to answer the question. Enter your answer in US ollars rounded to 2 decimal places. Do NOT enter any spaces, commas, or dollar sign ($), Just enter the

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A process for producing the mosquito repellant Deet has an initial investment of $205,000 with annual costs of $51,000. Income is expected to be $90,000 per year. What is the payback period at /= 0% per year? At i=12% per year? (Note: Round your answers to the nearest integer.) The payback period at /= 0% is determined to be The payback period at /= 12% is determined to be years. years.
The cost of a special purpose equipment will increase at the rate of 10% per year. If the cost for the first year is $10,000, what is the present worth of the costs for a 3-year time period at a MARR of 12% per year compounded annually? Your Answer:
A new project is being planned for a study period of 8 years. It will require $250,000 for the start-up and after theend of the first year, $13,500 shall be paid for its innovation. The board then requires to add another modifiedtechnology which will cost $25,000 by the end of the second year. After the end of third year, the project will startto earn $57,500 annually. Calculate the annual effective interest rate using ERR method if the interest rate externalto this project (ε) is 13.75%.
Ocean Tide Industries is planning to introduce a new product with a projected life of eightyears. The project is in the government’s preferred industry list and qualifies for a one-timesubsidy of $2,000,000 at the start of the project. Initial equipment (IE) will cost $14,000,000and an additional equipment (AE) costing $1,000,000 will be needed at the end of year 2. Atthe end of 8 years, the original equipment, IE, will have no resale value but the supplementaryequipment, AE, can be sold for its book value of $100,000. A working capital of $1,500,000will be needed.The sales volume over the eight-year period have been forecast as follows: Year 1 80,000 unitsYear 2 120,000 unitsYears 3-5 300,000 unitsYears 6-8 200,000 units A sale price of $100 per unit is expected and the variable expenses will amount to 40% of salesrevenue. Fixed cash operating expenses will amount to $1,600,000 per year.Additionally, an extensive advertising campaign will be launched, which will need annual expenses…
A project requires the following investments: initial investment of $ 3,000,000, from the first month and for 6 consecutive months a monthly investment of $ 350,000. If $6,250,000 is received at the end of the year, what was the monthly rate of return?
You are evaluating a project for your company. You estimate the sales price to be $520 per unit and sales volume to be 2,200 units in year 1; 3,200 units in year 2; and 1,700 units in year 3. The project has a three-year life. Variable costs amount to $320 per unit and fixed costs are $210,000 per year. The project requires an initial investment of $335,000 in assets which will be depreciated straight-line to zero over the three-year project life. The actual market value of these assets at the end of year 3 is expected to be $52,000. NWC requirements at the beginning of each year will be approximately 20 percent of the projected sales during the coming year. The tax rate is 21 percent and the required return on the project is 10 percent. What change in NWC occurs at the end of year 1? $104,000 $139,672 $82,160 $176,800
Aguilera Acoustics, Inc. (AAI), projects unit sales for a newseven-octave voice emulation implant as follows: Year Unit Sales 1 8300 2 9200 3 10400 4 9800 5 8400 Production of the implants will require GH¢ 150,000 in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales for that year. In the final year of the project, net working capital will decline to zero as the project is wound down. In other words, the investment in working capital is to be completely recovered by the end of the project’s life. Total fixed costs are GH¢ 240,000 per year, variable production costs are GH¢ 190 per unit, and the units are priced at GH¢ 345 each. The equipment needed to begin production has an installed cost of GH¢ 2,300,000. Because the implants are intended for professional singers, this equipment depreciated using the straight-line basis. In five years,…
Cardinal Company is considering a project that would require a $2,782,000 investment in equipment with a useful life of five years. At the end of five years, the project would terminate and the equipment would be sold for its salvage value of $200,000. The company’s discount rate is 18%. The project would provide net operating income each year as follows: Sales $ 2,873,000 Variable expenses 1,019,000 Contribution margin 1,854,000 Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs $ 754,000 Depreciation 516,400 Total fixed expenses 1,270,400 Net operating income $ 583,600 Required:If the equipment’s salvage value was $400,000 instead of $200,000, what would be the project’s simple rate of return? (Round your answer to 2 decimal places.)
A process for producing the mosquito repellant Deet has an initial investment of $210,000 with annual costs of $52,000. Income is expected to be $90,000 per year. What is the payback period at i = 0% per year? At i = 12% per year?
Aria Acoustics, Incorporated (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year 12345 Unit Sales 73,400 86,400 105,500 97,600 67,500 Production of the implants will require $1,600,000 in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales increase for the following year. Total fixed costs are $3,400,000 per year, variable production costs are $257 per unit, and the units are priced at $381 each. The equipment needed to begin production has an installed cost of $16,900,000. Because the implants are intended for professional singers, this equipment is considered industrial machinery and thus qualifies as seven-year MACRS property. In five years, this equipment can be sold for about 20 percent of its acquisition cost. The tax rate is 22 percent and the required return is 14 percent. MACRS schedule a. What is the NPV of the project? Note: Do not round intermediate…
The initial investment to an equipment is $400,000 and annual revenues are expected to be $190,000 over the six-year life of the furnace. Annual expenses will be $50,000 at the end of year one and will increase by $10,000 each year thereafter. The resale value of the furnace after six years is $20,000. The MARR is 20%. Determine the simple payback period.
Everest Dew Corporation is planning to construct a new manufacturing plant on which has 60 production lines to run at any point of time to make output. The usage of the line is expected to be 92% all time throughout the years. The initial investment cost for all the lines is RM950,000. It is expected to generate revenue RM8,200 per line in year 1 and 10% increase for every year from year 2 to 6. The operating cost per line is RM1,200 and expected to increase by 10% every year from year 2 to 6. At year 6 it can cease the operation by selling the entire business for RM420,000. The cost of capital is expected to be about 12%. Advice whether the project is acceptable or rejected by using the below methods. A. Accounting Rate of Return (AROR) B. Payback Period Technique (PBP) C. Discounted Payback Period (DPP) D. Net Present Value Technique (NPV) E. Profitability Index (PI) F. What is the importance of the Technique used for analysis on Capital budgeting cost for a project?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS