DIVINE MERCY CONSTRUCTION PROJECT SPREADSHEET
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBEBFBGBHBKBLBMBNBOBP
1
DIVINE MERCY BUILDING PROJECT FINANCESFisc Yrs. '01-'04Hurr. Katrina<-----mergerTOTALS% of Budg. amt.BUDGET
2
Quarter ending06-30-0409-30-0412-31-0403-31-0506-30-0509-30-0512-31-0503-31-0606-30-0609-30-0612-31-0603-31-0706-30-0709-30-0712-31-0703-31-0806-30-0809-30-0812-31-0803-31-0906-30-0909-30-0912-31-0903-31-1006-30-1009-30-1012-31-1003-31-1106-30-1109-30-1112-31-1103-31-1206-30-1209-30-1212-31-1203-31-1306-30-1309-30-1312-31-1303-31-1406-30-1409-30-1412-31-1403-31-1506-30-1509-30-1512-31-1503-31-1606-30-1609-30-1612-31-1603-31-17(to date)
3
Expense
4
SEAS Building Campaign Expense5,250.002,360.672,789.0810,750.00750.0021,899.75100.00%21,899.75
5
SEAS Architect7,807.4410,932.8129,201.1046,119.0841,633.5011,398.8025,951.55173,044.28100.00%173,044.28
6
7
129-28DM Building Campaign Expense3,000.0032,793.4737,032.2212,557.5697.153,202.7588,683.1598.54%90,000.00
8
9
Phase I
10
171-08Phase I Builder's Risk Insurance238.00334.04572.04
11
171-09Phase I Building Permits0.000.00%50,000.00
12
171-10Phase I Construction357,627.501,318,710.582,346,422.432,215,515.051,394,375.04612,950.08991,198.70453,298.5643,665.0060,637.869,794,400.80114.76%8,535,000.00* Phase I includes Divine Mercy Church and the Parish Community Center. The church was dedicated on November 16, 2013. A donated rectory was also built in Phase I. In July, 2013, the Archdiocese agreed to add $1.1 million to the original Phase I budget shown here in order for the Parish Community Center to be built. The PCC was completed in the summer of 2014.
13
171-11Phase I Architect29,292.5073,009.45133,800.35242,848.0889,395.0865,798.34116,984.54-5,513.893,044.63748,659.08110.98%674,578.00
14
171-12Phase I Building Office Fee (1%)86,883.00784.5087,667.50102.72%85,350.00
15
171-13Phase I Pile Test25,700.00290.0025,990.00103.96%25,000.00
16
171-14Phase I Test Lab Services14,600.007,000.0018,409.702,374.5010,825.258,914.754,827.63514.005,647.96974.0074,087.79211.68%35,000.00
17
171-15Phase I Test and Balance14,700.0014,700.0073.50%20,000.00
18
171-16Phase I Landscaping83,734.5983,734.5941.87%200,000.00
19
171-17Phase I Fill3,300.001,150.004,250.00183,271.3042,789.501,242.31566,100.00158,782.5078,492.50290.40290.40108,350.7323,145.53380,315.8988,013.725,445.00500.00250.001,645,979.78102.38%1,607,749.00
20
171-18Phase I Liturgical Consultant960.00375.00200.00250.00134.101,919.10100.00%1,919.10
21
171-19Phase I Acoustical Engineer22,720.009,280.0032,000.00
22
172-11Phase I Church Pews46,612.93113,319.18159,932.1191.39%175,000.00
23
172-12Phase I Other Furnishings640.0024,244.0038,183.5158,093.00208,545.5728,993.9617,809.05376,509.09251.01%150,000.00
24
172-13Phase I Organ51,840.0031,104.0020,736.00103,680.00103.68%100,000.00
25
$13,149,831.88112.78%$11,659,596.10PHASE I TOTAL* (original budget amt. given here does not include 5% conting., nor the $1.1 million added to the budget by the Archdiocese in 7/13.
26
Phase II
27
171-20Phase II Construction3,438.003,438.000.03%13,149,640.00Phase II includes education facilities for parish and school. Permission was given for Phase II construction to take place once the post-Phase I debt principal is brought down to $3,700,000 (plus any other sources of anticipated funding). While interest began to accrue on the total debt beginning 1/1/2014, until Phase II begins, for the purpose of arriving at the $3.7 million benchmark, all payments on the loan are deducted from the principal only.
28
171-21Phase II Architect8,837.5043,350.00158,958.28211,145.7821.49%982,403.50
29
171-22Phase II Building Office Fee (1%) 0.000.00%131,496.40
30
171-23Phase II Test Lab Services2,957.5010,100.0013,057.5019.86%65,748.20
31
171-24Phase II Test and Balance0.000.00
32
171-25Phase II Landscaping0.000.00%100,000.00
33
171-26Phase II Furnishings0.000.00%200,000.00
34
171-27Phase II Fill1,960.00325,321.7487,998.9610,110.006,930.0012,920.007,110.008,460.001,170.0010,260.006,920.009,270.0016,745.00505,175.7074.40%679,000.00
35
171-28Phase II Building Permits60,882.83
36
732,816.984.77%$15,369,170.93PHASE II TOTAL (budget amt. does not include 5% conting.)
37
38
TOTAL EXPENSES8,550.003,510.677,039.08194,021.3043,539.500.000.000.009,049.7510,932.81595,301.10204,901.58120,126.0011,689.20290.400.0025,951.550.000.000.000.00108,350.7324,105.5331,627.50380,515.89413,585.4688,133.0681,846.9551,840.00157,485.35331,561.5537,322.22370,435.061,340,174.932,462,436.012,408,277.081,482,118.791,038,411.091,020,706.66606,458.11126,008.1170,747.8610,759.1312,920.007,110.008,460.001,170.0013,462.756,920.0052,620.00185,803.2814,166,276.0451.87%27,313,711.06
39
1,230,386.275% Conting. on construction items incomplete as of 6-30-11 for Phase I and 9-30-16 for Phase II
40
49.63%$28,544,097.33TOTAL PROJECT BUDGETED COST* (Budget amt. does not include the $1.1 million added to the Phase I budget by the Archd. in 7/13.)
41
42
Income
43
Capital Campaign Income--old 914,339.7254,464.67109,801.64105,235.5055,711.0010,759.0710,622.19131,736.20129,132.1713,167.5055,271.9661,611.3366,896.1256,159.5928,548.2786,667.1525,139.9121,315.288,136.8659,001.289,152.6230,963.752,720.02112,339.6324,693.432,651.7121,082.0647,598.5910,339.8112,527.8022,067.7653,247.592,353,102.18103.11%2,282,170.00
44
Surplus deposited into campaign fund529,046.4390,000.00160,000.00140000160,000.0090,000.0092,000.0098,000.00272,641.9991,000.0028,964.24142,000.00160,000.00103,966.0489,000.00172,000.00176,000.0078,507.17117,000.00145,524.00149,000.003,084,649.87129.40%2,383,800.00
45
Capital Campaign Income--new 227,382.54229,936.91160,659.28165,947.59265,232.65167,423.93164,634.86165,625.82110,670.06218,104.83129,634.8490,504.73101,260.30165,147.7064,642.2065,391.1056,746.8560925.6242,272.9041,869.252,694,013.9667.35%4,000,000.00
46
043-00Sale of Parish Property1,504,000.00-3,500.001,500,500.0021.13%7,100,000.00
47
Expenses paid from operating income8,550.003,510.677,039.0891,712.111,014.0024.78290.40290.4043,010.7323,145.532,285.005,300.8059.1030.0017.470.40-5,513.895,055.003,465.006,460.003,555.004,230.00585.008,332.753,285.004,635.003,692.50224,061.83120.28%186,280.47
48
Cell company contribution150,000.00150,000.0050.00%300,000.00
49
Other sources5,055.003,465.006,460.003,555.004,230.00585.005,130.003,285.004,635.003,692.5040,092.50337,000
50
TOTAL INCOME914,339.7263,014.67113,312.31112,274.58147,423.1111,773.0710,622.19131,736.20129,132.1713,167.5055,271.9661,636.1166,896.1256,159.5928,838.6786,957.5525,139.9121,315.288,136.8659,001.289,152.6230,963.7545,730.75135,485.1626,978.437,952.5121,082.0647,657.6910,339.8112,527.80551,114.19143,247.59387,382.54229,936.91300,659.28325,947.59355,232.65259,453.93262,652.33588,267.81201,670.46241,555.18281,744.84257,434.73218,146.341,765,257.70245,102.20242,561.10148,716.77184,495.62193,566.90198,254.2510,046,420.3460.56%$16,589,250.47
51
52
Excess funds transferred from campaign to checking20.003.0023.00100.00%$23.00
53
54
BALANCE OF CAPITAL CAMPAIGN FUND/LOAN PRINCIPAL (with interest stripped out starting in 2014.)
55
$914,339.72$968,804.39$1,078,606.03$1,183,841.53$1,137,243.34$1,105,476.91$1,116,099.10$1,247,835.30$1,376,967.47$1,381,085.22$1,425,404.37$891,739.38$753,730.92$689,764.51$706,913.98$793,581.13$818,721.04$814,084.77$822,221.63$881,222.91$890,375.53$921,339.28$858,719.30$970,098.93$965,449.86$592,886.48$200,383.08$159,907.71$88,400.57$49,088.37$442,717.21$254,403.25$604,463.57$463,965.42-$575,550.23-$2,712,038.65-$4,765,083.08-$5,987,747.94-$6,763,506.70-$7,195,945.55-$7,600,733.20-$7,485,186.13-$7,274,189.15-$7,027,513.55-$6,822,287.21-$5,064,139.51-$4,827,497.31-$4,586,106.21-$4,450,852.19-$4,273,276.57-$4,132,329.67-$4,119,878.70-$4,119,878.7034.46%-$11,954,869.86Budgeted loan principal balance (with interest taken out) at end of Phase II & once NOL & SEAS sites are sold.) Does not include the additional $1.1 million the Archd. agreed to lend to Divine Mercy in 7/13.)
56
Loan interest (4.1% 1/1/14 - 6/30/16) (4.3% in July 2016) (no interest August 2016- April 2018)-69,101.22-76,968.23-79,978.70-79,555.38-76,066.14-75,089.07-65,871.38-56,693.49-53,735.44-52,600.17-18624.770.000.00-704,283.99(By concession of the Archdiocese, no interest accrued on any loan balance during the construction of the new church. Interest began to accrue on 1/1/2014. The Archdiocese also conceded the suspension of interest during Phase II design and construction (Aug. 2016 - April 2018).
57
Balance (including interest)-$7,265,046.77-$7,746,802.65-$7,711,234.28-$7,579,792.68-$7,409,183.22-$7,279,045.95-$5,586,769.63-$5,406,820.92-$5,219,165.26-$5,136,511.41-$4,977,560.56-$4,836,613.66-$4,824,162.69-$4,824,162.69
58
Nativity of Our Lord Parish (NOL) and St. Elizabeth Ann Seton Parish (SEAS) merged on July 1, 2009 to form Divine Mercy Parish. This color represents work on the new site prior to the merger, as well as St. Elizabeth Ann Seton Parish capital campaign fund balance. Nativity of Our Lord Parish had no capital campaign fund at the time of the merger.
59
This color represents expenses paid using ordinary parish income.
60
This color represents expenses partially paid using ordinary parish income.
62
63
Loading...
 
 
 
Sheet1
Matrix using "as is" value
Matrix using land value only (prop to Archd.)
FROM Archd: Matrix using land value only
StateFeeEngine2016
Reconciliation
Phase I budget variations
Phase II budget variations
Phase II timeline
Phase II design timeline
Phase Ib Budget
Sheet6
Phase II cost