I need help with these engineering economy homework problems. Use Microsoft Excel to solve these following problems with the following column headers.
Homework Answers
1)
NPV ( without snap ) = $12.9 million
2) Annual worth ( without snap ) = $6.52 million
3) Annual worth ( with snap ) = $5.92 million
Add Answer to:
I need help with these engineering economy homework problems.
Use Microsoft Excel to solve these following...
Hello! I need help solving these problems for engineering economy. Please show the full solution and...
Hello! I need help solving these problems for engineering
economy. Please show the full solution and all work for
BOTH PROBLEMS. please write neatly and large (the
resolution of photos on the site are low). please be as detailed as
possible and answer BOTH questions. Thank you
8. Find the present equivalent worth for the following cash flow diagram if the interest rate is 20%. compounded every three months 1500 1200 900 600 300 6 789 10 300 600 900...
Edit: Please do not use Excel as I need to learn to solve without it. thank...
Edit: Please do not use Excel as I need to learn to solve without
it. thank you.
Problem 4 After paying $3 million for a feasibility study, Stanley wrote a proposal with the following cash flow estimates for a 25-year capital project. Equipment cost: $34 million, Shipping costs: $1 million, Installation: S19 million, Salvage: $4, Working capital investment: $2 million, Revenues are expected to increase by $20 million per year and cash operating expenses by $9 million per year. The...
I just need help solving for alternative B, I think maybe I am just doing the...
I just need help solving for alternative B, I think maybe I am
just doing the formula wrong to solve it, so any and all assistance
would be appreciated.
An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost...
I only need help with doing Part C manually 4-1 You are considering three mutually exclusive...
I only need help with doing Part C manually
4-1 You are considering three mutually exclusive design alternatives. Do nothing is also an option. MARR is 15%. A B Category First cost, $ Annual Expense, $/yr Annual revenue, $/yr Salvage value, $ Useful life, yrs ROR 26,000 12,500 20,000 5,000 10 26.60% 52,000 12,000 25,000 9,000 10 22.13% 40,000 21,000 29,000 8,000 10 16.30% a. What is the present worth of each alternative? Which would you choose? b. Perform an...
Please help!!! Engineering Economics class homework!! attached below are the tables needed!! first picture is alterna...
Please help!!! Engineering Economics class homework!!
attached below are the tables needed!! first picture is
alternative options, second picture is i=9% values, third picture
is i=18% values!!!
Potable water is in short supply in many countries. To address this need, two mutually exclusive water purification systems are being considered for implementation in China. Doing nothing is not an option. Assume the repeatability of cash flows for alternative 1. a. Use the PW method to determine which system should be selected...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
I need help answering questions 9-1 thru 9-7. Step by step would be very appreciated. Problems...
I need help answering questions 9-1 thru 9-7. Step by step
would be very appreciated.
Problems 9-1 If you invest $500 today in an account that pays 6 percent interest compounded nnually, how much will be in your account after two years? What is the present value of an investment that promises to pay you $1,000 in five years if you can earn 6 percent interest compounded annually? 9-2 9-3 What is the present value of $1,552.90 due in 10...
I just need help with Part B. Please DON'T use Excel, and show all calculations. Thank...
I just need help with Part B. Please
DON'T use Excel, and show all calculations. Thank
you in advance.
Net Cash Flow Project 3 Project 1 $1,400 Project 2 0 -$1,400 -$1,400 1 2,900 1,970 1,070 2,000 400 2 930 Single Payment Compound Amount Equal Payment Series Capital Recovery Factor Present Compound Amount Sinking Fund Present Worth Worth Factor Factor Factor Factor Factor (FIP, i, N) (P/F, i, N) (FIA, i, N) (A/F, i, N) (P/A, i, N) (A/P, i,...
i need help worh this problem please Homework (Ch 14) Attempts: Average: 12 6. Individual Problems...
i
need help worh this problem please
Homework (Ch 14) Attempts: Average: 12 6. Individual Problems 14-6 At a student cafe, there are equal numbers of two types of customers with the following values. The café owner cannot distinguish between the two types of students because many students without early classes arrive early anyway (le, she cannot price.discriminate). Students with Early Classes Students without Early Classes Coffee 73 Banana 48 The marginal cost of coffee is 5 and the marginal...
Hello! I need help solving these problems for engineering
economy. Please show the full solution and all work for
BOTH PROBLEMS. please write neatly and large (the
resolution of photos on the site are low). please be as detailed as
possible and answer BOTH questions. Thank you
8. Find the present equivalent worth for the following cash flow diagram if the interest rate is 20%. compounded every three months 1500 1200 900 600 300 6 789 10 300 600 900...
Edit: Please do not use Excel as I need to learn to solve without
it. thank you.
Problem 4 After paying $3 million for a feasibility study, Stanley wrote a proposal with the following cash flow estimates for a 25-year capital project. Equipment cost: $34 million, Shipping costs: $1 million, Installation: S19 million, Salvage: $4, Working capital investment: $2 million, Revenues are expected to increase by $20 million per year and cash operating expenses by $9 million per year. The...
I just need help solving for alternative B, I think maybe I am
just doing the formula wrong to solve it, so any and all assistance
would be appreciated.
An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost...
I only need help with doing Part C manually
4-1 You are considering three mutually exclusive design alternatives. Do nothing is also an option. MARR is 15%. A B Category First cost, $ Annual Expense, $/yr Annual revenue, $/yr Salvage value, $ Useful life, yrs ROR 26,000 12,500 20,000 5,000 10 26.60% 52,000 12,000 25,000 9,000 10 22.13% 40,000 21,000 29,000 8,000 10 16.30% a. What is the present worth of each alternative? Which would you choose? b. Perform an...
Please help!!! Engineering Economics class homework!!
attached below are the tables needed!! first picture is
alternative options, second picture is i=9% values, third picture
is i=18% values!!!
Potable water is in short supply in many countries. To address this need, two mutually exclusive water purification systems are being considered for implementation in China. Doing nothing is not an option. Assume the repeatability of cash flows for alternative 1. a. Use the PW method to determine which system should be selected...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
I need help answering questions 9-1 thru 9-7. Step by step
would be very appreciated.
Problems 9-1 If you invest $500 today in an account that pays 6 percent interest compounded nnually, how much will be in your account after two years? What is the present value of an investment that promises to pay you $1,000 in five years if you can earn 6 percent interest compounded annually? 9-2 9-3 What is the present value of $1,552.90 due in 10...
I just need help with Part B. Please
DON'T use Excel, and show all calculations. Thank
you in advance.
Net Cash Flow Project 3 Project 1 $1,400 Project 2 0 -$1,400 -$1,400 1 2,900 1,970 1,070 2,000 400 2 930 Single Payment Compound Amount Equal Payment Series Capital Recovery Factor Present Compound Amount Sinking Fund Present Worth Worth Factor Factor Factor Factor Factor (FIP, i, N) (P/F, i, N) (FIA, i, N) (A/F, i, N) (P/A, i, N) (A/P, i,...
i
need help worh this problem please
Homework (Ch 14) Attempts: Average: 12 6. Individual Problems 14-6 At a student cafe, there are equal numbers of two types of customers with the following values. The café owner cannot distinguish between the two types of students because many students without early classes arrive early anyway (le, she cannot price.discriminate). Students with Early Classes Students without Early Classes Coffee 73 Banana 48 The marginal cost of coffee is 5 and the marginal...
Most questions answered within 3 hours.
-
Walgreen Company (NYSE: WAG) is currently trading at $48.50 on
the NYSE. Walgreen Company is also...
asked 7 minutes ago -
Based on historical data, your team knows what proportion of the
company's orders come from Males...
asked 25 minutes ago -
8. Which of the following atoms has the largest magnitude
electron affinity?
(a) Sodium (Na)
(b)...
asked 27 minutes ago -
Assess the two types of tests of cognitive abilities. (
regarding HR course)
asked 32 minutes ago -
1.Write an inspiring vision statement for an organization where
you work or have worked. If the...
asked 33 minutes ago -
2. Is fair trade coffee sustainable for the mass market,
or is it a niche product...
asked 34 minutes ago -
Please answer this asap in MATLAB.
In the following for loop, the the loop is executed...
asked 46 minutes ago -
A 50.0-g golf ball is driven from the tee with an initial speed
of 44.6 m/s...
asked 41 minutes ago -
Use the molar concentration of the 50 mL solution to calculate
the moles of Cr(III) in...
asked 44 minutes ago -
Calculate the molarity of Fe3+ in solution A.
Solution A: 10 mL of 0.0600 M Fe(No3)3 ...
asked 52 minutes ago -
two dogs pull 2 strings horizontally which are tied to a sleigh.
the angle between the...
asked 53 minutes ago -
please write a paper about any ethical violation based on the
case study Stanford's Prison Experiment....
asked 1 hour ago