Homework Answers
Add Answer to:
slove it in excel , show formula
The GEM Company just purchased upgraded CAD software for...
The GEM Company just purchased upgraded CAD software for $20,000 now and annual payments of $600...
The GEM Company just purchased upgraded CAD software for $20,000 now and annual payments of $600 per year for 10 years starting 3 years from now for annual upgrades. What is the present worth in year 0 of the payments if the interest rate is 6% per year? solve it in Excel, shoe formula
3.10 A company purchased new equipment for $250,000 now, that will require annual operations and maintenance...
3.10 A company purchased new equipment for $250,000 now, that will require annual operations and maintenance (O&M) costs of $30,000 per year for 5 years starting 3 years from now. What is the present worth of these costs if the interest rate is 8% per year?
please show all steps for thump up do not excel 4. (20 points) A machine purchased...
please show all steps for thump up
do not excel
4. (20 points) A machine purchased 3 years ago for $140,000 is now too slow to satisfy demand. The machine can be upgraded now for $70,000 (and thus be able to satisfy demand) or be sold to a smaller company for $40,000. After upgrading, the existing machine will have an annual operating cost of $85,000 per year, and an estimated life of 3 years after upgrading you will keep the...
show all steps for thump up no excel 4. (20 points) A machine purchased 3 years...
show all steps for thump up
no excel
4. (20 points) A machine purchased 3 years ago for $140,000 is now too slow to satisfy demand. The machine can be upgraded now for $70,000 (and thus be able to satisfy demand) or be sold to a smaller company for $40,000. After upgrading, the existing machine will have an annual operating cost of $85,000 per year, and an estimated life of 3 years (after upgrading you will keep the machine for...
please dont use excel, show me the formula used 5. Machines that have the following costs...
please dont use excel, show me the formula used
5. Machines that have the following costs are under consideration for a robotized welding process. Using an interest rate of 10% per year, determine which alternative should be selected on the basis of a present worth analysis. Machine X Machine Y First cost, $ Annual operating cost, $ per year Salvage value, $ Life, years - 250,000 --60.000 70.000 -430.000 -40,000 95.000
Solve without excel: 9.17 A piece of imaging equipment was purchased two years ago for $50,000...
Solve without excel:
9.17 A piece of imaging equipment was purchased two years ago for $50,000 with an expected useful life of 5 years and a $5000 salvage value. Since its in- stallation performance was poor, it was upgraded for $20,000 one year ago. Increased demand now requires another upgrade for an additional $22,000 so that it can be used for 3 more years. Its new an- nual operating cost will be $27.000 with a $12,000 salvage after the 3...
Please dont use excel,show me the formula used 7. Compare the alternatives shown below on the...
Please dont use excel,show me the formula used
7. Compare the alternatives shown below on the basis of a future worth analysis, using an interest rate of 8% per year. Р First cost, $ Annual operating cost, $ per year Salvage value, $ Life, years -23.000 -4,000 3,000 -30,000 -2.500 1.000
Can you show me the solutuon by using Excel sheet and Excel formula!? 5. Assume you...
Can you show me the solutuon by using Excel sheet and Excel
formula!?
5. Assume you took out a mortgage of $180,000 and the mortgage is paid off in 15 years. You make annual payments. The coupon rate is 10%. Use excel to amortize the mortgage and determine the interest and principal that is paid during the 9th year of the mortgage. Assume no balloon payment.
*Note: You should form cash flow diagrams and use excel functions to solve following questions. You...
*Note: You should form cash flow diagrams and use excel functions to solve following questions. You should upload your excel files on blackboard and attach the hard copy of them to your HW. Q1: The present worth of the cash flow shown below at į= 10% is? 8 show the formula in excel step by step P ? 0 1 2 3 456 7 A $13,000 Q2: An engineering company in Wyoming that owns 50 hectares of valuable land has...
3. Determine the present worth of a maintenance contract that has a cost of $50,000 in...
3. Determine the present worth of a maintenance contract that has a cost of $50,000 in year 1 and annual increases of 8% per year for 10 years. Use an interest rate of 8% per year. (10 points) Pg=. 2 - 8v. Sop VVVV. 72 70 Now $s < 4. The equivalent present worth of a geometric gradient series of cash flows for 10 years was found to be $19,776. If the interest rate was 15% per year and the...
please show all steps for thump up
do not excel
4. (20 points) A machine purchased 3 years ago for $140,000 is now too slow to satisfy demand. The machine can be upgraded now for $70,000 (and thus be able to satisfy demand) or be sold to a smaller company for $40,000. After upgrading, the existing machine will have an annual operating cost of $85,000 per year, and an estimated life of 3 years after upgrading you will keep the...
show all steps for thump up
no excel
4. (20 points) A machine purchased 3 years ago for $140,000 is now too slow to satisfy demand. The machine can be upgraded now for $70,000 (and thus be able to satisfy demand) or be sold to a smaller company for $40,000. After upgrading, the existing machine will have an annual operating cost of $85,000 per year, and an estimated life of 3 years (after upgrading you will keep the machine for...
please dont use excel, show me the formula used
5. Machines that have the following costs are under consideration for a robotized welding process. Using an interest rate of 10% per year, determine which alternative should be selected on the basis of a present worth analysis. Machine X Machine Y First cost, $ Annual operating cost, $ per year Salvage value, $ Life, years - 250,000 --60.000 70.000 -430.000 -40,000 95.000
Solve without excel:
9.17 A piece of imaging equipment was purchased two years ago for $50,000 with an expected useful life of 5 years and a $5000 salvage value. Since its in- stallation performance was poor, it was upgraded for $20,000 one year ago. Increased demand now requires another upgrade for an additional $22,000 so that it can be used for 3 more years. Its new an- nual operating cost will be $27.000 with a $12,000 salvage after the 3...
Please dont use excel,show me the formula used
7. Compare the alternatives shown below on the basis of a future worth analysis, using an interest rate of 8% per year. Р First cost, $ Annual operating cost, $ per year Salvage value, $ Life, years -23.000 -4,000 3,000 -30,000 -2.500 1.000
Can you show me the solutuon by using Excel sheet and Excel
formula!?
5. Assume you took out a mortgage of $180,000 and the mortgage is paid off in 15 years. You make annual payments. The coupon rate is 10%. Use excel to amortize the mortgage and determine the interest and principal that is paid during the 9th year of the mortgage. Assume no balloon payment.
*Note: You should form cash flow diagrams and use excel functions to solve following questions. You should upload your excel files on blackboard and attach the hard copy of them to your HW. Q1: The present worth of the cash flow shown below at į= 10% is? 8 show the formula in excel step by step P ? 0 1 2 3 456 7 A $13,000 Q2: An engineering company in Wyoming that owns 50 hectares of valuable land has...
3. Determine the present worth of a maintenance contract that has a cost of $50,000 in year 1 and annual increases of 8% per year for 10 years. Use an interest rate of 8% per year. (10 points) Pg=. 2 - 8v. Sop VVVV. 72 70 Now $s < 4. The equivalent present worth of a geometric gradient series of cash flows for 10 years was found to be $19,776. If the interest rate was 15% per year and the...
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