Homework Answers
Using excel formula
| Year | 0.00 | 1 | 2 | 3 | 4 | 5 |
| Project A | -220000 | 60000 | 70000 | 85000 | 70000 | 50000 |
| Cumulative Cash flow | -220000.00 | -$160,000.00 | -$90,000.00 | -$5,000.00 | $65,000.00 | $115,000.00 |
| Payback Period | 3.07 | |||||
| excel formula | (3+5000/7000) | |||||
| Year | 0.00 | 1 | 2 | 3 | 4 | 5 |
| Project A | -220000 | 60000 | 70000 | 85000 | 70000 | 50000 |
| Discounted Cash Flow | -220000.00 | 55045.87 | 58917.60 | 65635.60 | 49589.76 | 32496.57 |
| Cumulative Cash flow | -220000.00 | -$164,954.13 | -$106,036.53 | -$40,400.93 | $9,188.83 | $41,685.40 |
| Discounted Payback Period | 3.81 | |||||
| excel formula | 3+40400.93/49589.76 | |||||
USing excel to calculate NPV and PI
| A | |||
| Project A | |||
| 1 | Year | Cash Flow | |
| 2 | 0 | -220000 | |
| 3 | 1 | 60000 | |
| 4 | 2 | 70000 | |
| 5 | 3 | 85000 | |
| 6 | 4 | 70000 | |
| 7 | 5 | 50000 | |
| NPV | $261,686.40 | ||
| Excel formula | NPV(9%,A3:A7)+A2 | ||
| PI | $2.19 | ||
| Excel formula | (1+261686.50/220000) | ||
Since NPV is positive project should be accepted
Add Answer to:
1. A company is considering a project, Project A. The established time horizon to recover the...
You are considering a project that will require an initial outlay of $200,000. This project has...
You are considering a project that will require an initial outlay of $200,000. This project has an expected life of four years and will generate after-tax cash flows to the company as a whole of $60,000 at the end of each year over its five-year life. Thus, the free cash flows associated with this project look like this: Year Free Cash Flow 0 -150,000 1 60,000 2 60,000 3 60,000 4 60,000 Given a required rate of return of 10%...
QUESTION 1 Star Industries is considering three alternative projects for the company's investment. The cash flows for three independent projects are as follows: Year 1 Project A ($50,000) $10,...
QUESTION 1 Star Industries is considering three alternative projects for the company's investment. The cash flows for three independent projects are as follows: Year 1 Project A ($50,000) $10,000 $15,000 $20,000 $25,000 $30,000 Project B ($100,000) $25,000 $25,000 $25,000 $25,000 $25,000 Project C ($450,000) $200,000 $200,000 $200,000 a) If the discount rate for all three projects is 9.5 percent, calculate the profitability index (PI) of these three projects. Which project will be accepted if the projects are mutually exclusive? b)...
Newfoundland Vintners Co-operative is considering two mutually exclusive projects: Absinth and Brandy. Project Absinth requires a...
Newfoundland Vintners Co-operative is considering two mutually exclusive projects: Absinth and Brandy. Project Absinth requires a $20,000 cash outlay today and is expected to generate after-tax cash flows of $11,000 in year 1, $8,500 in year 2, and $7,500 in year 3. Project Brandy requires a $30,000 cash outlay today and is expected to generate after-tax cash flows of $7,000 in year 1, $9,000 in year 2, $11,000 in year 3, and $16,000 in year 4. Neither project can be...
The management team of U. Dunnit Limited have four projects for consideration. In the past, they have evaluated project...
The management team of U. Dunnit Limited have four projects for consideration. In the past, they have evaluated projects against simple payback. The following information is available: Project A Project B Project C Project D Capital outlay 65,000 140,000 30,000 160,000 Net cash inflows: 30,000 45,000 20,000 35,000 ear 20,000 45,000 10,000 35,000 ear 15,000 45,000 10,000 55,000 ear Year 4 10,000 45,000 55,000 Year 5 10,000 45,000 65,000 REQUIRED Evaluate the projects using each of the following methods: (a)...
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year...
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year Project Cash Flow (millions) $(210) AWNO If the project's appropriate discount rate is 11 percent, what is the project's discounted payback period? The project's discounted payback period is years. (Round to two decimal places.) (Mutually exclusive projects and NPV) You have been assigned the task of evaluating two mutually exclusive projects with the following projected cash flows: Project A Project B Year Cash Flow...
You are considering a project that will require an initial outlay of $400,000. This project has...
You are considering a project that will require an initial outlay of $400,000. This project has an expected life of four years and will generate after-tax cash flows to the company as a whole of $120,000 at the end of each year over its five-year life. Thus, the free cash flows associated with this project look like this: Year Free Cash Flow 0 -150,000 1 120,000 2 120,000 3 120,000 4 120,000 Given a required rate of return of 20%...
you are considering a project with an initial cash outlay of $74,000 and expected cash flows...
you are considering a project with an initial cash outlay of $74,000 and expected cash flows of $23,680 at the end of each year for six years. the discount rate for the project is 9.7 percent. a. what are the project's payback discounted payback periods? - if the discount rate for this project is 9.7 percent, the discounted payback period of the project is how many years? b. what is the projects NPV? c. what is the project's PI? d....
Part 2 - The second model isfor a project forGardialFisheries. GardialFisheries is considering two mutually exclusive...
Part 2 - The second model isfor a project forGardialFisheries. GardialFisheries is considering two mutually exclusive investments. The projects’ expected net cash flows are as follows: Expected Net Cash Flows for the 7 year Project are: Project A −$375, −300, −200, −100, 600, 600, 926 and, −200 Project B −$575, 190, 190, 190, 190, 190, 190 and, 0 If each project’s cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project...
All techniques, conflicting rankings - Nicholson Roofing Materials, Inc. is considering two mutually exclusive projects, each...
All techniques, conflicting rankings - Nicholson Roofing Materials, Inc. is considering two mutually exclusive projects, each with an initial investment of $180,000. The company's board of directors has set a 4 year payback requirement and has set its cost of capital at 9%. The cash inflows associated with the two projects are shown in the following table. Capital inflows (CF) Year Project A Project B 1 $60,000 $75,000 2 $60,000 $70,000 3 $60,000 $50,000 a. calculate the payback period for...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 10 percent, and that the maximum allowable payback and discounted payback statistics for your company are 3.0 and 3.5 years, respectively. Time: 4 Cash flow-$245, 000 $66,800 $85,000 $142,000 $123,000 $82,200 Use the discounted payback decision rule to evaluate this project. (Do not round intermediate calculations and round your final answer to...
QUESTION 1 Star Industries is considering three alternative projects for the company's investment. The cash flows for three independent projects are as follows: Year 1 Project A ($50,000) $10,000 $15,000 $20,000 $25,000 $30,000 Project B ($100,000) $25,000 $25,000 $25,000 $25,000 $25,000 Project C ($450,000) $200,000 $200,000 $200,000 a) If the discount rate for all three projects is 9.5 percent, calculate the profitability index (PI) of these three projects. Which project will be accepted if the projects are mutually exclusive? b)...
The management team of U. Dunnit Limited have four projects for consideration. In the past, they have evaluated projects against simple payback. The following information is available: Project A Project B Project C Project D Capital outlay 65,000 140,000 30,000 160,000 Net cash inflows: 30,000 45,000 20,000 35,000 ear 20,000 45,000 10,000 35,000 ear 15,000 45,000 10,000 55,000 ear Year 4 10,000 45,000 55,000 Year 5 10,000 45,000 65,000 REQUIRED Evaluate the projects using each of the following methods: (a)...
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year Project Cash Flow (millions) $(210) AWNO If the project's appropriate discount rate is 11 percent, what is the project's discounted payback period? The project's discounted payback period is years. (Round to two decimal places.) (Mutually exclusive projects and NPV) You have been assigned the task of evaluating two mutually exclusive projects with the following projected cash flows: Project A Project B Year Cash Flow...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 10 percent, and that the maximum allowable payback and discounted payback statistics for your company are 3.0 and 3.5 years, respectively. Time: 4 Cash flow-$245, 000 $66,800 $85,000 $142,000 $123,000 $82,200 Use the discounted payback decision rule to evaluate this project. (Do not round intermediate calculations and round your final answer to...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago