HW6_Nadia_khan_929

xlsx

School

Ohio State University *

*We aren’t endorsed by this school

Course

2040

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

26

Uploaded by MateMongoose3388

Report
Year Cash Flow 0 -650000 1 225000 2 225000 3 225000 4 225000 5 225000 6 225000 7 225000 8 225000 9 225000 10 295000 IRR 32.79% Problem 7.7 If a manufacturer of electronic devices invests $650,000 in equipment for making compact pie purpose vibration measurement, estimate the rate of return from revenue of $225,000 per ye value from the used equipment sale in year 10. Solve with spreadsheet functions. Enter the IRR from the spreadsheet function, without a % sign (For example, for an IRR of 15.5
ezoelectric accelerometers for general ear for 10 years and $70,000 in salvage 5%, enter 15.5 into the answer field)
Year 0 1 2 3 4 5 6 7 8 IRR 7.11 Determine the rate of return for the following cash flow series in the problem Enter the IRR without the percent sign, xx.x
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cash Flow -4000 0 -300 -300 -300 -300 -100 -100 11900 11.67%
Year Cash Flow 0 -130000 1 29000 2 30000 3 31000 4 32000 5 33000 6 34000 7 35000 8 59000 IRR 19.17% Problem 7.17 Barron Chemical uses a thermoplastic polymer to enhance the appearance of certain RV panels. Th $130,000 with annual costs of $49,000 and revenues of $78,000 in year 1, increasing by $1000 per was realized when the process was discontinued after 8 years. What rate of return did the company trial and error or verify i* by spreadsheet. Enter IRR into Carmen without the % sign, xx.x
he initial cost of one process was year. A salvage value of $23,000 y make on the process? Solve by
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
A 10000 PV 90000 i = A/PV 11.11% Problem 7.19 Aloma, a university graduate who started a successful business, wants to start an endowment in her n provide scholarships to IE students. She wants the scholarship to provide $10,000 per year and expec awarded on the day she fulfills the endowment obligation. If Aloma plans to donate $100,000, what r the university realize in order to award the $10,000 per year scholarship forever? Enter the IRR without the % sign, xx.x
name that will cts the first one to be rate of return must
Year Cash Flow i 0.08 0 -8200 Face Value 10000 1 800 2 800 3 800 4 800 5 10800 IRR 13.13% Problem 7.46 A mortgage bond issued by Automation Engineering is for sale for $8200. The bond has a face value o with a coupon rate of 8% per year, payable annually. What rate of return will be realized if the purcha the bond to maturity 5 years from now? Enter the IRR without the % sign (xx.x)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
of $10,000 aser holds
Year Cash Flow 0 -9250 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 13 0 14 0 15 0 16 0 17 0 18 50000 Rate 9.83% Problem 7.47 An engineer planning for his child’s college education purchased a zero-coupon corporate bond (i. bond that has no dividend payments) for $9250. The bond has a face value of $50,000 and is due years. If the bond is held to maturity, determine the i* for the investment. Enter the IRR without the % sign, xx.x
.e., a in 18
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
FV 10000 i 0.08 PV -9200 n 7 a) ROR 3 months 2.40% b) ROR per year 9.58% Problem 7.51 A $10,000 mortgage bond with a bond interest rate of 8% per year, payable quarterly, was purc The bond was kept until it was due, a total of 7 years. What rate of return was made by the pur (a) per 3 months? (b) per year (nominal)?
chased for $9200. rchaser:
Year Ford Cash Flow Toyota Cash Flow Toyota - Ford 0 -30900 -36400 -5500 1 0 0 600 2 0 0 600 3 15450 21840 6990 IRR 15.55% Problem 8.19 A consulting engineering firm’s CFO wants to purchase either Ford Explorers or Toyota 4Runners for com models under consideration cost $30,900 for the Ford and $36,400 for the Toyota. When considering lif Explorer is expected to be $600 per year more than that of the 4Runner. The trade-in values after 3 yea the first cost for the Explorer and 60% for the 4Runner. (a) What is the incremental ROR between the tw firm’s MARR is 18% per year, which vehicle should it buy?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
mpany principals. The two fe-cycle costs, the AOC of the ars are estimated to be 50% of wo vehicles? (b) Provided the
i a) b) Year P Q Q-P Year P 0 -18000 -35000 -17000 0 -18000 1 -4000 -3600 400 1 -4000 2 -4000 -3600 400 2 -4000 3 -21000 -3600 17400 3 -3000 4 -4000 -3600 400 4 5 -4000 -3600 400 5 6 -3000 -900 2100 6 NPV ($47,628.92) ($49,154.86) NPV ($27,196.09) AW ($10,935.95) ($11,286.32) AW ($10,935.95) FV ($84,377.54) ($87,080.83) IRR 6.84% Problem 8.25 A solid-waste recycling plant is considering two types of storage bins using an MARR of 10% per year. (a) Use ROR evaluation to determine which should be selected. (b) Confirm the selection using the regular AW method at MARR = 10% per year.
0.1 Q -35000 -3600 -3600 -3600 -3600 -3600 -900 ($49,154.86) ($11,286.32) r
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
n 8 Year A B C D D-C i 0.11 0 -30000 -36000 -41000 -53000 -12000 1 4000 5000 8000 10500 2500 Defender Challenger 2 4000 5000 8000 10500 2500 DN A 3 4000 5000 8000 10500 2500 DN B 4 4000 5000 8000 10500 2500 DN C 5 4000 5000 8000 10500 2500 C D 6 4000 5000 8000 10500 2500 7 4000 5000 8000 10500 2500 8 5000 7000 8500 8500 0 IRR 2.12% 3.43% 11.26% 11.09% 10.43% Problem 8.31 A metal plating company is considering four different methods for recovering by-product heavy metals from a manufacturing site’s liquid waste. The investment costs and annual net incomes associated with each method have been estimated. All methods have an 8-year life; the MARR is 11% per year; and an AW-based ROR analysis is required. (a) If the methods are independent (because they can be implemented at different plants), which ones are acceptable? (b) If the methods are mutually exclusive, determine which one should be selected.
Defender 8 10 10 20 Size 8 Size 10 Size 15 Size 20 Size 25 Size 10 - 8 Size 15 - 10 0 -30000 -34000 -38000 -48000 -57000 -4000 -4000 1 12500 14500 15500 19500 23000 2000 1000 2 12500 14500 15500 19500 23000 2000 1000 3 12500 14500 15500 19500 23000 2000 1000 4 12500 14500 15500 19500 23000 2000 1000 5 14500 17000 18500 23000 27600 2500 1500 IRR 31.67% 32.97% 30.75% 30.46% 30.23% 42.35% 10.93% Problem 8.33 A recent graduate who wants to start an excavation/earth-moving business is trying to determine which size of used dump truck to buy. He knows that as the bed size increases, the net income increases, but he is uncertain whether the incremental expenditure required for the larger trucks is justified. The cash flows associated with each size truck are estimated below. The contractor has established a MARR of 18% per year, and all trucks are expected to have a remaining economic life of 5 years. (a) Determine which size truck he should purchase. (b) If two trucks are to be purchased, what should be the size of the second truck?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Challenger 10 15 20 25 Size 20 - 15 Size 25 - 20 -10000 -9000 4000 3500 4000 3500 4000 3500 4000 3500 4500 4600 29.37% 28.99%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
a) A C b) Defender Challenger DN A A B A C A D c) A Problem 8.37 The four alternatives described below are being evaluated by the rate of return method. (a) If the proposals are independent, which should be selected at a MARR of 16% per year? (b) If the proposals are mutually exclusive, which one should be selected at a MARR of 9% per year? (c) If the proposals are mutually exclusive, which one should be selected when the MARR is 12% per year?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year Pessimistic Optimistic i 0.2 0 -850000 -850000 1 290000 325000 2 290000 325000 3 290000 325000 4 290000 325000 5 290000 325000 NPV $17,277.52 $121,948.95 AW $5,777.25 $40,777.25 IRR 20.92% 26.37% > 20% Problem 18.1 Decker Scientific is considering an investment of $850,000 in a new product line. The company will make the investment only if it will result in a rate of return of 20% per year or higher. If the revenue is expected to be between $290,000 and $325,000 per year for each of 5 years, determine if the decision to invest is sensitive to the projected range of income using an annual worth analysis.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help