I = 8%
Option A
Initial cost = 8000
Annual operating cost = 500
Annual Benefit = 5500
life = 2 years
As widget molder is required for 6 years, option A will be bought for total of 3 times (EOY0, EOY2 & EOY4)
Present worth for 6 years = -8000 + (5500-500) *(P/A, 8%,6) - 8000 *(P/F,8%,2) - 8000 *(P/F, 8%,4)
= -8000 + 5000*(P/A, 8%,6) - 8000 *(P/F,8%,2) - 8000 *(P/F, 8%,4)
= -8000 + 5000*4.622879 - 8000 *0.8573388 - 8000 *0.7350298
= 2375.45
Option B
Initial cost = 15000
Annual operating cost = 1250
Annual benefit = 7250
Life = 3 years
As widget molder is required for 6 years, option B will be bought for total of 2 times (EOY0 & EOY3)
Present worth for 6 years = -15000 + (7250 - 1250)*(P/A, 8%,6) - 15000 *(P/F,8%,3)
= -15000 + 6000*(P/A, 8%,6) - 15000 *(P/F,8%,3)
= -15000 + 6000*4.622879 - 15000 *0.7938322
= 829.79
Option A should be chosen as it has more present value
It is economic engineering question. Please calculate using net present analysis. Don’t use excel. Write clear...
Engineering Economic Analysis. Please do out, not excel.
9-13. Use the PW method to select the better of the following alternatives: Annual Expenses Alternative A Alternative B Defender: Challenger: Labor Material insurance and S300,000 S250,000 250,000 4% of initial 100.000 None property taxes capital investment Maintenance Leasing cost $8,000 None None $100,000 Assume that the defender was installed five years ago. The MARR is 10% per year. (97) Definition of alternatives: A: Retain an already owned machine (defender) in service...
"Engineering Economics"
How do you solve this using excel?
1. A machine costs $35,000 to buy and $5,000 per year to operate and maintain. It will have a salvage value of $8,000 in 9 years. It will generate $10,000 per year in net revenue for the first four years, and then the revenue will fall by $1,000 each year after. If the company purchasing the machine uses a MARR of 7% to make project, find the NPW, NEW, and AW....
Please don’t use Excel and do all the parts of the questions. Show
your work!!!
Problem 1 Greg borrowed $100,000 to purchase a house. He agreed to repay the loan with equal monthly payments over a 30 year period at a nominal annual rate of 6 percent. a. What would be his monthly payment? b. What is the effective annual interest rate on the loan? c. Consider a closing fees of $2,000 on the loan. If he chooses to finance...
PLEASE WITH
EXCEL MICROSOFT PROGRAM!!!!!!!
Objective: This activity has the purpose of helping students calculate the benefit - cost ratio of each alternative and select the best alternative using the software Microsoft Excel. (Objective 4) Student Instructions: Read example to be used to compute the Benefit - Cost ratio. Textbook problem 10 - 4 (Sullivan W., Wicks E., and Patrick C.), page 468: A retrofitted space- heating system is being considered for a small office building. The system can be...
please help with question #12.24 without using
excel.
net present worth of this investment. Contributedby value, and Assume unit 444 CHAPTER 12: INCOME TAXES FOR CORPORATIONS Mukasa Ssemakula, Wayne State University (b) Explain why the rate of return obtained in part (a) is different from the rate of return obtained in Problem 12-20. 12-25 A firm has invested $400.000 in car- ment. They will depreciate the r-washing equip equipment by 6% (a) Comput (b) Comput MACRS G MACRS, assuming a...
I could really use some help with this system analysis question
I got. Thank you!!!!
Using the following data, create a table similar to the one at the
bottom of the page. Note that there are 8 years of data here vs. 5
years in the table. You will have to add the extra 3 years to your
table. There is also a different discount factor for each
year.
Calculate the net present value, the payback period, and the return...
Please help solving the 3 questions
1) Use EXCEL to calculate the net present value of the proposed
2020 Noble Rascal release. Assume that increases in profits are
realised at the end of each month. The cost of capital for Orange
Wines is 4.73% per year compounded monthly.
2) To gauge the viability of the Cellar Door press release, you
need to know how long it will take for Orange Wines to completely
recoup the initial outlay of $95,000. You...
Cost benefit analysis for the
Long Engineering Company
The Long Engineering Company (LEC) has decided to install a network
system to help their technical support engineers (five of them who
earn an average of $100,000 each per year) to deliver better
customer service including: mail out sales and other literature,
answer phone calls for technical assistance and log and forward
repair requests using an alpha-numeric paging system that will be
part of the new network system. Currently all company...