Sanando la tierra internacional cafr 2010 revised (last)

Page 1

Com mpara ative Annu ual Fiinanccial Reportts

Manag gement F Financialss 07/17/2011


TABLE E OF CON NTENT T


GEN NERA AL PA ASTO OR LET TTER R


SANANDO LA TIERRA INTERNACIONAL, INC 2124 N DEAN RD ORLANDO, FL 32817 To any interested party: Re: Iglesia Sanando La Tierra Internacional

I hereby certify and attest the financial statements for iglesia Sanando la Tierra Internacional, Inc., submitted for the years 2008 through 2011 are true and correct to the best of my knowledge.

I affirmatively state that I am the General Pastor of the church and its leadership.

Sincerely, Alex Castro- General Pastor 07/17/2011


ENGAGEMENT LETTER


Â

July 17, 2011 Sanando la Tierra Internacional, Inc. 2124 N. Dean Road Orlando, FL 32817

To the Administration, General Pastors and Board of Elder, The principal scope of this project is to present a financial picture of the Church last three years performance, as well as actual interim financials and next five years expectations. This presentation has been conducted on a pro bono basis as a contribution as a member of this church. We also add to the scope of this presentation a feasibility of the project for a daily care facility. Emphasis on this project is sustainability and possible contributions to the general fund and for the construction of the new building. The operation of a daily care facility is controlled by Florida Department of Children and Families. The agency required all facilities compliance with the standards provided on the Florida Administrative Code Child Care Standards also known as Chapter 65C-22. In addition to rigorous inspections are conducted regularly to assess compliance and reports are public documents available on the website of the Department of Children and Family. In exchange the Department of Children and Families provided programs that subsidized the cost for the parents and provide different sources of income to the providers. The most known program is called 4C which provided payment for the caring fees charged by the facility. Other programs like Child care food programs and Head Start are also administered by DCF and provide also additional sources of income. The principal source of revenue is through the public support and charges of fees for the daily care to the parents while other less used are through the use of grants from private and public sector for the benefit of the general public and the community that the church serve.


We cover also the ability to generated cash flow streams through the current institute called “Desarollo Explosivo” as a seven week continuous class for members with four levels and a three years Institute called “Instituto FM” to serve as a bridge to ordained new pastors and to expand the ministry. Is my understanding that members of the board will like to pursuit the Institute as a credit postsecondary education in the near future. The permits and license to open a postsecondary institution are governed by the Florida statues Title XLVIII known as K-20 Education code. Whether the Church decides to pursuits all the permits to allow the institute as a credited postsecondary school will have to be decided by the Board of Elders. All revenues and expenses projected are based on judgment, other estimates are based on current operational unit cost from the church allocated to the space designed for these projects, never the less these projections are not pretended to be final numbers they are just the beginning of the planning process. One recommendation once the person in charge of these project are selected is to overlook to the assumptions and submit recommendations to the management and board which facilitates the amendment of the projections and ends in the approval of this planning process and on the approval of a final budget. I want to express my gratitude to allow me to work with the board and with the management to present this draft allowing the management to continue with the planning process.

Sincerely

Francisco G Catalan, Christian Solution Group, consultant Partner.


FINANCIALS: 1. Year End. 2. Interim. 3. Pro‐forma Projections. 4. Notes to Financials.


SANANDO LA TIERRA INTERNACIONAL, INC STATEMENT OF FINANCIAL POSITION (UNAUDITED) CONSOLIDATED DECEMBER 31, 2010, 2009 AND 2008 2010 ASSETS CURRENT ASSETS Cash and Cash Equivalent-Unrestricted Cash and Cash Equivalent-Restricted Inventory,Bookstore Prepaid Expense-Unrestricted Prepaid Expense-Restricted

$

Total Current Assets FIXED ASSETS Audio and Visual Equipment Music Equipment Office Equipment Furniture and Fixture Land and Buildings Less Accumulated Depreciation

OTHER ASSETS Construction in Progress, Note F

TOTAL ASSETS

2009

23,773 $ 53,762 -

27,908 $ 53,762 -

36,530 -

77,535

81,669

36,530

15,302 32,880 5,877 909,660 (66,090) 897,629

15,302 32,880 3,751 896,582 (35,759) 912,756

15,302 29,743 2,853 (7,414) 40,484

28,299

$

2008

-

1,003,463 $

-

994,426 $

77,014

- $ 510 510

-

LIABILITIES AND NET ASSETS CURRENT LIABILITIES Accounts Payable Accrued payroll Accrued vacation payroll Current Portion of Long Term Debt

$

1,493 1,493

$

LONG TERM LIABILITIES, Net of Current Portion, Note G

793,257

884,784

-

TOTAL LIABILITIES

794,750

885,294

-

FUND BALANCE Unrestricted, Note A Undesignated Unresticted

135,304 135,304

94,480 94,480

81,702 81,702

73,409

14,652

(4,688)

208,713

109,132

77,014

994,426 $

77,014

Temporarily Restricted TOTAL NET ASSETS

TOTAL LIABILITIES AND NET ASSETS

$

1,003,463 $ -


SANANDO LA TIERRA INTERNACIONAL, INC STATEMENT OF ACTIVITIES (UNAUDITED) CONSOLIDATED - YEARS ENDED DECEMBER 31, 2010, 2009 AND 2008 2010

UNRESTRICTED NET ASSETS REVENUE Contributions Contributions of investment property Investment Income

$

NET ASSETS RELEASED FROM RESTRICTIONS TOTAL UNRESTRICTED REVENUE AND SUPPORT

272,228 $ 1,525 273,753

2008

2009

195,401 $ 2,861 198,262

198,306 666 198,972

27,176

10,739

10,332

300,929

209,001

209,304

50,900 25,946 19,924 3,452 46,474 30,331 32,363 209,390

