Purpose of Assignment
The purpose of this assignment is to allow the students to become familiar with and practice the measurement of Net Present Value (NPV), payback, and Weighted Average Cost of Capital (WACC) using Microsoft ®Excel ®.
Assignment Steps
Resources:Microsoft ®Excel ®, Capital Budgeting Decision Models Template
Calculatethe following problems using Microsoft ®Excel ®:
- Calculate the NPV for each project and determine which project should be accepted.
| Project A | Project B | Project C | Project D | |
| Inital Outlay | (105,000.000) | (99,000.00) | (110,000.00) | (85,000.00) |
| Inflow year 1 | 53,000.00 | 51,000.00 | 25,000.00 | 45,000.00 |
| Inflow year 2 | 50,000.00 | 47,000.00 | 55,000.00 | 50,000.00 |
| Inflow year 3 | 48,000.00 | 41,000.00 | 15,000.00 | 30,000.00 |
| Inflow year 4 | 30,000.00 | 52,000.00 | 21,000.00 | 62,000.00 |
| Inflow year 5 | 35,000.00 | 40,000.00 | 35,000.00 | 68,000.00 |
| Rate | 7% | 10% | 13% | 18% |
- Your company is considering three independent projects. Given the following cash flow information, calculate the payback period for each. If your company requires a three-year payback before an investment can be accepted, which project(s) would be accepted?
| Project D | Project E | Project F | |
| Cost | 205,000.00 | 179,000.00 | 110,000.00 |
| Inflow year 1 | 53,000.00 | 51,000.00 | 25,000.00 |
| Inflow year 2 | 50,000.00 | 87,000.00 | 55,000.00 |
| Inflow year 3 | 48,000.00 | 41,000.00 | 21,000.00 |
| Inflow year 4 | 30,000.00 | 52,000.00 | 9,000.00 |
| Inflow year 5 | 24,000.00 | 40,000.00 | 35,000.00 |
- Using market value and book value (separately), find the adjusted WACC, using 30% tax rate.
| Component | Balance Sheet Value | Market Value | Cost of Capital |
| Debt | 5,000,000.00 | 6,850,000.00 | 8% |
| Preferred Stock | 4,000,000.00 | 2,200,00.00 | 10% |
| Common Stock | 2,000,000.00 | 5,600,000.00 | 13%
|
Why is research important for the fields of Psychology and
Sociology?
When responding to ALL discussion...
/*! elementor - v3.6.5 - 27-04-2022 */
.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
Due Week 5 and worth 80 points B. The state school board chairperson has asked you (a consultant on health and we...
The RN to BSN program at Grand Canyon University meets the requirements for clinical competencies as defined by the Commission on Collegiate Nursin...
(The work needs to be shown in Exel to turn in)Seventy percent of the students applying to a university are accepted. Using...
Find these ratios, providing the following information for each; Formula (express the ratio in words), a detailed calculation (actual numbers from...
1Running head: TRANSFORMATION LEADERSHIP THEORYTransformational Leadership theoryName:Institution:Professor:2Running head: TRANSFORMATION LEADERSHIP...
From your experience, how can developing strong interprofessional relationships increase collaboration and benefit patient outcomes or orga...
eek One Discussion: Formal Report Topic
(First post should occur by Wednesday 11:59 PM.)
In preparation for the Formal Rep...
n the last module we looked at the Balanced Scorecard and how it is implemented from more of a purist’s approach and...
Ben Davis had just completed an intensive course in Statistical Thinking for Business Improvement, which was offered to all employees of a large he...
Running Head: CYBERCRIME1CybercrimeName of ProfessorName of StudentCourseSubmission DateCYBERCRIME2IntroductionCybercrime is a form of fraud that is...
Other samples, services and questions:
Calculate Price
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.
