See attached doc. Please help to find solution of these questions. Need to include excel...

Question

See attached doc. Please help to find solution of these questions. Need to include excel calculations and formula to each question. the correct answer is on the bottom of the doc. need to find step by step how those answers comes from (in excel Spread sheet). Thanks

Prateek · Accepted Answer

Sheet1
	Q1
	C0	-283
	C1	234
	C2	336
	C3	97
	r	12.70%
	NPV	256.94
	Q2
	Probab	Return
	32%	-0.39%
	30%	6.53%
	38%	0.01%
	Expected Return	1.84%
	Q3
	Beta	1.5
	r	11.99%
	Rf	2.80%
	MRP	6%
	Q4
	Flotation Cost	5%
	P0	21.24	1.062
	Dividend	1.3
	Dividend Yield	6.12%
	R	11%
	Q5
	PV FC	157
	FV P	747
	MIRR	68.19%
	Q6
	Par Value	1000
	Interest	12.86
	Debt Cost	1.29%
	Q7
	Current Shares	10,000,000.00
	Price Per Share	20.

See attached doc. Please help to find solution of these questions. Need to include excel calculations and formula to each question. the correct answer is on the bottom of the doc. need to find step by...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment