Log in
Finance
1
answer
0
watching
1,198
views

Shao Airlines is considering two alternative planes. Plane A has an expected life of 5

years, will cost $100 million, and will produce net cash flows of $30 million per year.

Plane B has a life of 10 years, will cost $132 million, and will produce net cash flows of

$25 million per year. Shao plans to serve the route for only 10 years. Inflation in operating

costs, airplane costs, and fares is expected to be zero, and the company’s cost of capital is

12%. By how much would the value of the company increase if it accepted the better

project (plane)?

*****SOLUTION*****

Plane A: Expected life = 5 years; Cost = $100 million; NCF = $30 million; COC = 12%.

Plane B: Expected life = 10 years; Cost = $132 million; NCF = $25 million; COC = 12%.

Answer:

NPVa= $12.76 million

NPVb= $9.26 million

How can I calculate the NPV in Excel for this problem? step by step (ex. Plane B = =25*5.65-132 (I am not sure where is the 5.65 comes from))

Watch
1
answer
0
watching
1,198
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Casey Durgan
Casey DurganLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

S-Airlines is considering two alternative planes. Plane A has an expected life of 5 years, will cost $100 million and will produce net cash flows of $32 million per year. Plane B has a life of 10 years, will cost $132 million and will produce net cash flows of $26 million per year. S-Airlines plans to serve the route for only 10 years. Inflation in operating costs, airplane costs, and fares is expected to be zero, and the company's cost of capital is 14%.

A) By how much would the value of the company increase if it accepted the better project (plane)? Enter your answer in millions.

B) What is the equivalent annual annuity for each plane? Enter your answer in millions.

Plane A $ million
Plane B $ million

8. A project has an initial cost of $71,950, expected net cashinflows of $9,000 per year for 6 years, and a cost of capital of10%. What is the project's PI? Do not round your intermediatecalculations. Round your answer to two decimal places.

9. A project has an initial cost of $54,925, expected net cashinflows of $12,000 per year for 8 years, and a cost of capital of11%. What is the project's payback period? Round your answer to twodecimal places.

10. A project has an initial cost of $40,000, expected net cashinflows of $9,000 per year for 9 years, and a cost of capital of11%. What is the project's discounted payback period? Round youranswer to two decimal places. Edelman Engineering is consideringincluding two pieces of equipment, a truck and an overhead pulleysystem, in this year's capital budget. The projects areindependent. The cash outlay for the truck is $19,000 and that forthe pulley system is $20,000. The firm's cost of capital is 12%.After-tax cash flows, including depreciation, are as follows: YearTruck Pulley 1 $5,100 $7,500 2 5,100 7,500 3 5,100 7,500 4 5,1007,500 5 5,100 7,500 a. Calculate the IRR for each project. Roundyour answers to two decimal places. Truck: % What is the correctaccept/reject decision for this project? Pulley: % What is thecorrect accept/reject decision for this project? b. Calculate theNPV for each project. Round your answers to the nearest dollar, ifnecessary. Enter each answer as a whole number. For example, do notenter 1,000,000 as 1 million. Truck: $ What is the correctaccept/reject decision for this project? Pulley: $ What is thecorrect accept/reject decision for this project? c. Calculate theMIRR for each project. Round your answers to two decimal places.Truck: % What is the correct accept/reject decision for thisproject? Pulley: % What is the correct accept/reject decision forthis project?

11. Talbot Industries is considering launching a new product.The new manufacturing equipment will cost $14 million, andproduction and sales will require an initial $1 million investmentin net operating working capital. The company's tax rate is 35%. a.What is the initial investment outlay? Write out your answercompletely. For example, 2 million should be entered as 2,000,000.$ b. The company spent and expensed $150,000 on research related tothe new project last year. Would this change your answer? c. Ratherthan build a new manufacturing facility, the company plans toinstall the equipment in a building it owns but is not now using.The building could be sold for $1.5 million after taxes and realestate commissions. How would this affect your answer? Theproject's cost will .

12. The financial staff of Cairn Communications has identifiedthe following information for the first year of the roll-out of itsnew proposed service: Projected sales $25 million Operating costs(not including depreciation) $12 million Depreciation $6 millionInterest expense $3 million The company faces a 40% tax rate. Whatis the project's operating cash flow for the first year (t = 1)?Write out your answer completely. For example, 2 million should beentered as 2,000,000. $

Cleaner Than Dirt manufactures a variety of household products. The company is considering
introducing a new household cleaning product. The company’s CFO has collected the following
information about the proposed product. (Note: You may or may not need to use all of this information,
use only the information that is relevant.)
• The project has an anticipated economic life of 4 years.
• The company will have to purchase a new machine to produce the product. The machine has an upfront
cost (t = 0) of $2 million. The machine will be depreciated on a straight-line basis over 4 years
(that is, the company’s depreciation expense will be $500,000 in each of the first four years (t = 1, 2,
3, and 4). The company anticipates that the machine will last for four years, and that after four
years, its salvage value will equal zero.
• If the company goes ahead with the proposed product, it will have an effect on the company’s net
operating working capital. At the outset, t = 0, inventory will increase by $140,000 and accounts
payable will increase by $40,000. At t = 4, the net operating working capital will be recovered after
the project is completed.
• The new product is expected to generate sales revenue of $1 million the first year (t = 1), $2 million
the second year (t = 2), $2 million the third year (t = 3), and $1 million the final year (t = 4). Each
year the operating costs (not including depreciation) are expected to equal 50 percent of sales
revenue.
• The company’s interest expense each year will be $100,000.
• The new product is expected to reduce the after-tax cash flows of the company’s existing products
by $250,000 a year (t = 1, 2 , 3, and 4).
• The company’s overall WACC is 10 percent. However, the proposed project is riskier than the
average project for Cleaner Than Dirt; the project’s WACC is estimated to be 12 percent.
• The company’s tax rate is 40 percent.
What is the net present value of the proposed project?

Weekly leaderboard

Home
Homework Help 3,900,000
Finance 370,000
Start filling in the gaps now
Log in