A construction company Y is considering to participate in the tendering process for building a toll bridge. The duration of the construction project is 5 years. The successful tenderer is allowed to collect toll from the bridge users after the completion of the project and subsequently will be responsible for maintaining the bridge. The expected cash flow transactions from this project are as follows: • Receive bank loan of RM 2,000,000 now • Annual material expenses of RM 200,000 in year 1 and expected to increase by RM 20,000 per year until year 5 • Annual bridge maintenance cost of RM 70,000 from year 6 until end of bridge life • Annual bank loan payment of RM 500,000 starting from the first year until at the end of year 10 • Progress payment received from the government: RM 4,000,000 (end of year 3) and RM 8,000,000 (end of year 5) • Toll revenue of RM 500,000 per year from year 6 until year 10 a) Construct cash flow diagram to summarize the above transactions. b) Another company is interested in this project and is willing to buy over this project worth RM 1,500,000 now. Should this offer being accepted? Show all your calculations to justify your decision and assume the growth rate is 12% per year.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

A construction company Y is considering to participate in the tendering process for
building a toll bridge. The duration of the construction project is 5 years. The successful
tenderer is allowed to collect toll from the bridge users after the completion of the project
and subsequently will be responsible for maintaining the bridge. The expected cash flow
transactions from this project are as follows:
• Receive bank loan of RM 2,000,000 now
• Annual material expenses of RM 200,000 in year 1 and expected to increase by RM
20,000 per year until year 5
• Annual bridge maintenance cost of RM 70,000 from year 6 until end of bridge life
• Annual bank loan payment of RM 500,000 starting from the first year until at the
end of year 10
• Progress payment received from the government: RM 4,000,000 (end of year 3)
and RM 8,000,000 (end of year 5)
• Toll revenue of RM 500,000 per year from year 6 until year 10


a) Construct cash flow diagram to summarize the above transactions.

b) Another company is interested in this project and is willing to buy over this project
worth RM 1,500,000 now. Should this offer being accepted? Show all your calculations
to justify your decision and assume the growth rate is 12% per year. 

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.