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...
Need help on these homework problems images attached. Disregard the question title I don't know what...
Need help on these homework problems images attached. Disregard
the question title I don't know what happened. Thanks!
at P(1, 1,-1) in the direction of the vector v = ( 4, 5,-272). Homework 3 1. (14 pts) Find an equation of the tangent plane of the function at (x, y) = = (0,4). f(x,y) = e *sin (y) 2. (16 pts) Find the linear approximation of the function at (x,y) = (1, 1) and use it to approximate f(1.1,0.9). b.(4...
Find Equivalent Annual Worth for the following Cash flow if i=3%: Use excel to solve this...
Find Equivalent Annual
Worth for the following Cash flow if i=3%:
Use excel to solve this
question
show formula
Year Cash flow, $ 0 0 1 2 3 4 5 6 7 own 550 $50 350 Step 1. Finding NPV 5110 $130 Step 2. Finding AT 0 1 2 3 4 5 6 7 1 $50 $50 $50 $70 $90 $110 $130
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 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...
QUESTION 7 Select the correct EXCEL programming to compute the net present value of the cash...
QUESTION 7 Select the correct EXCEL programming to compute the net present value of the cash flow stream below. A C D 1 Interest Rate 5% 2 Period CF 4 ($500.00) $100.00 5 6 1 $300.00 7 2 $500.00 $250.00 4 10 11 A. -NPV(C2,C5:C9,1) B. NPV(C2,C5:C9) C. PV(C2, C5:C9) D. C5+NPV(C2,C6:C9) E. NPV(C2,C5:C9,1) 00 9 QUESTION 8 The future value (at the terminal year) of the following cash flow time line (figure below) was computed. (i5% per year) The...
Hey, I need help answering these questions, please provide your reasoning to each thanks! 1. Policymakers...
Hey, I need help answering these questions, please provide your reasoning to each thanks! 1. Policymakers are discussing various proposals regarding how to deal with natural monopolies. Transportation Minister Gaston wants to regulate natural monopolies by equating price with average total cost. Gaston contends that such a policy will ensure that monopolies make every effort to reduce costs. Finance Minister Chen wants the government to own natural monopolies. Chen argues that government-owned monopolies usually do a better job of holding...
Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of...
Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of Money Functions (demonstrated in class) as well as cell references to receive FULL credit. Make sure to set up the data for each problem so you can "point" to the appropriate values in your formulas. Each problem is worth 20 points. This assignment must be completed INDIVIDUALLY. THIS IS NOT A GROUP ASSIGNMENT. The file you submit in CANVAS must be one that YOU...
please i need help The use of which of the following during the Industrial Revolution were...
please i need help
The use of which of the following during the Industrial Revolution were crucial to the modern economic growth that defines society today. O the steam engine -0 the computer O the gas-powered car O the power loom DI Question 42 1.5 pts Which of the following statements about government policy and unemployment are true? OAverage unemployment benefits are equal to about one-half of the wage that the person earned in his or her previous job. 0...
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...
Need help on these homework problems images attached. Disregard
the question title I don't know what happened. Thanks!
at P(1, 1,-1) in the direction of the vector v = ( 4, 5,-272). Homework 3 1. (14 pts) Find an equation of the tangent plane of the function at (x, y) = = (0,4). f(x,y) = e *sin (y) 2. (16 pts) Find the linear approximation of the function at (x,y) = (1, 1) and use it to approximate f(1.1,0.9). b.(4...
Find Equivalent Annual
Worth for the following Cash flow if i=3%:
Use excel to solve this
question
show formula
Year Cash flow, $ 0 0 1 2 3 4 5 6 7 own 550 $50 350 Step 1. Finding NPV 5110 $130 Step 2. Finding AT 0 1 2 3 4 5 6 7 1 $50 $50 $50 $70 $90 $110 $130
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 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...
QUESTION 7 Select the correct EXCEL programming to compute the net present value of the cash flow stream below. A C D 1 Interest Rate 5% 2 Period CF 4 ($500.00) $100.00 5 6 1 $300.00 7 2 $500.00 $250.00 4 10 11 A. -NPV(C2,C5:C9,1) B. NPV(C2,C5:C9) C. PV(C2, C5:C9) D. C5+NPV(C2,C6:C9) E. NPV(C2,C5:C9,1) 00 9 QUESTION 8 The future value (at the terminal year) of the following cash flow time line (figure below) was computed. (i5% per year) The...
Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of Money Functions (demonstrated in class) as well as cell references to receive FULL credit. Make sure to set up the data for each problem so you can "point" to the appropriate values in your formulas. Each problem is worth 20 points. This assignment must be completed INDIVIDUALLY. THIS IS NOT A GROUP ASSIGNMENT. The file you submit in CANVAS must be one that YOU...
please i need help
The use of which of the following during the Industrial Revolution were crucial to the modern economic growth that defines society today. O the steam engine -0 the computer O the gas-powered car O the power loom DI Question 42 1.5 pts Which of the following statements about government policy and unemployment are true? OAverage unemployment benefits are equal to about one-half of the wage that the person earned in his or her previous job. 0...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago