Scribd
Upload
13 views3 pages

Paidup Capital Calculation and Forecast

This document contains a calculation sheet analyzing the paid-up capital of a company from 2005 to 2012. It includes the actual paid-up capital amounts each year along with forecasted values and errors. A linear trend line was fitted to the data to forecast future paid-up capital amounts in 2013 through 2015. The Durbin-Watson test was used to check for autocorrelation in the dependent variable but no conclusion could be drawn.

Uploaded by

Santosh Nepal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
13 views3 pages

Paidup Capital Calculation and Forecast

This document contains a calculation sheet analyzing the paid-up capital of a company from 2005 to 2012. It includes the actual paid-up capital amounts each year along with forecasted values and errors. A linear trend line was fitted to the data to forecast future paid-up capital amounts in 2013 through 2015. The Durbin-Watson test was used to check for autocorrelation in the dependent variable but no conclusion could be drawn.

Uploaded by

Santosh Nepal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Calculation Sheet for Paidup Capital

Year

Paidup Capital

x*y

x^2

forecasted y

error ei

ei-1

(ei-ei-1)^2

2005

-7

374,640,400

(2,622,482,800.00)

49

162,879,866.67

2006

-5

374,640,400

(1,873,202,000.00)

25

378,275,104.76

(3,634,704.76)

2007

-3

413,254,800

(1,239,764,400.00)

593,670,342.86

(180,415,542.86)

(3,634,704.76)

2008

-1

620,784,000

(620,784,000.00)

809,065,580.95

(188,281,580.95)

(180,415,542.86)

61,874,555,315,735.00

2009

931,966,400

931,966,400.00

1,024,460,819.05

(92,494,419.05)

(188,281,580.95)

9,175,180,385,769,050.00

2010

1,398,483,600

4,195,450,800.00

1,239,856,057.14

158,627,542.86

(92,494,419.05)

63,062,239,750,896,800.00

2011

1,610,168,000

8,050,840,000.00

25

1,455,251,295.24

154,916,704.76

158,627,542.86

13,770,319,369,071.10

2012

1,610,168,000

11,271,176,000.00

49

1,670,646,533.33

(60,478,533.33)

154,916,704.76

46,395,108,594,104,300.00

SUM
Mean X

7,334,105,600

18,093,200,000.00

211,760,533.33
211,760,533.33

168.00

46,395,108,594,104,300.00
31,251,464,717,654,800.00

196,354,746,917,214,000.00

2008.5

Trend Analysis

DW Test

b0

916763200

b1

107697619.047619

R squared

0.9179

Forecast
Year

Forecast
2013

1,886,041,771.43

2014

2,101,437,009.52

2015

2,316,832,247.62

Test statstics

1.1269845066

dl

0.763

du

1.332

4-du

2.668

4-dl

3.237

Conclusion

No conclusion can be derived about the autocorrelation in dep

Year

ei^2

Paidup Capital

Forecasted Paidup Capital

2005

374,640,400

162,879,866.67

2006

374,640,400

378,275,104.76

44,842,523,477,617,700.00

2007

413,254,800

593,670,342.86

13,211,078,706,212.80

2008

620,784,000

809,065,580.95

32,549,768,104,437,600.00

2009

931,966,400

1,024,460,819.05

35,449,953,725,928,000.00

2010

1,398,483,600

1,239,856,057.14

8,555,217,554,956,560.00

2011

1,610,168,000

1,455,251,295.24

25,162,697,352,894,700.00

2012

1,610,168,000

1,670,646,533.33

23,999,185,414,287,200.00

2013

1,886,041,771.43

3,657,652,994,151,100.00

2014

2,101,437,009.52

2015

2,316,832,247.62

174,230,209,702,979,000.00

relation in dependent variable

2,500,000,000
2,000,000,000
1,500,000,000
1,000,000,000
500,000,000
0

Paidup Capital
Forecasted Paidup Capital

You might also like