37,242 34,190 21,366 67,339 28,344 188,481

39,623 32,114 2,907 5,131 77,478 5,707 162,958

33,015 17,700 50,715

2,816 4,926 7,742

2,690 2,690

260,105

196,223

165,649

UNRESTRICTED EXPENSES Program Services Compensation Church Programs Church Programs-designated Funds Fellowship-outreach Benevolence-designated funds Building rental Debt Service Depreciation Lawsuit Settlement

Supporting Services: Note H Administrative Personnel

TOTAL UNRESTRICTED EXPENSE

CHANGE IN UNRESTRICTED NET ASSETS

$

TEMPORARILY RESTRICTED NET ASSETS Building offerings Custodial Income Net assets released from restrictions CHANGE IN TEMPORARILY RESTRICTED NET ASSETS

49,358 36,576 (27,176)

$

NET ASSETS BEGINNING OF YEAR NET ASSETS, END OF THE YEAR

40,825 $

58,757 $ 109,132

$

208,713 $

12,778 $

30,079 (10,739)

43,655

2,960 2,683 (10,332)

19,340 $

(4,688)

77,014

38,047

109,132 $

77,014


SANANDO LA TIERRA INTERNACIONAL, INC STATEMENT OF ACTIVITIES (UNAUDITED) CONSOLIDATED - ITERIM FOR THE SIX MONTH ENDING JUNE 30, 2011 2011

UNRESTRICTED NET ASSETS REVENUE Contributions Contributions of investment property Investment Income

$

NET ASSETS RELEASED FROM RESTRICTIONS

138,302 2,473 140,775 31,315

TOTAL UNRESTRICTED REVENUE AND SUPPORT

172,090

UNRESTRICTED EXPENSES Program Services Compensation Church Programs Church Programs-designated Funds Fellowship-outreach Benevolence-designated funds Building rental Debt Service Depreciation

32,715 42,917 23,582

23,523 15,166 137,903

Supporting Services: Note H Administrative Personnel

17,141 9,629 26,770

TOTAL UNRESTRICTED EXPENSE

CHANGE IN UNRESTRICTED NET ASSETS

164,673

$

TEMPORARILY RESTRICTED NET ASSETS Building offerings Custodial Income Net assets released from restrictions CHANGE IN TEMPORARILY RESTRICTED NET ASSETS

49,172 21,997 (31,315)

$

NET ASSETS BEGINNING OF YEAR NET ASSETS, END OF THE YEAR

7,417

39,854 208,713

$

255,984


SANANDO LA TIERRA INTERNACIONAL, INC PRO FORMA STATEMENT OF ACTIVITIES PRJECTIONS (UNAUDITED) CONSOLIDATED - YEARS ENDED DECEMBER 31, 2010, 2009 AND 2008 2015

UNRESTRICTED NET ASSETS REVENUE Contributions Contributions of investment property Investment Income

$

NET ASSETS RELEASED FROM RESTRICTIONS TOTAL UNRESTRICTED REVENUE AND SUPPORT

2014

2013

916,513 $ 2,624 919,137

2012

436,014 $ 2,548 438,561

2011

1,078,252 $ 2,784 1,081,036

1,003,599 $ 2,703 1,006,302

307,253 2,473 309,726

57,024

55,908

54,818

53,752

94,237

1,138,060

1,062,210

973,955

492,314

403,963

213,901 114,726 68,601 2,732 63,422 186,921 53,316 703,619

207,671 111,385 66,603 2,652 61,575 181,477 51,763 683,126

187,423 108,141 95,363 2,575 52,500 181,477 50,255 677,734

67,394 84,844 38,145 1,030 74,703 34,835 300,950

65,431 82,373 37,034 1,000 47,046 30,331 263,215

96,928 20,110 117,038

94,104 19,524 113,629

91,364 18,956 110,319

38,763 18,403 57,167

37,634 17,867 55,502

820,657

796,754

788,053

358,117

318,717

317,403 $

265,455 $

185,901 $

134,197 $

232,215 (57,024)

228,198 (55,908)

41,503 203,864 (54,818)

87,502 172,983 (53,752)

175,191 $

172,290 $

190,549 $

206,733 $

703,423

362,494

208,713

703,423 $

362,494

UNRESTRICTED EXPENSES Program Services Compensation Church Programs Church Programs-designated Funds Fellowship-outreach Benevolence-designated funds Building rental Debt Service Depreciation Lawsuit Settlement

Supporting Services: Note H Administrative Personnel

TOTAL UNRESTRICTED EXPENSE

CHANGE IN UNRESTRICTED NET ASSETS

$

TEMPORARILY RESTRICTED NET ASSETS Building offerings Custodial Income Net assets released from restrictions CHANGE IN TEMPORARILY RESTRICTED NET ASSETS

$

NET ASSETS BEGINNING OF YEAR NET ASSETS, END OF THE YEAR

$

1,517,619

1,079,874

2,010,213 $

1,517,619 $

1,079,874 $

85,246

98,344 64,427 (94,237)

68,535


SANANDO LA TIERRA INTERNACIONAL, INC. NOTES TO FINANCIAL STATEMENTS‐CONTINUED December 31, 2010, 2009 and 2008 Interim June 30, 2011 Pro‐forma Projections; December 31, 2011,2012,2013,2014 and 2015 NOTE A‐ NATURE OF ACTIVITIES AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES NATURE OF ACTIVITIES Iglesia Sanando la Tierra Internacional, Inc (the Church) was organized in 2006 and is a not for profit organization located in Orlando, Florida. The Church is dedicated to establishing and maintaining the public worship of God and to promoting the evangelical faith in accordance with the principle and doctrines of the Holy Scriptures. The Church is supported primarily through contributions from the congregation and provides various programs to its members and the community including Christian education, pastoral counseling, missions and other special programs to the youth and to the community. Revenue Recognition Contributions received are recorded as unrestricted, temporarily unrestricted or permanently restricted support, depending of the existence and/or nature of any donor restrictions. Contributions received with donor‐imposed restrictions that are met in the same year in which contributions are received are classified as unrestricted contributions. All donors –restricted contributions are reported as an increase in temporarily or permanently restricted net assets depending on the nature of the restriction. When a restriction expires, temporarily restricted net assets are reclassified to unrestricted net assets and reported in the statement of activities as net assets released from restrictions. Contributed Services The church receives a substantial amount of services donated by its members in carrying out the church ministry. No amounts have been reflected in the financial statements for those services since they do not meet the criteria for recognition under SFAS No 116, Accounting for Contributions Received and Contributions made.


SANANDO LA TIERRA INTERNACIONAL, INC. NOTES TO FINANCIAL STATEMENTS‐CONTINUED Property and Equipment Property and Equipment acquisitions are recorded at cost or if donated at fair value at the date of the gift. Property and Equipment with a useful life of more than one year and an acquisition cost of $500.00 or more is capitalized, according to its actual accounting policies and procedures. Depreciation is provided over the estimated useful life of each depreciable asset and is computed using straight –line method over the estimated useful life of the equipment. Amortization is included in depreciation and amortization in the financial statements. The estimated useful lives of property and equipment are as follows: Land and improvements 5‐25 years Buildings 25‐40 years Equipment and vehicles 3‐20 years Income Taxes The Church is a not‐for‐profit religious organization exempt from income taxes under the provision of Section 501 © (3) of the Internal Revenue Code; thereto no provision for income taxes has been made in these financial statements. Cash and Cash Equivalent Cash and cash equivalents include all monies in banks and highly liquid investments with maturity dates of less than 12 month. The carrying value of the cash equivalents approximates fair value because of the short maturities. Use of Estimates The preparation of financial statements in conformity with generally accepted accounting principles require management to make estimates and assumption that affect certain reported amounts and disclosures. Accordingly, actual results could differ from those estimates.


SANANDO LA TIERRA INTERNACIONAL, INC. NOTES TO FINANCIAL STATEMENTS‐CONTINUED NOTE B –FIXED ASSETS Depreciation expense was $15,165.65 for the 6 month ended June 30, 2011. Depreciation expense was $30,331 and $28,344 consecutively for the 12 months ended December 31, 2010 and 2009 and $5,707 for the 12 month ended December 31, 2008. NOTE C‐ INTENTIONS TO GIVE This year, the church asks the members of the congregations to submit pledges cards indicating the donations the members intend to give for the construction of the new building during upcoming year. The pledge cards clearly indicate that is to be used for the Church budgetary purpose only and that the members may rescind the pledge at any time. Since the pledges do not meet the criteria for revenue recognition under SFAS No 116 they are not reflected as contributions in the statement of activities until the pledge are collected. NOTE D‐ FUNCTIONAL ALLOCATION OF EXPENSES The costs of providing the various programs and other activities have been summarized on a functional basis in the statement of activities. Accordingly certain cost have been allocated among the programs and supporting services benefited. NOTE E‐LEASE OBLIGATIONS The church has no lease obligations. NOTE F‐CONTRUCTION IN PROGRESS As the church is currently in the planning stages the amount shown in the Construction in Progress represents funds spent on pre construction cost. NOTE G‐ LONG TERM DEBT The church Long Term Debt for the 12 Months ended December 31, 2010 and 2009 is as follows: Note Payable to AG Solutions, bearing interest at 8.25%. The loan is payable in month installments of $4,278.46, principal and interest and is collateralized with a first mortgage


SANANDO LA TIERRA INTERNACIONAL, INC. NOTES TO FINANCIAL STATEMENTS‐CONTINUED to the church property located at 2124 N Dean Road, Orlando, FL 32817 and a certificate of deposit. Note Payable to AG Solutions, bearing interest at 8.25%. The loan is payable in month installments of $240.41, principal and interest. Note Payable to the previous owner of the property, at no interest bearing. The loan is payable in month installments of $2,291.67, principal only and is collateralized with a second mortgage against the church property located at 2124 N Dean Road, Orlando, FL 32817. NOTE H‐ LAWSUIT SETTLEMENT The amount settles for previous unexpired lease term for the church previous leased facility.


APPE ENDIX XES


Questtionn naire


REGIONS BANK BUSINESS / COMMUNITY BANKING

Religious Organization Questionnaire Organization Name: Sanando La Tierra Internacional, Inc.

Year Founded:

Address:

Telephone Number:

2124 N Dean Rd, Orlando, FL 32817

Time in Current Location: Organization Leader:

1 yr. 1/2

Tax ID Number:

Rev Alex Castro

2006 407-737-7771

20-4423342

Years with Organization:

Other Contact(s): 321-297-2726 Attendance information: ( last 3 years )

Since church was founded

Referral Y/N:

Attendance Information: (last 3 years) Year Average Attendance: Primary Services if Appl. Other Services if Appl.

1 2010 300

2 2009 129

3 2008 95 Average Attendance in the most recent year:

Membership: Active Members Non Active Members Total # of Giving Units Seating Capacity

200

75-80

60

170

Number of Services Held

Age Profile 21-29 30-39 40-50 51+ Youth (13-20) Children and Preschool

120 85 60 40 30 30

Weekday Weekend Wednesday 2 on Sunday & Thursday

When was the current membership roll last purged? Selected Financial Information: Operating Budget: Year

1 2010

2 2009

3 2008

Indebtedness: Creditor(s)

AG Financial (1st Mortgage) 204,615 OC Church(2nd Mortgage) 165,648 AG Financial-Unsecured

Total Due

Mo. Pymt.

4,278.46 359,687 Total Operating Revenues: 228,341 2,291.67 Total Operating Expenses: 260,105 196,223 240.41 Discretionary Exp. (included in TOE) 19,924 21,366 2,907 Building Fund Contributions: (not included in Tot. Oper. 49,358 2,960 Revs) If the Organization is part of a national affiliation or denomination, please describe the nature and level of support offered


through this relationship.

Describe all outreach programs, and detail Discretionary Expenses identified above? (examples: childcare, eldercare, community education, thrift store, etc.) Special Events: (Anniversary, Fellowship, Speakers) Children School, Youth Describe the trends in membership. 2010 membership double. Please provide a brief history of the Organization, emphasizing important dates, including those associated with building programs. Daughter church of Iglesia el Calvario (4000 member church). Start stewardship campaign on the 26th of September. Our ministry is to win this generation for Jesus Christ through ministry outside the 4 walls, youth and kids. Briefly describe the nature of the Organization's governance and provide a copy of Organization By-Laws, including those of affiliate organizations. Board of Elders pastoral staff and finally congregation. See bylaws enclosed. Provide a list of those individuals (along with their address and social security number) that are authorized to borrow on behalf of the organization. See list enclosed. Please provide a description of the proposed project, if applicable. 

 

For requests greater than $50,000, please attach detailed Receipts and Disbursements Statements for each of the past three years and a Balance Sheet for the most recent year end. Revenues should be identified as to pledges, plate offerings, events, or other revenues. If the loan request is for construction/mini-perm financing, please attach a detailed breakdown of budgeted construction costs. If a capital campaign has commenced, or is contemplated, and is to serve as a repayment source for the proposed loan, please provide detailed information regarding the campaign (i.e., start date, anticipated duration, how much has been pledged to date, pledges received/paid, pledge amounts by giving unit to identify concentrations) Campaign starts on September 26th, 2010, between leadership and congregation pledges adds to the amount of $369, 406 40.

__________________________________ Signature of Organization Leader

_________________________________ Signature of Business Banker

_______________ Date

______________ Date


SANANDO LA TIERRA INTERNACIONAL, INC. Matrix Table‐ General Assumptions for the Next Five Years 1. Increase 3% Non Discretionary Expenses 2. Day and After School Care 3. Institute FM/Explosive Development. 4. Increase in Attendance w/New Bldg.* 5. Increase of Interest Expense w/New Bldg.** 6. Increase in Pastoral Payroll.

2011

2012

2013

2014

2015

See Appendix

See Appendix

See Appendix

See Appendix

See Appendix

See Appendix

See Appendix

See Appendix

Start by Sept

Start by Sept

7. Add Occupancy expense for 2 new satellite church. 8. Recruit New Pastors.***

Start by January Start by March

Start by March


SANANDO LA TIERRA INTERNACIONAL, INC. Matrix Table‐ General Assumptions for the Next Five Years Notes to the Assumptions:    

*Average Unrestricted Contributions of $907.42 per year per attendant. *Restricted Contributions for Building of $164.52 per year per attendant. *Restricted Custodial Contributions of $121.62 per year per attendant. ** Assume an increase in loan interest rate for the building construction. See proyected amortization Schedule.  ***Increase actual Pastoral team salaries to comparable size churches and adjust the AP Salary to Full time.  *****New Pastors to recruit:  Worship Pastor.  Cells AP Pastor.  Missions AP Pastor.  Youth HTL Kid AP Pastor.


Sanando la Tierra Internacional Depreciation Methods Comparison 7/17/11 Gray cells are calculated for you. You do not need to enter anything in them.

Cost of property Recovery period (years) Declining balance type Declining balance rate Number of months in first year of service Salvage value

$1,200,000 40 200% 0.05 6 $50,000 Sanando la Tierra Internacional CONFIDENTIAL

Year

1 2 3 4 5 6 TOTAL

Straight Line Depreciation per year

Accumulated depreciation

$14,375 $28,750 $28,750 $28,750 $28,750 $1,020,625

$14,375 $43,125 $71,875 $100,625 $129,375 $1,150,000

$1,150,000

Start in October 1, 2012.

Sum-of-Years' Digits Depreciation per year

$28,049 $55,396 $53,994 $52,591 $51,189 $49,787 $291,006

Accumulated depreciation

$28,049 $83,445 $137,439 $190,030 $241,220 $291,006

Declining Balance Depreciation per year

$28,750 $56,063 $53,259 $50,596 $48,067 $913,265 $1,150,000

Accumulated depreciation

$28,750 $84,813 $138,072 $188,668 $236,735 $1,150,000


Loan Amortization Schedule

SANANDO LA TIERRA INTERNACIONAL

Enter values Loan amount $ 1,200,000.00 Annual interest rate Loan period in years Number of payments per year Start date of loan Optional extra payments

$

Total interest

Loan summary $ 9,440.40 360 360 $ $ 2,198,545.75

Principal

Interest

Scheduled payment

8.75 % 30 12 10/1/2012 -

Scheduled number of payments Actual number of payments Total early payments

Lender name: BANK

Pmt No. Payment Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Beginning Balance

11/1/2012 $ 1,200,000.00 12/1/2012 1,199,309.60 1/1/2013 1,198,614.16 2/1/2013 1,197,913.65 3/1/2013 1,197,208.03 4/1/2013 1,196,497.27 5/1/2013 1,195,781.32 6/1/2013 1,195,060.15 7/1/2013 1,194,333.73 8/1/2013 1,193,602.01 9/1/2013 1,192,864.95 10/1/2013 1,192,122.52 11/1/2013 1,191,374.67 12/1/2013 1,190,621.38 1/1/2014 1,189,862.59 2/1/2014 1,189,098.26 3/1/2014 1,188,328.37 4/1/2014 1,187,552.86 5/1/2014 1,186,771.69 6/1/2014 1,185,984.83 7/1/2014 1,185,192.23 8/1/2014 1,184,393.85 9/1/2014 1,183,589.65 10/1/2014 1,182,779.59 11/1/2014 1,181,963.62 12/1/2014 1,181,141.70 1/1/2015 1,180,313.78 2/1/2015 1,179,479.83 3/1/2015 1,178,639.80 4/1/2015 1,177,793.65 5/1/2015 1,176,941.32 6/1/2015 1,176,082.78 7/1/2015 1,175,217.98 8/1/2015 1,174,346.87 9/1/2015 1,173,469.41 10/1/2015 1,172,585.56

Scheduled Payment $

9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40

Extra Payment $

-

Total Payment $

9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40 9,440.40

$

690.40 695.44 700.51 705.62 710.76 715.95 721.17 726.42 731.72 737.06 742.43 747.84 753.30 758.79 764.32 769.90 775.51 781.17 786.86 792.60 798.38 804.20 810.06 815.97 821.92 827.91 833.95 840.03 846.16 852.33 858.54 864.80 871.11 877.46 883.86 890.30

$

8,750.00 8,744.97 8,739.89 8,734.79 8,729.64 8,724.46 8,719.24 8,713.98 8,708.68 8,703.35 8,697.97 8,692.56 8,687.11 8,681.61 8,676.08 8,670.51 8,664.89 8,659.24 8,653.54 8,647.81 8,642.03 8,636.21 8,630.34 8,624.43 8,618.48 8,612.49 8,606.45 8,600.37 8,594.25 8,588.08 8,581.86 8,575.60 8,569.30 8,562.95 8,556.55 8,550.10

Ending Balance $1,199,309.60 1,198,614.16 1,197,913.65 1,197,208.03 1,196,497.27 1,195,781.32 1,195,060.15 1,194,333.73 1,193,602.01 1,192,864.95 1,192,122.52 1,191,374.67 1,190,621.38 1,189,862.59 1,189,098.26 1,188,328.37 1,187,552.86 1,186,771.69 1,185,984.83 1,185,192.23 1,184,393.85 1,183,589.65 1,182,779.59 1,181,963.62 1,181,141.70 1,180,313.78 1,179,479.83 1,178,639.80 1,177,793.65 1,176,941.32 1,176,082.78 1,175,217.98 1,174,346.87 1,173,469.41 1,172,585.56 1,171,695.25

Cumulative Interest $

8,750.00 17,494.97 26,234.86 34,969.65 43,699.29 52,423.75 61,142.99 69,856.97 78,565.65 87,269.00 95,966.97 104,659.53 113,346.64 122,028.25 130,704.34 139,374.84 148,039.74 156,698.98 165,352.52 174,000.33 182,642.35 191,278.56 199,908.90 208,533.33 217,151.82 225,764.31 234,370.77 242,971.14 251,565.39 260,153.47 268,735.33 277,310.93 285,880.23 294,443.18 302,999.73 311,549.83


SANANDO LA TIERRA INTERNACIONAL, INC.

APPENDIX A-PROJECT FOR DAY CARE FACILITY

Prepared by: Franco G Catalรกn, MBA, EA, CGFO For the Administration and Board of Elders www.angelsoforlando.intuitwebsites.com (sample website)


SANANDO LA TIERRA INTERNACIONAL, INC PROJECT DRAFT BUDGET & PROJECTIONS FOR THE NEXT FIVE YEAR ENDING ON DECEMBER 2011 THRU 2015 TABLE OF CONTENT LETTER TO THE ADMINISTRATION AND BOARD OF ELDER PROJECTED SOURCES OF REVENUES UNRESTRICTED PUBLIC SUPPORT RESTRICTED PUBLIC SUPPORT CONTRIBUTIONS AND DONATIONS DEPARTMENT OF FAMILY AND CHILDREN UNITED WAY OTHER INCOME ASSUMPTION FOR EXPENSES SLARIES AND WAGES PARENT AND PROVIDER ASSISTANCE OCCUPANCY PROFESSIONAL FEES MIS SUPPLIES IN KIND EXPENSES PRINTING AND PUBLICATIONS STAFF DEVELOPMENT AND TRAINNING POSTAGE & SHIPPING


TABLE OF CONTENT

DUES SUSCRIPTIONS AND ADVERTISING EQUIPMENT RENT & REPAIRS INSURANCE TRAVEL, LODGING AND MEALS OTHER EXPENSES START UP COST AND AMORTIZATION SUBCONTRACTOR DEPRECIATION DEBT SERVICE PROJECTED INCOME AND EXPENSE STATEMENT MANAGEMENT RECOMMENDATION APPENDIXES FROM DEPARTMENT OF CHILDREN AND FAMILIES APPENDIX A: FLORIDA ADMINISTRATIVE CODE. APPENDIX B: ADDITIONAL QUALITY INDICATORS APPENDIX C: APPLICATION FOR A LICENSE TO OPERATE A CHILD CARE FACILITY/ FORM CF-FSP 5017 APPENDIX D: DIRECTOR CREDENTIAL AND RENEWAL APPENDIX E: ADDITIONAL QUALITY INDICATORS APPENDIX F: TWO CLOSEST COMPETITORS APPENDIXES FROM DEPARTMENT OF FOOD AND DRUG ADMINISTRATION APPENDIXES FROM AVAILABLE MARKET SOFTWARE FOR DAILY CARE MANAGEMENT


OBJECTIVES FOR THE PROJECT Community and Economic Development This project has two main objectives, first partnering the community we serve

assisting with their children care under a loving and Christian atmosphere and second of all is the job creation part. We believe the jobs creation will serve to facilitate the economic stability and assistance to needy family.

