{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Financial Application","Project Budget"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Financial Application","index":0,"n_rows":123,"n_cols":14,"rows_kept":123,"cut":false,"hidden":false,"merged":[[3,12,3,14],[2,8,2,14],[55,5,55,12],[26,5,26,6],[27,5,27,6],[30,5,30,6],[52,5,52,11],[32,11,33,12],[37,5,37,13],[29,5,29,6],[29,7,29,9],[27,11,27,12],[38,5,44,14],[10,7,10,14],[7,5,7,14],[51,12,52,14],[14,7,14,14],[15,7,15,14],[12,7,12,14],[21,5,21,6],[25,7,25,9],[31,7,31,9],[30,13,30,14],[25,13,25,14],[111,5,111,14],[98,5,98,12],[101,5,101,6],[110,5,110,14],[99,5,99,14],[109,6,109,13],[1,12,1,14],[80,5,80,12],[56,5,56,14],[95,5,95,11],[94,12,95,14],[92,5,94,8],[1,5,3,7],[47,5,51,7],[4,5,4,14],[8,7,8,8],[5,5,5,14],[32,13,33,14],[34,7,34,9],[35,13,35,14],[17,7,17,10],[27,7,27,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Version: v13_20250707"]
[null,null,null,null,null,null,null,null,"Please be sure to use the updated version from CCSI webpage"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"FINANCIAL APPLICATION-PARISH"]
[]
[null,null,null,null,null,"GENERAL INFORMATION"]
[null,null,null,null,null,"Directions: Enter general contact information as well as the financial information requested below.  Be sure to include a current Balance Sheet and Income Statement when submitting this application."]
[null,null,null,null,null,null,"Date:"]
[]
[null,null,null,null,null,null,"Parish Name:"]
[]
[null,null,null,null,null,null,"Pastor:"]
[]
[null,null,null,null,null,null,"Parish Address:"]
[]
[]
[null,null,null,null,null,null,"Telephone number:"]
[]
[null,null,null,null,null,"SELECTED FINANCIAL INFORMATION"]
[]
[null,null,null,null,null,"Most Recent Closed Fiscal Year:"]
[]
[]
[null,null,null,null,null,"Current Cash Balances"]
[null,null,null,null,null,null,"Operating Accounts",null,null,null,null,null,"Capital Reserve Account"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(for building manitenance)"]
[null,null,null,null,null,"Savings Accounts"]
[]
[null,null,null,null,null,"Other Liabilities",null,0,null,null,null,"Capital Campaign"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Goal"]
[null,null,null,null,null,null,"(3 months Operating Expenses)",{"$f":"(((SUM(G77:I77)/3)/12*3))","v":0}]
[null,null,null,null,null,null,"(automatic calculation after entries below)",null,null,null,null,"Total Pledges to Date"]
[]
[null,null,null,null,null,null,"Cash Available for the Project",{"$f":"SUM(H26+H28+H30+H32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Collected to Date"]
[]
[null,null,null,null,null,"PROJECT DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H11","v":0}]
[null,null,null,null,null,"FINANCIAL APPLICATION-PARISH"]
[]
[]
[null,null,null,null,null,"SIX YEAR FINANCIAL PLAN"]
[null,null,null,null,null,"Directions: Input data for Revenue and Expenses for the two most recent closed fiscal years (under red headings) and then input data projections for the next 6 years (under blue headings)."]
[null,null,null,null,null,null,{"$f":"G113","v":"FY21/22"},{"$f":"H113","v":"FY22/23"},{"$f":"I113","v":"FY23/24"},{"$f":"J113","v":"FY24/25"},"FY25/26","FY26/27","FY27/28","FY28/29"]
[null,null,null,null,null,"Revenue"]
[null,null,null,null,null,"  Offertory"]
[null,null,null,null,null,"Capital Campaign"]
[null,null,null,null,null,"  Fund Drives"]
[null,null,null,null,null,"  Donations"]
[null,null,null,null,null,"  Other"]
[null,null,null,null,null,"Total Revenue",{"$f":"SUM(G60:G64)","v":0},{"$f":"SUM(H60:H64)","v":0},{"$f":"SUM(I60:I64)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,"Expenses"]
[null,null,null,null,null,"  Liturgy"]
[null,null,null,null,null,"  Religious Ed"]
[null,null,null,null,null,"  Admin & Gen"]
[null,null,null,null,null,"  Plant"]
[null,null,null,null,null,"  Rectory"]
[null,null,null,null,null,"  Arch Assessment"]
[null,null,null,null,null,"  School Subsidies"]
[null,null,null,null,null,"  Capital Expense"]
[null,null,null,null,null,"  Other"]
[null,null,null,null,null,"(Total Expenses)",{"$f":"SUM(G68:G76)*-1","v":0},0,0,0,0,0,0,{"$f":"SUM(N68:N76)*-1","v":0}]
[null,null,null,null,null,"NET OPERATING INCOME",{"$f":"G65-ABS(G77)","v":0},{"$f":"H65-ABS(H77)","v":0},{"$f":"I65-ABS(I77)","v":0},{"$f":"J65-ABS(J77)","v":0},{"$f":"K65-ABS(K77)","v":0},0,0,{"$f":"N65-ABS(N77)","v":0}]
[]
[null,null,null,null,null,"THIS SECTION TO BE COMPLETED BY THE ARCHDIOCESE OF ATLANTA"]
[]
[null,null,null,null,null,null,{"$f":"G113","v":"FY21/22"},{"$f":"H113","v":"FY22/23"},{"$f":"I113","v":"FY23/24"},"FY24/25","FY25/26","FY26/27","FY27/28","FY28/29"]
[null,null,null,null,null,"Debt Service"]
[null,null,null,null,null,"Bridge Loan (P&I)"]
[null,null,null,null,null,"Long Term Loan (P&I)"]
[null,null,null,null,null,"Total Debt Service",{"$f":"SUM(G84:G85)","v":0},{"$f":"SUM(H84:H85)","v":0},{"$f":"SUM(I84:I85)","v":0},0,0,0,0,0]
[null,null,null,null,null,"NET INCOME",{"$f":"G78-G86","v":0},0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H11","v":0}]
[null,null,null,null,null,"FINANCIAL APPLICATION-PARISH"]
[]
[]
[null,null,null,null,null,"SIX YEAR FINANCIAL PLAN - Continued"]
[null,null,null,null,null,"THIS SECTION TO BE COMPLETED BY THE ARCHDIOCESE OF ATLANTA"]
[null,null,null,null,null,null,{"$f":"G113","v":"FY21/22"},{"$f":"H113","v":"FY22/23"},{"$f":"I113","v":"FY23/24"},"FY24/25","FY25/26","FY26/27","FY27/28","FY28/29"]
[null,null,null,null,null,"Non-Operating Revenue & Expenses"]
[null,null,null,null,null,"Proceeds of Borrowing "]
[null,null,null,null,null,"Bridge Borrowing"]
[null,null,null,null,null,"(Construction Expenses)"]
[null,null,null,null,null,"(Real Property Expenses)"]
[null,null,null,null,null,"(Other Expenses)"]
[null,null,null,null,null,"Total Non-Operating R&E",{"$f":"SUM(G103:G107)","v":0},{"$f":"SUM(H103:H107)","v":0},{"$f":"SUM(I103:I107)","v":0},0,0,0,0,0]
[null,null,null,null,null,"NET CASH FLOW",{"$f":"G87+G108","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,"*All Expenses must be entered as a negative number using parentheses"]
[]
[null,null,null,null,null,"Directions:  \n1.  Input Cash at the End of Year for the Most Recent Closed Fiscal Year Only (outlined in red).  \n2.  Input number of parish families for the two most recent closed fiscal years (under red headings) and then input family data projections for the next 6 years (under blue headings).                                                                                                                                                                                                                                                                                                    3.  Input number of GA Bulletin Receipients and number of Archdiocese Annual Appeal Donors in the same manner."]
[null,null,null,null,null,null,"FY21/22","FY22/23","FY23/24","FY24/25","FY25/26","FY26/27","FY27/28","FY28/29"]
[null,null,null,null,null,"Miscellaneous"]
[null,null,null,null,null,"Cash Beginning of Year ",null,null,{"$f":"H117","v":0},0,0,0,0,0]
[null,null,null,null,null,"Net Cash Flow",null,null,{"$f":"I109","v":0},0,0,0,0,0]
[null,null,null,null,null,"CASH END OF YEAR",null,null,{"$f":"SUM(I115:I116)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,"Number of Families"]
[null,null,null,null,null,"Avg Annual Offertory/Family",{"$f":"IFERROR(SUM(G60/G119),0)","v":0},{"$f":"IFERROR(H60/H119,0)","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,null,"# of GA Bulletin Recipients"]
[null,null,null,null,null,"# of AAA Donors"]

{"sheet":"Project Budget","index":1,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,9,42,10],[44,9,44,10],[46,9,46,10],[49,9,49,10],[50,5,50,14],[42,14,44,14],[42,13,44,13],[39,13,41,13],[39,14,41,14],[40,9,40,10],[20,6,20,9],[21,6,21,9],[22,6,22,9],[23,6,23,9],[24,6,24,9],[25,6,25,9],[35,5,35,13],[36,9,36,10],[37,12,38,13],[37,14,38,14],[38,9,38,10],[19,6,19,9],[3,12,4,14],[7,5,7,12],[10,5,10,12],[18,6,18,9],[1,5,3,7]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Financial Application'!H11","v":0}]
[null,null,null,null,null,"CONSTRUCTION COSTS-PARISH"]
[]
[]
[null,null,null,null,null,"STATUS OF SUBMISSION"]
[null,null,null,null,null,"Check One:"]
[]
[null,null,null,null,null,"SUMMARY OF HARD AND SOFT CONSTRUCTION COSTS"]
[]
[null,null,null,null,null,"Gross Building Size",null,"sf",null,null,"Worship Center Seating"]
[]
[null,null,null,null,null,"Usable Building Size",null,"sf",null,null,"Parking Spaces"]
[]
[]
[null,null,null,null,null,null,null,null,"Soft Construction Costs",null,"%","Cost","Cost/SF"]
[null,null,null,null,null,null,"Architect/Engineering Fees",null,null,null,{"$f":"IFERROR(SUM(L19/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L19/G13),0)","v":0}]
[null,null,null,null,null,null,"Consulting Fees",null,null,null,{"$f":"IFERROR(SUM(L20/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L20/G13),0)","v":0}]
[null,null,null,null,null,null,"CCSI Program Management Fee",null,null,null,{"$f":"IFERROR(SUM(L21/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L21/G13),0)","v":0}]
[null,null,null,null,null,null,"Permits and Impact Fees",null,null,null,{"$f":"IFERROR(SUM(L22/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L22/G13),0)","v":0}]
[null,null,null,null,null,null,"Geotechnical & Testing",null,null,null,{"$f":"IFERROR(SUM(L23/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L23/G13),0)","v":0}]
[null,null,null,null,null,null,"Furniture, Fixture and Equipment",null,null,null,{"$f":"IFERROR(SUM(L24/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L24/G13),0)","v":0}]
[null,null,null,null,null,null,"Owner Furnished Systems",null,null,null,{"$f":"IFERROR(SUM(L25/L33),0)","v":0},null,{"$f":"IFERROR(SUM(L25/G13),0)","v":0}]
[null,null,null,null,null,null,"Moving, Phasing, Temporary Costs",null,null,null,{"$f":"IFERROR(SUM(L26/L27),0)","v":0},null,{"$f":"IFERROR(SUM(L26/G13),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Soft Construction Costs",{"$f":"SUM(K19:K26)","v":0},{"$f":"SUM(L19:L26)","v":0},{"$f":"SUM(M19:M26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total Hard Construction Costs",null,null,{"$f":"IFERROR(SUM(L29/G13),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Overall Construction Contingency @",{"$f":"IFERROR(SUM(L31/L29), 0)","v":0},null,{"$f":"IFERROR(SUM(L31/G13),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL CONSTRUCTION COSTS",null,{"$f":"L27+L29+L31","v":0},{"$f":"M27+M29+M31","v":0}]
[]
[]
[null,null,null,null,null,"PROJECT FINANCING"]
[null,null,null,null,null,null,null,"Total project estimated cost",null,{"$f":"L33","v":0},null,null,null,"Interest Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Time Period(months)"]
[null,null,null,null,null,null,null,"(Spent to Date)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Payment",{"$f":"IFERROR(-PMT(O37/12,O38,J47),0)","v":0}]
[null,null,null,null,null,null,null,"(Funds Available for the Project)",null,{"$f":"'Financial Application'!H35","v":0}]
[]
[null,null,null,null,null,null,null,"Financing Need",null,{"$f":"J37-J39-J41","v":0},null,null,null,"Annual Payment",{"$f":"SUM(O40*12)","v":0}]
[]
[null,null,null,null,null,null,null,"(Uncollected capital campaign pledges)",null,{"$f":"'Financial Application'!N33-'Financial Application'!N36","v":0}]
[]
[null,null,null,null,null,null,null,"Loan Request ",null,{"$f":"IF((J43-J45)<0,\"0\",(J43-J45))","v":0}]
[]
[null,null,null,null,null,"Additional Finance Information"]
[null,null,null,null,null,null,null,"Average total revenue per year during loan term",null,{"$f":"SUM('Financial Application'!I65:N65)/6","v":0}]