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).
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).
This criterion is linked to a Learning Outcome Requirements
20.0 to >16.0 pts
Meets Expectation
Includes all of the required components, as specified in the assignment.
16.0 to >12.0 pts
Approaches Expectation
Includes most of the required components, as specified in the assignment.
12.0 to >8.0 pts
Below Expectation
Includes some of the required components, as specified in the assignment.
8.0 to >0 pts
Limited Evidence
Includes few of the required components, as specified in the assignment.
20.0 pts
This criterion is linked to a Learning Outcome Content
30.0 to >24.0 pts
Meets Expectation
Demonstrates strong or adequate knowledge of the materials; correctly represents knowledge from the readings and sources.
24.0 to >18.0 pts
Approaches Expectation
Some significant but not major errors or omissions in demonstration of knowledge.
18.0 to >12.0 pts
Below Expectation
Major errors or omissions in demonstration of knowledge.
12.0 to >0 pts
Limited Evidence
Fails to demonstrate knowledge of the materials.
30.0 pts
This criterion is linked to a Learning Outcome Problem Solving
20.0 to >16.0 pts
Meets Expectation
Demonstrates strong or adequate thought and insight in problem solving.
16.0 to >12.0 pts
Approaches Expectation
Some significant but not major errors or omissions in problem solving.
12.0 to >8.0 pts
Below Expectation
Major errors or omissions in problem solving.
8.0 to >0 pts
Limited Evidence
Fails to demonstrate problem solving.
20.0 pts
This criterion is linked to a Learning Outcome Critical Analysis
20.0 to >16.0 pts
Meets Expectation
Provides a strong critical analysis and interpretation of the information given.
16.0 to >12.0 pts
Approaches Expectation
Some significant but not major errors or omissions in analysis and interpretation.
12.0 to >8.0 pts
Below Expectation
Major errors or omissions in analysis and interpretation.
8.0 to >0 pts
Limited Evidence
Fails to provide critical analysis and interpretation of the information given.
20.0 pts
This criterion is linked to a Learning Outcome Sources
10.0 to >8.0 pts
Meets Expectation
Cites and integrates at least three credible sources, as specified in description.
8.0 to >6.0 pts
Approaches Expectation
Cites and integrates two credible sources, as specified in description.
6.0 to >4.0 pts
Below Expectation
Cites and integrates one credible source, as specified in description.
4.0 to >0 pts
Limited Evidence
Cites and integrates no credible sources.
10.0 pts
This criterion is linked to a Learning Outcome Demonstrates college-level proficiency in organization, grammar and style.
10.0 to >8.0 pts
Meets Expectation
Project is clearly organized, well written, and in proper format, as outlined in the assignment. Strong sentence and paragraph structure; few errors in grammar and spelling.
8.0 to >6.0 pts
Approaches Expectation
Project is fairly well organized and written and is in proper format, as outlined in the assignment. Reasonably good sentence and paragraph structure; significant number of errors in grammar and spelling.
6.0 to >4.0 pts
Below Expectation
Project is poorly organized; does not follow proper paper format. Inconsistent to inadequate sentence and paragraph development; numerous errors in grammar and spelling.
4.0 to >0 pts
Limited Evidence
Project is not organized or well written and is not in proper paper format. Poor quality work; unacceptable in terms of grammar and spelling.
10.0 pts
This criterion is linked to a Learning Outcome Demonstrates proper use of APA style.
10.0 to >8.0 pts
Meets Expectation
Project contains proper APA formatting, according to the CSU-Global Guide to Writing and APA, with no more than one significant error.
8.0 to >6.0 pts
Approaches Expectation
Few errors in APA formatting, according to the CSU-Global Guide to Writing and APA, with no more than two to three significant errors.
6.0 to >4.0 pts
Below Expectation
Significant errors in APA formatting, according to the CSU-Global Guide to Writing and APA, with four to five significant errors.
4.0 to >0 pts
Limited Evidence
Numerous errors in APA formatting, according to the CSU-Global Guide to Writing and APA, with more than five significant errors.
Absolutely spot on. I have had the best experience with Elite Academic Research and all my work have scored highly. Thank you for your professionalism and using expert writers with vast and outstanding knowledge in their fields. I highly recommend any day and time.
Stuart L
Thanks for keeping me sane for getting everything out of the way, I’ve been stuck working more than full time and balancing the rest but I’m glad you’ve been ensuring my school work is taken care of. I'll recommend Elite Academic Research to anyone who seeks quality academic help, thank you so much!
Mindi D
Brilliant writers and awesome support team. You can tell by the depth of research and the quality of work delivered that the writers care deeply about delivering that perfect grade.
Samuel Y
I really appreciate the work all your amazing writers do to ensure that my papers are always delivered on time and always of the highest quality. I was at a crossroads last semester and I almost dropped out of school because of the many issues that were bombarding but I am glad a friend referred me to you guys. You came up big for me and continue to do so. I just wish I knew about your services earlier.
Cindy L
You can't fault the paper quality and speed of delivery. I have been using these guys for the past 3 years and I not even once have they ever failed me. They deliver properly researched papers way ahead of time. Each time I think I have had the best their professional writers surprise me with even better quality work. Elite Academic Research is a true Gem among essay writing companies.
Got an A and plagiarism percent was less than 10%! Thanks!
Jermaine Byrant
Nicole Johnson
OVER
RATING
YEARS
