Question

In: Finance

A capital budget project is estimated to have the following after-tax cash flows, by year: 0...

A capital budget project is estimated to have the following after-tax cash flows, by year:

0

1

2

3

4

-$35,000

$13,000

$15,000

$17,000

$19,000

Use the information in the table above for the following questions 11a. through 11f. The company utilizes a discount rate of 9% to evaluate capital projects. You may have rounding errors in your calculations so choose the closest answer.

1. Find NPV, IRR, MIRR, and PI for the project shown above

2. Find Payback and Discounted Payback

Please show work!

Solutions

Expert Solution

We can calculate the desired result in excel sheet as follows:

Formulas used in the excel sheet are:

The answers are calculated as above which are

1) NPV of the Project = $ 16,139

IRR of the Project = 27.21%

MIRR of the Project = 19.84%

PI of the Project = 46.11%

2) Payback Period of Project = 2.41 years

Discounted Payback period = 2.53 years

Hope I am able to solve your concern. If you are satisfied hit a thumbs up !!


Related Solutions

1)you've estimated the following cash flows (in$) for a project A. B year. cash flow 0...
1)you've estimated the following cash flows (in$) for a project A. B year. cash flow 0 -5,300 1 1,325 2 2,148 3 2,209 what is the IRE for the project 2)you've estimated the following cash flows (in$) for 2 projects: A. B. C.    year. ProjectA. ProjectB 0. -78 -261 1 15 50 2 21 73 3 29 82 4 35 127 the required return is 7% for both projects What is the IRR for project B? What is the...
A project has the following total (or net) after-tax cash flows.                ____________________________________________________         Year&nbs
A project has the following total (or net) after-tax cash flows.                ____________________________________________________         Year             Total (or net) after-tax cash flow                ____________________________________________________                   1 $1,000,000 2 1,500,000 3 2,000,000 4 2,500,000                   _______________________________________________________ The required rate of return on the project is 15 percent. The initial investment (or initial cost or initial outlay) of the project is $4,000,000. a) Find the (regular) payback period of the project. b) Compute the discounted payback period of the project. c) Find...
•You are looking at a new project and you have estimated the following cash flows: Year...
•You are looking at a new project and you have estimated the following cash flows: Year 0: CF = -$150,000 Year 1-2: CF = $80,000 Year 3-4: CF = $50,000 Year 5-6: CF = $30,000 Year 7: CF = -$180,000 Your cost of capital is 10% Please calculate NPV and IRR, and decide whether we should take this project?
Evaluating a capital budgeting project that costs $40,000 that is expected to generate after-tax cash flows...
Evaluating a capital budgeting project that costs $40,000 that is expected to generate after-tax cash flows of $15,000 per year for three years. If the required rate of return is 10 percent calculate the project’s (a) NPV and (b) IRR. Should the project be purchased? This is for a review Please show steps and rationale for project purchase.
what is the net present value of a project with the following after tax cash flows...
what is the net present value of a project with the following after tax cash flows using a discount rate of 10% year 0 45,000 year 1 14,000 year 2 14,000 year 3 10,000 year 4 10,000 year 5 8,000 would you accept the project? ehat is payback period? what is the profitbility index?
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 380 ?$ 380 1 210 280 2 210 280 3 210 280 4 210 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 280 ?$ 280 1 160 180 2 160 180 3 160 180 4 160 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project A Profitability Index Project B
The following are the cash flows of two projects: Year Project A Project B 0 −$...
The following are the cash flows of two projects: Year Project A Project B 0 −$ 290 −$ 290 1 170 190 2 170 190 3 170 190 4 170 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 $...
The following are the cash flows of two projects: Year Project A Project B 0 $ (330) $ (330) 1 160 230 2 160 230 3 160 230 4 160 If the opportunity cost of capital is 12%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project Profitability Index: A B
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 220 ?$ 220 1 100 120 2 100 120 3 100 120 4 100 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT