Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the two word questions in the last picture. thank you! (Comprehensive Spreadsheet Problem 11-23 from the end-of-chapter question set) Your division is considering

please answer the two word questions in the last picture. thank you! image text in transcribed
image text in transcribed
image text in transcribed
(Comprehensive Spreadsheet Problem 11-23 from the end-of-chapter question set) Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: vs.. Find the internal rate of return with Excel's IRR function: We find the modified internal rate of return with Excel's MIRR function using the 10% WACC: We find the modified internal rate of return with Excel's MIRR function using the 10% WACC: \begin{tabular}{ll} MIRR A= & 16.50% \\ MIRR B= & 15.57% \\ \hline \end{tabular} roject A Discounted Pavback Period; \begin{tabular}{rc} Time period: & 0 \\ Cash flow: & (30) \\ Disc. cash flow: & ($30) \\ Disc. cum. cash flow: & (30.00) \\ Discounted Payback A: & 3.43 \\ \hline \end{tabular} Project B Discounted Pavback Period: \begin{tabular}{rccccc|c|} \hline Time period: & 0 & 1 & 2 & 3 & 4 \\ \hline Cash flow: & (30) & 20 & 10 & 8 & 6 \\ \hline Disc. cash flow: & (30.00) & 18.18 & 8.26 & 6.01 & 4.10 \\ \hline Disc. cum. cash flow: & (30.00) & (11.82) & (3.55) & 2.46 & 6.55 \\ \hline \end{tabular} Discounted Payback Pas B2.40 b. If the two projects are independent, which project(s) should be chosen? c. If the two projects are mutually exclusive and the WACC is 10%, which project(s) should be chosen? 5 fine far the two projects. Identify the projects' IRRs on the graph

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Trends Of Modernization In Budgeting And Finance

Authors: Denis Ushakov

1st Edition

1522577602,1522577610

More Books

Students also viewed these Finance questions

Question

Which type of energy does an object have when it is in motion?

Answered: 1 week ago

Question

The working principle of a washing machine is?

Answered: 1 week ago

Question

Nuclear sizes are expressed in a unit named?

Answered: 1 week ago