Question

5-43 A new alloy can be produced by Process A, which costs $200,000 to implement. The operating cost salvage value of $25,000

PLEASE SHOW HOW TO WORK THIS PROBLEM IN EXCEL AND SHOW ALL STEPS, PLEASE.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

8% Compaunded quarterie Interest rate Quarterly interest rate- 2% -D24 Year 2 Year Procoss A Q1 Q2 Q3 Q4 Initial cost -200000

Add a comment
Know the answer?
Add Answer to:
PLEASE SHOW HOW TO WORK THIS PROBLEM IN EXCEL AND SHOW ALL STEPS, PLEASE. 5-43 A new alloy can be produced by Process A...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 3-6 How long will it take for an investment to double at a 6% per year...

    3-6 How long will it take for an investment to double at a 6% per year . (a) simple interest rate (b) compound interest rate Contributed by Hamed Kashani, Saeid Sadri, and Baabak Ashuri, Georgia Institute of Technology

  • 4-84 An engineer will deposit 10% of her salary each year into a retirement fund. If...

    4-84 An engineer will deposit 10% of her salary each year into a retirement fund. If her current annual salary is $95,000 and she expects that it will increase by 6% each year, what will be the present worth of the fund after 30 years if it earns 6% per year? Contributed by Hamed Kashani, Saeid Sadri, and Baabak Ashuri, Georgia Institute of Technology

  • 6-5 6-12 A firm is buying an adjacent 10-acre parcel for a future plant expansion. The...

    6-5 6-12 A firm is buying an adjacent 10-acre parcel for a future plant expansion. The price has been set at $30,000 per acre. The payment plan is 25% down, and the balance 2 years from now. If the transac- tion interest rate is 9% per year, what are the two payments? Contributed by Hamed Kashani, Saeid Sadri, and Baabak Ashuri, Georgia Institute of Technology

  • A sports star can sign a 6-year contract that starts at $12M with increases of $3M...

    A sports star can sign a 6-year contract that starts at $12M with increases of $3M each year for his expected playing career of 6 years. It is also possible to sign a contract that starts at $8M for the first year and then increases at $2M each year for 10 years. (note some income is deferred until after he retires). If his interest rate for the time value of money is 8%, what is the value of each choice?...

  • dont use excel 5.14 Tivo processes can be used for producing a polyuner that reduces friction...

    dont use excel 5.14 Tivo processes can be used for producing a polyuner that reduces friction loss in en. gines. Process K will have a first cost of $160.000, an operating cost of $7000 per quarter, and a salvage value of $40,000 after its 2-yew life. Process I will have a first cost of $210,000, an operating cost of $5000 per quarier, and a $26,000 salvage value after its 4-year life. Which process should be selected on the basis of...

  • 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...

  • 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

  • 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 do this in excel and show all the functions. A new grape press was purchased...

    please do this in excel and show all the functions. A new grape press was purchased for $150,000. The annual operating and maintenance costs for the press are estimated to be $4,000 the first year. These costs are expected to increase by $5,000 each year after the first year. The market value is expected to decrease by $25,000 each year to a value of zero. (Hint: treat the market value as a salvage value.) Installation and removal of a press...

  • Exercise 5 a. A new operating system for an existing machine is expected to cost $520,000...

    Exercise 5 a. A new operating system for an existing machine is expected to cost $520,000 and have a useful life of 6 years. The system yields an incremental after-tax income of $150,000 each year after deducting its straight-line depreciation. The predicted salvage value of the system is $10,000 b. A machine costs $380,000, has a $20,000 salvage value is expected to last 8 years, and will generate an after tax income of $60,000 per year after straight-line depreciation. Compute...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT