Homework Help is Here – Start Your Trial Now!
Business
Finance
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 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) A C 1. Chapter 14: Applying Excel 2 3 Data 4 Example E Cost of equipment needed 6 Working capital needed 7. 320,000 55,000 Overhaul of equipment in four years 24 25,000 8 Salvage value of the equipment in five years Annual revenues and costs: 35,000 9. %24 380,000 235,000 10 Sales revenues 11 Cost of goods sold 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 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) A C 1. Chapter 14: Applying Excel 2 3 Data 4 Example E Cost of equipment needed 6 Working capital needed 7. 320,000 55,000 Overhaul of equipment in four years 24 25,000 8 Salvage value of the equipment in five years Annual revenues and costs: 35,000 9. %24 380,000 235,000 10 Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 65,000 13 Discount rate 10 %

Accounting Information Systems
Accounting Information Systems
11th Edition
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Chapter5: Database Management System
Section: Chapter Questions
Problem 13P: Use the Internet to research knowledge management systems. Specifically, (1) find one example of a...
See similar textbooks
icon
Related questions
Question
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 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) A B 1 Chapter 14: Applying Excel 2 3 Data 4 Example E Cost of equipment needed 6 Working capital needed 320,000 55,000 Overhaul of equipment in four years 25,000 8 Salvage value of the equipment in five years 35,000 Annual revenues and costs: 10 380,000 235,000 65,000 10 % Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate
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 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) A B 1 Chapter 14: Applying Excel 2 3 Data 4 Example E Cost of equipment needed 6 Working capital needed 320,000 55,000 Overhaul of equipment in four years 25,000 8 Salvage value of the equipment in five years 35,000 Annual revenues and costs: 10 380,000 235,000 65,000 10 % Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate
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.) Net present value 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.)? The internal rate of return is between and d. Reset the discount rate to 10%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minimum salvage value required to generate a positive prosent valuo
Transcribed Image Text: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.) Net present value 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.)? The internal rate of return is between and d. Reset the discount rate to 10%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minimum salvage value required to generate a positive prosent valuo
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Information system controls
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Accounting Information Systems
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q…
Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
SWFT Essntl Tax Individ/Bus Entities 2020
SWFT Essntl Tax Individ/Bus Entities 2020
Accounting
ISBN:
9780357391266
Author:
Nellen
Publisher:
Cengage
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
SEE MORE TEXTBOOKS