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

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