Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

THE STOCK MARKET & THE FIRMS? FUNDAMENTALS Stock market facilitates the exchange of securities between buyers and sellers. It is an important place for firms

THE STOCK MARKET & THE FIRMS? FUNDAMENTALS

Stock market facilitates the exchange of securities between buyers and sellers. It is an important

place for firms to raise money and for shareholders to realise their investment returns. Through

learning by doing, this project aims to provide understandings of how companies? shares are

actually traded in the stock market, as well as of what relevant fundamental forces that possibly

move the stock prices.

Each 5 students will form a group to work on a real-time simulation of equities portfolios for

the Asian markets. Applying the classroom knowledge, each group will manage a stock portfolio

with a starting amount of MYR 1 million during the semester for a total of seven weeks.

Portfolio will be marked to market based on every Wednesday?s and Friday?s closing values. At

end of semester, a group report of analysis and trading (1.5 line spacing, Times New Roman 12

Font) will be required.

Refer next page for further guidelines.

2

YOUR TASK CHECKLIST

Step 1 - Group formation:

Form your group & submit names to the instructor BY TODAY.

Step 2 - Short list your firms:

You may pick several non-financial stocks (please find out the definition of non-financial stocks)

of your choice in any Asian country. Go to the internet to get relevant business and financial

information of your selected firms.

Step 3 - Research your firms:

Identify at least 5 firms that you are interested to purchase for your portfolio. Download the

historical price data of the stocks for the last 5 years. Download the financial data from annual

reports. Apply your knowledge of financial analysis and equity valuation on the information

collected. Use the findings as the basics for your trading decisions.

Step 4 ? Trade the equity:

Recreate the Stock Market Trading Handout for your portfolio with a starting value of MYR 1

million. The handout is just a guide to get you started. Please recreate your own portfolio format.

Build your stock portfolios, fill out your Excel trading sheets and keep record of trading

activities on a semi-weekly basis. Mark to market as of Wednesday & Friday closing price and

compare your portfolio performance with the benchmark. You may trade as frequently as you

wish on any trading day. Remember to log all your buy/sell decisions and reasoning throughout

the project duration. Make sure you use formulas in the spreadsheet cells. Include the exchange

rate at the time of opening positions. At the end of project you will need to convert all the

proceeds back to the Malaysian currency. Record all dividends received, if any.

Step 5 - Progress confirmation:

Hand in 1-page Performance Report within 1 week of starting portfolio as progress confirmation

Step 6 - Report writing: (see Report Content Guidelines next page)

Record your analysis, valuation basis, trading timing, learning experience, mistakes, and any

other relevant reasoning used in making your decisions. Your task is to reflect on your decisions,

self-discover mistakes and learn from those mistakes by associating correct theories,

methodology and solutions as learnt in the classroom.

Step 7 - Submission:

Hand in an 8-page report with journal entries, and prepare for a group presentation at the end of

semester to qualify for scoring. You will need to convince the instructor that the whole report is

produced by you.

______________________________________________________________________________

Many questions & problems may arise in the beginning. You are required to find solutions by

yourself through proactive initiative. Ask instructor ONLY after you have given up!

3

__________________________________________________________________

Report Content Guidelines

1.0 Executive Summary (max page ? 3%)

2.0 Stock Research & Evaluation (6 pages + journal logs ? 60 + 30%)

2.1 Risk & Return Analysis (10%)

a. Using the downloaded data, calculate and comment the risk and return

of the firms you have chosen.

b. Identify the correlations among your portfolio members and comment

on the possible diversification effects.

c. Estimate your portfolio beta.

You may use Excel tools in your calculations from 2.1(a) through 2.1(c).

2.2 Evaluation of Firms? Performance

a. Analyse and compare the profitability of these firms. (10%)

b. Assess and compare the ability of paying cash dividend of these firms. (10%)

c. Assess and compare the capital structure decisions of these firms. (10%)

2.3 Stock Valuation (15%)

Perform stock valuation for these firms using appropriate methods. State

whether you would have bought/sold these firms. Your justification of

method selection is crucial to gain good marks.

2.4 Based on your works in 2.2 and 2.3, provide ONE suggestion to each of

these firms which could help enhancing their shareholders values. (5%)

3.0 Briefly evaluate and discuss your portfolio performance using appropriate

benchmarks. ( page ? 5%)

4.0 Summary and Conclusions. (max page ? 2%)

References must be provided when using information from other sources.

Appendices / Exhibits (Example: journal entries; formulae and detailed calculations; stocks &

market data; financial data/statements.)

______________________________________________________________________________

NOTE: Marks will not be added / deducted just because your trades make gains / losses.

Demonstration of your analysis, reflection, & learning is the most important. The page limit is

not your main limitation to produce a good report. Report should be to the point and focus on

analysis but less on fact compilation!

------------------------------

We have choose the company,so i provide our group trade and some date,some question i have finished, but other we have no idea, so please help me to finish the question.please use my provide data to finish the question

