Financial Exercises 4: Cash flows - Versionsgeschichte

Wikimeister am 24. Januar 2013 um 17:11 Uhr

2013-01-24T17:11:40Z

← Nächstältere Version		Version vom 24. Januar 2013, 19:11 Uhr
Zeile 1:		Zeile 1:
	''by Clemens Werkmeister''		''by Clemens Werkmeister''
	<html><img src=""http://vg06.met.vgwort.de/na/1ef62971f2654358b44f34513d765bc5"" width=""1"" height=""1"" alt=""""></html>		<html><img src="http://vg06.met.vgwort.de/na/1ef62971f2654358b44f34513d765bc5" width="1" height="1" alt=""></html>

Wikimeister am 12. Januar 2012 um 15:26 Uhr

2012-01-12T15:26:11Z

← Nächstältere Version		Version vom 12. Januar 2012, 17:26 Uhr
Zeile 7:		Zeile 7:
	Construction Partners Inc. considers submitting a proposal for a large construction project. Your task is to assess the effects on working capital and cash flows. You already prepared the expected development of the four most important positions of (net) working capital:<br>		Construction Partners Inc. considers submitting a proposal for a large construction project. Your task is to assess the effects on working capital and cash flows. You already prepared the expected development of the four most important positions of (net) working capital:<br>

			{\|align="left" border="1" cellpadding="3" cellspacing="0"
	{\|align="~~center~~" border="1" cellpadding="3" cellspacing="0"
	\|- align="center"		\|- align="center"
	\|Year\|\| 0\|\| 1\|\| 2\|\| 3\|\| 4		\|Year\|\| 0\|\| 1\|\| 2\|\| 3\|\| 4
Zeile 24:		Zeile 23:
	\|align="left"\| Change in working capital \|\| \|\| \|\| \|\| \|\|		\|align="left"\| Change in working capital \|\| \|\| \|\| \|\| \|\|
	\|}		\|}
	<br>		<br style="clear:left;"/>

	a. Calculate the net working capital for years 0 to 4.<br>		a. Calculate the net working capital for years 0 to 4.<br>
	b. What effects on the cash flow of years 0 to 4 do you expect? <br>		b. What effects on the cash flow of years 0 to 4 do you expect? <br>
Zeile 33:		Zeile 33:
	United Eye-T presents the following income statement of a business unit:		United Eye-T presents the following income statement of a business unit:

	{\|align="~~center~~" border="1" cellpadding="3" cellspacing="0"		{\|align="left" border="1" cellpadding="3" cellspacing="0"
	\|- align="left"		\|- align="left"
	\|Revenues\|\| align="right" \|500.000		\|Revenues\|\| align="right" \|500.000
Zeile 51:		Zeile 51:
	\| Profit\|\| align="right" \| 50.000		\| Profit\|\| align="right" \| 50.000
	\|}		\|}
	<br>		<br style="clear:left;"/>

	a. Determine the cash flow for a discounted cash-flow (DCF)-analysis.<br>		a. Determine the cash flow for a discounted cash-flow (DCF)-analysis.<br>
Zeile 76:		Zeile 76:


	=== 3. Cash flows based on accounting and tax depreciation ===		=== 4. Cash flows based on accounting and tax depreciation ===

	Solar Innos is considering a proposal to manufacture a new line of solar panels. Given its innovative design, Solar Innos expects strong sales in the next three years. After year 3, the equipment and technology will be sold to prevent losses from the expected strong international competition. <br>		Solar Innos is considering a proposal to manufacture a new line of solar panels. Given its innovative design, Solar Innos expects strong sales in the next three years. After year 3, the equipment and technology will be sold to prevent losses from the expected strong international competition. <br>
	Solar Innos forecasts necessary capital investments of 10 mio € (in year 0), a resale value of equipment and technology of 1 mio € (in year 3), a tax rate of 35 % and a cost of capital of 10 %. Working capital is assumed to be 20 % of the sales. The following table resumes the sales and cost forecasts for years 0 to 4.<br>		Solar Innos forecasts necessary capital investments of 10 mio € (in year 0), a resale value of equipment and technology of 1 mio € (in year 3), a tax rate of 35 % and a cost of capital of 10 %. Working capital is assumed to be 20 % of the sales. The following table resumes the sales and cost forecasts for years 0 to 4.<br>

			{\|align="left" border="1" cellpadding="3" cellspacing="0"
	{\|align="~~center~~" border="1" cellpadding="3" cellspacing="0"
	\|- align="center"		\|- align="center"
	\|Year\|\| 0\|\| 1\|\| 2\|\| 3\|\| 4		\|Year\|\| 0\|\| 1\|\| 2\|\| 3\|\| 4
Zeile 92:		Zeile 91:
	\|align="left" \|Other costs\|\| 3.000\|\| 1.000\|\| 1.000\|\| 1.000\|\| 0		\|align="left" \|Other costs\|\| 3.000\|\| 1.000\|\| 1.000\|\| 1.000\|\| 0
	\|}		\|}
	<br>		<br style="clear:left;"/>

	a. Prepare the asset statements and the income statements for years 0 to 4, based on these informations. Assume straight line depreciation over the 3-years depreciable life of the capital investment. <br>		a. Prepare the asset statements and the income statements for years 0 to 4, based on these informations. Assume straight line depreciation over the 3-years depreciable life of the capital investment. <br>
	b. Prepare the corresponding cash flow analysis and calculate the NPV of the solar panel project.<br>		b. Prepare the corresponding cash flow analysis and calculate the NPV of the solar panel project.<br>

Wikimeister am 10. Januar 2012 um 13:06 Uhr

2012-01-10T13:06:56Z

← Nächstältere Version		Version vom 10. Januar 2012, 15:06 Uhr
Zeile 3:		Zeile 3:


	~~sorry, this page is still under construction~~		=== 1. Working capital and cash flows ===

			Construction Partners Inc. considers submitting a proposal for a large construction project. Your task is to assess the effects on working capital and cash flows. You already prepared the expected development of the four most important positions of (net) working capital:<br>


			{\|align="center" border="1" cellpadding="3" cellspacing="0"
			\|- align="center"
			\|Year\|\| 0\|\| 1\|\| 2\|\| 3\|\| 4
			\|- align="right"
			\|align="left"\| Accounts receivable\|\|10.000 \|\| 50.000\|\| 125.000\|\| 90.000\|\| 10.000
			\|- align="right"
			\|align="left"\| Inventory\|\| 25.000 \|\| 80.000\|\| 90.000\|\| 45.000\|\| 25.000
			\|- align="right"
			\|align="left"\| Cash\|\| 10.000\|\| 20.000\|\| 20.000\|\| 20.000\|\| 10.000
			\|- align="right"
			\|align="left"\| Accounts payable\|\|15.000 \|\| 60.000\|\| 60.000\|\| 50.000\|\| 15.000
			\|- align="right"
			\|align="left"\| Net working capital\|\| \|\| \|\| \|\| \|\|
			\|- align="right"
			\|align="left"\| Change in working capital \|\| \|\| \|\| \|\| \|\|
			\|}
			<br>
			a. Calculate the net working capital for years 0 to 4.<br>
			b. What effects on the cash flow of years 0 to 4 do you expect? <br>


			=== 2. Indirect determination of cash flows ===

			United Eye-T presents the following income statement of a business unit:

			{\|align="center" border="1" cellpadding="3" cellspacing="0"
			\|- align="left"
			\|Revenues\|\| align="right" \|500.000
			\|- align="left"
			\|Cost of sales (CoGS)\|\|align="right" \|200.000
			\|- align="left"
			\|Depreciation\|\|align="right" \| 80.000
			\|- align="left"
			\|Amortization\|\| align="right" \|30.000
			\|- align="left"
			\|Selling, general and<br> administrative expenses (S, G & A)\|\|align="right" \|70.000
			\|- align="left"
			\|Interest expense\|\| align="right" \| 40.000
			\|- align="left"
			\| Income Tax\|\| align="right" \|30.000
			\|- align="left"
			\| Profit\|\| align="right" \| 50.000
			\|}
			<br>

			a. Determine the cash flow for a discounted cash-flow (DCF)-analysis.<br>
			b. Explain and evaluate your approach.
			<br>


			=== 3. Identification of relevant cash flows for NPV analysis ===

			Project analysts of Drewmore Inc. compiled the following informations about their next project which is supposed to start next year:<br>
			* Manufacturing will be in a plant that otherwise would be sold for 8 mio € at the end of this year.
			* Site clearance, additional buildings and installations will cost 20 mio € next year and will be depreciated over 20 years, beginning next year, too.
			* Development and management of the project is outsourced to a constructor. He charges 500.000 € for the services already delivered this year and the same amount for next year’s management.
			* Tax effects will be computed using straight line depreciation and a corporate tax rate of 35 %.
			* The project will use specific knowledge of a R&D-subsidiary which was acquired two years ago for 5 mio € and causes annual costs of 2 mio €.
			* Costs for licenses will be 200.000 € per year.
			* The project is expected to attract sales of 25 mio € per year, beginning next year.
			* Costs for human resources and raw materials are 10 mio € per year.
			* Working capital requirements will be 1 mio € next year and 1,5 mio € in year 2.
			* Overhead of Drewmore Inc. is 20 % of sales.
			a. Prepare the relevant cash flows for year 0, 1 and 2.<br>
			b. Estimate the payback period based on the given information. <br>
			c. What happens if the sales forecasts include 8 mio € from existing customers and other products of Drewmore Inc.?<br>


			=== 3. Cash flows based on accounting and tax depreciation ===

			Solar Innos is considering a proposal to manufacture a new line of solar panels. Given its innovative design, Solar Innos expects strong sales in the next three years. After year 3, the equipment and technology will be sold to prevent losses from the expected strong international competition. <br>
			Solar Innos forecasts necessary capital investments of 10 mio € (in year 0), a resale value of equipment and technology of 1 mio € (in year 3), a tax rate of 35 % and a cost of capital of 10 %. Working capital is assumed to be 20 % of the sales. The following table resumes the sales and cost forecasts for years 0 to 4.<br>


			{\|align="center" border="1" cellpadding="3" cellspacing="0"
			\|- align="center"
			\|Year\|\| 0\|\| 1\|\| 2\|\| 3\|\| 4
			\|-
			\|Sales\|\|align="right" \| 0 \|\|10.000\|\| 25.000\|\| 20.000\|\| 0
			\|- align="right"
			\|align="left" \|Costs of goods sold\|\| 0 \|\| 5.000\|\| 10.000\|\| 10.000\|\| 0
			\|- align="right"
			\|align="left" \|Other costs\|\| 3.000\|\| 1.000\|\| 1.000\|\| 1.000\|\| 0
			\|}
			<br>
			a. Prepare the asset statements and the income statements for years 0 to 4, based on these informations. Assume straight line depreciation over the 3-years depreciable life of the capital investment. <br>
			b. Prepare the corresponding cash flow analysis and calculate the NPV of the solar panel project.<br>
			c. Solar innos wants to take advantage of the Modified Accelerated Cost Recovery System (MACRS). The tax depreciation factors are 33,33 % for year 1, 44,45 % for year 2, 14,81 % for year 3 and 7,41 % for year 4. Calculate the corresponding tax depreciations and the profits after taxes.<br>
			d. Prepare the cash flow analysis based on the accelerated depreciation. Calculate the NPV of the project and the advantage of the tax depreciation.<br>

Wikimeister am 2. Januar 2012 um 15:05 Uhr

2012-01-02T15:05:40Z

← Nächstältere Version		Version vom 2. Januar 2012, 17:05 Uhr
Zeile 1:		Zeile 1:
	''by Clemens Werkmeister''		''by Clemens Werkmeister''
			<html><img src=""http://vg06.met.vgwort.de/na/1ef62971f2654358b44f34513d765bc5"" width=""1"" height=""1"" alt=""""></html>

Wikimeister: Die Seite wurde neu angelegt: „''by Clemens Werkmeister'' sorry, this page is still under construction ---
References:
For some useful formulae you might have a look at our [[Fi…“

2012-01-02T15:04:44Z

Die Seite wurde neu angelegt: „''by Clemens Werkmeister'' sorry, this page is still under construction --- References: For some useful formulae you might have a look at our [[Fi…“

Neue Seite