9 Capital Budgeting Analysis Problems
All work must be shown including equations
Show all dollar and percentage values to two decimals ($000.00, 0.00%)
FIN
7
0
1
, Spring
2
020 AP1 Practical Application for M
4
DHC Development Co. has several new projects that look attractive, but some are riskier than the firm’s past projects. DHC has received a $1
5
million inflow of cash from a venture capital firm, in exchange for
20%
of the firm’s closely held stock. The VC firm has asked DHC managers to “run the numbers” to examine both the market outlook and the expected returns on each of the projects they are considering.
For each of the following questions, you will need to show your work. That means to show the equations used for items such as required return, average expected return, profitability index, etc. When you are using the financial calculator (or Excel), identify each of your inputs. Anyone looking at your work should be able to replicate your answer based on the backup info you provide.
1. Based on DHC’s earnings history over the past 15 years, which have covered various states of the economy, the venture capital execs want DHC to estimate their overall returns. Given the following estimates of economy over the next several years, determine DHC’s expected rate of return. (
3
pts)
Note, this type of development firm has much higher than normal returns under normal and boom conditions.
State of the Economy |
Probability of State of the Economy |
Rate of Return if State Occurs |
Boom |
20% |
35% |
Normal |
55% |
12% |
Recession |
25% |
-15% |
Expected return for “average” company project =
2. Historically, DHC projects have had an average beta of
1.1
5 Assuming the return on the overall market is
9
.25% and the risk free rate is 1.5%, what is the required return for an “average” DHC project using based on its average project beta? Round the average required return to 2 decimal places (x.xx%). Hint: Remember that the market risk premium = return on the market – risk free rate, R = Rf + (β*(Rm – Rf)) (3 pts)
Expected return for “average” company project =
3. The potential projects that DHC is considering have the following expected cash flows. Each project has its own unique risk and as such, the beta on each project is given. Using the data from part 2 for the risk free rate and market returns, what is the required percentage return for each of the projects? Show the required returns to 2 decimals, that is xx.xx% (4 pts)
|
Project A |
Project B |
Project C |
Project D |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Beta |
1.3 |
0.9 |
1.1 |
1. 6 |
4-7. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a hard and fast rule on payback period, all projects must be completed within 6 years or less.
Expected cash flows for the four potential projects that DHC is considering as shown below:
Year |
||||||||||||||||||||||
0 |
-$4,000,000 |
-$ 8 ,000,000 |
-$6,000,000 |
-$3,000,000 |
||||||||||||||||||
1 |
$1,000,000 |
$1,250,000 |
$1,500,000 |
$300,000 |
||||||||||||||||||
2 |
$500,000 |
|||||||||||||||||||||
3 |
$2,500,000 |
|||||||||||||||||||||
4 |
$750,000 |
|||||||||||||||||||||
5 |
$800,000 |
|||||||||||||||||||||
6 |
$0 |
|||||||||||||||||||||
7 | ||||||||||||||||||||||
8 | ||||||||||||||||||||||
9 | ||||||||||||||||||||||
10 |
I have provided a suggested template for your final answers. Below the grid (and/or next page) is where you should put all your required backup calculations. If you are working this in Excel, feel free to submit your Excel sheet, where the equations in the cells will provide the required backup. Be sure to clearly indicate the required rate of return (from part 3) you are using for each project.
Points |
Req. Return (use 2 decimals xx.xx%) |
|
4a |
NPV (to nearest $1) |
|
4b |
NPV accept/reject |
|
5a |
IRR (xx.xx%) |
|
5b |
IRR accept/reject |
|
6a |
PI (show 2 decimals) |
|
6b |
PI accept/reject |
|
7a |
Payback Period (x.x years) |
|
7b |
Payback accept/reject |
|
Please show your supporting equations and/or the calculator inputs below. |
8. Discuss your results. What I’m looking for is a short discussion of how some capital budgeting techniques provide the same accept/reject decision, while others do not. Can this be a problem for the firm? Which of the decisions methods seems the most helpful (and why) and which least helpful (and why)? (6 points max, no outside sources necessary)
9. Finally, recall that the venture capital firm only provided $15 million in funding. That $15 million is the funding that will cover the initial investments required on projects. Assuming all projects that are acceptable using the “gold standard”, NPV, which of those projects should be accepted, while staying within the $15 mm budget. Identify the projects that should be accepted, the total outflow at time 0 (must be within your budget) and the total NPV. (2 pts) Hint: look at Practice Problem 14.
2
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.