Exercise You work as a production manager in a construction company and your task is to clarify the profitability conditions of the investment to your supervisor. The investment target is a new enterprise resource planning system. You estimate its retention period to be 5 years. The company's interest rate is 10%. You have determined the costs and benefits of the investment below. The investment has no residual value. a) Prepare a cash flow statement b) Calculate the present value of the investment. c) What is the internal interest rate of the investment? d) What is the interest-bearing repayment period of the investment day e) Is the investment profitable? Justify. Use Excel formulas and functions in invoices. Investment equipment €1,000,000 software €300,000 -cabling €10,000 furnishings €25,000 Annual costs personnel costs €280,000 training €20,000 related material €20,000 Annual returns reduction of losses by €300,000 reduction of inventories by €150,000 personnel costs €360,000

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Calculate the task according to the instructions. Show formulas in Excel for each point. Put pictures of the formulas or attach an excel file with solutions.

Exercise
You work as a production manager in a construction company and your task is to clarify the profitability conditions of the investment to your supervisor. The
investment target is a new enterprise resource planning system. You estimate its retention period to be 5 years. The company's interest rate is 10%. You
have determined the costs and benefits of the investment below. The investment has no residual value.
a) Prepare a cash flow statement
b) Calculate the present value of the investment.
c) What is the internal interest rate of the investment?
d) What is the interest-bearing repayment period of the investment day
e) Is the investment profitable? Justify.
Use Excel formulas and functions in invoices.
Investment
equipment €1,000,000
software €300,000
-cabling €10,000
furnishings €25,000
Annual costs
personnel costs €280,000
training €20,000
related material €20,000
Annual returns
reduction of losses by €300,000
reduction of inventories by €150,000
personnel costs €360,000
Transcribed Image Text:Exercise You work as a production manager in a construction company and your task is to clarify the profitability conditions of the investment to your supervisor. The investment target is a new enterprise resource planning system. You estimate its retention period to be 5 years. The company's interest rate is 10%. You have determined the costs and benefits of the investment below. The investment has no residual value. a) Prepare a cash flow statement b) Calculate the present value of the investment. c) What is the internal interest rate of the investment? d) What is the interest-bearing repayment period of the investment day e) Is the investment profitable? Justify. Use Excel formulas and functions in invoices. Investment equipment €1,000,000 software €300,000 -cabling €10,000 furnishings €25,000 Annual costs personnel costs €280,000 training €20,000 related material €20,000 Annual returns reduction of losses by €300,000 reduction of inventories by €150,000 personnel costs €360,000
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning