Application Software Exercise: Spreadsheet Exercise
Not what you're looking for?
Please convert this CAD.doc file into excel with all the formulas. I need this today within three hours (need to see the excel formula involved). By the way, Kevin forgot to answer this question: Is this investment worthwhile? Why or why not?
Business, Finance - Year 1
Application Software Exercise: Spreadsheet Exercise:
Just want double check my calculation - all work must be performed in Excel using Excel built-in formulas. Thanks. (extra credit)
See attached.
Problem: Your Company would like to invest in a new computer-aided-design (CAD) system that requires purchasing hardware, software, and networking technology, as well as expenditures for installation, training, and support. The tables showing each cost component for the new system as well as annual maintenance costs over a five-year period are listed below. You believe the new system will produce annual savings by reducing the amount of labor required to generate designs and design specifications, thus increasing cash flow. Using the data provided and instructions at the Web site for this chapter create a worksheet that calculates the costs and benefits of the investment over a five-year period and analyzes the investment using the six capital budgeting models presented in this Chapter 15. Is this investment worthwhile? Why or why not?
? Payback period - indicate yearly and cumulative figures for years 2005-2009
? Accounting Rate of Return on Investment (ROI). Assume depreciation to be the total initial cost of the investment in Year 0.
? Cost-Benefit Ratio
? Net Present Value, assuming an interest rate of 5%
? Profitability Index
? Internal Rate of Return
See attached.
Thanks, Gary
Purchase this Solution
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Motivation
This tests some key elements of major motivation theories.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.