Question

In: Accounting

The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following

A

B

C

1

2

3

4

5

6

7

8

9

10

11

12

13

Chapter 7: Applying Excel    
     
Data    
Example E    
Cost of equipment needed $360,000  
Working capital needed $30,000  
Overhaul of equipment in four years $25,000  
Salvage value of the equipment in five years $30,000  
Annual revenues and costs:    
Sales revenues $430,000  
Cost of goods sold $245,000  
Out-of-pocket operating costs $90,000  
Discount rate 12 %

The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 7B-1 and Exhibit 7B-2. (Use appropriate factor(s) from the tables provided.)

a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.)

c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)?

d. Reset the discount rate to 12%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value?

Solutions

Expert Solution


Related Solutions

2. The company is considering a project involving the purchase of new equipment. Change the data...
2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: A B C 1 Chapter 8: Applying Excel 2 3 Data 4 Example E 5 Cost of equipment needed $160,000 6 Working capital needed $60,000 7 Overhaul of equipment in four years $5,000 8 Salvage value of the equipment in $40,000 9 Annual revenues and costs: 10    Sales revenues $370,000 11    Cost of goods sold $255,000...
2. The company is considering a project involving the purchase of new equipment. Change the data...
2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 12B-1 and Exhibit 12B-2. (Use appropriate factor(s) from the tables provided.) 1 2 3 4 5 6 7 8 9 10 11 12 13 Chapter 12: Applying Excel Data Example E Cost of equipment needed $260,000 Working capital needed $60,000 Overhaul of equipment in four years $20,000 Salvage value of the equipment in five...
A company is considering the purchase of new equipment for its production area. The equipment has...
A company is considering the purchase of new equipment for its production area. The equipment has an initial cost of $ 3,000 with operation and maintenance costs, as well as the market liquidation value as shown in the following table: Year Costs of operation Rescue value 1 $1,000 $1,500 2 $1,700 $1,000 3 $2,400 $500 4 $3,100 $0 Determine the Optimal Economic Life of this investment, if the MARR of the company is 12%
Your company is considering a project which will require the purchase of $685,000 in new equipment....
Your company is considering a project which will require the purchase of $685,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $244,000. Initial net working capital equal to 30.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $715,000 in new equipment....
Your company is considering a project which will require the purchase of $715,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $256,000. Initial net working capital equal to 32.00% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $725,000 in new equipment....
Your company is considering a project which will require the purchase of $725,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $260,000. Initial net working capital equal to 32.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $805,000 in new equipment....
Your company is considering a project which will require the purchase of $805,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $292,000. Initial net working capital equal to 36.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $775,000 in new equipment....
Your company is considering a project which will require the purchase of $775,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $280,000. Initial net working capital equal to 35.00% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $785,000 in new equipment....
Your company is considering a project which will require the purchase of $785,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $284,000. Initial net working capital equal to 35.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $825,000 in new equipment....
Your company is considering a project which will require the purchase of $825,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $300,000. Initial net working capital equal to 37.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT