Financial Management

Essay by   •  December 8, 2010  •  1,019 Words (5 Pages)  •  2,416 Views

Essay Preview: Financial Management

Report this essay
Page 1 of 5

FIN 410

Individual Project 4

1. Prepare a statement showing the incremental cash flows for this project over an 8-year period.

-Initial investment:

I = \$1,000,000

-Working Capital:

WC = \$200,000

ChWCi = Previous Year WC - Current WC = 0 (for i=1 to 7)

ChWC0 = -\$200,000

The working capital is recovered, this means that for the end of the year 8 it will be zero or:

ChWC8 = \$200,000

-Depreciation:

Di = (Invest in plant and equipment)/5 = \$1,000,000/5 = \$200,000

For the years 6 to 8 the depreciation will be zero.

-Revenues:

R1 = \$950,000

For the years Yi (i=2 to 8):

Ri = \$1,500,000

-Expenses:

Indirect incremental costs will be \$80,000 all the eight years.

For each year the direct costs will be 0.55*Ri .

Then for each year Yi (i=1 to 8), the expenses (Ei) will be:

Ei = \$80,000 + 0.55*Ri ,

then:

E1 = \$80,000 + 0.55*\$950,000 = \$602,500

For i=2 to 8:

Ei = \$80,000 + 0.55*\$1,500,000 = \$905,000

-Taxes:

The firm's marginal tax rate is 35%, then the taxes will be:

T1 = 0.35*(\$950,000-\$602,500-\$200,000) = \$51,625

For i=2 to 5

Ti = 0.35*(\$1,500,000-\$905,000-\$200,000) = \$138,250

For i=6 to 8

Ti = 0.35*(\$1,500,000-\$905,000-\$0) = \$208,250

YEARS (IN THOUSANDS)

0 1 2 3 4 5 6 7 8

1.Revenues 0 950 1500 1500 1500 1500 1500 1500 1500

2.Expenses 0 602.5 905 905 905 905 905 905 905

3.Depreciation 0 200 200 200 200 200 0 0 0

4.Income before 0 147.5 395 395 395 395 595 595 595

tax, [1-(2+3)]

5.Taxes 0 51.6 138.2 138.2 138.2 138.2 238.2 238.2 238.2

6.Net Income 0 95.9 256.8 256.8 256.8 256.8 356.8 356.8 356.8

[4-5]

7.Cash flow

from operation 0 295.9 456.8 456.8 456.8 456.8 356.8 356.8 356.8

[1-2-5]

--------------------------------------------------------------

8.Investments -1000 0 0 0 0 0 0 0 0

9.Change in WC -200 0 0 0 0 0 0 0 200

10.Total cash -1200 0 0 0 0 0 0 0 200

flow from investment

--------------------------------------------------------------

11.Total cash -1200 295.9 456.8 456.8 456.8 456.8 356.8 356.8 556.8

flow

--------------------------------------------------------------

2. Calculate the Payback Period and the NPV for the project.

-Payback Period:

PB = Y + U/CFi

We will consider the total initial investment (TI) as the sum of the

invest in plant and equipment plus the initial Working Capital

required.

TI = \$1,200,000

At the

...

...