Present a viability cash flow table for a chemical plant that purchased equipments with $25million through a loan at a bank interest rate of 10%. The project life is expected to be 5years for a 1year moratorium. Company tax and excise duty are 20% and 5% respectively. Sales at the end of the first year is $11million while the expenditure is 10% of the sales. It is expected that the income will increase 12% yearly, while the expenditure will increase 8% yearly. Calculate the discounted cash flow rate of return of the plant. Write a simple computer program on how to estimate the DCFR showing every necessary step to achieve this.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter12: Capital Investment Decisions
Section: Chapter Questions
Problem 21BEA
Question
Please correct answer and don't use hand raiting
Present a viability cash flow table for a chemical plant that purchased equipments with
$25million through a loan at a bank interest rate of 10%. The project life is expected to be
5years for a 1year moratorium. Company tax and excise duty are 20% and 5%
respectively. Sales at the end of the first year is $11million while the expenditure is 10%
of the sales. It is expected that the income will increase 12% yearly, while the
expenditure will increase 8% yearly. Calculate the discounted cash flow rate of return of
the plant. Write a simple computer program on how to estimate the DCFR showing every
necessary step to achieve this.
Transcribed Image Text:Present a viability cash flow table for a chemical plant that purchased equipments with $25million through a loan at a bank interest rate of 10%. The project life is expected to be 5years for a 1year moratorium. Company tax and excise duty are 20% and 5% respectively. Sales at the end of the first year is $11million while the expenditure is 10% of the sales. It is expected that the income will increase 12% yearly, while the expenditure will increase 8% yearly. Calculate the discounted cash flow rate of return of the plant. Write a simple computer program on how to estimate the DCFR showing every necessary step to achieve this.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub