Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20
Order a Similar Paper Order a Different Paper
Module 2: Critical Thinking
Critical Thinking Assignment (120 Points)
Important! Read First
Choose one of the following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission.
Option #1: NPV
Review the following data concerning the amount of capital investment and return of investment for two alternative projects.
|
Project/ Year |
0 |
1 |
2 |
3 |
4 |
|
A |
-$124,000 |
$32,000 |
$44,000 |
$50,000 |
$50,000 |
|
B |
-$211,000 |
$72,000 |
$75,000 |
$77,000 |
$80,000 |
Use Excel to calculate the NPV values for the two projects with the discount rates of 5%, 15% and 20% using proper formula in Excel.
Provide a two-page narrative to:
- Describe the steps you took to calculate the NPV values
- Explain your findings
- Specify which project you would select for each of the discount rates of 5%, 15%, and 20%.
Include an excerpt (showing your calculations and outcomes) from your Excel file in your narrative and specify the formula you used.
Be sure to organize your writing properly and include the following:
- Cover page
- Introduction
- Body of your work with headings and subheadings
- Analysis and recommendations
- Conclusion
- List of references.
Consult the Sample Paper template (Links to an external site.) for more information on how to organize the paper. Please note that Lynda.com is a great resource to learn how Excel can be used to utilize economic models (e.g., NPV, IRR).
Support your assignment with a minimum of three scholarly references. The CSU-Global library is a good place to locate these sources. The written section should follow the CSU-Global Guide to Writing and APA (Links to an external site.).
Option #2: IRR
Review the following data concerning the amount of capital investment and return of investment for two alternative projects.
|
Project/ Year |
0 |
1 |
2 |
3 |
4 |
|
A |
-$124,000 |
$32,000 |
$44,000 |
$50,000 |
$50,000 |
|
B |
-$211,000 |
$72,000 |
$75,000 |
$77,000 |
$80,000 |
Use Excel to calculate the IRR values for the two projects. Explain if choosing different discount rates of 5%, 15% and 20% will make a difference in the results.
Provide a two-page narrative to:
- Describe the steps you took to calculate the IRR values
- Explain your findings
- Specify which project you would choose.
Include an excerpt (showing your calculations and outcomes) from your Excel file in your narrative and specify the formula you used.
Be sure to organize your writing properly and include the following:
- Cover page
- Introduction
- Body of your work with headings and subheadings
- Analysis and recommendations
- Conclusion
- List of references.
Consult the Sample Paper template (Links to an external site.) for more information on how to organize the paper. Please note that Lynda.com is a great resource to learn how Excel can be used to utilize economic models (e.g., NPV, IRR).
Support your assignment with a minimum of three scholarly references. The CSU-Global library is a good place to locate these sources. The written section should follow the CSU-Global Guide to Writing and APA (Links to an external site.).
Rubric
PJM380 Mod 2 CT
|
PJM380 Mod 2 CT |
||||||
|
Criteria |
Ratings |
Pts |
||||
|
This criterion is linked to a Learning Outcome Requirements |
|
20.0 pts |
||||
|
This criterion is linked to a Learning Outcome Content |
|
30.0 pts |
||||
|
This criterion is linked to a Learning Outcome Problem Solving |
|
20.0 pts |
||||
|
This criterion is linked to a Learning Outcome Critical Analysis |
|
20.0 pts |
||||
|
This criterion is linked to a Learning Outcome Sources |
|
10.0 pts |
||||
|
This criterion is linked to a Learning Outcome Demonstrates college-level proficiency in organization, grammar and style. |
|
10.0 pts |
||||
|
This criterion is linked to a Learning Outcome Demonstrates proper use of APA style. |
|
10.0 pts |
||||
|
Total Points: 120.0 |
||||||
Got stuck with another paper? We can help! Use our paper writing service to score better grades and meet your deadlines.
Get 15% discount for your first order
Order a Similar Paper Order a Different Paper