PROJECTED SOURCES OF REVENUES Unrestricted & Restricted Public Support This represents the fees charged as fees for daily care of the children which are not constraint to any specific use on the facility. The collections may be used to pay any of the operational cost of the facility. The estimated percentage for public support is as follows:

Sponsors

2011

2012

2013

2014

2015

Public

60%

40%

30%

20%

20%

4-C

40%

40%

40%

40%

50%

20%

20%

25%

25%

United Way

5%

5%

5%

Grants

5%

5%

0%

5%

0%

100%

100%

Head Start

Debts Total

100%

100%

100%


Based on the conversations with the management and the general pastors they anticipated that the daily and after school care facility will use approximately 1,200 square feet of living space from the building for this activity.

The fees anticipated for the daily and after school facility are as follows:

Clients

Age

Fees

Estimate

Estimate

Estimate per

per

of Clients

Monthly

Year

Clients Infants

1-12 Mth

$199

3

$ 2.388

$ 28,656

Toddlers

12-24 Mth $150

3

$ 1,800

$ 21,600

Children

2 years

$125

6

$ 3,000

$ 36,000

Children

3 years

$105

6

$ 2,520

$ 30,240

Children

4 years

$95

6

$ 2,280

$ 27,360

Children

5 years

$85

6

$ 2,040

$ 24,480

$75

10

$ 3,000

$ 36,000

30

$17,028

$204,336

After School Totals

Two additional assumptions for the planning for these activities: first of all is that we assume an increase of 3% at least annually from base year starting on 2013 for Public Support and second of all we are assuming that subsidized activities allocation will increase each year through the department of family and children (DFC).


EXPENSES Salaries and Wages This section covers the expected staff using the same model provided by DCF on their website as shown on the table below: Positions

Wages

Weekly

Monthly

Yearly

Manager/Teacher

$400

$1.733

$20,796

Teacher # 1

$320

$1,387

$16,644

Teacher # 2

$290

$1,257

$15,084

Teacher # 3

$270

$1,170

$14,040

Aides (3)

$612

$2,652

$31,824

Aide (1)

$204

$884

$10,608

The table below shows the estimated cost for next five years:

Position

2011

2012

2013

2014

2015

Manager/Teacher $20,796

$21,420

$22,062

$22,724

$23,406

Teacher # 1

$16,644

$17,143

$17,658

$18,187

$18,773

Teacher # 2

$15,084

$15,537

$16,003

$16,483

$16,977

Teacher # 3

$14,040

$14,461

$14,895

$15,342

$15,802

Aides

$21,216

$21,853

$30,071

$30,911

$31,838

Total Wages

$87,790

$90,423

$100,689

$103,647

$106,796

Benefits

$3,512

$3,617

$4,028

$4,146

$4,272

Payroll Taxes

$11,851

$12,207

$13,593

$13,992

$14,417

$103,153

$106,247

$118,310

$121,785

$125,485

Total Wages,

benefits & taxes


Parent and Providers Assistance This may be used for reimbursements to parents and providers for products provided for the general use of the care facility.

Occupancy This category use estimates based on the following actual square feet expenses for the occupancy applied to the expected use of 1,200 sf:

AVG

2011

2012

2013

2014

2015

MTH BLDG & GROUND MAINT Mortgage

$6,646

Security Alarm

$36

Cleaning Supplies

$24

Pest Control

$54

Grounds Maint.

$71

UTILITIES Telephone\Internet $269

Electricity

$502

Water

$109

Waste

$97

Total

$26,847 $27,652 $28,482 $29,336 $30,217

Church Square Ft

4,188

Cost per Square Ft

$1.86


Professional Fees Under this category fall any special assignments that may be need such as legal and accounting fees for contract reviewed and letters needed or opinions for this activity.

MIS Our actual church management software do not have capabilities for the management of a Daily Care Facility, therefore we includes as an Appendix 3 options to open the discussion over this area.

In Kind Expenses. Usually this category is used for labor expenses as matching requirements for the grants.

Printing and Publications. The amount on this category is assumed as ½ of 1% of the revenues for each of the five years.


Staff Development & Training. This category is mostly driven by DCF requirements for the staff. We assumed To be as much as 1% of the total salaries and benefits.

Postage & Shipping A minimum amount was assigned to allow the management to keep a good communication at all times.

Dues, subscription and Advertising. Keep insight from professional organization that enhances the services and exposure of the care facility is necessary to maintain growth and stability. A minimum amount is assigned for that purpose.

Equipment Rent and Repairs. Keep the necessary equipment and maintain its conditions are essential for the operation of the daily care facility.


Insurance. This category is essential to the protection of the project and the church and consists of an estimate increase of the liability insurance due to the increase of the exposure.

Travel, lodging and Meals. Although this category is frozen for now it was keep open for future assistance to the National Industry Forum sponsor by professional organization on the Industry. For now we recommended assistance to local activities only.

Other Expenses. Startup cost. The actual information highlight an investment of tiles and other necessary

investments to be made necessary to relocate the kitchen and condition the space for the children

Subcontractor. This category was mainly projected to provide security to the children and a cost of $500.00 per month was assumed for that purpose.


Depreciation. The amount estimated for new equipment’s, including a playground and materials which aggregated value is $500.00 or more is $5,000.00 It is assumed to be usable for five years and to be charged a usage fee also known as depreciation of the equipment $1,000.00 per year.

Debt Service. This option is kept open to be used when working capital is needed.


Casa de Adoracion Sanando la Tierra Day & After School Care Projected Income and Expense Statement For the twelve month ending YTD 31-Dec-11 INCOME REVENUE Public Support Revenue and Other Support: Unrestricted Public Support $ Total Unrestricted Income Restricted Public Support Contributions Department of Family and Children Head Start ( Dept of Education) United Way Grants Net assets released from Restrictions Total Public Support, Rev & Other

30,650 $ 30,650

81,734 $ 81,734

20,434

81,734 40,867

20,434

$

EXPENSES SALARIES & WAGES Salaries and Wages Employee Benefits Payroll Taxes Total Salaries Expenses GENERAL & ADMINISTRATIVE EXPENSES Parent and provider assistance Occupancy Professional Fees MIS Expense Supplies In Kind Expenses Printing and Publications Staff Development,training and meetings Postage & Shipping Dues, subscriptions and advertising Equipment, Rent & Repairs Insurance Travel, lodging and meals Other Expenses Subcontractor Depreciation Debt Service TOTAL GEN & ADMIN EXPENSES TOTAL PROGRAM EXPENSES TRANSFERS Transfers from General Fund Transfers to General Fund Total Transfers INCOME ADDED VALUE

YTD 31-Dec-13

$

YTD 31-Dec-14

63,140 $ 63,140

YTD 31-Dec-15

43,319 $ 43,319

81,734 51,084 10,217 10,217

44,545 44,545

122,602

81,734 40,867 10,217 10,217 143,035

153,252

102,168 51,084 10,217 163,469

-

-

10,217 10,217

-

-

Other Income Interest Income Debts Proceeds Total Other Income TOTAL INCOME

YTD 31-Dec-12

51,084 $

204,336 $

206,175 $

206,788 $

208,014

21,948 878 2,963 25,788

90,423 3,617 12,207 106,247

100,689 4,028 13,593 118,310

103,647 4,146 13,992 121,785

106,796 4,272 14,417 125,485

100 4,464 600 1,895 3,940 64 258 400 300 200 1,500 600 1,500 250 16,071

100 18,392 600 200 15,760 255 1,062 412 309 206 6,000 600 6,000 1,000 50,896

100 18,943 600 200 15,902 263 1,183 424 318 212 6,180 600 6,000 1,000 51,926

100 19,512 600 200 15,949 271 1,218 437 328 219 6,365 600 6,000 1,000 3,567 56,366

100 20,097 600 200 16,044 279 1,255 450 338 225 6,556 600 6,000 1,000 3,567 57,311

41,859

157,143

170,235

178,151

182,796

-

-

-

-

-

9,225 $

47,193 $

UNAUDITED

35,940 $

28,637 $

25,218


SANAN NDO LA A TIERRA INTTERNAC CIONA AL, INC..

AP PPENDIX B‐PROJECT FOR D DESARROLLO EXPLLOSIVO E INSTITUTO Prepared by: Fran nco G Cataláán, MBA, EA A, CGFO For the Adminisstration and d Board of Ellders


SANANDO LA TIERRA INTERNACIONAL, INC PROJECT DRAFT BUDGET & PROJECTIONS FOR THE NEXT FIVE YEAR ENDING ON DECEMBER 2011 THRU 2015 TABLE OF CONTENT LETTER TO THE ADMINISTRATION AND BOARD OF ELDER PROJECTED SOURCES OF REVENUES UNRESTRICTED PUBLIC SUPPORT RESTRICTED PUBLIC SUPPORT CONTRIBUTIONS AND DONATIONS OTHER INCOME ASSUMPTION FOR EXPENSES OCCUPANCY PROFESSIONAL FEES MIS SUPPLIES IN KIND EXPENSES PRINTING AND PUBLICATIONS STAFF DEVELOPMENT AND TRAINNING POSTAGE & SHIPPING


TABLE OF CONTENT DUES SUSCRIPTIONS AND ADVERTISING EQUIPMENT RENT & REPAIRS INSURANCE TRAVEL, LODGING AND MEALS OTHER EXPENSES START UP COST AND AMORTIZATION SUBCONTRACTOR DEPRECIATION DEBT SERVICE PROJECTED INCOME AND EXPENSE STATEMENT MANAGEMENT RECOMMENDATION


OB BJECTIV VES FO OR THEE PROJJECT Church h Goverrnance and Faith Devvelopmeent These projects has few main n objectivees; one is tto provide the development an nd opportun nity to ourr memberss and the ccommunityy we servee with the word of th he Holy Spirrit and with h teachings under a fformal currriculum th hat allows all membe ers and the neighborh hood to developed their poteential and d allow us the church governan nce to properly ordaain those that would d serve as pastors an nd leaders in our churcch and in ssatellites afffiliates. These projects also o serve as tthe bridgee for jobs ccreation ass future paastors will b be working w with our organization.

PRO OJECTTED SO OURCES OF R REVEN NUES Unresttricted & Restricted P Public SSupportt This represents the e tuition an nd applicattion fees charged forr the studeents who w will be atten nding to the three year Instiitute scho ool and th he membeers who are currentlyy assisting to the acctual 7 weeeks institu ute called “Desarollo o Explosivo” and for the Institutte FM proje ected. Thee collection ns may be used to paay any of the operation nal cost off the existin ng and new w facility. The estim mated perccentage for public suupport is ass follows:


Sponssors

2011

2012

2013

2014

2015

Publicc

100%

100%

955%

95%

95%

Grantts

55%

5%

5%

Tottal

100%

100%

1000%

100%

100% %

Based on the convversations with the managem ment, general pasto ors and o our person nal observation ns we anticcipated thaat both Insstitute’s w will use app proximately 2,000 sq quare feet of livving space e from the building fo or this activvity most likely for tw wo day of tthe week. The fees anticipated ffor the dailly and afte er school faacility are aas follows: Clien nts

Applicattion Tuition

Estim mate

Esstimate Estimate p per

Feess

Fee es

Stud dents

M Monthly

Year

$10

$1 10

330

$$ 1,167

$ 14,000 0

$50

$6 60

225

