Question

In: Finance

Idea has planned to launch itself in Pakistan with multiple stores throughout the country in next...

Idea has planned to launch itself in Pakistan with multiple stores throughout the country in next 6 years. The company is planning to launch in Lahore and Islamabad in first three years and expecting a growth rate of 12%. Next it would expand itself to Karachi and Multan and expects 6% growth through 4th to 6th years. Then company plans to have constant earnings (0% growth) till forever. Currently company has issued dividend of $2(see table) on its shares which are trading in market at a market value of $25. Estimate cost of equity of Idea.

Given dividend is 2.2 and discounting percentage is 8%. Feel free to choose the other value of discounting.

Solutions

Expert Solution

Note: - Since the capital structure of the company is not mentioned, therefore i have assumed it to be zero debt company

Current Price = PV of all Dividends + Terminal Value

Terminal Value = D6(1 + Terminal Growth Rate) / (ke - Terminal Growth Rate)
PV of Dividends = Dn/(1+ke)n

C F - J D Year Dividend E 0 1 =B1 =E2*((1+$B$2)) G 2 =F2*((1+$B$2)) H 3 =G2*((1+$B$2)) 4 =H2*(1+$B$3) 5 =12*(1+$B$3) K 6 =J2*(1+$B$3) Terminal Value A B 1 Dividend 2 Growth for first 3 years 0.12 3 Growth for first 4-6 years 0.06 4 Forever Growth Rate 0 5 6 Cost of Equity 0.122271698942757 7 Total of PV of Dividends =SUM(F7:K7) 8 9 Current Stock Price 25 =(K2*(1+B4))/(B6-B4) Total Value Present Value =F2+F4 =G2+G4 =H2+H4 =12+14 I=J2+14 =K2+K4 =F6/((1+$B$6)^F1) |=G6/((1+$B$6)^G1) |=H6/((1+$B$6)^H1) |=16/((1+$B$6)^l1) |=J6/((1+$B$6)^J1) |=K6/((1+$B$6)^K1)

B n D E F G H - . K 0 2.0 12.0% Year Dividend 1 2.24 2 2.51 3 2.81 4 2.98 5 3.16 6 3.35 2.0 6.0% 0.0% Terminal Value 27.37 A 1 Dividend 2 Growth for first 3 years 3 Growth for first 4-6 years 4 Forever Growth Rate 5 6 Cost of Equity 7 Total of PV of Dividends 8 9 Current Stock Price 12.23% 2.81 3.16 Total Value Present Value 2.24 2.00 2.51 1.99 2.98 1.88 30.72 15.37 25.00 1.99 1.77 25.0


Related Solutions

The Gravy Company has decided to launch a new advertisement campaign in grocery stores to promote...
The Gravy Company has decided to launch a new advertisement campaign in grocery stores to promote their products. The idea is to put small signs in the meat section (next to the Turkey, Ham, etc.) which read, "Get on board to the gravy train! The company wonders whether the different groups of consumers who eat different meats also have different gravy preferences. The table below is from a random sample of college students. The row denotes whether the student's family...
The fictional country of Sendaria finds itself in the following situation: the government has a deficit...
The fictional country of Sendaria finds itself in the following situation: the government has a deficit of 2% GDP, private savings is 17% of GDP, and physical investments are 15% of GDP. a)What is the trade balance? b) If the government budget is set at zero, how will this affect the trade balance? Question 1 options: a) Trade balance = 4%, b) Trade balance will DECREASE to 0% a) Trade balance = 0%, b) Trade balance will INCREASE to 2%...
The Fraley Company, a merchandising firm, has planned the following sales for the next four months:...
The Fraley Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales...... $50,500 $71,450 $93,600 $67,000 All sales at Fraley are on credit. From experience, the company has learned that a month’s sales on account are collected according to the following pattern: Month of sale....................................................... 68% First month following month of sale................. 29% Uncollectible........................................................ 3%       The company requires a minimum cash balance of $5,000 to start a month....
Hook's Boat Supplies Limited has planned the following sales and inventory purchases for the next three...
Hook's Boat Supplies Limited has planned the following sales and inventory purchases for the next three months: July August September Budgeted sales un 75,000 $ 60,000 S 80,000 Inventory purchases $ 35,000 $ 28,000 $ 40,000 Sales are made 20% for cash & 80% on account. From experience the company has learned that a month's sales on account are collected according to the following: Month of sale First month following sale Second month following sale Uncollectible 60% 30% 596 5%...
URGENT____ The Dennison Company has planned the following sales for the next three months: January February...
URGENT____ The Dennison Company has planned the following sales for the next three months: January February March Budgeted Sales $40,000 $50,000 $70,000 Sales are made 20% for cash and 80% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 60% First month following sale 30% Second month following sale 8% Uncollectible 2% The company requires a minimum cash balance of $5,000 to start a month....
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten...
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten (10) to be specific. At these offices, all the administrative matters of the Program are administered, inclusive of payments to suppliers, payroll and Information Technology services. There are several assets and confidential data on each compound such as computer equipment, filing cabinets, personal data and several pieces of furniture. Within recent times, there were numerous burglaries’ at a number of locations, which resulted in...
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten...
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten (10) to be specific. At these offices, all the administrative matters of the Program are administered, inclusive of payments to suppliers, payroll and Information Technology services. There are several assets and confidential data on each compound such as computer equipment, filing cabinets, personal data and several pieces of furniture. Within recent times, there were numerous burglaries’ at a number of locations, which resulted in...
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten...
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten (10) to be specific. At these offices, all the administrative matters of the Program are administered, inclusive of payments to suppliers, payroll and Information Technology services. There are several assets and confidential data on each compound such as computer equipment, filing cabinets, personal data and several pieces of furniture. Within recent times, there were numerous burglaries’ at a number of locations, which resulted in...
A popular U.S. automobile manufacturer has​ 10,000 dealerships located throughout the country. The automobile manufacturer has...
A popular U.S. automobile manufacturer has​ 10,000 dealerships located throughout the country. The automobile manufacturer has multiple brands within its​portfolio: a value brand that caters to younger​ clientele, a moderate brand that caters to middle class customers and​ finally, a premium brand which is marketed to wealthy clientele. The​ company's leadership, located at corporate​ headquarters, is very interested in the relationship between the median salary of potential customers and the​ company's revenue.​ Specifically, the company is concerned that if potential​...
The Zambian Government has embarked on various developmental projects throughout the country. The projects include Water...
The Zambian Government has embarked on various developmental projects throughout the country. The projects include Water and Sanitation, Roads, Schools and Hospitals. Private companies have also invested in shopping malls in various parts of the country. This has resulted in a boost for the construction industry. a. Discuss why there is an increase in the use of steel as compared to concrete in most of the building works around the country under construction. b. Consider the iron value chain from...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT