Discussion Question and 2 responses

Anonymous
timer Asked: Oct 16th, 2018
account_balance_wallet $9.99

Question Description

For the second week of the module, dig into the assignments and start to use Microsoft Excel. There are some videos on Excel in the background reading page, but find an additional video or two that helps you get started. Share the link with your classmate and discuss the usefulness of the video you found.

Module 1 - Background

PRESENT VALUE AND THE RISK/RETURN TRADE-OFF

To begin the module, start off with these two videos to give yourself an overview of the main concepts covered in this module. The first video is from Professor Holthausen of the Wharton School of Business at the University of Pennsylvania. He explains the concept of the time value of money and also goes through some calculations using Microsoft Excel. The second video is from Professor Pinder of the University of Melbourne and covers some basic concepts of risk and return.

University of PennsylvaniaHolthausen, R. (2015). Time value of money. Coursera. Retrieved from: https://www.coursera.org/learn/wharton-decision-making-scenarios/lecture/ZE2tE/1-2-time-value-of-money

Unversity of Melbourne

Pinder, S. (2017) Unsystematic versus systematic risk. Coursera. Retrieved from: https://www.coursera.org/learn/valuation/lecture/LLtZP/2-1-unsystematic-versus-systematic-risk-getting-rid-of-unrewarded-risk

A second video from Dr. Pinder on the capital asset pricing model is highly recommended but not required. A link to Dr. Pinder’s video is included under the optional reading list below.

Once you have finished viewing the videos, take a closer look at the concepts covered in the videos by reading through these book chapters. In addition to reading about the basic concepts, make sure to work through some of the numerical examples as these will help you with your assignments:

time and money scale

Vishwanath, S. (2007). Chapter 2: Time value of money. Corporate finance: Theory and practice. SAGE Publications India. Available in the Trident Online Library.

risk and reward tightwire

Vishwanath, S. (2007). Chapter 3: Risk and return. Corporate finance: Theory and practice. SAGE Publications India. Available in the Trident Online Library.

If you have any difficulty with the material above, it is highly recommended that you take a look at some of the optional readings below. The materials below cover the same material but sometimes concepts can be absorbed better if you see some explained in a different manner or see additional examples.

Finally, if you don’t have much experience with Microsoft Excel then please take a look at the following videos:

Davis, J. (2013). Present value of a single amount in Excel. Retrieved from: https://www.youtube.com/watch?v=ruIfnNoe1Co&t=85s

Moy, R. (2014). Present value of multiple cash flows in Excel. Retrieved from: https://www.youtube.com/watch?v=kDOIuJbHpLc

Codible. (2012). Future value for a series of annual deposits. Retrieved from: https://www.youtube.com/watch?v=EcfmEVVHDsw

Optional Reading

Pinder, S. (2017). Capital asset pricing model (It’s all about the discount rate). Coursera. Retrieved from: https://www.coursera.org/learn/valuation/lecture/6Oh5F/2-2-capital-asset-pricing-model-its-all-about-the-discount-rate

Clifford, J. (2014). Time value of money. ACDC Leadership. Retrieved from: https://www.youtube.com/watch?v=nfkqCv3Rd_g



Module 1 Week 2

Contains unread posts

posted Oct 14, 2018 8:08 AM

Hello Class,

For the Case assignment, I was scouring over Google and YouTube to find a video to help me find the expected return, standard deviation, and coefficient of variation given multiple probabilities and returns associated with each probability. Eventually, I came across a video from ExcelIsFun titled "Excel Statistics 61: Stock Expected Return & Standard Deviation (Probability)." ExcelIsFun (2009) presents a table similar to the question in the Case assignment and shows what formula that was used to solve the expected return, standard deviation, and coefficient of variation.

References

ExcelIsFun. (2009, Jul. 13). Excel Statistics 61: Stock Expected Return & Standard Deviation (Probability) [Video file]. Retrieved from https://www.youtube.com/watch?v=UHAw4P12E0o


Module 1 Week 2

Contains unread posts

posted Oct 15, 2018 5:24 PM

Subscribe

Good Evening Class

There are many resources the professor provided as well as a quick Google and YouTube search will yield a large amount of information for tutorials calculating present and future value. I personally prefer videos using built in Excel functions and found 2 YouTube videos calculating in Excel.

Net Present Value Function in Excel at: https://www.youtube.com/watch?v=hG68UMupJzs

Future Value Function Excel at: https://www.youtube.com/watch?v=w8TJrFB3yP8

The NPV video shows the function in use, while the Future Value Function video shows how to perform the calculation the 'long way', and then shortcut way using a built in function in Excel.

Johnny

Codible. (2012). Calculating Future Value on Excel. YouTube. Retrieved from: https://www.youtube.com/watch?v=w8TJrFB3yP8

Excel, Word and PowerPoint Tutorials from Howtech. (2013). How to Calculate Net Present Value (Npv) in Excel. YouTube. Retrieved from: https://www.youtube.com/watch?v=hG68UMupJzs

Tutor Answer

Robert__F
School: Purdue University

Please let me know if there is anything needs to be changed or added. I will be also appreciated that you can let me know if there is any problem or you have not received the work. Please let me know if there is anything needs to be changed or added. I will be also appreciated that you can let me know if there is any problem or you have not received the work Good luck in your study and if you need any further help in your assignments, please let me know Can you please confirm if you have received the work? Once again, thanks for allowing me to help you R

Report: Responses (2)

Responses (2)
by HAL

General metrics
3,732

569

46

2 min 16 sec

4 min 22 sec

characters

words

sentences

reading
time

speaking
time

Writing Issues
No issues found

Plagiarism
This text seems 100% original. Grammarly found no matching text on
the Internet or in ProQuest’s databases.

Report was generated on Tuesday, Oct 16, 2018, 4:55 PM

Page 1 of 2

Report: Responses (2)

Unique Words

41%

Measures vocabulary diversity by calculating the
percentage o...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors