SLP 3 Tasks



SLP 3 TASKS

Cash Flow Estimation Report

Assumptions for making cash flow estimation report for the hospital are given below:

The hospital projects revenues to be $3,100,000 in 2012, $3,200,000 in 2013, 3,250,000 in 2014 and 3,300,000 in 2015.

Operating expenses are expected to increase by 25000 on annual basis from 2012 to 2015.

Cost of capital is estimated to be 15%.

Depreciation expense is expected to increase by 5000 on annual basis for the next five years.

All other elements of the given income statement are expected to remain constant throughout the given period.

ASSETS

2011

2012

2013

2014

2015

REVENUE

1300000

3100000

3200000

3250000

3300000

EQUITY

1,000,000

1,300,000

1,300,000

1,300,000

1,300,000

DELAYED PAYMENTS

500,000

500,000

500,000

500,000

500,000

GRANTS

250,000

250,000

250,000

250,000

250,000

TOTAL

3,050,000

5,900,000

6,000,000

6,050,000

6,100,000

LIABILITIES

2011

2012

2013

2014

2015

OPERATING

1,200,000

1,225,000

1,250,000

1,275,000

1,300,000

DEBT RETIREMENT

150,000

150,000

150,000

150,000

150,000

RETIREMENT

150,000

150,000

150,000

150,000

150,000

DEPRECIATION

105,000

110,000

115,000

120,000

125,000

TOTAL

1,605,000

1,635,000

1,665,000

1,695,000

1,725,000

ASSETS

3,050,000

5,150,000

5,250,000

5,300,000

5,350,000

LIABILITIES

1605000

1635000

1665000

1695000

1725000

NET PROFIT

1,445,000

3,515,000

3,585,000

3,605,000

3,625,000

The cash flow statement based on the ...