Homework Answers
1. USE DISCOUNT RATE @ 6 % - PVIF TABLE
| Year | Cash Flow | Discount rate @6% | Present Value |
| (A) | (B) | (A X B) | |
| 0 | -50 | 1 | -50.00 |
| 1 | 5 | 0.9434 | 4.72 |
| 2 | 7 | 0.89 | 6.23 |
| 3 | 6 | 0.8396 | 5.04 |
| 4 | 4 | 0.7921 | 3.17 |
| 5 | 18 | 0.7473 | 13.45 |
| 6 | 28 | 0.705 | 19.74 |
| TOTAL | NPV | 2.34 (ANSWER) |
2. SOLVED IN EXCEL
| Year | Cash Flow |
| (A) | |
| 0 | -152790 |
| 1 | -1293 |
| 2 | 2135 |
| 3 | 26574 |
| 4 | 56549 |
| 5 | 75855 |
| 6 | 90800 |
| 7 | 102031 |
| IRR | =IRR(F18:F25) |
| IRR | 17% (ANSWER) |
Add Answer to:
Question 11 (1 point) ✓ Saved What is the Net Present Value of the following cash...
Question 4 (1 point) v Saved What's the present value of $10,000 discounted back 5 years...
Question 4 (1 point) v Saved What's the present value of $10,000 discounted back 5 years if the appropriate interest rate is 6%, compounded monthly? O a) $8506.28 O b) s8150.51 O c) 87413.72 d) $6090-49 e) $799 20
Question 1 (1 point) Saved Averages are referred to as measures of central normalcy. Question 1...
Question 1 (1 point) Saved Averages are referred to as measures of central normalcy. Question 1 options: True False Question 2 (1 point) Saved The value in the middle of a set of ranked data is called the mean. Question 2 options: True False Question 3 (1 point) Saved The piece of data that occurs the most in a set of data is called the median. Question 3 options: True False Question 4 (1 point) Saved Measures of dispersion are...
Question 2 (1 point) What is the discounted payback for a project with the following cash...
Question 2 (1 point) What is the discounted payback for a project with the following cash flows, at 4.0%? Cost 0 ($10,000) Returns 1 $4,500 2 $3,250 3 $3,000 4 $1,000 2.25 02.5 03.0 3.9
Find the present value of the streams of cash flows shown in the following table, Assume...
Find the present value of the streams of cash flows shown in the following table, Assume that the firm's opportunity cost is 12%. a. The present value of stream A is $ (Round to the nearest dollar.) Enter your answer in the answer box. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.)Data Table A B C Year Cash Flow Year Cash Flow Year Cash Flow...
Question 3 (1 point) ✓ Saved You are given a cash flow with an expense at...
Question 3 (1 point) ✓ Saved You are given a cash flow with an expense at EOY O, and revenues from EOY 1 to EOY 5. To compute the NAW of this cash flow using Excel, you must: a) Use the PMT function for cash flows from EOY O to EOY 5 b) Compute the NPV of this cash flow and then compute the PMT of this NPV value where Nper=1 Compute the NPV of this cash flow at EOY...
What is the Net Present Value of the following cash flows which represent expected benefits from...
What is the Net Present Value of the following cash flows which
represent expected benefits from opening a small ice cream business
part time. You are expecting a return of 20%, and you must invest
$60,000 at the start. Fill in the chart below. Determine the IRR
using Excel. Interpret the results in view of your expectations for
this project.
PV Year | Cash Flow T 1 5,000 9,000 10,000 10,000 12,000 14,000 7 101,500 Present Value NPV (Est IRR)...
Help and verified and be clear. The net present value (NPV) and internal rate of return...
Help
and verified and be clear.
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Lambda is...
If mutually exclusive projects with normal cash flows are being analyzed, the net present value (NPV)...
If mutually exclusive projects with normal cash flows are being analyzed, the net present value (NPV) and internal rate of return (IRR) methods agree. Projects Y and Z are mutually exclusive projects. Their cash flows and NPV profiles are shown as follows. NPV (Dollars) 800 Year Project Y Project Z 0 -$1,500 -$1,500 1 $200 $900 2 $400 $600 $600 $300 4 $1,000 $200 Project Y Project 2 If the weighted average cost of capital (WACC) for each project is...
Buestion . .. What is the present value of the following set of cash flows, discounted...
Buestion . .. What is the present value of the following set of cash flows, discounted at 100% per year? Year CI 1 $10 522 4 565 5 b. What is the present of the following set of cash flows, discounted at 100% per year? Year CF 1 558 2 5-46 531 4 522 590 5 510 c. Each set contains the same cash flow (510, 522 54 546 558)so why is the present value different? .. What is the...
Ch 11: Assignment - The Basics of Capital Budgeting The net present value (NPV) and internal...
Ch 11: Assignment - The Basics of Capital Budgeting The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of...
Question 4 (1 point) v Saved What's the present value of $10,000 discounted back 5 years if the appropriate interest rate is 6%, compounded monthly? O a) $8506.28 O b) s8150.51 O c) 87413.72 d) $6090-49 e) $799 20
Question 2 (1 point) What is the discounted payback for a project with the following cash flows, at 4.0%? Cost 0 ($10,000) Returns 1 $4,500 2 $3,250 3 $3,000 4 $1,000 2.25 02.5 03.0 3.9
Question 3 (1 point) ✓ Saved You are given a cash flow with an expense at EOY O, and revenues from EOY 1 to EOY 5. To compute the NAW of this cash flow using Excel, you must: a) Use the PMT function for cash flows from EOY O to EOY 5 b) Compute the NPV of this cash flow and then compute the PMT of this NPV value where Nper=1 Compute the NPV of this cash flow at EOY...
What is the Net Present Value of the following cash flows which
represent expected benefits from opening a small ice cream business
part time. You are expecting a return of 20%, and you must invest
$60,000 at the start. Fill in the chart below. Determine the IRR
using Excel. Interpret the results in view of your expectations for
this project.
PV Year | Cash Flow T 1 5,000 9,000 10,000 10,000 12,000 14,000 7 101,500 Present Value NPV (Est IRR)...
Help
and verified and be clear.
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Lambda is...
If mutually exclusive projects with normal cash flows are being analyzed, the net present value (NPV) and internal rate of return (IRR) methods agree. Projects Y and Z are mutually exclusive projects. Their cash flows and NPV profiles are shown as follows. NPV (Dollars) 800 Year Project Y Project Z 0 -$1,500 -$1,500 1 $200 $900 2 $400 $600 $600 $300 4 $1,000 $200 Project Y Project 2 If the weighted average cost of capital (WACC) for each project is...
Buestion . .. What is the present value of the following set of cash flows, discounted at 100% per year? Year CI 1 $10 522 4 565 5 b. What is the present of the following set of cash flows, discounted at 100% per year? Year CF 1 558 2 5-46 531 4 522 590 5 510 c. Each set contains the same cash flow (510, 522 54 546 558)so why is the present value different? .. What is the...
Ch 11: Assignment - The Basics of Capital Budgeting The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of...
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