Feasib Scratch Muna

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Feasib Scratch Muna as PDF for free.

More details

  • Words: 1,367
  • Pages: 15
EALA INC.

SALES FORECAST (YEAR YEAR Production Volume Estimated Percentage of items sold (at regular price) Sold units (at regular price) Average Selling Price Revenue From regular Sales Unsold Items from Previous year Units Available for Discount Sale (50% discount) Percentage sold (at discount price) Sold units (at discount price) Selling Price (at discount) Revenue From Discounted Sales Total Sales (in units) Total Sales (in peso)

Year 1 Year 2 Year 3 5,749 5,857 5,966 95% 95% 95% 5,462 5,564 5,668 800 816 832 4,369,316.00 4,539,976.69 4,717,303.21 0 0 0 287 293 298 100% 100% 100% 287 293 298 400 408 416 114,982 119,473 124,140 5,749 5,857 5,966 4,484,298.00 4,659,449.77 4,841,442.77

EALA INC.

S FORECAST (YEAR 1-10) Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 6,077 6,191 6,307 6,425 6,545 6,667 95% 95% 95% 95% 95% 95% 5,774 5,881 5,991 6,103 6,217 6,333 849 866 883 901 919 937 4,901,555.90 5,093,005.30 5,291,932.51 5,498,629.59 5,713,400.04 5,936,559.18 0 0 0 0 0 0 304 310 315 321 327 333 100% 100% 100% 100% 100% 100% 304 310 315 321 327 333 424 433 442 450 459 469 128,988 134,026 139,261 144,701 150,353 156,225 6,077 6,191 6,307 6,425 6,545 6,667 5,030,544.21 5,227,031.76 5,431,193.89 5,643,330.37 5,863,752.67 6,092,784.42

Year 10 6,791 95% 6,452 956 6,168,434.68 0 340 100% 340 478 162,327 6,791 6,330,761.90

EALA INC Pro-forma Income Statement For the period from Year 1 to Year 10 Year 1

Year 2

Year 3

4,484,298.00 538,115.76

4,659,449.77 21,018.21 559,133.97

4,841,442.77 21,839.16 580,973.13

4,484,298.00

4,659,449.77

4,841,442.77

35,841.92

37,241.87

4,449,803.40

4,623,607.84

4,804,200.90

110,500.00 180,000.00 102,293.90 150,000.00

30,000.00 180,000.00 102,293.90 35,000.00 161,250.00

30,000.00 180,000.00 102,293.90 35,000.00 173,343.75

2,760,000.00 90,985.20 19,950.00 230,000.00 187,080.00

2,760,000.00 90,985.20 19,950.00 140,000.00 190,821.60

2,842,800.00 91,348.80 19,950.00 236,900.00 194,638.03

16,911.90

14,546.90

14,546.90

7,472.00 22,500.00 3,877,693.00

7,472.00 22,500.00 3,754,819.60

7,472.00 22,500.00 3,950,793.38

Operating Income Less: Interest Expense (16%)

572,110.40 27,855.10

868,788.24 27,855.10

853,407.52

Earnings before Tax Less: Income Tax (32%)

544,255.30 174,161.70

Net Income

370,093.60

840,933.14 269,098.61 94,936.91 571,834.54

853,407.52 273,090.41 3,991.80 580,317.11

Gross Sales Revenue VAT Output Tax (12%) Net Sales Revenue Cost of Sales Gross Income Less: Operating Expenses Advertising Expense Washing Expenses Depreciation Expense Repairs & Maintainance Rent Expense Salaries and Wages SSS Contribution Phil Health/Medicare Employee Benefits ( 13th Month Pay) Utilities Expense (electricity, water, gasoline, telephone) Supplies Expense Miscellaneous Expense ( Business Permit,etc) Insurance Expense Total Operating Expenses

34,494.60

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Year 10

5,030,544.21 22,692.17 603,665.31

5,227,031.76 23,578.51 627,243.81

5,431,193.89 24,499.46 651,743.27

5,643,330.37 25,456.38 677,199.64

5,863,752.67 26,450.68 703,650.32

6,092,784.42 27,483.81 731,134.13

6,330,761.90 28,557.30 759,691.43

5,030,544.21

5,227,031.76

5,431,193.89

5,643,330.37

5,863,752.67

6,092,784.42

6,330,761.90

38,696.49

40,207.94

81,084.05

82,581.28

84,141.99

85,696.71

87,315.28

4,991,847.72

5,186,823.82

5,350,109.84

5,560,749.09

5,779,610.68

6,007,087.71

6,243,446.62

110,500.00 180,000.00 102,293.90 35,000.00 186,344.53

30,000.00 180,000.00 102,293.90 35,000.00 200,320.37

100,500.00 180,000.00 102,993.90 35,000.00 215,344.40

30,000.00 180,000.00 102,993.90 35,000.00 231,495.23

30,000.00 180,000.00 102,993.90 35,000.00 248,857.37

30,000.00 180,000.00 102,993.90 35,000.00 267,521.67

30,000.00 180,000.00 102,993.90 35,000.00 287,585.80

2,842,800.00 91,348.80 19,950.00 144,200.00 198,530.79

2,928,084.00 93,530.40 19,950.00 244,007.00 202,501.41

2,928,084.00 93,630.40 19,950.00 244,007.00 206,551.44

3,015,926.52 93,895.20 20,550.00 251,327.21 210,682.47

3,015,926.52 99,475.20 20,550.00 251,327.21 214,896.11

3,106,404.32 95,080.40 20,700.00 258,867.03 219,194.04

3,106,404.32 102,024.00 20,700.00 258,867.03 223,577.92

14,546.90

14,546.90

14,546.90

14,546.90

14,546.90

14,546.90

14,546.90

7,472.00 22,500.00 3,955,486.92

7,472.00 22,500.00 4,080,205.98

7,472.00 22,500.00 4,170,580.04

7,472.00 22,500.00 4,216,389.42

7,472.00 22,500.00 4,243,545.22

7,472.00 22,500.00 4,360,280.26

7,472.00 22,500.00 4,391,671.86

1,036,360.80

1,106,617.84

1,179,529.81

1,344,359.67 -

1,536,065.47 -

1,646,807.46 -

1,851,774.76 -

1,036,360.80 331,635.45 58,545.05 704,725.34

1,106,617.84 354,117.71 22,482.25 752,500.13

1,179,529.81 377,449.54 23,331.83 802,080.27

1,344,359.67 430,195.09 52,745.56 914,164.58

1,536,065.47 491,540.95 61,345.85 1,044,524.52

1,646,807.46 526,978.39 35,437.44 1,119,829.07

1,851,774.76 592,567.92 65,589.54 1,259,206.83

EALA INC.

Pro-forma Statement of Retained Earnin For the period from Year 1 to Year 10 Year 1

Retained Earnings - Beginning

Year 2

-

Year 3

Year 4

370,093.60

941,928.14

1,522,245.25

Less: Net Income for the Year Dividends Declared During the Year

370,093.60 -

571,834.54 -

580,317.11 -

704,725.34 -

Retained Earnings - Ending

370,093.60

941,928.14

1,522,245.25

2,226,970.59

EALA INC.

tement of Retained Earnings iod from Year 1 to Year 10 Year 5

Year 6

Year 7

Year 8

Year 9

Year 10

2,226,970.59

2,979,470.73

3,281,551.00

3,695,715.57

4,240,240.09

4,860,069.16

752,500.13 -

802,080.27 500,000.00

914,164.58 500,000.00

1,044,524.52 500,000.00

1,119,829.07 500,000.00

1,259,206.83 500,000.00

2,979,470.73

3,281,551.00

3,695,715.57

4,240,240.09

4,860,069.16

5,619,275.99

EALA INC. Pro-forma Statement of Cash Flows For the period from Year 1 to Year 5 Year 1 Cash Flows from Operating Activities Net Income Increase (Decrease) in Depreciation - Fixed Assets Increase (Decrease) in Depreciation - Leasehold Improvements Increase (Decrease) in Supplies On Hand Increase (Decrease) in Prepaid Expense Increase (Decrease) in Interest Payable Increase (Decrease) in Insurance Payable Increase (Decrease) in VAT Output Tax Payable Increase (Decrease) in Income Tax Payable Net Cash Provided by Operating Activities Cash Flows from Investing and Financing Activities Acquisition of Office Assets Acquisition of Store Assets Increase (Decrease) in Long-term Loan Dividends Paid Net Cash Provided by Investing and Financing Activities

389,640.54 (72,131.00) (30,862.90) (12,382.70) (75,000.00) 27,855.10 22,500.00 538,115.76 174,161.70 1,136,661.90

(109,200.00) (464,610.00) 198,465.00 (375,345.00)

Year 2

529,620.72 (72,131.00) (30,862.90) (423.54) 21,018.21 94,936.91 543,005.48

-

Increase (Decrease) in Cash

761,316.90

543,005.48

Add: Cash - Beginning

100,000.00

861,316.90

Cash Balance - End

861,316.90

1,404,322.39

Flows Year 5 Year 3

472,761.95 (57,131.00) (30,862.90) 21,839.16 3,991.80 410,599.01

(15,000.00) (198,965.00) (213,965.00)

Year 4

Year 5

528,086.57 (72,131.00) (30,862.90) 22,692.17 58,545.05 506,329.89

-

Year 6

502,867.07 1,311,630.78 (57,131.00) 15,369.00 (30,862.90) (30,862.90) 23,578.51 24,499.46 22,482.25 23,331.83 460,933.93 1,343,968.17

(15,000.00) (15,000.00)

(72,000.00) (15,500.00)

Year 7

1,357,991.74 (57,131.00) (30,862.90) 25,456.38 52,745.56 1,348,199.77

Year 8

1,418,461.31 (72,131.00) (30,862.90) 26,450.68 61,345.85 1,403,263.94

(500,000.00) (587,500.00)

(15,000.00) (500,000.00) (515,000.00)

(500,000.00) (500,000.00)

196,634.01

506,329.89

445,933.93

756,468.17

833,199.77

903,263.94

1,404,322.39

1,600,956.40

2,107,286.29

2,553,220.22

3,309,688.38

4,142,888.15

1,600,956.40

2,107,286.29

2,553,220.22

3,309,688.38

4,142,888.15

5,046,152.09

Year 9

1,419,515.82 (57,131.00) (30,862.90) 27,483.81 35,437.44 1,394,443.17

(15,000.00)

Year 10

1,480,083.13 (72,131.00) (30,862.90) 28,557.30 65,589.54 1,471,236.07

-

-

(500,000.00) (515,000.00)

(500,000.00) (500,000.00)

879,443.17

971,236.07

5,046,152.09

5,925,595.26

5,925,595.26

6,896,831.33

33,848,257.41

EALA INC. Pro-forma Balance Sheet As of December 31, Year 0 to Year 10 Y E A 0

1

2

ASSETS Currents Assets Cash Inventory ( Raw Materials) Supplies on Hand Prepaid Rent Total Current Assets

100,000.00 39,885.00 16,911.90 75,000.00 231,796.90

861,316.90 40,682.70 4,529.20 906,528.80

1,404,322.39 40,682.70 4,105.66 1,449,110.75

Fixed Assets Office Assets Store Assets Total Fixed Assets Less: Accumulated Depreciation Total Fixed Assets

109,200.00 464,610.00 573,810.00 573,810.00

109,200.00 464,610.00 573,810.00 72,131.00 501,679.00

109,200.00 464,610.00 573,810.00 144,262.00 429,548.00

Intangibles Leasehold Improvement Less: Accumulated Depreciation (10%) Total Intangibles

308,629.00 308,629.00

(30,862.90) 308,629.00 30,862.90 277,766.10

(30,862.90) 308,629.00 61,725.80 246,903.20

1,114,235.90

1,685,973.90

2,125,561.95

-

27,855.10 22,500.00 538,115.76 174,161.70

27,855.10 22,500.00 559,133.97 94,936.91

-

762,632.56

704,425.98

TOTAL ASSETS

LIABILITIES AND STOCKHOLDER'S EQUITY Current Liabilities Interest Payable Insurance Payable VAT Output Tax Payable Income Tax Payable Dividends Payable Total Current Liabilities Long-term Liabilities Long-term loan

198,965.00

198,965.00

198,965.00

TOTAL LIABILITIES

198,965.00

961,597.56

903,390.98

Stockholder's Equity Capital Stock (P10 par value) Retained Earnings

700,000.00 -

700,000.00 389,640.54

700,000.00 919,261.26

TOTAL STOCKHOLDER'S EQUITY

700,000.00

1,089,640.54

1,619,261.26

TOTAL LIABILITIES AND STOCKHOLDERS EQUITY

898,965.00

2,051,238.10

2,522,652.25

(215,270.90) (215,270.90)

365,264.20 365,264.20

397,090.30 397,090.30

ar 10 Y E A R 3

4

5

6

1,600,956.40 40,682.70 4,105.66 1,645,744.75

2,107,286.29 40,682.70 4,105.66 2,152,074.64

2,553,220.22 40,682.70 4,105.66 2,598,008.57

3,309,688.38 40,682.70 4,105.66

4,142,888.15 40,682.70 4,105.66

5,046,152.09 40,682.70 4,105.66

3,354,476.74

4,187,676.51

5,090,940.45

109,200.00 464,610.00 573,810.00 201,393.00 372,417.00

109,200.00 464,610.00 573,810.00 273,524.00 300,286.00

109,200.00 464,610.00 573,810.00 330,655.00 243,155.00

109,200.00 464,610.00 573,810.00 315,286.00 258,524.00

109,200.00 464,610.00 573,810.00 372,417.00 201,393.00

109,200.00 464,610.00 573,810.00 444,548.00 129,262.00

(30,862.90) 308,629.00 92,588.70 216,040.30

(30,862.90) 308,629.00 123,451.60 185,177.40

(30,862.90) 308,629.00 154,314.50 154,314.50

(30,862.90) 308,629.00 185,177.40 123,451.60

(30,862.90) 308,629.00 216,040.30 92,588.70

(30,862.90) 308,629.00 246,903.20 61,725.80

2,234,202.05

2,637,538.04

2,995,478.07

3,736,452.34

4,481,658.21

5,281,928.25

22,500.00 580,973.13 3,991.80

22,500.00 603,665.31 58,545.05

22,500.00 627,243.81 22,482.25

607,464.93

684,710.36

672,226.07

22,500.00 651,743.27 23,331.83 500,000.00 1,197,575.10

22,500.00 677,199.64 52,745.56 500,000.00 1,252,445.20

22,500.00 703,650.32 61,345.85 500,000.00 1,287,496.17

-

-

-

7

-

8

-

-

607,464.93

684,710.36

672,226.07

1,197,575.10

1,252,445.20

1,287,496.17

700,000.00 1,392,023.21

700,000.00 1,920,109.78

700,000.00 2,422,976.85

700,000.00 3,234,607.63

700,000.00 4,092,599.37

700,000.00 5,011,060.68

2,092,023.21

2,620,109.78

3,122,976.85

3,934,607.63

4,792,599.37

5,711,060.68

2,699,488.14

3,304,820.13

3,795,202.91

5,132,182.73

6,045,044.57

6,998,556.85

465,286.09 465,286.09

667,282.09 667,282.09

799,724.84 799,724.84

1,395,730.39 1,395,730.39

1,563,386.36 1,563,386.36

1,716,628.60 1,716,628.60

9

10

5,925,595.26 40,682.70 4,105.66

6,896,831.33 40,682.70 4,105.66

5,970,383.62

6,941,619.69

109,200.00 464,610.00 573,810.00 501,679.00 72,131.00

109,200.00 464,610.00 573,810.00 573,810.00 -

(30,862.90) 308,629.00 277,766.10 30,862.90

(30,862.90) 308,629.00 308,629.00 -

6,073,377.52

6,941,619.69

22,500.00 731,134.13 35,437.44 500,000.00 1,289,071.57

22,500.00 759,691.43 65,589.54 500,000.00 1,347,780.96

-

-

1,289,071.57

1,347,780.96

700,000.00 5,930,576.50

700,000.00 6,910,659.63

6,630,576.50

7,610,659.63

7,919,648.07

8,958,440.60

1,846,270.55 1,846,270.55

2,016,820.91 2,016,820.91

Related Documents

Feasib Scratch Muna
November 2019 8
Muna
May 2020 8
Scratch
May 2020 11
Scratch
May 2020 14
Scratch
December 2019 28