![mprjug6](/avatars/15843.jpg)
mprjug6
18.07.2020 •
Mathematics
BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:
Expected Net Cash Flows
Time Project A Project B
0 ($405) ($705)
1 ($285) $200
2 ($205) $205
3 ($105) $210
4 $605 $215
5 $650 $220
6 $925 $225
7 ($200) $230
In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions.
Part 1: Net Present Value
C. Construct NPV profiles (a data table of project NPVs for different costs of capital) using the Excel NPV function for Projects A and B.
D. Graph both NPV profiles in a single plot with NPV on the y-axis and cost of capital on the x-axis (label the x-axis, y-axis, chart title, and axis). Use a scatter with straight lines chart type. (7 points)
C) NPV Profiles
Cost of Capital Project A Project B
0%
1%
2%
3%
4%
5%
6%
7%
8%
9%
10%
11%
12%
13%
14%
15%
D) NPV Profiles Graph
Solved
Show answers
More tips
- H Health and Medicine 10 Ways to Cleanse Your Colon and Improve Your Health...
- D Dating, Love, Relationships How to Overcome Jealousy: Tips and Tricks...
- H Health and Medicine Angina: Causes, Symptoms, and Treatment...
- C Computers and Internet How to Learn to Type Fast?...
- F Food and Cooking Delight for Gourmets: How to Prepare Liver Pate...
- S Style and Beauty How to braid friendship bracelets?...
- H Health and Medicine Mercury Thermometer Danger: What to do when a thermometer breaks?...
- F Food and Cooking Which Calamari Salad is the Most Delicious?...
- S Society and Politics 10 Tips for Boosting Your Self-Esteem...
- F Food and Cooking The Most Delicious and Simple Fish in Batter Recipe...
Answers on questions: Mathematics
- M Mathematics 11.••Johnny is buying concert tickets.Adult tickets are $9.Child tickets are $5.Johnny spend $184 on tickets.Johnny buys 24 tickets total.How many adult tickets does he buy?How...
- M Mathematics Complete the equation 1 3/5 - 2/3 = 24/blank - 10/blank = blank/blank...
- M Mathematics A vector has an x-component of 6.15 m and a y-component of -3.88 m. Find the magnitude of the vector....
- M Mathematics Desi has a coupon that entitles him to 35% off the regular price of a sweater. The original price of the sweater he would like to buy can be represented as x , so Desi says that...
- M Mathematics Use addition to solve the linear system of equations. Include all of your work in your final answer. 3x - y = 6y = x - 4...
- M Mathematics Calculate the value of x. Then find the area of the shaded region....
- M Mathematics Negative six times a number is at least 14...
- M Mathematics What is the rate of change in the equation y= 6x + 8...
- M Mathematics Pls help A survey of patients at a hospital classified the patients by gender and blood type, as seen in the two-way table. Male Female TOTAL A 105 93 198 B 99 84 183 O 160 140...
- M Mathematics What are the zeros of the polynomial function f(x)=x^3-9x^2+29x?...
Ответ:
y = 4x – 2 has slope = 4
parallel lines have same slope so slope = 4
passes through the point (–1, 5).
y = mx+b
5 = 4(-1) + b
b =9
equation
y = 4x + 9
answer
The slope of y = 4x – 2 is 4
The slope of a line parallel to y = 4x – 2 is 4
The equation of the line parallel to y = 4x – 2 that passes through the point (–1, 5) is y = 4x + 9