The Martian Corporation, a space vehicle development company, is starting a new division that will develop the next-generation launch missile engine configuration. Use a hand application of the MIRR method to determine the EROR for the estimated net cash flows (in $1000 units) of $-42,000 in year 0, $11,000 in years 1 through 8, and $-2,000 in year 9. Assume a borrowing rate of 15% and an investment rate of 29% per year. The external rate of return is 22.73 %

The Martian Corporation, a space vehicle development company, is starting a new division that will develop the next-generation launch missile engine configuration. Use a hand application of the MIRR method to determine the EROR for the estimated net cash flows (in $1000 units) of $-42,000 in year 0, $11,000 in years 1 through 8, and $-2,000 in year 9. Assume a borrowing rate of 15% and an investment rate of 29% per year. The external rate of return is 22.73 %

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

If your goal was to have the largest amount of money in your bank account in two years, which of the following would you choose? (Assume that the beginning deposit and all interest earnings remain in the account for the full two years.) a beginning deposit of $1,010 earning, 3% per a beginning deposit of $950, earning 5% per year a beginning deposit of $930, earning 8% per year a beginning deposit of $1,000, earning 4% per year
GoBulls Media is considering opening a new manufacturing facility to process and mail coupons to 660,000 households in the Tampa Bay area. The new facility will require an initial investment of $240,000 and an annual operating cost of $22,000. It will have a $86,500 salvage value after 5 years. Calculate the Effective annual interest rate of the MARR if the company's minimum attractive rate of return is 5% per year, compounded monthly.
If you contributed $250 to an investment account at age 20, and assuming an average growth rate of 5.50% per year and dividends of 2.50%, how much would you have at age 90?
incremental rate of return analysis MARR = 20% %3| 1st 0=-8000 + 12.886,63(P/A,i*,15) + 533,33(P/Fi",15) I*= ? 2nd 0=-2800 + 864,87(P/A,i",15) + 186,67(P/F,i*,15) 1*= ? 3rd 0=-2960 + 1297,32(P/A,i*,15) + 197,33(P/F,i*,15) |*= ? wie 4th 0=-1040 + 2767,6(P/A,i*,15) + 69,33(P/E.i*,15) I*2 0=-2000 + 2508,13(P/A.i*,15)+ 133,34(P/E.i*,15) I*= ?
One share of Harris, Andrews, and Tatum (HAT) Enterprises was purchased 5 years ago for $10.89. Dividends of 5¢ were paid each quarter over the 5-year period of ownership. The share is sold today for $18.31. Determine the effective rate of return on the stock.
Spectra Scientific of Santa Clara, CA, manufactures Q-switched solid state industrial lasers for LED substrate scribing and silicon wafer dicing. The company got a $70 million loan to be repaid over a 14-year period at 12% per year interest. Determine the amount of the unrecovered balance of the principal immediately after the first payment. The amount of the unrecovered balance of the principal immediately after the first payment is $
Costa Rica Savings Bank issues 100,000 bonds as a response to the Costa Rica Central Bank's initiatives to increase domestic saving. The bonds have a face value of $40,000, a bond interest rate of 8% per year payable annually and a maturity date of 14 years. What is the current price one should pay for this bond, if the market interest rate is 9% per year, compounded annually? Requires to answer these questions using EXCEL spreadsheets. I am clueless went it comes to this subject and using EXCEL formulas so it would help if you provided which formula to use and how to enter it into EXCEL to get the correct answer. Don't just post values it will not help I need Excel formulas to enter in Excel. Thank you!
A town in Wyoming wants to drill a geothermal well to provide district heating steam and hot water for its businesses and residences. After government subsidies, the capital investment for the well is $732,000, and the geothermal well will reduce natural gas consumption for steam and hot water production by $60,000 per year. The salvage value of the well is negligible. The simple payback period for this well is 13 years. If the MARR of the town is 5% per year and the life of the geothermal well is 23 years, what is the IRR for this project? Choose the closest answer below. A. The IRR for the project is 6.1% per year. B. The IRR for the project is 7% per year. O C. The IRR for the project is 7.4% per year. O D. The IRR for the project is 3.9% per year.
Trial and error is the only way to compute the internal rate of return (IRR) when interest is calculated over five or more periods Select one: True False
The prospective exploration for oil in the outer continental shelf by a small, independent drilling company has produced a rather curious pattern of cash flows as follows: EOY Net Cash Flow -$520,000 1-10 $200,000 10 -$1,500,000 The $1,500,000 expenses at EOY 10 will be incurred by the company in dismantling the drilling rig. Customarily, the company expects to earn at least 20% per year on invested capital before taxes. Complete the compounding factors below to determine the ERR. (-520000-1500000( ,20%, 10) ,i%, 10) = 200000(F/ ,20%,10)) (
A bulk materials hauler purchased a used dump truck for %50,000. The operating cost was %5,000 per year, with average revenues of %7,500 per year. After 24 years, the truck was sold for %11,000. The rate of return was closest to; Your answer: 6.6% per year 2.6% per year 4.6% per year 7.6% per year
A certain medical device will result in an estimated $15,000 reduction in hospital labor expenses during its first year of operation. Labor expenses (and thus savings) are projected to increase at a rate of 7% per year after the first year. Additional operating expenses for the device (maintenance, electric power, etc.) are $3,500 annually, and they increase by $250 per year thereafter (i.e., $3,750 in year two and so on). It is anticipated that the device will last for 10 years and will have no market value at that time. If the MARR is 10% per year, how much can the hospital afford to pay for this device? Use an Excel spreadsheet in your solution.