Required information The Chapter 14 Form worksheet is to be used to create your own worksheet...

Transcribed Image Text:

Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the text. 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 148-1 and Exhibit 148-2. (Use appropriate factor(s) from the tables provided.) A B C 2 3 4 1 Chapter 14: Applying Excel Data Example E 5 Cost of equipment needed. $ 320,000 6 Working capital needed $ 55,000 7 Overhaul of equipment in four years $ 25,000 8 Salvage value of the equipment in five years: $ 35,000 9 Annual revenues and costs: 10 Sales revenues $ 380,000 11 Cost of goods sold $ 235,000 12 Out-of-pocket operating costs $ 65,000 13 Discount rate 10% Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the text. 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 148-1 and Exhibit 148-2. (Use appropriate factor(s) from the tables provided.) A B C 2 3 4 1 Chapter 14: Applying Excel Data Example E 5 Cost of equipment needed. $ 320,000 6 Working capital needed $ 55,000 7 Overhaul of equipment in four years $ 25,000 8 Salvage value of the equipment in five years: $ 35,000 9 Annual revenues and costs: 10 Sales revenues $ 380,000 11 Cost of goods sold $ 235,000 12 Out-of-pocket operating costs $ 65,000 13 Discount rate 10%