image text in transcribed 2.1 Profitability Ratios Profitability is the ease with which a company generates income. Profitability ratios measure a firm's past performance and help predict its future profitability level. 2.1.1 Gross profit margin This ratio indicates how much of every dollar of sales is left after costs of goods sold Gross profit margin =Gross income Sales =4509440001374931000=32.80% 2.1.2 Operating profit margin This ratio indicates how much of each dollar of sales is left over after operating expenses. Operating profit margin =Operating income Sales =2756210001374931000=20.05% 2.1.3 Net profit margin This ratio indicates how much of each dollar of sales is left over after all expenses. Net profit margin =Net income Sales =1765950001374931000=12.84% 2.2 Liquidity Ratios An asset's liquidity describes the ease with which it can be converted to cash. Liquidity ratios evaluate a firm's ability to generate sufficient cash to meet its shortterm obligations. 2.2.1 Current ratio:This ratio measures the company's ability to meet its current liabilities with current assets. Current ratio =Current assets Current liabilities=2482154000424467000=584.77% 2.2.2 Quick ratio: This ratio is a stringent test of liquidity that compares highly liquid current assets to current liabilities. Quick ratio = (Current asset - Inventory) Current liabilities=(248215400098078000)424467000=561.66 2.2.3 Net working capital to sales ratio This ratio indicates a company's liquid assets relative to its need for liquidity. Net working capital to sales ratio=(current asset - current liabilities) sales=(2482154000-424467000)1374931000=149.66% 2.3 asset management efficiency 2.3.1 Inventory turnover This ratio indicates how many times inventory is created and sold during the period. Inventory turnover = Cost of goods sold Inventory=923987000 98078000=9.42 times 2.3.2 Accounts receivable turnover This ratio indicates how many times in the period credit sales have been created and collected on. Accounts receivable turnover = Sales on credit Accounts receivable=1374931000334097000=4.12times 2.3.3 Total asset turnover This ratio indicates the extent that the investment in total assets results in sales. Total asset turnover = Sales Total assets=13749310007245597000=0.19 times 2.3.4 Fixed asset turnover This ratio indicates the ability of the company's management to put the fixed assets to work to generate sales. Fixed asset turnover = Sales Fixed assets=1374931000(1561740000+2109665000)=0.3745times 2.4 Distribution decision 2.5 Financing decision 2.6 Cost of capital of the firm Weighted average cost of capital (WACC) All sources of capital, including common stock, preferred stock, bonds and any other long-term debt, are included in a WACC calculation. A firm's WACC increases as the beta and rate of return on equity increase, as an increase in WACC denotes a decrease in valuation and an increase in risk. WACC=(1-T)[D/(D+E)](rd)+[E/(D+E)](re) Date Adj Close 9/1/2016 8/1/2016 7/1/2016 6/1/2016 5/2/2016 4/1/2016 3/1/2016 2/1/2016 1/1/2016 12/1/2015 11/2/2015 10/1/2015 9/1/2015 8/3/2015 7/1/2015 6/1/2015 5/1/2015 4/1/2015 3/2/2015 2/2/2015 1/1/2015 12/1/2014 11/3/2014 10/1/2014 9/1/2014 8/1/2014 7/1/2014 6/2/2014 5/1/2014 4/1/2014 3/3/2014 2/3/2014 1/1/2014 12/2/2013 11/1/2013 10/1/2013 9/2/2013 8/1/2013 7/1/2013 6/3/2013 5/1/2013 4/1/2013 3/1/2013 2/1/2013 1/1/2013 12/3/2012 11/1/2012 10/1/2012 9/3/2012 8/1/2012 monthy return KLSE 2.88 0.0154431986 2.8362 0.0792237443 2.628 0.1181551291 2.3503 0.0106643733 2.3255 0.0821815813 2.1489 0.0579460417 2.0312 -0.0251955656 2.0837 0.0643612402 1.9577 0.0802295426 1.8123 0.089253516 1.6638 0.1372522215 1.463 0.1333178403 1.2909 0.0035761486 1.2863 0.0224147524 1.2581 0.0075278289 1.2487 -0.0332146175 1.2916 0 1.2916 -0.0411284336 1.347 0.0315515393 1.3058 -0.0136717275 1.3239 0 1.3239 -0.1525412879 1.5622 -0.0489467917 1.6426 -0.0416569428 1.714 0.0514047356 1.6302 -0.0750113482 1.7624 0.0152658563 1.7359 0.0344437161 1.6781 -0.0397688258 1.7476 0.0523273318 1.6607 0.0992189568 1.5108 0.1000436872 1.3734 -0.1160455686 1.5537 0.0311255641 1.5068 0.0056730962 1.4983 0.0056379623 1.4899 -0.0028110568 1.4941 0.0113036415 1.4774 -0.0635141988 1.5776 -0.0691527024 1.6948 0.1452125144 1.4799 -0.0677208013 1.5874 0.0604582804 1.4969 0.0110773387 1.4805 -0.0216098335 1.5132 0.0687195423 1.4159 -0.1463796949 1.6587 -0.0237772939 1.6991 -0.0360810121 1.7627 0.0731811263 7/2/2012 6/1/2012 5/1/2012 4/2/2012 3/1/2012 2/1/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 Average monthly return Average yearly return monthly std yearly std Beta 1.6425 1.4742 1.4097 1.3305 1.1483 1.0869 1.0165 0.8523 0.8136 0.7983 0.664 0.027424545 0.3290945406 0.0737570711 0.2555019891 1.1763116574 0.1141636142 0.0457544158 0.0595264938 0.1586693373 0.0564909375 0.0692572553 0.1926551684 0.0475663717 0.0191657272 0.2022590361 Date Adj Close monthy return 9/1/2016 1658.72998 -0.0115193011 8/1/2016 1678.060059 0.0150006949 7/1/2016 1653.26001 -0.0004957112 6/1/2016 1654.079956 0.0172693456 5/3/2016 1626 -0.0279305394 4/1/2016 1672.719971 -0.0261181349 3/1/2016 1717.579956 0.0379694552 2/2/2016 1654.75 -0.0078247084 1/4/2016 1667.800049 -0.0145995952 12/1/2015 1692.51001 0.0121698734 11/2/2015 1672.160034 0.0038722666 10/1/2015 1665.709961 0.0275563348 9/1/2015 1621.040039 0.0051465512 8/3/2015 1612.73999 -0.0640690971 7/1/2015 1723.140015 0.0096681197 6/1/2015 1706.640015 -0.023393154 5/1/2015 1747.52002 -0.0389106124 4/1/2015 1818.27002 -0.0068331579 3/2/2015 1830.780029 0.0052547857 2/2/2015 1821.209961 0.0224279166 1/2/2015 1781.26001 0.0113612548 12/1/2014 1761.25 -0.0327532221 11/3/2014 1820.890015 -0.018467514 10/1/2014 1855.150024 0.0047879092 9/2/2014 1846.310059 -0.0106102674 8/1/2014 1866.109985 -0.0028054463 7/1/2014 1871.359985 -0.0060285313 6/2/2014 1882.709961 0.0049802795 5/2/2014 1873.380005 0.0009938366 4/1/2014 1871.52002 0.0120646435 3/3/2014 1849.209961 0.0073815013 2/4/2014 1835.660034 0.0175329703 1/2/2014 1804.030029 -0.0337071674 12/2/2013 1866.959961 0.0299218803 11/1/2013 1812.719971 0.0032487451 10/1/2013 1806.849976 0.0216157123 9/2/2013 1768.619995 0.0237557972 8/1/2013 1727.579956 -0.0254087391 7/1/2013 1772.619995 -0.0005187613 6/3/2013 1773.540039 0.0024417925 5/2/2013 1769.219971 0.0300235475 4/1/2013 1717.650024 0.0275300269 3/1/2013 1671.630005 0.0207617105 2/4/2013 1637.630005 0.0061933309 1/2/2013 1627.550049 -0.0363538907 12/3/2012 1688.949951 0.0484967359 11/1/2012 1610.829956 -0.0372010687 10/1/2012 1673.069946 0.0222464722 9/3/2012 1636.660034 -0.0057407774 8/1/2012 1646.109985 0.0088931167 7/2/2012 6/1/2012 5/2/2012 4/2/2012 3/1/2012 2/2/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 1631.599976 1599.150024 1580.670044 1570.609985 1596.329956 1569.650024 1521.290039 1530.72998 1472.099976 1491.890015 1387.130005 0.0202919998 0.0116912319 0.0064051923 -0.0161119391 0.0169973762 0.0317888001 -0.0061669538 0.0398274607 -0.0132650791 0.0755228491 Date Adj Close 9/1/2016 8/1/2016 7/1/2016 6/1/2016 5/2/2016 4/1/2016 3/1/2016 2/1/2016 1/1/2016 12/1/2015 11/2/2015 10/1/2015 9/1/2015 8/3/2015 7/1/2015 6/1/2015 5/1/2015 4/1/2015 3/2/2015 2/2/2015 1/1/2015 12/1/2014 11/3/2014 10/1/2014 9/1/2014 8/1/2014 7/1/2014 6/2/2014 5/1/2014 4/1/2014 3/3/2014 2/3/2014 1/1/2014 12/2/2013 11/1/2013 10/1/2013 9/2/2013 8/1/2013 7/1/2013 6/3/2013 5/1/2013 4/1/2013 3/1/2013 2/1/2013 1/1/2013 12/3/2012 11/1/2012 10/1/2012 9/3/2012 8/1/2012 7/2/2012 6/1/2012 5/1/2012 2.8 2.94 2.93 2.6 2.3 1.866 1.798 1.444 1.395 1.267 1.336 1.454 1.257 0.855 1.336 1.513 2.122 2.199 2.306 2.538 2.713 2.635 2.5 2.422 2.451 2.335 2.364 2.228 2.383 2.107 2.431 2.431 2.155 2.097 2.278 2.555 2.441 2.46 3.013 3.041 3.051 2.74 2.647 2.722 2.6 2.563 2.665 2.834 2.824 3.227 3.498 3.339 3.247 monthy return KLSE -0.0476190476 0.0034129693 0.1269230769 0.1304347826 0.2325830654 0.0378197998 0.2451523546 0.035125448 0.1010260458 -0.0516467066 -0.0811554333 0.1567223548 0.4701754386 -0.3600299401 -0.1169861203 -0.2869934025 -0.0350159163 -0.0464006938 -0.0914105595 -0.0645042388 0.029601518 0.054 0.0322047894 -0.0118319053 0.0496788009 -0.0122673435 0.0610412926 -0.0650440621 0.1309919317 -0.1332784862 0 0.1280742459 0.0276585598 -0.0794556629 -0.1084148728 0.0467021712 -0.0077235772 -0.183538002 -0.0092074975 -0.0032776139 0.1135036496 0.0351341141 -0.0275532697 0.0469230769 0.0144362076 -0.0382739212 -0.0596330275 0.0035410765 -0.124883793 -0.0774728416 0.0476190476 0.0283338466 0.0569661458 4/2/2012 3/1/2012 2/1/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 Average monthly return Average yearly return monthly std yearly std Beta 3.072 3.183 3.376 3.275 3.478 3.404 3.598 2.795 0.0076286453 0.0915437437 0.1239720677 0.4294518401 1.8833540941 -0.0348727615 -0.0571682464 0.0308396947 -0.0583668775 0.0217391304 -0.0539188438 0.2872987478 Date Adj Close monthy return 9/1/2016 1658.72998 -0.0115193011 8/1/2016 1678.060059 0.0150006949 7/1/2016 1653.26001 -0.0004957112 6/1/2016 1654.079956 0.0172693456 5/3/2016 1626 -0.0279305394 4/1/2016 1672.719971 -0.0261181349 3/1/2016 1717.579956 0.0379694552 2/2/2016 1654.75 -0.0078247084 1/4/2016 1667.800049 -0.0145995952 12/1/2015 1692.51001 0.0121698734 11/2/2015 1672.160034 0.0038722666 10/1/2015 1665.709961 0.0275563348 9/1/2015 1621.040039 0.0051465512 8/3/2015 1612.73999 -0.0640690971 7/1/2015 1723.140015 0.0096681197 6/1/2015 1706.640015 -0.023393154 5/1/2015 1747.52002 -0.0389106124 4/1/2015 1818.27002 -0.0068331579 3/2/2015 1830.780029 0.0052547857 2/2/2015 1821.209961 0.0224279166 1/2/2015 1781.26001 0.0113612548 12/1/2014 1761.25 -0.0327532221 11/3/2014 1820.890015 -0.018467514 10/1/2014 1855.150024 0.0047879092 9/2/2014 1846.310059 -0.0106102674 8/1/2014 1866.109985 -0.0028054463 7/1/2014 1871.359985 -0.0060285313 6/2/2014 1882.709961 0.0049802795 5/2/2014 1873.380005 0.0009938366 4/1/2014 1871.52002 0.0120646435 3/3/2014 1849.209961 0.0073815013 2/4/2014 1835.660034 0.0175329703 1/2/2014 1804.030029 -0.0337071674 12/2/2013 1866.959961 0.0299218803 11/1/2013 1812.719971 0.0032487451 10/1/2013 1806.849976 0.0216157123 9/2/2013 1768.619995 0.0237557972 8/1/2013 1727.579956 -0.0254087391 7/1/2013 1772.619995 -0.0005187613 6/3/2013 1773.540039 0.0024417925 5/2/2013 1769.219971 0.0300235475 4/1/2013 1717.650024 0.0275300269 3/1/2013 1671.630005 0.0207617105 2/4/2013 1637.630005 0.0061933309 1/2/2013 1627.550049 -0.0363538907 12/3/2012 1688.949951 0.0484967359 11/1/2012 1610.829956 -0.0372010687 10/1/2012 1673.069946 0.0222464722 9/3/2012 1636.660034 -0.0057407774 8/1/2012 1646.109985 0.0088931167 7/2/2012 1631.599976 0.0202919998 6/1/2012 1599.150024 0.0116912319 5/2/2012 1580.670044 0.0064051923 4/2/2012 3/1/2012 2/2/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 1570.609985 1596.329956 1569.650024 1521.290039 1530.72998 1472.099976 1491.890015 1387.130005 -0.0161119391 0.0169973762 0.0317888001 -0.0061669538 0.0398274607 -0.0132650791 0.0755228491 Date Adj Close 9/1/2016 8/1/2016 7/1/2016 6/1/2016 5/2/2016 4/1/2016 3/1/2016 2/1/2016 1/1/2016 12/1/2015 11/2/2015 10/1/2015 9/1/2015 8/3/2015 7/1/2015 6/1/2015 5/1/2015 4/1/2015 3/2/2015 2/2/2015 1/1/2015 12/1/2014 11/3/2014 10/1/2014 9/1/2014 8/1/2014 7/1/2014 6/2/2014 5/1/2014 4/1/2014 3/3/2014 2/3/2014 1/1/2014 12/2/2013 11/1/2013 10/1/2013 9/2/2013 8/1/2013 7/1/2013 6/3/2013 5/1/2013 4/1/2013 3/1/2013 2/1/2013 1/1/2013 12/3/2012 11/1/2012 10/1/2012 9/3/2012 8/1/2012 7/2/2012 6/1/2012 5/1/2012 6.7 7.399 6.738 6.678 6.639 6.56 6.511 6.392 6.295 6.566 6.305 6.45 6.469 6.196 6.253 6.244 6.95 6.946 6.815 6.675 6.553 6.45 6.637 6.75 6.187 5.875 5.764 5.865 5.708 5.583 5.331 5.106 4.962 4.998 4.629 4.719 4.719 4.783 4.66 4.775 4.854 4.775 4.662 4.602 4.801 5.224 4.731 5.172 5.354 5.174 4.808 4.808 4.587 monthy return KLSE -0.094472226 0.0981003265 0.008984726 0.0058743787 0.0120426829 0.0075257257 0.0186170213 0.0154090548 -0.0412732257 0.0413957177 -0.0224806202 -0.0029370846 0.0440606843 -0.0091156245 0.0014413837 -0.1015827338 0.000575871 0.0192223037 0.0209737828 0.0186174271 0.0159689922 -0.0281753804 -0.0167407407 0.0909972523 0.053106383 0.0192574601 -0.0172208014 0.0275052558 0.0223893964 0.0472706809 0.0440658049 0.0290205562 -0.0072028812 0.0797148412 -0.0190718373 0 -0.0133807234 0.0263948498 -0.0240837696 -0.0162752369 0.0165445026 0.0242385242 0.0130378096 -0.041449698 -0.0809724349 0.1042062989 -0.0852668213 -0.0339932761 0.0347893313 0.0761231281 0 0.0481796381 0.0186542305 4/2/2012 3/1/2012 2/1/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 Average monthly return Average yearly return monthly std yearly std Beta 4.503 4.445 4.336 4.01 4.144 3.609 3.542 3.417 0.0123249446 0.1478993352 0.0458304827 0.1587614493 0.971417492 0.013048369 0.0251383764 0.0812967581 -0.0323359073 0.1482405098 0.0189158667 0.0365817969 Date Adj Close monthy return 9/1/2016 1658.72998 -0.0115193011 8/1/2016 1678.060059 0.0150006949 7/1/2016 1653.26001 -0.0004957112 6/1/2016 1654.079956 0.0172693456 5/3/2016 1626 -0.0279305394 4/1/2016 1672.719971 -0.0261181349 3/1/2016 1717.579956 0.0379694552 2/2/2016 1654.75 -0.0078247084 1/4/2016 1667.800049 -0.0145995952 12/1/2015 1692.51001 0.0121698734 11/2/2015 1672.160034 0.0038722666 10/1/2015 1665.709961 0.0275563348 9/1/2015 1621.040039 0.0051465512 8/3/2015 1612.73999 -0.0640690971 7/1/2015 1723.140015 0.0096681197 6/1/2015 1706.640015 -0.023393154 5/1/2015 1747.52002 -0.0389106124 4/1/2015 1818.27002 -0.0068331579 3/2/2015 1830.780029 0.0052547857 2/2/2015 1821.209961 0.0224279166 1/2/2015 1781.26001 0.0113612548 12/1/2014 1761.25 -0.0327532221 11/3/2014 1820.890015 -0.018467514 10/1/2014 1855.150024 0.0047879092 9/2/2014 1846.310059 -0.0106102674 8/1/2014 1866.109985 -0.0028054463 7/1/2014 1871.359985 -0.0060285313 6/2/2014 1882.709961 0.0049802795 5/2/2014 1873.380005 0.0009938366 4/1/2014 1871.52002 0.0120646435 3/3/2014 1849.209961 0.0073815013 2/4/2014 1835.660034 0.0175329703 1/2/2014 1804.030029 -0.0337071674 12/2/2013 1866.959961 0.0299218803 11/1/2013 1812.719971 0.0032487451 10/1/2013 1806.849976 0.0216157123 9/2/2013 1768.619995 0.0237557972 8/1/2013 1727.579956 -0.0254087391 7/1/2013 1772.619995 -0.0005187613 6/3/2013 1773.540039 0.0024417925 5/2/2013 1769.219971 0.0300235475 4/1/2013 1717.650024 0.0275300269 3/1/2013 1671.630005 0.0207617105 2/4/2013 1637.630005 0.0061933309 1/2/2013 1627.550049 -0.0363538907 12/3/2012 1688.949951 0.0484967359 11/1/2012 1610.829956 -0.0372010687 10/1/2012 1673.069946 0.0222464722 9/3/2012 1636.660034 -0.0057407774 8/1/2012 1646.109985 0.0088931167 7/2/2012 1631.599976 0.0202919998 6/1/2012 1599.150024 0.0116912319 5/2/2012 1580.670044 0.0064051923 4/2/2012 3/1/2012 2/2/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 1570.609985 1596.329956 1569.650024 1521.290039 1530.72998 1472.099976 1491.890015 1387.130005 -0.0161119391 0.0169973762 0.0317888001 -0.0061669538 0.0398274607 -0.0132650791 0.0755228491 Date Adj Close 9/1/2016 8/1/2016 7/1/2016 6/1/2016 5/2/2016 4/1/2016 3/1/2016 2/1/2016 1/1/2016 12/1/2015 11/2/2015 10/1/2015 9/1/2015 8/3/2015 7/1/2015 6/1/2015 5/1/2015 4/1/2015 3/2/2015 2/2/2015 1/1/2015 12/1/2014 11/3/2014 10/1/2014 9/1/2014 8/1/2014 7/1/2014 6/2/2014 5/1/2014 4/1/2014 3/3/2014 2/3/2014 1/1/2014 12/2/2013 11/1/2013 10/1/2013 9/2/2013 8/1/2013 7/1/2013 6/3/2013 5/1/2013 4/1/2013 3/1/2013 2/1/2013 1/1/2013 12/3/2012 11/1/2012 10/1/2012 9/3/2012 8/1/2012 7/2/2012 6/1/2012 5/1/2012 10.8 10.381 10.521 10.6 10.351 10.65 11.147 10.789 11.386 10.55 10.212 10.65 9.863 9.799 10.325 9.838 9.789 9.799 10.026 10.284 10.046 9.888 10.58 10.462 9.819 9.918 10.864 11.436 11.081 10.943 10.647 10.352 10.154 10.884 10.844 10.726 9.267 9.32 9.684 9.065 8.786 8.356 8.444 8.269 8.034 8.786 8.366 8.766 8.981 9.027 9.183 9.037 9.029 monthy return KLSE 0.0403622002 -0.0133067199 -0.0074528302 0.0240556468 -0.0280751174 -0.0445859873 0.0331819446 -0.0524328122 0.0792417062 0.0330983157 -0.0411267606 0.0797931664 0.0065312787 -0.0509443099 0.0495019313 0.0050056186 -0.0010205123 -0.0226411331 -0.0250875146 0.0236910213 0.0159789644 -0.0654064272 0.0112789142 0.0654852836 -0.0099818512 -0.0870765832 -0.0500174886 0.0320368198 0.0126108014 0.0278012586 0.0284969088 0.0194997045 -0.0670709298 0.0036886758 0.0110013052 0.1574403798 -0.0056866953 -0.0375877736 0.0682846111 0.0317550649 0.0514600287 -0.0104216011 0.0211633813 0.0292506846 -0.0855907125 0.0502032034 -0.0456308465 -0.0239394277 -0.0050958236 -0.0169879124 0.0161558039 0.0008860339 -0.0052880908 4/2/2012 3/1/2012 2/1/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 Average monthly return Average yearly return monthly std yearly std Beta 9.077 9.164 8.981 9.077 8.305 7.851 7.098 6.76 0.0088943432 0.106732119 0.0463525385 0.1605699034 0.9014058844 -0.0094936709 0.0203763501 -0.0105761816 0.0929560506 0.0578270284 0.1060862215 0.05 Date Adj Close monthy return 9/1/2016 1658.72998 -0.0115193011 8/1/2016 1678.060059 0.0150006949 7/1/2016 1653.26001 -0.0004957112 6/1/2016 1654.079956 0.0172693456 5/3/2016 1626 -0.0279305394 4/1/2016 1672.719971 -0.0261181349 3/1/2016 1717.579956 0.0379694552 2/2/2016 1654.75 -0.0078247084 1/4/2016 1667.800049 -0.0145995952 12/1/2015 1692.51001 0.0121698734 11/2/2015 1672.160034 0.0038722666 10/1/2015 1665.709961 0.0275563348 9/1/2015 1621.040039 0.0051465512 8/3/2015 1612.73999 -0.0640690971 7/1/2015 1723.140015 0.0096681197 6/1/2015 1706.640015 -0.023393154 5/1/2015 1747.52002 -0.0389106124 4/1/2015 1818.27002 -0.0068331579 3/2/2015 1830.780029 0.0052547857 2/2/2015 1821.209961 0.0224279166 1/2/2015 1781.26001 0.0113612548 12/1/2014 1761.25 -0.0327532221 11/3/2014 1820.890015 -0.018467514 10/1/2014 1855.150024 0.0047879092 9/2/2014 1846.310059 -0.0106102674 8/1/2014 1866.109985 -0.0028054463 7/1/2014 1871.359985 -0.0060285313 6/2/2014 1882.709961 0.0049802795 5/2/2014 1873.380005 0.0009938366 4/1/2014 1871.52002 0.0120646435 3/3/2014 1849.209961 0.0073815013 2/4/2014 1835.660034 0.0175329703 1/2/2014 1804.030029 -0.0337071674 12/2/2013 1866.959961 0.0299218803 11/1/2013 1812.719971 0.0032487451 10/1/2013 1806.849976 0.0216157123 9/2/2013 1768.619995 0.0237557972 8/1/2013 1727.579956 -0.0254087391 7/1/2013 1772.619995 -0.0005187613 6/3/2013 1773.540039 0.0024417925 5/2/2013 1769.219971 0.0300235475 4/1/2013 1717.650024 0.0275300269 3/1/2013 1671.630005 0.0207617105 2/4/2013 1637.630005 0.0061933309 1/2/2013 1627.550049 -0.0363538907 12/3/2012 1688.949951 0.0484967359 11/1/2012 1610.829956 -0.0372010687 10/1/2012 1673.069946 0.0222464722 9/3/2012 1636.660034 -0.0057407774 8/1/2012 1646.109985 0.0088931167 7/2/2012 1631.599976 0.0202919998 6/1/2012 1599.150024 0.0116912319 5/2/2012 1580.670044 0.0064051923 4/2/2012 3/1/2012 2/2/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 1570.609985 1596.329956 1569.650024 1521.290039 1530.72998 1472.099976 1491.890015 1387.130005 -0.0161119391 0.0169973762 0.0317888001 -0.0061669538 0.0398274607 -0.0132650791 0.0755228491 Date Adj Close 9/1/2016 8/1/2016 7/1/2016 6/1/2016 5/2/2016 4/1/2016 3/1/2016 2/1/2016 1/1/2016 12/1/2015 11/2/2015 10/1/2015 9/1/2015 8/3/2015 7/1/2015 6/1/2015 5/1/2015 4/1/2015 3/2/2015 2/2/2015 1/1/2015 12/1/2014 11/3/2014 10/1/2014 9/1/2014 8/1/2014 7/1/2014 6/2/2014 5/1/2014 4/1/2014 3/3/2014 2/3/2014 1/1/2014 12/2/2013 11/1/2013 10/1/2013 9/2/2013 8/1/2013 7/1/2013 6/3/2013 5/1/2013 4/1/2013 3/1/2013 2/1/2013 1/1/2013 12/3/2012 11/1/2012 10/1/2012 9/3/2012 8/1/2012 monthy return KLSE 6.66 0.0045248869 6.63 0.0231481481 6.48 -0.0091743119 6.54 0.0046082949 6.51 -0.0195783133 6.64 0 6.64 0.009118541 6.58 -0.0613409415 7.01 -0.0112834979 7.09 0.0791476408 6.57 0.0613893376 6.19 0.0333889816 5.99 0.0118243243 5.92 -0.038961039 6.16 0.0131578947 6.08 0.0099667774 6.02 0.0654867257 5.65 0.0424354244 5.42 0.0463320463 5.18 0.0724637681 4.83 -0.0657640232 5.17 -0.031835206 5.34 -0.0840480274 5.83 -0.013536379 5.91 -0.0100502513 5.97 -0.040192926 6.22 -0.0189274448 6.34 0.0047543582 6.31 0.0015873016 6.3 -0.0262751159 6.47 0.0237341772 6.32 0.0326797386 6.12 -0.0422535211 6.39 0.0289855072 6.21 -0.0504587156 6.54 0.0380952381 6.3 0.0482529118 6.01 0 6.01 0 6.01 0.0238500852 5.87 0.0103270224 5.81 0.0192982456 5.7 0.0088495575 5.65 0.0680529301 5.29 -0.0702987698 5.69 0.0756143667 5.29 -0.0847750865 5.78 0.0158172232 5.69 0 5.69 -0.0172711572 7/2/2012 6/1/2012 5/1/2012 4/2/2012 3/1/2012 2/1/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 Average monthly return Average yearly return monthly std yearly std Beta 5.79 5.68 5.81 5.67 5.85 5.81 5.79 5.38 5.13 5.52 4.76 0.0066011927 0.0792143128 0.0447655951 0.1550725702 1.0885637929 0.0193661972 -0.0223752151 0.024691358 -0.0307692308 0.0068846816 0.0034542314 0.0762081784 0.0487329435 -0.0706521739 0.1596638655 Date Adj Close monthy return 9/1/2016 1658.72998 -0.0115193011 8/1/2016 1678.060059 0.0150006949 7/1/2016 1653.26001 -0.0004957112 6/1/2016 1654.079956 0.0172693456 5/3/2016 1626 -0.0279305394 4/1/2016 1672.719971 -0.0261181349 3/1/2016 1717.579956 0.0379694552 2/2/2016 1654.75 -0.0078247084 1/4/2016 1667.800049 -0.0145995952 12/1/2015 1692.51001 0.0121698734 11/2/2015 1672.160034 0.0038722666 10/1/2015 1665.709961 0.0275563348 9/1/2015 1621.040039 0.0051465512 8/3/2015 1612.73999 -0.0640690971 7/1/2015 1723.140015 0.0096681197 6/1/2015 1706.640015 -0.023393154 5/1/2015 1747.52002 -0.0389106124 4/1/2015 1818.27002 -0.0068331579 3/2/2015 1830.780029 0.0052547857 2/2/2015 1821.209961 0.0224279166 1/2/2015 1781.26001 0.0113612548 12/1/2014 1761.25 -0.0327532221 11/3/2014 1820.890015 -0.018467514 10/1/2014 1855.150024 0.0047879092 9/2/2014 1846.310059 -0.0106102674 8/1/2014 1866.109985 -0.0028054463 7/1/2014 1871.359985 -0.0060285313 6/2/2014 1882.709961 0.0049802795 5/2/2014 1873.380005 0.0009938366 4/1/2014 1871.52002 0.0120646435 3/3/2014 1849.209961 0.0073815013 2/4/2014 1835.660034 0.0175329703 1/2/2014 1804.030029 -0.0337071674 12/2/2013 1866.959961 0.0299218803 11/1/2013 1812.719971 0.0032487451 10/1/2013 1806.849976 0.0216157123 9/2/2013 1768.619995 0.0237557972 8/1/2013 1727.579956 -0.0254087391 7/1/2013 1772.619995 -0.0005187613 6/3/2013 1773.540039 0.0024417925 5/2/2013 1769.219971 0.0300235475 4/1/2013 1717.650024 0.0275300269 3/1/2013 1671.630005 0.0207617105 2/4/2013 1637.630005 0.0061933309 1/2/2013 1627.550049 -0.0363538907 12/3/2012 1688.949951 0.0484967359 11/1/2012 1610.829956 -0.0372010687 10/1/2012 1673.069946 0.0222464722 9/3/2012 1636.660034 -0.0057407774 8/1/2012 1646.109985 0.0088931167 7/2/2012 6/1/2012 5/2/2012 4/2/2012 3/1/2012 2/2/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 1631.599976 1599.150024 1580.670044 1570.609985 1596.329956 1569.650024 1521.290039 1530.72998 1472.099976 1491.890015 1387.130005 0.0202919998 0.0116912319 0.0064051923 -0.0161119391 0.0169973762 0.0317888001 -0.0061669538 0.0398274607 -0.0132650791 0.0755228491 GENTING PLANTATION Date Adj Close monthy return 9/1/2016 10.8 0.0403622002 8/1/2016 10.381 -0.0133067199 7/1/2016 10.521 -0.0074528302 6/1/2016 10.6 0.0240556468 5/2/2016 10.351 -0.0280751174 4/1/2016 10.65 -0.0445859873 3/1/2016 11.147 0.0331819446 2/1/2016 10.789 -0.0524328122 1/1/2016 11.386 0.0792417062 12/1/2015 10.55 0.0330983157 11/2/2015 10.212 -0.0411267606 10/1/2015 10.65 0.0797931664 9/1/2015 9.863 0.0065312787 8/3/2015 9.799 -0.0509443099 7/1/2015 10.325 0.0495019313 6/1/2015 9.838 0.0050056186 5/1/2015 9.789 -0.0010205123 4/1/2015 9.799 -0.0226411331 3/2/2015 10.026 -0.0250875146 2/2/2015 10.284 0.0236910213 1/1/2015 10.046 0.0159789644 12/1/2014 9.888 -0.0654064272 11/3/2014 10.58 0.0112789142 10/1/2014 10.462 0.0654852836 9/1/2014 9.819 -0.0099818512 8/1/2014 9.918 -0.0870765832 7/1/2014 10.864 -0.0500174886 6/2/2014 11.436 0.0320368198 5/1/2014 11.081 0.0126108014 4/1/2014 10.943 0.0278012586 3/3/2014 10.647 0.0284969088 2/3/2014 10.352 0.0194997045 1/1/2014 10.154 -0.0670709298 12/2/2013 10.884 0.0036886758 11/1/2013 10.844 0.0110013052 10/1/2013 10.726 0.1574403798 9/2/2013 9.267 -0.0056866953 8/1/2013 9.32 -0.0375877736 7/1/2013 9.684 0.0682846111 6/3/2013 9.065 0.0317550649 5/1/2013 8.786 0.0514600287 4/1/2013 8.356 -0.0104216011 3/1/2013 8.444 0.0211633813 2/1/2013 8.269 0.0292506846 1/1/2013 8.034 -0.0855907125 12/3/2012 8.786 0.0502032034 11/1/2012 8.366 -0.0456308465 10/1/2012 8.766 -0.0239394277 9/3/2012 8.981 -0.0050958236 8/1/2012 9.027 -0.0169879124 7/2/2012 9.183 0.0161558039 6/1/2012 9.037 0.0008860339 5/1/2012 9.029 -0.0052880908 4/2/2012 9.077 -0.0094936709 3/1/2012 9.164 0.0203763501 2/1/2012 8.981 -0.0105761816 1/3/2012 9.077 0.0929560506 12/1/2011 8.305 0.0578270284 11/1/2011 7.851 0.1060862215 10/3/2011 7.098 0.05 9/22/2011 6.76 Average monthly return 0.0088943432 Average yearly return 0.106732119 monthly std 0.0463525385 yearly std 0.1605699034 Beta 0.901405884 Correlation between GENTING PLANTATION&Telekom Malaysia Berhad correlation 0.1439149764 Telekom Malaysia Berhad Date Adj Close 9/1/2016 8/1/2016 7/1/2016 6/1/2016 5/2/2016 4/1/2016 3/1/2016 2/1/2016 1/1/2016 12/1/2015 11/2/2015 10/1/2015 9/1/2015 8/3/2015 7/1/2015 6/1/2015 5/1/2015 4/1/2015 3/2/2015 2/2/2015 1/1/2015 12/1/2014 11/3/2014 10/1/2014 9/1/2014 8/1/2014 7/1/2014 6/2/2014 5/1/2014 4/1/2014 3/3/2014 2/3/2014 1/1/2014 12/2/2013 11/1/2013 10/1/2013 9/2/2013 8/1/2013 7/1/2013 6/3/2013 5/1/2013 4/1/2013 3/1/2013 2/1/2013 1/1/2013 12/3/2012 11/1/2012 10/1/2012 9/3/2012 8/1/2012 6.7 7.399 6.738 6.678 6.639 6.56 6.511 6.392 6.295 6.566 6.305 6.45 6.469 6.196 6.253 6.244 6.95 6.946 6.815 6.675 6.553 6.45 6.637 6.75 6.187 5.875 5.764 5.865 5.708 5.583 5.331 5.106 4.962 4.998 4.629 4.719 4.719 4.783 4.66 4.775 4.854 4.775 4.662 4.602 4.801 5.224 4.731 5.172 5.354 5.174 laysia Berhad correlation 7/2/2012 6/1/2012 5/1/2012 4/2/2012 3/1/2012 2/1/2012 1/3/2012 12/1/2011 11/1/2011 10/3/2011 9/22/2011 Average monthly return Average yearly return monthly std yearly std Beta 4.808 4.808 4.587 4.503 4.445 4.336 4.01 4.144 3.609 3.542 3.417 0.0123249446 0.1478993352 0.0458304827 0.1587614493 0.971417492 monthy return -0.094472226 0.0981003265 0.008984726 0.0058743787 0.0120426829 0.0075257257 0.0186170213 0.0154090548 -0.0412732257 0.0413957177 -0.0224806202 -0.0029370846 0.0440606843 -0.0091156245 0.0014413837 -0.1015827338 0.000575871 0.0192223037 0.0209737828 0.0186174271 0.0159689922 -0.0281753804 -0.0167407407 0.0909972523 0.053106383 0.0192574601 -0.0172208014 0.0275052558 0.0223893964 0.0472706809 0.0440658049 0.0290205562 -0.0072028812 0.0797148412 -0.0190718373 0 -0.0133807234 0.0263948498 -0.0240837696 -0.0162752369 0.0165445026 0.0242385242 0.0130378096 -0.041449698 -0.0809724349 0.1042062989 -0.0852668213 -0.0339932761 0.0347893313 0.0761231281 0 0.0481796381 0.0186542305 0.013048369 0.0251383764 0.0812967581 -0.0323359073 0.1482405098 0.0189158667 0.0365817969 PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Profitability beta Beta Weight 1.1763117 0.1176 1.8833541 0.0288 0.9714175 0.0344 0.9014059 0.4328 1.0885638 0.0663 Average Beta 0.1383342509 0.0542405979 0.0334167617 0.3901284666 0.0721717795 0.6882918566 Market: Initial capital: Transaction cost: Malaysia RM 1,000,000 0.50% per transaction Transaction Date Time (optional) Stock Name Buy/Sell 1 14-Sep-16 13:10 PADINI Buy 2 14-Sep-16 14:20 AIR ASIA Buy 3 14-Sep-16 16:20 Telekom MalaysBuy 4 14-Sep-16 16:30 GENTING PLABuy 5 Buying /Selling price RM2.94 RM2.89 RM6.89 RM10.74 16:30 Petronas ChBuy 14-Sep-16 RM6.65 Week 1 Wednesday Summary (14th Septenmber 2016) Holdings on: 14-Sep-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 14th Septenmber 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 14-Sep-16 1,000,000 319,565 679,900 (535) Week 1 Thursday Summary ( 15th Septenmber 2016)(Because 16th is Malaysia Day) Holdings on: 15-Sep-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 15th Septenmber 2016): Initial Cash Capital Ending Cash Capital Total Stock Market value Unrealised Gain/Loss 15-Sep-16 1,000,000 319,565 684,600 4,165 Week 2 Wednesday Summary (21st Septenmber 2016) Holdings on: 21-Sep-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 21st Septenmber 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 21-Sep-16 1,000,000 319,565 676,100 (4,335) Week 2 Friday Summary (23rd Septenmber 2016) Holdings on: 23-Sep-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 21st Septenmber 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 23-Sep-16 1,000,000 319,565 680,400 (35) Week 3 Wednesday Summary (28th Septenmber 2016) Holdings on: 28-Sep-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 28th Septenmber 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 28-Sep-16 1,000,000 319,565 677,350 (3,085) Transaction Date Time (optional) Stock Name Buy/Sell 6 30-Sep-16 12:26 PADINI Sell 7 30-Sep-16 12:29 AIR ASIA Sell 8 30-Sep-16 11:54 Telekom MalaysSell 9 29-Sep-16 16:44 GENTING PLASell 10 30-Sep-16 Buying /Selling price RM2.86 RM2.84 RM6.77 RM10.94 15:38 Petronas ChSell RM6.70 Week 3 Friday Summary (30th Septenmber 2016) Holdings on: 30-Sep-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 30th Septenmber 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 30-Sep-16 1,000,000 997,409 0.00 0.00 Transaction Date 11 12 13 14 15 Time (optional) Stock Name Buy/Sell 5-Oct-16 16:00 PADINI Buy 4-Oct-16 10:15 AIR ASIA Buy 4-Oct-16 9:20 Telekom MalaysBuy 4-Oct-16 15:50 GENTING PLABuy 4-Oct-16 15:50 Petronas ChBuy Week 4 Wednesday Summary (5th October 2016) Holdings on: 5-Oct-16 5pm PADINI AIR ASIA Buying /Selling price RM2.71 RM2.78 RM6.75 RM10.60 RM6.58 Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 5th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 5-Oct-16 1,000,000 3,514 965,420 (28,475) Week 4 Friday Summary ( 7th October 2016) Holdings on: 7-Oct-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 7th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 7-Oct-16 1,000,000 3,514 981,880 (12,015) Week 5 Wednesday Summary (12th October 2016) Holdings on: 12-Oct-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 12th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 12-Oct-16 1,000,000 3,514 961,800 (32,095) Transaction Date Time (optional) Stock Name Buy/Sell 16 14-Oct-16 9:43 PADINI Sell 17 14-Oct-16 9:38 AIR ASIA Sell 18 13-Oct-16 16:43 Telekom MalaysSell 19 14-Oct-16 16:45 GENTING PLASell 20 14-Oct-16 Buying /Selling price RM2.86 RM2.82 RM6.70 RM10.78 10:52 Petronas ChSell RM6.82 Week 5 Friday Summary (14th October 2016) Holdings on: 14-Oct-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 14th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 14-Oct-16 1,000,000 1,029,857 0.00 0.00 Transaction Date Time (optional) Stock Name Buy/Sell 21 17-Oct-16 9:34 PADINI Buy 22 17-Oct-16 14:52 AIR ASIA Buy 23 17-Oct-16 16:14 Telekom MalaysBuy 24 19-Oct-16 12:05 GENTING PLABuy 25 18-Oct-16 11:29 Petronas ChBuy Week 6 Wednesday Summary (19th October 2016) Holdings on: 19-Oct-16 5pm PADINI AIR ASIA Buying /Selling price RM2.84 RM2.78 RM6.64 RM10.64 RM6.80 Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 19th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 19-Oct-16 1,000,000 9,942 600,200 (419,714) Week 6 Friday Summary ( 21th October 2016) Holdings on: 21-Oct-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 15th Septenmber 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 21-Oct-16 1,000,000 9,942 601,000 (418,914) Transaction Date Time (optional) Stock Name Buy/Sell 26 24-Oct-16 15:40 PADINI Sell 27 26-Oct-16 15:10 AIR ASIA Sell 28 24-Oct-16 9:30 Telekom MalaysSell 29 26-Oct-16 11:20 GENTING PLASell 30 24-Oct-16 Buying /Selling price RM3.00 RM2.84 RM6.68 RM10.76 11:15 Petronas ChSell Week 7 Wednesday Summary (26th October 2016) Holdings on: 26-Oct-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad RM7.01 Total Portfolio performance (from 26th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 26-Oct-16 1,000,000 1,062,782 0.00 0.00 Transaction Date Time (optional) Stock Name Buy/Sell 31 27-Oct-16 10:10 PADINI Buy 32 27-Oct-16 16:50 AIR ASIA Buy 33 27-Oct-16 9:45 Telekom MalaysBuy 34 27-Oct-16 13:45 GENTING PLABuy 35 27-Oct-16 Buying /Selling price RM2.98 RM2.78 RM6.56 RM10.70 10:15 Petronas ChBuy RM6.98 Week 7 Friday Summary ( 28th October 2016) Holdings on: 28-Oct-16 5pm PADINI AIR ASIA Telekom Malaysia Berhad GENTING PLANTATION Petronas Chemicals Group Berhad Total Portfolio performance (from 28th October 2016): Initial Cash Ending Cash Total Stock Unrealised Capital Capital Market value Gain/Loss 28-Oct-16 1,000,000 193,628 808,650 2,278 Quantity 40,000 10,000 5,000 40,000 Transaction cost (0.5% per Total transaction) Total Cost Proceeds 588 118,188 145 29,045 172 34,622 2,148 431,748 10,000 Realised Gain/Loss - 333 66,833 Market price (closing price) Quantity RM2.94 40,000 RM2.88 10,000 RM6.88 5,000 RM10.82 40,000 RM6.63 10,000 RM2.94 RM2.88 RM6.88 RM10.82 RM6.63 40,000 10,000 5,000 40,000 10,000 % Change Total Change in in Active Portfolio Active Portfolio Portfolio Value Value Value 999,465 (535) -0.05% Index on 14th day 1661.39 RM2.94 RM2.88 RM6.78 RM10.96 RM6.59 Realised Gain/Loss Total Portfolio Value % Change Change in in Active Active Portfolio Portfolio Value Value 40,000 10,000 5,000 40,000 10,000 Index on 14th day - 1,004,165 4,165 0.42% 1661.39 RM2.88 RM2.80 RM6.70 RM10.82 RM6.66 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 0 995,665 (4,335) -0.43% Index on 14th day 1661.39 RM2.84 RM2.74 RM6.80 RM10.96 RM6.70 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 0 999,965 (35) 0.00% 40,000 10,000 5,000 40,000 10,000 Index on 14th day 1661.39 RM2.84 RM2.86 RM6.79 RM10.88 RM6.60 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 0 996,915 (3,085) -0.31% 40,000 10,000 5,000 40,000 10,000 40,000 10,000 5,000 40,000 10,000 Index on 14th day 1661.39 Quantity 40,000 10,000 5,000 40,000 10,000 Transaction cost (0.5% per transaction) Total Cost 572 142 169 2,188 335 Total Market price Proceeds (closing price) 113,828 28,258 33,681 435,412 66,665 RM2.85 RM2.79 RM6.78 RM11.00 RM6.65 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value (2,591) 997,409 (2,591) -0.26% Quantity 220,000 20,000 5,000 10,000 30,000 Transaction cost (0.5% per Total transaction) Total Cost Proceeds 2,981 599,181 278 55,878 169 33,919 530 106,530 987 Quantity 198,387 0.00 0.00 0.00 0.00 Index on 14th day 1661.39 Market price (closing price) Quantity RM2.74 220,000 RM2.82 20,000 RM6.76 5,000 RM10.66 10,000 RM6.70 30,000 RM2.81 RM2.82 22,000 200,000 RM6.76 RM10.66 RM6.64 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value (2,591) 968,934 (31,066) -3.11% Index on 14th day 1661.39 RM2.94 RM2.88 RM6.78 RM10.96 RM6.59 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value (2,591) 985,394 (14,606) -1.46% 22,000 200,000 5,000 10,000 30,000 Index on 14th day 1661.39 RM2.70 RM2.79 RM6.70 RM10.66 RM6.81 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value (2,591) 965,314 (34,686) -3.47% 5,000 10,000 30,000 22,000 200,000 5,000 10,000 30,000 Index on 14th day 1661.39 Quantity 220,000 20,000 5,000 10,000 30,000 Transaction cost (0.5% per transaction) Total Cost 3,146 282 168 539 1,023 Total Market price Proceeds (closing price) 626,054 56,118 33,333 107,261 203,577 RM2.85 RM2.78 RM6.68 RM10.78 RM6.81 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 29,856 1,029,857 29,857 2.99% Quantity 200,000 10,000 1,000 10,000 45,000 Transaction cost (0.5% per Total transaction) Total Cost Proceeds 2,840 570,840 139 27,939 33 6,673 532 106,932 1,530 Quantity 307,530 0.00 0.00 0.00 0.00 Index on 14th day 1661.39 Market price (closing price) Quantity RM2.89 20,000 RM2.80 20,000 RM6.70 20,000 RM10.70 20,000 RM6.81 20,000 RM2.88 RM2.86 20,000 20,000 RM6.71 RM10.70 RM6.86 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 29,856 610,142 (389,858) -38.99% Index on 14th day 1661.39 RM2.98 RM2.80 RM6.71 RM10.58 RM6.98 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 29,856 610,942 (389,058) -38.91% Quantity 200,000 10,000 1,000 10,000 45,000 Transaction cost (0.5% per transaction) Total Cost 3,000 142 33 538 1,577 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Index on 14th day 1661.39 Total Market price Proceeds (closing price) 597,000 28,258 6,647 107,062 Quantity 313,873 RM2.88 RM2.80 RM6.60 RM10.68 RM6.98 0.00 0.00 0.00 0.00 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 62,781 1,062,782 62,782 6.28% Transaction cost (0.5% per Total Quantity transaction) Total Cost Proceeds 1,000 15 2,995 10,000 139 27,939 35,000 1,148 230,748 ### 2,675 537,675 1,000 35 7,015 % Change Total Change in in Active Realised Portfolio Active Portfolio Portfolio Gain/Loss Value Value Value 62,781 1,002,278 2,278 0.23% Index on 14th day 1661.39 Market price (closing price) Quantity RM2.90 1,000 RM2.78 10,000 RM6.60 50,000 RM10.74 6,000 RM7.00 1,000 RM2.89 RM2.78 RM6.60 RM10.80 RM6.96 1,000 10,000 35,000 50,000 1,000 Index on 14th day 1661.39 Unrealised Total Market Gain/Loss Unrealised Realised Realised Value (RM) Gain/Loss (%) Gain/Loss (RM) Gain/Loss (%) 117,600 (588) -0.50% 28,800 (245) -0.84% 34,400 (222) -0.64% 432,800 1,052 0.24% 66,300 (533) -0.80% 117,600 28,800 34,400 432,800 66,300 679,900 (588) (245) (222) 1,052 (533) (535) -0.50% -0.84% -0.64% 0.24% -0.80% Active Portfolio Index on 14th % Change in Outperforms / Sep 2016 Index Underperforms? 1661.39 0.00% Underperforms 117,600 28,800 33,900 438,400 65,900 684,600 Index on 15th Sep 2016 (588) (245) (722) 6,652 (933) 4,165 % Change in Index 0 by? -0.05% -0.50% -0.84% -2.09% 1.54% -1.40% - Active Portfolio Outperforms / Underperforms? by? 1652.99 -0.51% Outperform 115,200 28,000 33,500 432,800 66,600 676,100 (2,988) (1,045) (1,122) 1,052 (233) (4,335) 0.92% -2.53% -3.60% -3.24% 0.24% -0.35% 0 Active Portfolio Index on 21st % Change in Outperforms / Sep 2016 Index Underperforms? 1658.73 -0.16% Underperforms 113,600 27,400 34,000 438,400 67,000 680,400 (4,588) (1,645) (622) 6,652 168 (35) -3.88% -5.66% -1.80% 1.54% 0.25% 0 Active Portfolio Index on 23rd % Change in Outperforms / Sep 2016 Index Underperforms? 1670.99 0.58% Underperforms 113,600 28,600 33,950 435,200 66,000 677,350 (4,588) (445) (672) 3,452 (833) (3,085) by? -0.27% by? -0.58% -3.88% -1.53% -1.94% 0.80% -1.25% Active Portfolio Index on 28th % Change in Outperforms / Sep 2016 Index Underperforms? 1644.96 -0.99% Outperform 0 by? 0.68% Total Market Value Unrealised Gain/Loss (RM) Unrealised Gain/Loss (%) Realised Realised Gain/Loss (RM) Gain/Loss (%) -4,360 -3.69% -787 -2.71% -942 -2.72% 3,664 0.85% -168 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.25% 0.00% 0.00% 0.00% 0.00% 0.00% (2,591) Active Portfolio Index on 30th % Change in Outperforms / Sep 2016 Index Underperforms? 1652.55 -0.53% Outperform by? 0.27% Unrealised Total Market Gain/Loss Unrealised Realised Realised Value (RM) Gain/Loss (%) Gain/Loss (RM) Gain/Loss (%) 602,800 3,619 0.60% 56,400 522 0.93% 33,800 (119) -0.35% 106,600 70 0.07% 201,000 2,613 1.32% 61,820 564,000 (537,361) 508,122 -896.83% 90.93% 33,800 106,600 199,200 965,420 (119) 70 813 (28,475) -0.35% 0.07% 0.41% Active Portfolio Index on 5th Oct % Change in Outperforms / 2016 Index Underperforms? 1662.92 0.09% Underperforms 64,680 576,000 33,900 109,600 197,700 981,880 (534,501) 520,122 (19) 3,070 (687) (12,015) -892.05% 93.08% -0.06% 2.88% -0.35% - Active Portfolio Index on 7th Oct % Change in Outperforms / 2016 Index Underperforms? 1652.99 -0.51% Underperforms 59,400 558,000 33,500 106,600 204,300 961,800 (539,781) 502,122 (419) 70 5,913 (32,095) by? -3.20% by? -0.95% -900.86% 89.86% -1.23% 0.07% 2.98% Active Portfolio Index on 12th % Change in Outperforms / Oct 2016 Index Underperforms? 1667.03 0.34% Underperforms by? -3.81% Total Market Value Unrealised Gain/Loss (RM) Unrealised Gain/Loss (%) Realised Realised Gain/Loss (RM) Gain/Loss (%) 26,873 4.48% 240 0.43% -586 -1.73% 731 0.69% 5,190 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.62% 0.00% 0.00% 0.00% 0.00% 0.00% 32,448 Active Portfolio Index on 14th % Change in Outperforms / Oct 2016 Index Underperforms? 1658.97 -0.15% Outperform by? 3.13% Unrealised Total Market Gain/Loss Unrealised Realised Realised Value (RM) Gain/Loss (%) Gain/Loss (RM) Gain/Loss (%) 57,800 (513,040) -89.87% 56,000 28,061 100.44% 134,000 127,327 1908.03% 214,000 107,068 100.13% 136,200 (171,330) -55.71% 57,600 57,200 (513,240) 29,261 -899.10% 52.37% 134,200 214,000 137,200 600,200 127,527 107,068 (170,330) (419,714) 95.55% 100.13% -55.39% Active Portfolio Index on 19th % Change in Outperforms / Oct 2016 Index Underperforms? 1668.27 0.41% Underperforms 59,600 56,000 134,200 211,600 139,600 601,000 (511,240) 28,061 127,527 104,668 (167,930) (418,914) Unrealised Gain/Loss (RM) by? -39.40% -895.59% 50.22% 95.55% 48.94% -122.86% - Active Portfolio Index on 21th % Change in Outperforms / Oct 2016 Index Underperforms? 1669.98 0.52% Underperforms Total Market Value 0 Unrealised Gain/Loss (%) by? -39.42% Realised Realised Gain/Loss (RM) Gain/Loss (%) 26,160 4.58% 319 1.14% -27 -0.40% 130 0.12% 6,343 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00% 0.00% 0.00% 0.00% 2.06% 0.00 0.00 32,925 Active Portfolio Index on 26th % Change in Outperforms / Oct 2016 Index Underperforms? 1673.92 0.75% Outperform Total Market Value 2,900 27,800 330,000 64,440 by? 5.52% Unrealised Gain/Loss Unrealised Realised Realised (RM) Gain/Loss (%) Gain/Loss (RM) Gain/Loss (%) (95) -3.17% (139) -0.50% 99,252 43.01% (473,235) -88.02% 7,000 (15) -0.21% 2,890 27,800 231,000 540,000 6,960 808,650 (105) (139) 252 2,325 (55) 2,278 -3.50% -0.50% 0.11% 0.43% -0.78% Active Portfolio Index on 28th % Change in Outperforms / Oct 2016 Index Underperforms? 1670.27 0.53% Underperforms 0 by? -0.31% Summary of Reason /Justificati on (Details in main report) Padini, a well-known brand in Malaysia the business of AIR ASIA is very good in those day they have a new service that is 100 Mbs UniFi PRO PLAN This stock has offered the most potential for growth This stock already in a low price ,the price will go up in the future Summary of Reason /Justificati on (Details in main report) Three consecutive days of stock price decline, decided to sell most of the stock the price of the stock still go down ,i decide to sell half stock to lower the loss Summary of Reason /Justificati on (Details in main report) Padini, a well-known brand in Malaysia the business of AIR ASIA is very good in those day they have a new service that is 100 Mbs UniFi PRO PLAN This stock has offered the most potential for growth This stock already in a low price ,the price will go up in the future Summary of Reason /Justificati on (Details in main report) Three consecutive days of stock price decline, decided to sell most of the stock the price of the stock still go down ,i decide to sell half stock to lower the loss Summary of Reason /Justificati on (Details in main report) Padini, a well-known brand in Malaysia the business of AIR ASIA is very good in those day they have a new service that is 100 Mbs UniFi PRO PLAN This stock has offered the most potential for growth This stock already in a low price ,the price will go up in the future Summary of Reason /Justificati on (Details in main report) Three consecutive days of stock price decline, decided to sell most of the stock the price of the stock still go down ,i decide to sell half stock to lower the loss Summary of Reason /Justificati on (Details in main report) Padini, a well-known brand in Malaysia the business of AIR ASIA is very good in those day they have a new service that is 100 Mbs UniFi PRO PLAN This stock has offered the most potential for growth This stock already in a low price ,the price will go up in the future

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Mathematics

Authors: Charles MillerStanley SalzmanStanley SalzmanGary Clendenen

11th Edition

0321500121, 9780321500120

More Books

Students also viewed these Finance questions

Question

Do I make impulse purchases during my surfing sessions?

Answered: 1 week ago