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 - BackgroundPRESENT VALUE AND THE RISK/RETURN TRADE-OFFTo 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.Holthausen, 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-moneyPinder, 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-riskA 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:Vishwanath, S. (2007). Chapter 2: Time value of money. Corporate finance: Theory and practice. SAGE Publications India. Available in the Trident Online Library.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=85sMoy, R. (2014). Present value of multiple cash flows in Excel. Retrieved from: https://www.youtube.com/watch?v=kDOIuJbHpLcCodible. (2012). Future value for a series of annual deposits. Retrieved from: https://www.youtube.com/watch?v=EcfmEVVHDswOptional ReadingPinder, 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_gModule 1 Week 2Contains unread posts posted Oct 14, 2018 8:08 AMHello 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.ReferencesExcelIsFun. (2009, Jul. 13). Excel Statistics 61: Stock Expected Return & Standard Deviation (Probability) [Video file]. Retrieved from https://www.youtube.com/watch?v=UHAw4P12E0oModule 1 Week 2Contains unread posts posted Oct 15, 2018 5:24 PMSubscribeGood Evening ClassThere 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=hG68UMupJzsFuture Value Function Excel at: https://www.youtube.com/watch?v=w8TJrFB3yP8The 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.JohnnyCodible. (2012). Calculating Future Value on Excel. YouTube. Retrieved from: https://www.youtube.com/watch?v=w8TJrFB3yP8Excel, 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

Using the Excel file provided below as a starting point, or by creating your own Excel file, complete the following problem, and submit your assignment as an attachment here. Be sure to save your work before you submit, and present your work in a reasonable format with major answers highlighted. Because you have plenty of time to do this assignment, and given that the textbook is available for your use, this assignment should really be close to perfect. ***************************************Here is the problem:Dordine Company acquired equipment on March 1, 2020, at a cash cost of $1,000,000. Transportation charges amounted to $12,000, installation cost was $40,000, testing costs were $30,000, and the payment of a fine for not getting the proper permit for moving the equipment was $1,000. The equipment was estimated to have a useful life of 12 years and a salvage value of $60,000 at the end of its life. It was further estimated that the equipment would be used in the production of $364,000 units of product during its life. During the 2020 year, 40,000 units of product were produced. Required:A. Prepare a schedule to calculate the original cost and the depreciable base of the asset.B. Compute the depreciation to the nearest dollar for the year ended December 31, 2020, using the straight-line method.C. Compute the depreciation to the nearest dollar for the year ended December 31, 2020, using the units-of-production method. D. Compute the depreciation to the nearest dollar for the year ended December 31, 2020, using the sum-of-the-years-digits method. E. Compute the depreciation to the nearest dollar for the year ended December 31, 2020, using the double-declining balance method. *****************************************Here is a very rough document that you might use to get you started on this assignment. Please feel free to modify it to the extent necessary to complete this assignment. In doing so, please change the name of the file to include your name before submitting it.