ets (Actual 2020) Taka =10

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter3: Evaluation Of Financial Performance
Section: Chapter Questions
Problem 19P
icon
Related questions
Question

Note: Taka is the currency unit and your answer should be in taka

Use Microsoft Excel to estimate the value per share with FCFF method.
Fixed Assets (Actual 2020) Taka =1011063
(Actual 2020) Taka 4580,000 = sales
Cash Operating Cost 80% of Sales
Depreciation 10% of Fixed Asset
Sales growth rate 10%, 8%, 6%, 5% and 5% for Year 1 through Year 5 respectively. Tax rate 25%
Operating working capital 6% of sales
Volume of Debt Taka 650,000
Number of Common Shares 220,000
Terminal Growth rate of FCFF 4%.
WACC 10%
The firm is running in full capacity.
Make forecasting for 5 years.
(Keep 2 digits after decimal)
Transcribed Image Text:Use Microsoft Excel to estimate the value per share with FCFF method. Fixed Assets (Actual 2020) Taka =1011063 (Actual 2020) Taka 4580,000 = sales Cash Operating Cost 80% of Sales Depreciation 10% of Fixed Asset Sales growth rate 10%, 8%, 6%, 5% and 5% for Year 1 through Year 5 respectively. Tax rate 25% Operating working capital 6% of sales Volume of Debt Taka 650,000 Number of Common Shares 220,000 Terminal Growth rate of FCFF 4%. WACC 10% The firm is running in full capacity. Make forecasting for 5 years. (Keep 2 digits after decimal)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
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
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
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning