Capital budgeting question | Business & Finance homework help

1.A public transit authority is evaluating whether to purchase new high-speed railcars from Siemens AG or General Electric. The Siemens AG cars cost $275,000 each, are expected to last ten years and have anticipated annual maintenance costs of $10,000 each. The General Electric cars cost $195,000, are expected to last six years and have anticipated annual maintenance costs of $15,000 each. If the transit authority’s cost of capital is 8%, and the cost is spread evenly over each year, which manufacturer should they chose? (Hint: Annualize the cost using the PMT function in Excel.) Does your conclusion change if General Electric guarantees that annual maintenance on their railcars will not exceed $10,000 each?
2.The code enforcement unit of a public safety department has two options for purchasing a new vehicle: a $23,000 four-cylinder sedan that averages 26 mpg or a $28,000 hybrid that averages 47 mpg. Assuming that gasoline will cost $4.00 per gallonthat the vehicle will be driven for 15,000 miles per year and will incur annual maintenance costs of $200, which vehicle should the unit purchase? Further assume the vehicle will be kept for five years with no salvage value and a discount rate of 5%. Does your recommendation change if the vehicle is kept for six years?

 

Don't use plagiarized sources. Get Your Custom Essay on
Capital budgeting question | Business & Finance homework help
Just from $13/Page
Order Essay

 

Please provide an answer together with an excel file.

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper