Assume that Anonas Company is planning to invest P4M in a new project which will provide net cash inflows of P1.5M in 2022, P1.4M in 2023, P1.3M in 2024, P1.2M in 2025 and P1.1M in 2026. The company uses 12% as cost of capital. If the IRR will be computed using Excel Formula, which computation will give the lowest rate?  • IRR • XIRR • MIRR • Answer not given

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 4EB: Assume a company is going to make an investment in a machine of $825,000 and the following are the...
icon
Related questions
Question

Assume that Anonas Company is planning to invest P4M in a new project which will provide net cash inflows of P1.5M in 2022, P1.4M in 2023, P1.3M in 2024, P1.2M in 2025 and P1.1M in 2026. The company uses 12% as cost of capital. If the IRR will be computed using Excel Formula, which computation will give the lowest rate? 
• IRR
• XIRR
• MIRR
• Answer not given

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Future Value
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT