SAPM Course Assignment Help Online

SAPM Course Assignment Help Online

Experiential Learning Assignment #1

Dear Students,

Here are the details of the first (and only) experiential learning assignment for SAPM course. The due date for this assignment is 18, April 23, 9.00 PM. I expect you to complete this assignment by this date/ time. Hence you have 2 weeks to work on this assignment, which should give you plenty of time to do a quality job in a timely manner. This is a Capstone assignment that will help you synthesize your learnings across the course. This assignment will be for 15 marks.

This will be an individual assignment, meaning each and every student is expected to do independent and original work as per guidelines elaborated below.

Two ways to get the data:

1)     Prowess database

You may download the data from PROWESS database – details on how to access Prowess database were communicated earlier and training sessions were also held earlier. Please follow those instructions. PROWESS database is a reliable and robust database and BITS, Pilani, WILP Division has subscribed to the same so that our students can get access to the most reliable and up to date financial data for analysis and project work. Prowess can be accessed remotely by the students. Details have already been shared and students should follow those instructions.

2)     Bloomberg Terminal

Second option is to get the data from Bloomberg Terminal. Again, Bloomberg is a world renowned database used by top banks across the globe. BITS, Pilani, WILP Division has subscribed to the same so that our students can get access to the most reliable and up to date financial data for analysis and project work. However remote access to Bloomberg is not available as per the policy of Bloomberg world wide. You may come to campus during the “Lab Open Week” and get the data if you so desire. Details of the Lab Open Week have been communicated separately. Alternatively you may submit an email request to Ms. Shilpa Narlagiri (Email: narlagiri.shilpa@wilp.bits-pilani.ac.in) and she will send the data (in Excel format) via email to you from Bloomberg. But you have to clearly mention what data you need, i.e. company name, ticker symbol, and what data you want, i.e. closing stock price data for one year. She will reply back generally within 48 hours.

When you submit your assignment, (i.e. in your excel file) you must mention the source of your data, i.e. whether it is Prowess or Bloomberg and the date you downloaded the data. This is very important.

Detailed instructions are as follows:

1) Select two stocks/ companies of your choice for this assignment, and also one index (to which they belong like Nifty 50 or BSE Sensex)

First step is to select two stocks/ companies of your choice. The only condition is that they should be from different industries. For example, you may select Tata Motors and say Infosys (Manufacturing/ Automotive and IT), but do not select Wipro and Infosys (both IT industry). Ideally one of the companies should be the company you are working for or in the same industry as the one you are working in. But in any case, select the companies from different industries, otherwise you will not be able to see any diversification benefits.

2) Please obtain the daily closing stock price of these two companies (and also obtain the closing index) from Bloomberg or Prowess database for the past one year, i.e. from 1 April 2022 to 31 March 2023. You can get the data only from these two sources and no other data source. You need to mention the data source and the date of obtaining the data in your excel sheet.

3) From the price series you should compute the daily returns either simple returns or log returns. Please choose one method and be consistent, i.e. apply same method for both the stocks (and the index) for the one year entire period. Please include a brief explanation as to your choice of method (in your report), i.e. why you chose to use simple returns or log returns as the case may be.

4) First sheet should have identified information: Make sure you have one sheet which has your student ID, name, course code, course name, companies chosen and why (does it relate to the company you are working in? Means one of the companies should be the company you are working or from the same industry.) In this sheet the source of the data (Bloomberg or Prowess) should be mentioned along with the date on which the data was obtained.

5) Next sheet should have the closing stock price and index data that you have downloaded

6) First set of calculations (do this in separate tab in Excel):

You will need to calculate the following:

–       Average daily return, Variance, and Standard deviation of Stock #1 over the period of a year

–       Average daily return, Variance, and Standard deviation of Stock #2 over the period of a year

–       Covariance and Correlation across the two stocks (over the same time period)

7) Assume that you are being given Rs. 100,000 in your portfolio (as of the starting date) and you need to split that 60:40 between the two stocks. You may choose which stock should get 60% and which stock should get 40%.

8) In another sheet in excel do the following set of calculations:

–       Expected return, Variance, and Standard deviation of Overall portfolio (with 60:40 split)

9)  In this sheet you will also need to plot the efficient frontier and the CML. I will now outline some guidelines as to how to go about doing this. Compute the portfolio risk and portfolio return for various combinations of the two stocks that you have selected. Go from 0% in stock 1 and 100% in stock 2 all the way to 100% in stock 1 and 0% in stock 2 in increments of either 1% or 5% or 10%. You should now have two columns of data, one column which has the portfolio risk and the second column which has the portfolio return. Draw a scatter plot using this data. Excel requires that the first column in your dataset should represent the X axis, which in our case is portfolio risk and the second column should represent the Y axis which in our case is the portfolio return. The chart that you obtain would be the efficient frontier.

