Fin630 Assignment No. 1 solution
Wednesday, April 20, 2011 Posted In Fin Edit ThisSpring Semester 2011
“Financial Analysis & Portfolio Management (Fin 630)”
Assignment No. 01 Total Marks: 20
Question #01
Ellite Corporation has total assets of Rs. 6,000,000 of which Rs. 1,000,000 is inventory, Rs. 500, 000 is cash, Rs. 1,000, 000 is account receivable, Rs. 500, 000 is marketable securities and the balance is fixed assets. Ellite Corporation has total liabilities of Rs. 2,500, 000 of which current liabilities are Rs. 15, 00,000.
1. Calculate the current and quick ratio for Ellite Corporation.
2. If Ellite Corporation takes 250,000 from cash and pays off Rs. 250,000 of current liabilities, what happens to its current ratio and quick ratio?
3. If Ellite Corporation sells the inventory of Rs. 10, 00, 000 and places the proceeds from the sale of inventory in marketable securities, what happens to its current ratio and quick ratio?
Question #02
Currently Alpha Corporation’s shares are selling at $60 per share and company is paying dividend of $5 per share. Dividends are expected to grow at an annual rate of 3% for foreseeable future. Required rate of return for investors is 12% At the same time, Heller Corporation’s shares are selling at $58 per share and company is paying dividend of $4 per share. Dividends are expected to grow at an annual rate of 5% for foreseeable future. Required rate of return for investors is 12%
a) Calculate the current value of each stock on the basis of Dividend Discount Model.
b) On the basis of above calculation, determine either each stock is overvalued or undervalued.
Note:
Show complete working (formula and calculations) for each part of question.
2
Important Tips
1. This Assignment can be best attempted from the knowledge acquired after
watching video lecture no. 1 to lecture no 12 and reading handouts as well as
recommended text book).
2. Video lectures can be downloaded for free from www.youtube.com/vu.
Assignment Schedule
Opening Date and Time 19th April , 2011 At 12:01 A.M. (Mid-Night)
Due Date and Time 22nd April , 2011 At 11:59 P.M. (Mid-Night)
Note: Only in the case of Assignment, 24 Hrs extra / grace period after the above mentioned
due date is usually available to overcome uploading difficulties which may be faced by the
students on last date. This extra time should only be used to meet the emergencies and above
mentioned due dates should always be treated as final to avoid any inconvenience.
Important Instructions:
Please read the following instructions carefully before attempting the assignment solution.
Deadline:
• Make sure that you upload the solution file before the due date. No
assignment will be accepted through e-mail once the solution has been
uploaded by the instructor.
Formatting guidelines:
• Use the font style “Times New Roman” and font size “12”.
• It is advised t compose your document in MS-Word 2003.
• Use black and blue font colors only.
Solution guidelines:
• For acquiring the relevant knowledge don’t rely only on handouts but
watch the video lectures and use other reference books also.
• Show complete working (formula and calculations) for each part of
question.
• Marks will be deducted if complete working is not provided.
Rules for Marking
Please note that your assignment will not be graded or graded as Zero (0) if:
• It has been submitted after due date
• The file you uploaded does not open or is corrupt
• It is in any format other than .doc (MS. Word)
• It is cheated or copied from other students, internet, books, journals etc…
:::::::::::::::::::::::::::
Solution:
_________________
Question #01
Ellite Corporation has total assets of Rs. 6,000,000 of which Rs. 1,000,000 is
inventory, Rs. 500, 000 is cash, Rs. 1,000, 000 is account receivable, Rs. 500, 000 is
marketable securities and the balance is fixed assets. Ellite Corporation has total
liabilities of Rs. 2,500, 000 of which current liabilities are Rs. 15, 00,000.
1. Calculate the current and quick ratio for Ellite Corporation.
Current Ratio: current asset/ current liabilities
Current asset: 1,000,000 + 500, 000 + 1,000, 000 + 500, 000 = 3000000
Current Ratio = 3000000 / 15, 00,000 = 2
Quick ratio: Current assets- Inventories/ Current Liabilities
= 2000000 / 1500000 = 1.33
2. If Ellite Corporation takes 250,000 from cash and pays off Rs. 250,000 of current
liabilities, what happens to its current ratio and quick ratio?
Cash = 250000
Current asset = 1,000,000 + 250, 000 + 1,000, 000 + 500, 000 = 2750000
Current liabilities =1500000-250000 = 1250000
Current Ratio = 2.2
Quick ratio: Current assets- Inventories/ Current Liabilities
Quick ratio: 1750000/1250000 = 1.4
Answer: both increases
3. If Ellite Corporation sells the inventory of Rs. 10, 00, 000 and places the proceeds
from the sale of inventory in marketable securities, what happens to its current ratio
and quick ratio?
Current Ratio: current asset/ current liabilities
Current asset: 500, 000 + 2,000, 000 + 500, 000 = 3000000
Current Ratio = 3000000 / 15, 00,000 = 2
Quick ratio: Current assets- Inventories/ Current Liabilities
= 3000000-0 / 1500000 = 2
Answer : current ratio remain same and quick ration increase
Question #02
Currently Alpha Corporation’s shares are selling at $60 per share and company is
paying dividend of $5 per share. Dividends are expected to grow at an annual rate of
3% for foreseeable future. Required rate of return for investors is 12%
At the same time, Heller Corporation’s shares are selling at $58 per share and
company is paying dividend of $4 per share. Dividends are expected to grow at an
annual rate of 5% for foreseeable future. Required rate of return for investors is
12%
a) Calculate the current value of each stock on the basis of Dividend Discount
Model.
Alpha Corporation
Dividend Discount Model = P0 = 5 (1+ 3%) / (12% - 3%)
= 57.22
Heller Corporation
Dividend Discount Model = P0 = 4 (1 + 5%) / (12% - 5%)
= 60
b) On the basis of above calculation, determine either each stock is overvalued or
undervalued.
Stock of Alpha Corporation is overstated by 60 - 57.22 = Rs. 2.78
Stock of Heller Corporation is understated by 58 - 60 = Rs. 2
::::::::::::::::::::::::::::::::::::::
Question #01
CASE # 1
Current Ratio
Current Assets/Current Liabilities
=Rs.3000000/Rs.1500000
= 2:1
CASE#2
=Rs 2750000 / Rs 1250000
= 2.2:1
Quick Ratio
CASE # 1
Current Assets – Inventory/Current Liabilities
=Rs.3000000 – Rs.1000000/ Rs.1500000
=Rs 2000000/Rs.1500000
=1.33:1
Case # 2
= Rs.1750000/1250000
=1.4: 1
Question #02
Formula:
Po = Do (1 + g)
K – g
= $5(1 + .03)
.12 - .03
= $57.22
Formula:
Po = Do (1 + g)
K – g
= $4(1 + .05)
.12 - .05
= $60
::::::::::::::::::::::
“Financial Analysis & Portfolio Management (Fin 630)”
Assignment No. 01 Total Marks: 20
Question #01
Ellite Corporation has total assets of Rs. 6,000,000 of which Rs. 1,000,000 is inventory, Rs. 500, 000 is cash, Rs. 1,000, 000 is account receivable, Rs. 500, 000 is marketable securities and the balance is fixed assets. Ellite Corporation has total liabilities of Rs. 2,500, 000 of which current liabilities are Rs. 15, 00,000.
1. Calculate the current and quick ratio for Ellite Corporation.
2. If Ellite Corporation takes 250,000 from cash and pays off Rs. 250,000 of current liabilities, what happens to its current ratio and quick ratio?
3. If Ellite Corporation sells the inventory of Rs. 10, 00, 000 and places the proceeds from the sale of inventory in marketable securities, what happens to its current ratio and quick ratio?
Question #02
Currently Alpha Corporation’s shares are selling at $60 per share and company is paying dividend of $5 per share. Dividends are expected to grow at an annual rate of 3% for foreseeable future. Required rate of return for investors is 12% At the same time, Heller Corporation’s shares are selling at $58 per share and company is paying dividend of $4 per share. Dividends are expected to grow at an annual rate of 5% for foreseeable future. Required rate of return for investors is 12%
a) Calculate the current value of each stock on the basis of Dividend Discount Model.
b) On the basis of above calculation, determine either each stock is overvalued or undervalued.
Note:
Show complete working (formula and calculations) for each part of question.
2
Important Tips
1. This Assignment can be best attempted from the knowledge acquired after
watching video lecture no. 1 to lecture no 12 and reading handouts as well as
recommended text book).
2. Video lectures can be downloaded for free from www.youtube.com/vu.
Assignment Schedule
Opening Date and Time 19th April , 2011 At 12:01 A.M. (Mid-Night)
Due Date and Time 22nd April , 2011 At 11:59 P.M. (Mid-Night)
Note: Only in the case of Assignment, 24 Hrs extra / grace period after the above mentioned
due date is usually available to overcome uploading difficulties which may be faced by the
students on last date. This extra time should only be used to meet the emergencies and above
mentioned due dates should always be treated as final to avoid any inconvenience.
Important Instructions:
Please read the following instructions carefully before attempting the assignment solution.
Deadline:
• Make sure that you upload the solution file before the due date. No
assignment will be accepted through e-mail once the solution has been
uploaded by the instructor.
Formatting guidelines:
• Use the font style “Times New Roman” and font size “12”.
• It is advised t compose your document in MS-Word 2003.
• Use black and blue font colors only.
Solution guidelines:
• For acquiring the relevant knowledge don’t rely only on handouts but
watch the video lectures and use other reference books also.
• Show complete working (formula and calculations) for each part of
question.
• Marks will be deducted if complete working is not provided.
Rules for Marking
Please note that your assignment will not be graded or graded as Zero (0) if:
• It has been submitted after due date
• The file you uploaded does not open or is corrupt
• It is in any format other than .doc (MS. Word)
• It is cheated or copied from other students, internet, books, journals etc…
:::::::::::::::::::::::::::
Solution:
Question # 1
(1)
Current Ratio = 3,000,000 / 1,500,000 = 2
Quick ratio = 2,000,000 / 1,500,000 = 1.34
(2)
Current Ratio = 2.2
Quick Ratio = 1.4
(3)
Current Ratio = 2
Quick Ratio = 2
Question # 2
(1)
Dividend Discount Model = P0 = 5 ( 1+ 3% ) / (12% - 3%)
= 57.22
Dividend Discount Model = P0 = 4 ( 1 + 5% ) / (12% - 5%)
= 60
(2)
Stock of Alpha Corps is overstated by 60 - 57.22 = Rs. 2.78
Stock of Heller Corps is understated by 58 - 60 = Rs. 2
(1)
Current Ratio = 3,000,000 / 1,500,000 = 2
Quick ratio = 2,000,000 / 1,500,000 = 1.34
(2)
Current Ratio = 2.2
Quick Ratio = 1.4
(3)
Current Ratio = 2
Quick Ratio = 2
Question # 2
(1)
Dividend Discount Model = P0 = 5 ( 1+ 3% ) / (12% - 3%)
= 57.22
Dividend Discount Model = P0 = 4 ( 1 + 5% ) / (12% - 5%)
= 60
(2)
Stock of Alpha Corps is overstated by 60 - 57.22 = Rs. 2.78
Stock of Heller Corps is understated by 58 - 60 = Rs. 2
_________________
Question #01
Ellite Corporation has total assets of Rs. 6,000,000 of which Rs. 1,000,000 is
inventory, Rs. 500, 000 is cash, Rs. 1,000, 000 is account receivable, Rs. 500, 000 is
marketable securities and the balance is fixed assets. Ellite Corporation has total
liabilities of Rs. 2,500, 000 of which current liabilities are Rs. 15, 00,000.
1. Calculate the current and quick ratio for Ellite Corporation.
Current Ratio: current asset/ current liabilities
Current asset: 1,000,000 + 500, 000 + 1,000, 000 + 500, 000 = 3000000
Current Ratio = 3000000 / 15, 00,000 = 2
Quick ratio: Current assets- Inventories/ Current Liabilities
= 2000000 / 1500000 = 1.33
2. If Ellite Corporation takes 250,000 from cash and pays off Rs. 250,000 of current
liabilities, what happens to its current ratio and quick ratio?
Cash = 250000
Current asset = 1,000,000 + 250, 000 + 1,000, 000 + 500, 000 = 2750000
Current liabilities =1500000-250000 = 1250000
Current Ratio = 2.2
Quick ratio: Current assets- Inventories/ Current Liabilities
Quick ratio: 1750000/1250000 = 1.4
Answer: both increases
3. If Ellite Corporation sells the inventory of Rs. 10, 00, 000 and places the proceeds
from the sale of inventory in marketable securities, what happens to its current ratio
and quick ratio?
Current Ratio: current asset/ current liabilities
Current asset: 500, 000 + 2,000, 000 + 500, 000 = 3000000
Current Ratio = 3000000 / 15, 00,000 = 2
Quick ratio: Current assets- Inventories/ Current Liabilities
= 3000000-0 / 1500000 = 2
Answer : current ratio remain same and quick ration increase
Question #02
Currently Alpha Corporation’s shares are selling at $60 per share and company is
paying dividend of $5 per share. Dividends are expected to grow at an annual rate of
3% for foreseeable future. Required rate of return for investors is 12%
At the same time, Heller Corporation’s shares are selling at $58 per share and
company is paying dividend of $4 per share. Dividends are expected to grow at an
annual rate of 5% for foreseeable future. Required rate of return for investors is
12%
a) Calculate the current value of each stock on the basis of Dividend Discount
Model.
Alpha Corporation
Dividend Discount Model = P0 = 5 (1+ 3%) / (12% - 3%)
= 57.22
Heller Corporation
Dividend Discount Model = P0 = 4 (1 + 5%) / (12% - 5%)
= 60
b) On the basis of above calculation, determine either each stock is overvalued or
undervalued.
Stock of Alpha Corporation is overstated by 60 - 57.22 = Rs. 2.78
Stock of Heller Corporation is understated by 58 - 60 = Rs. 2
::::::::::::::::::::::::::::::::::::::
Question #01
CASE # 1
Current Ratio
Current Assets/Current Liabilities
=Rs.3000000/Rs.1500000
= 2:1
CASE#2
=Rs 2750000 / Rs 1250000
= 2.2:1
Quick Ratio
CASE # 1
Current Assets – Inventory/Current Liabilities
=Rs.3000000 – Rs.1000000/ Rs.1500000
=Rs 2000000/Rs.1500000
=1.33:1
Case # 2
= Rs.1750000/1250000
=1.4: 1
Question #02
Formula:
Po = Do (1 + g)
K – g
= $5(1 + .03)
.12 - .03
= $57.22
Formula:
Po = Do (1 + g)
K – g
= $4(1 + .05)
.12 - .05
= $60
::::::::::::::::::::::