$$ 2,292

$ 27,500 0

Deesarollo Explosivo Gro oups I, II, IIII, IV Insstituto‐FM Totals

555

$$ 3,458 $ 41,500 0


PRO OJECTTED USSES OFF FUND DS EXP PENSEES Salarie es and W Wages Both Insttitutes courses are to ough by vo oluntary insstructors aat least for the next five yearss.

Memb bers Asssistance e This mayy be used fo or reimburrsements ffrom members and p providers fo or productts provided for the ge eneral use of the Insttitute.

Occup pancy This category use e estimates b based on thhe followin ng actual ssquare feett expensess for the occcupancy aapplied to the expectted use of 2,000 sf:

AVG

201 11

20112

20113

201 14

201 15

MTTH BLDG & GROUND MA AINT

Morttgage

$6,646

Securrity Alarm

$ 36

Clean ning Supplies

$ 24

Pest Control

$ 54

Grounds Maintt.

$ 71

U UTILITIES


Telep phone\Inte ernet $ 2 269

Electricity

$ 5 502

Wate er

$ 1 109

Wastte

$ 97

Total

$7,808 $11,904 $12,261 $12,629 $13,008 $13,398

Churcch Square Ft

4,188

Cost per Square e Ft

$1.86

Pro ofessional Fee es Und der this cattegory fall any speciaal assignmeents that m may be neeed such as legal and d accountin ng fees forr contract reviewed and letterrs needed or opinion ns for this activity.

MIIS Ourr actual ch hurch man nagement software do not h have capabilities for the man nagement of a Dailyy Care Facility, therefore we in ncludes as an Appen ndix 3 options to ope en the disccussion ove er this areaa.

In Kind Exxpensess. Usu ually this caategory is u used for labor expennses as mattching requirements for the grants.


Priinting a and Pub blication ns. The e amount o on this cate egory is asssumed as ½ ½ of 1% off the reven nues for each of the five years.

Sta aff Deve elopme ent & Trraining.. Thiss category is mostly d driven by D DCF requireements for the staff.. We assum med To b be as much h as 1% of he total sasalaries andd benefits..

Po ostage & & Shipp ping A m minimum am mount wass assigned to allow the manageement to kkeep a goo od com mmunicatio on at all tim mes.

Du ues, sub bscriptio on and Adverttising. Kee ep insight from professional orgganization that enhances the seervices and d exposure of th he care faccility is neccessary to m maintain ggrowth and d stability. A min nimum amo ount is assigned for tthat purpo ose.


Equipmen nt Rent and Re epairs. Kee ep the nece essary equipment and maintainn its condittions are eessential fo or the ope eration of tthe daily caare facility.

Inssurance e. Thiss category is essential to the p protection of the pro oject and tthe church h and consists of an estimate increase of the liability insuran nce due to the increaase of the exposure.

Tra avel, lodging aand Meaals. Alth hough this category iis frozen fo or now it w was keep o open for fu uture assisttance to the t Nation nal Industrry Forum sponsor s byy professio onal organ nization on n the Indu ustry. For now we re ecommend ded assistaance to loccal activitiees only.

Other Exp penses. Subcontra actor. Non ne subconttractor at tthis point.


De epreciattion. The e amount estimated e for new equipment e t’s, includiing softwaare, audiovvisual and d materials which agggregated value is $5000.00 or more is $5,0 000.00 It iss assumed to be usaable for fivve years and to be ccharged a usage feee also kno own as dep preciation o of the equiipment $1,000.00 peer year.

De ebt Servvice. Thiss option is not contem mplated att this time for this prroject.


Casa de Adoracion Sanando la Tierra Desarrollo Explosivo & Institute FM Projected Income and Expense Statement For the twelve month ending YTD 31-Dec-11 INCOME REVENUE Public Support Revenue and Other Support: Unrestricted Public Support $ Total Unrestricted Income Restricted Public Support Contributions Grants Net assets released from Restrictions Total Public Support, Rev & Other Other Income Interest Income Debts Proceeds Total Other Income TOTAL INCOME

10,375 $ 10,375

GENERAL & ADMINISTRATIVE EXPENSES Members and provider assistance Occupancy Professional Fees MIS Expense Supplies In Kind Expenses Printing and Publications Staff Development,training and meetings Postage & Shipping Dues, subscriptions and advertising Equipment, Rent & Repairs Insurance Travel, lodging and meals Other Expenses Subcontractor Depreciation Debt Service TOTAL GEN & ADMIN EXPENSES TOTAL PROGRAM EXPENSES TRANSFERS Transfers from General Fund Transfers to General Fund Total Transfers $

41,500 $ 41,500

YTD 31-Dec-14

39,425 $ 39,425

-

-

-

2,075 2,075

-

-

$

YTD 31-Dec-13

-

-

EXPENSES SALARIES & WAGES Salaries and Wages Employee Benefits Payroll Taxes Total Salaries Expenses

INCOME ADDED VALUE

YTD 31-Dec-12

10,375 $

41,500 $

41,500 $

YTD 31-Dec-15

39,425 $ 39,425

2,075

39,425 39,425

2,075

2,075 2,075

-

-

41,500 $

41,500

-

-

-

-

-

100 2,976 400 1,500 100 13 400 300 200 267 600 250 7,106

100 12,261 400 200 415 255 412 309 206 1,069 600 1,000 17,227

100 12,629 400 200 427 263 424 318 212 1,101 600 1,000 17,675

100 13,008 400 200 440 271 437 328 219 1,134 600 1,000 18,136

100 13,398 400 200 453 279 450 338 225 1,168 600 1,000 18,611

7,106

17,227

17,675

18,136

18,611

-

-

-

-

-

3,269 $

24,273 $

23,825 $

UNAUDITED

23,364 $

22,889


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.