Google Answers Logo
View Question
 
Q: Need Help with Excel Problem Needed by 05/19/2005 ( No Answer,   0 Comments )
Question  
Subject: Need Help with Excel Problem Needed by 05/19/2005
Category: Business and Money > Finance
Asked by: wingsattached-ga
List Price: $40.00
Posted: 17 May 2005 14:00 PDT
Expires: 18 May 2005 07:04 PDT
Question ID: 522712
Acme is considering the acquisition of a firm in the Czich Republic
and would like your opion on this. It plans to operate the firm for 3
years and then reevaluate the holding. Free cash flows are estimated
as follows:
Year 1 - 38.63M Czech Koruna (CZK) , Year 2- 44.33M CZK, Year 3 -
50.48M CZK  The third year terminal value is estimated at 375M CZK.
The Czech Koruna's exchange rate is assumed to be .038 USD/CZK for
each year. Acme uses a WACC of 13% for its domestic projects. So, the
PV of the firm is 363.78M CZK or 13.82M. The Czech firm has 1,000,000
shares outstanding and a debt to equity ratio of 1:1. Current market
price is 185 CZK per share.

All Monetary information (except per share) should be presented in CZK
millions (i.e. do not convert to USD).

1. Should Acme make a deal if its policy is to never exceed a 20%
premium in any tender offer? To defend your position, you must prepare
and present an Excel template that includes the calculated fair value
permium over market.

2. What changes in the analysis or additional analysis do you suggest
before a final decision should be made?

3. Using the DCF metholdology required in question 1. please take one
of your suggestions and reevaluate the buy-out. To complete  this
question, you will have to present a second Excel template that
includes your new assumed values and supports your recommendations.
Further, please comply with the following:

Assumptions must be reasonable - i.e. don't select arbitrary values.
Some discussion should be provided that explains how your arrived at
your new assumed values.

Variable changes should be restricted to the discount rate, the FCTs,
and /or the terminal value. Please present only one set of assumptions
(e.g. do not submit a table that includes multiple values for the same
variables.)

To help ensure that your values are unique, please use a minimum of
three significant (i.e. non-zero) digits to the right of the decimal
point.

Please present this problem in an excel spreadsheet with the analysis
and suggestions within the spreadsheet.  Thank you in advance for any
help you can give me. All my efforts have failed

Clarification of Question by wingsattached-ga on 17 May 2005 14:28 PDT
Acme is considering the acquisition of a firm in the Czich Republic
and would like your opion on this. It plans to operate the firm for 3
years and then reevaluate the holding. Free cash flows are estimated
as follows:
Year 1 - 38.63M Czech Koruna (CZK) , Year 2- 44.33M CZK, Year 3 -
50.48M CZK  The third year terminal value is estimated at 375M CZK.
The Czech Koruna's exchange rate is assumed to be .038 USD/CZK for
each year. Acme uses a WACC of 13% for its domestic projects. So, the
PV of the FCF's for the firm is 363.78M CZK or 13.82M. The Czech firm has 1,000,000
shares outstanding and a debt to equity ratio of 1:1. Current market
price is 185 CZK per share.

All Monetary information (except per share) should be presented in CZK
millions (i.e. do not convert to USD).

1. Should Acme make a deal if its policy is to never exceed a 20%
premium in any tender offer? To defend your position, you must prepare
and present an Excel template that includes the calculated fair value
permium over market.

2. What changes in the analysis or additional analysis do you suggest
before a final decision should be made?

3. Using the DCF metholdology required in question 1. please take one
of your suggestions and reevaluate the buy-out. To complete  this
question, you will have to present a second Excel template that
includes your new assumed values and supports your recommendations.
Further, please comply with the following:

Assumptions must be reasonable - i.e. don't select arbitrary values.
Some discussion should be provided that explains how your arrived at
your new assumed values.

Variable changes should be restricted to the discount rate, the FCFs,
and /or the terminal value. Please present only one set of assumptions
(e.g. do not submit a table that includes multiple values for the same
variables.)

To help ensure that your values are unique, please use a minimum of
three significant (i.e. non-zero) digits to the right of the decimal
point.

Please present this problem in an excel spreadsheet with the analysis
and suggestions within the spreadsheet.  Thank you in advance for any
help you can give me. All my efforts have failed

Clarification of Question by wingsattached-ga on 18 May 2005 06:08 PDT
Discounted Cash Flows Valuation of Czech Republic (millions of CZK)				
		Year 1	Year 2	Year 3
 Free cash flow (FCF; millions of CZK)"		38.63 CZK	44.33 CZK	50.48 CZK
				375
Expected FCF for discounting"		$38.63 	44.63	425.48
Present value interest factor (PVIF)"				
PVIF = 1 / (1 + k)^n" 		0.885	0.78315	0.69305
Discounted FCF"	13	34.19	34.72	294.88
Cumulative discounted FCF"	363.78			
"Residual equity value Less PV of net debt (D/E ratio = 1:1)""
"	185			
Residual equity value"	178.78M			
Fair value of equity/share"	178.78 (CZK178.78M / 1M shares)			
|	|

Clarification of Question by wingsattached-ga on 18 May 2005 06:11 PDT
Subject: Need Help with Excel Problem Needed by 05/21/2005
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy