PLEASE ANSWER USING :

1 - EXCEL

2 - DISPLAY FUNCTIONS/CELLS USED AND PROVIDE ORGANIZED SOLUTION EXPLAINING ANSWER

I WILL UPVOTE YOUR ANSWER

Your firm purchased the current machine it uses to manufacture widgets 3 years ago. The machine cost $545,000 at that time. Today the machine is worth $276,000. The machine could be operated for another 4 years. 4 years from now the old machine will be worth $72,000. The old machine machine generates revenues of $670,000 per year. The old machine has operating costs of $393,000 per year. The firm has a current investment in operating net working capital of $72,000. The firm is thinking about buying a new machine to replace the old machine. The new machine will cost $1,160,000. The new machine can be operated of 4 years. 4 years from now the new machine will have a salvage value of $129,000. The new machine will generate revenues of $854,000 per year. The new machine will have operating costs of $494,000. The new machine requires an investment in operating net working capital of $102,000. The tax rate is 25.0%. The CCA rate is 19%. The required rate of return is 12.0%. What is the present value of the incremental salvage value? Your answer should be correct to two decimal places