10) In this sheet you would also need to plot the CML. For this identify the risk-free rate from the internet and mark it as a point on the Y axis on the same scatter plot. You can do that by adding a new data series consisting of only one point and label it as risk free rate. Then insert a line into this chart that is anchored at the risk-free point and is tangential to the efficient frontier. This line represents the CML.

11) You may identify the point of tangency by using excel solver. The steps to do this are as outlined below. Remember the CML represent combinations of risk free asset and the market portfolio. Initially and quite arbitrarily assume that your market portfolio comprises of 50% in stock 1 and 50% in stock 2. Then calculate the risk and return of the market portfolio. Then compute the Sharpe ratio for this market portfolio in a cell in this sheet. Then use Excel solver to maximize the Sharpe ratio by changing the weight of the stocks in the portfolio. This will give you the point of tangency, which is the market portfolio.

12)    Finally, in another sheet, run a regression to calculate the Beta of each of the stocks with respect to the market, where the market is proxied by the index. Graph the regression on a chart. Using the calculated Beta and the risk-free rate calculate the required return for each of the stocks based on CAPM model.

13) Once you have completed all the above calculations in Excel, please write a short report in WORD (max two A4 size pages) outlining your key analysis, findings, learnings, as well any decisions you made such as methodology, etc. It should be a short report and to the point.

PLEASE NOTE THAT THIS IS AN INDIVIDUAL ASSIGNMENT AND EACH STUDENT SHOULD WORK INDEPENDENTLY AND PRESENT THEIR FINDINGS INDIVIDUALLY. PLEASE DO NOT COPY OR PLAGIARIZE IN ANY WAY EITHER FROM YOUR FRIENDS OR FROM THE INTERNET, ETC. IF YOU DO THEN YOU WILL BE AWARDED “0” MARKS WITHOUR ANY HESITATION. I CAN EASILY FIND OUT IF YOU HAVE COPIED.

You should upload a soft copy of your Excel Workbook and Word report to the course page in Taxila latest by April 18, 9.00 PM. 

Best Wishes!

Order Now

Get expert help for SAPM Course Assignment Help Online and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (April 13, 2026) SAPM Course Assignment Help Online. Retrieved from https://universalassignment.com/sapm-course-assignment-help-online/.
"SAPM Course Assignment Help Online." Universal Assignment - April 13, 2026, https://universalassignment.com/sapm-course-assignment-help-online/
Universal Assignment April 13, 2023 SAPM Course Assignment Help Online., viewed April 13, 2026,<https://universalassignment.com/sapm-course-assignment-help-online/>
Universal Assignment - SAPM Course Assignment Help Online. [Internet]. [Accessed April 13, 2026]. Available from: https://universalassignment.com/sapm-course-assignment-help-online/
"SAPM Course Assignment Help Online." Universal Assignment - Accessed April 13, 2026. https://universalassignment.com/sapm-course-assignment-help-online/
"SAPM Course Assignment Help Online." Universal Assignment [Online]. Available: https://universalassignment.com/sapm-course-assignment-help-online/. [Accessed: April 13, 2026]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Categories

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Professional Nursing Assignment Help for Students: Achieve Academic Excellence with Expert Support

Introduction Nursing is a demanding field that combines theoretical knowledge with practical skills. Students pursuing nursing courses often face challenges in completing assignments that require accuracy, critical thinking, and real-world application. This is where nursing assignment help becomes an essential academic support system. With increasing academic pressure and clinical responsibilities,

Read More »

Economics Assignment Help: A Complete Guide for Students

Introduction Economics is a fundamental subject that helps students understand how markets, governments, and individuals make decisions regarding resources. While it is highly relevant in today’s world, many students find economics assignments challenging due to complex theories, graphs, and data analysis. This is where economics assignment help becomes extremely useful.

Read More »

Law Assignment Help: A Complete Guide for Students

Introduction Law is a complex and intellectually demanding field that requires critical thinking, analytical skills, and a deep understanding of legal principles. Students pursuing law often face challenges in completing assignments due to extensive research requirements and intricate case analysis. This is where law assignment help becomes highly beneficial. With

Read More »

Nursing Assignment Help: A Complete Guide for Students

Introduction Nursing is a highly respected and demanding field that requires a strong understanding of medical concepts, patient care, and clinical practices. Students pursuing nursing often face intense academic pressure due to complex assignments, practical responsibilities, and tight deadlines. This is where nursing assignment help becomes essential. With expert assistance,

Read More »

Finance Assignment Help: A Complete Guide for Students

Introduction Finance is a core subject in business and management studies, covering areas like investment analysis, financial management, and risk assessment. While it offers excellent career opportunities, many students find finance assignments challenging due to complex calculations and analytical concepts. This is where finance assignment help becomes essential. With expert

Read More »

Computer Science Assignment Help: A Complete Guide for Students

Introduction Computer Science is one of the most popular and dynamic fields of study, offering vast career opportunities in software development, data analysis, cybersecurity, and more. However, students often face difficulties in completing assignments due to the technical complexity and time constraints. This is where computer science assignment help becomes

