Our company is considering to start a new product. We must choose between 3 options. Use Excel to decide which option to choose (if any). o Option 1 costs $10,000 and will earn $2000 annually O Option 2 costs $15,000 and will earn $2750 annually Option 3 costs $20,000 and will earn $3500 annually O Letâ€™Ms define the lifetime of the products as 30 years. In Excel, construct a table and graph of the 3 Present Worths versus interest rate Summarize in a table at which range one is preferred ovzer the other

Our company is considering to start a new product. We must choose between 3 options. Use Excel to decide which option to choose (if any). o Option 1 costs $10,000 and will earn $2000 annually O Option 2 costs $15,000 and will earn $2750 annually Option 3 costs $20,000 and will earn $3500 annually O Letâ€™Ms define the lifetime of the products as 30 years. In Excel, construct a table and graph of the 3 Present Worths versus interest rate Summarize in a table at which range one is preferred ovzer the other

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

.ull Globe ? © 82% 8:21 AM Compoulations, aliswtI 5 WIII NE ITva mu. Make sure to put your name on the left side corner of your excel file. 61-70. Compute for AP and MP INPUT ТР MP (5PTS) АP (5PTS) 1 8. 20 3 37 4 57 72 6 80 7 85 8 88 86 10 82 1 Add file A docs.google.com
Lewis’s management has been considering movingto a new downtown location, and they are concerned that these plans may come to fruition priorto the equipment lease’s expiration. If the moveoccurs then Lewis would buy or lease an entirelynew set of equipment, so management wouldlike to include a cancellation clause in the leasecontract. What effect would such a clause haveon the riskiness of the lease from Lewis’s standpoint? From the lessor’s standpoint? If you werethe lessor, would you insist on changing any ofthe other lease terms if a cancellation clause wereadded? Should the cancellation clause containprovisions similar to call premiums or any restrictive covenants and/or penalties of the type contained in bond indentures? Explain your answer.
Kiwidale Dairy is considering purchasing a new ice-cream maker. Two models, Smoothie and Creamy, are available and their information is given below. (perform all calculation using 5 significant figures, and give your final answer to 1 decimal place). (a) What is Kiwidale's MARR that makes the two alternatives equivalent? Use a present worth comparison. Smoothie 17,000 Creamy 40,000 12 years 12,000 3,920 5,400 First Cost Service Life Annual profit Annual operating cost Salvage value A MARR which makes the two alternatives equivalent in term of PW is 12 years 4,800 1,200 2,450
13.12 You work for Bellevue Window Products. While performing an analysis for a new window prod- uct, you found a report from last year that pro- vided the following information regarding the manufacture of a similar product: annual produc- tion rate T 40,000 units; selling price = $70 per unit; fixed production cost = $240,000 per year; variable production cost = $1,700,000 per year; variable selling expenses = $96,000 per year. As a first-cut, you decide to use this information to estimate (a) the breakeven production rate per year, (b) the company's profit last year, and (c) the annual production rate that would generate a profit of $1,000,000 per year. What are your estimates?
Cost component Alpha Beta Charlie development 100,000 immediately 150,000 year 1 10,000 immediately None Programming 45,000 immediately 35,000 year 1 45,000 immediately 30,000 year 1 None Operations 50,000 1-10 80,000 years 1-10 150,000 years 1-10 support 30,000 1-10 40,000 years 1-10 none If each system is expected to have a 10-year life, 1. calculate the net present value for each system if the cost of capital is 8%. 2. Specify which system should be selected and why
Benjamin receives an annual bonus of $1,000 and wants to invest it in an account that earns interest for the next 3 years. Below are the two options that he is considering putting his money into. Which of the following statements is true? NEED ASAP PLS. Benjamin receives an annual bonus of $1,000 and wants to invest it in an account that earns interest for the next 3 years. Below are the two options that he is considering putting his money into. Which of the following statements is true? Bank A 5% Simple Interest Bank B 5% Interest Compounded Annually Simple Interest: /= Prt; Compound interest A=P(1+r): After 3 years, Bank B will pay Benjamin $1875 more than Bank B. After 3 years, Bank B will pay Benjamin $3000 more than Bank A. After 3 years, Bank B will pay Benjamin $1007.63 more than Bank A. After 3 years, Bank B will pay Benjamin $7.63 more than Bank A. After 3 years, Bank A will pay Benjamin $10.13 less than Bank B.
Activity 3 mid1. Consider Option A and Option BFill-up the table Below for the Future Value and the Present value?Assume an initial Value of 15,000 pesos. a) Option A (FV) 5YRS 10YRS 25YRS 30YRS 1% 5% 10% 20% b) Option B (PV) 5YRS 10YRS 25YRS 30YRS 1% 5% 10% 20%
Johnson Controls spent more than $2.5 millionretrofitting a government complex and installing acomputerized energy-management system for theState of Massachusetts. As a result, the state’s energybill dropped from an average of $6 million a yearto $3.5 million. Moreover, both parties will benefitfrom the 10-year life of the contract. Johnson recovers half the money it saved in reduced utility costs(about $1.2 million a year over 10 years); Massachusetts has more money to spend on other things. Whatis the rate of return realized by Johnson Controls inthis energy-control system?
A contractor has a contract to construct a 12,000-ft-long tunnel in 30 months. He is trying to decide whether to do the job with his own forces or subcontract the job. He asks you to calculate the equivalent monthly cost of each alternative. His i = 1 percent per month. Production under both alternatives will be 300 ft per month. Alternative A Buy a tunneling machine and work with contractor’s own forces. cost of tunneling and machine = $ 2,400,000 paid now salvage value of machine at EOM 30 = $ 540,000 cost of labor and materials = $ 250/ft for the first 10 months, increasing by 0.5%/month at EOM each month thereafter Alternative B Subcontract the work. Cost $500 per foot of advance of the tunnel heading, for the full 12,000 ft.
58 If I invest $52,000 today for 6 years and it grows to $82,524, what rate of interest have I received? Multiple Choice O O O O 12% 6% 8% 16% NOV 16 ST all
101 Use the following information to answer the question which immediately follows Y = 2,000, GT-200, Cd=400 +0.9(Y-T) - 600r, 1200-80r, L-0.5Y 500, M-5000, P-7.35, n² = 0.02 What is the value of r? Select one a 0.58 Ob. 0.45 OC 0.62 Od 0.38 13
Fact 21 Eileen has 2.5% of her earnings deposited into her retirement plan. If $150 per month is deposited in the plan, find ner monthly and yearly earnings. 8. Her monthly earnings are $ (Round to the nearest cent as needed.) Her yearly earnings are $ (Round to the nearest cent as needed.) 09 C.SU7 365 https://xlitemprod.pearsoncmg.com/api/v1/print/math