Read More »

Digital Marketing Assignment Help: A Complete Guide for Students

Introduction Digital marketing has become a vital part of modern business strategies, making it a popular subject among students worldwide. From social media campaigns to search engine optimization, the field is dynamic and constantly evolving. However, completing assignments in this subject can be challenging due to its practical and analytical

Read More »

Cloud Computing Assignment Help: A Complete Guide for Students

Introduction Cloud computing has become a fundamental part of modern technology, powering everything from mobile apps to enterprise systems. As universities increasingly include this subject in their curriculum, students often find it challenging to keep up with assignments and projects. This is where cloud computing assignment help becomes essential. With

Read More »

Blockchain Assignment Help: A Complete Guide for Students

Introduction Blockchain technology has rapidly gained popularity across industries such as finance, healthcare, and supply chain management. As a result, it has become an important subject in academic programs worldwide. However, students often struggle with its technical concepts and practical applications. This is where blockchain assignment help becomes highly valuable.

Read More »

Data Science Assignment Help: A Complete Guide for Students

Introduction Data Science has become one of the most in-demand fields in today’s digital era, combining statistics, programming, and analytical thinking. However, many students find it difficult to keep up with the complexity of assignments and projects in this subject. This is where data science assignment help plays a crucial

Read More »

Artificial Intelligence Assignment Help: A Complete Guide for Students

Introduction Artificial Intelligence (AI) is transforming industries across the globe, making it one of the most sought-after academic subjects today. However, mastering AI concepts and completing assignments can be challenging for many students. This is where artificial intelligence assignment help becomes essential. With expert guidance, students can better understand complex

Read More »

Assignment Writing Services: A Complete Guide for Students

Introduction Assignments are a crucial part of academic life, helping students develop knowledge, research skills, and critical thinking. However, managing multiple assignments along with exams and personal responsibilities can be overwhelming. This is where assignment writing services become highly beneficial. These services provide expert assistance, helping students complete their assignments

Read More »

Blockchain Assignment Help: A Complete Guide for Students

Introduction Blockchain technology has emerged as one of the most revolutionary innovations in recent years. From cryptocurrencies to secure data management, blockchain is transforming industries like finance, healthcare, and supply chain. Students studying blockchain often face challenges due to its technical concepts and real-world applications. This is where blockchain assignment

Read More »

Assignment Writing Services: A Complete Guide for Students

Introduction Assignments are a crucial part of academic life, helping students develop knowledge, research skills, and critical thinking. However, managing multiple assignments along with exams and personal responsibilities can be overwhelming. This is where assignment writing services become highly beneficial. These services provide expert assistance, helping students complete their assignments

Read More »

Academic Writing Services: A Complete Guide for Students

Introduction Academic writing is a fundamental part of education, requiring students to produce essays, research papers, case studies, and dissertations. It demands strong writing skills, proper structure, and in-depth research. However, many students struggle with academic writing due to time constraints and lack of expertise. This is where academic writing

Read More »

Online Homework Help Services: A Complete Guide for Students

Introduction Homework is an essential part of a student’s learning process, helping reinforce classroom knowledge and improve understanding. However, with increasing academic pressure and multiple responsibilities, students often struggle to complete their homework on time. This is where online homework help services become highly beneficial. They provide expert guidance, save

Read More »

Thesis Writing Help: A Complete Guide for Students

Introduction A thesis is one of the most important academic documents a student will write during their educational journey. It requires in-depth research, critical analysis, and a clear presentation of ideas. However, many students find thesis writing overwhelming due to its complexity and time-consuming nature. This is where thesis writing

Read More »

Essay Writing Help: A Complete Guide for Students

Introduction Essay writing is a fundamental part of academic life, helping students express their ideas, analyze topics, and develop critical thinking skills. Whether it’s argumentative, descriptive, or analytical, writing a high-quality essay requires proper structure, research, and clarity. However, many students struggle with essay writing due to time constraints and

Read More »

Content Writing Assignment Help: A Complete Guide for Students

Introduction Content writing has become a crucial skill in the digital era, playing a key role in blogging, marketing, and online communication. From academic essays to website content, strong writing skills are essential for students across all fields. However, many students struggle with structuring content, maintaining clarity, and optimizing for

Read More »

Digital Marketing Assignment Help: A Complete Guide for Students

Introduction Digital marketing has become one of the most important skills in today’s online-driven world. From social media marketing to search engine optimization (SEO), businesses rely heavily on digital strategies to reach their audience. Students studying digital marketing often face challenges in understanding strategies, tools, and real-world applications. This is

Read More »

UI/UX Design Assignment Help: A Complete Guide for Students

Introduction UI/UX design is a crucial aspect of modern digital products, focusing on creating visually appealing and user-friendly interfaces. From websites to mobile apps, good design enhances user experience and engagement. Students studying UI/UX design often face challenges in creativity, tools, and usability principles. This is where UI/UX design assignment

Read More »

Can't Find Your Assignment?