Excel/Access 2013 Assignment
GEODON
group_project_.xlsBudget
| Quarterly Budget | ||||||||
| Income | January | February | March | Total | ||||
| Projected Income | ||||||||
| Tithe | $ 10,224.00 | $ 8,937.00 | $ 9,336.00 | $ 28,497.00 | ||||
| Donations | $ 5,739.00 | $ 6,683.00 | $ 4,772.00 | $ 17,194.00 | ||||
| Investments | $ 968.00 | $ 1,039.00 | $ 1,274.00 | $ 3,281.00 | ||||
| TOTAL INCOME | $ 16,931.00 | $ 16,659.00 | $ 15,382.00 | $ 48,972.00 | ||||
| Expenses | January | February | March | Total | ||||
| Administrative Cost | ||||||||
| Salaries | $ 7,389.00 | $ 7,393.00 | $ 7,388.00 | $ 22,170.00 | ||||
| Insurance | $ 392.00 | $ 392.00 | $ 392.00 | $ 1,176.00 | ||||
| Reinbursement | $ 1,485.00 | $ 847.00 | $ 1,049.00 | $ 3,381.00 | ||||
| Total | $ 9,266.00 | $ 8,632.00 | $ 8,829.00 | $ 26,727.00 | ||||
| Facility Cost | ||||||||
| Utilities | $ 2,302.00 | $ 2,104.00 | $ 1,928.00 | $ 6,334.00 | ||||
| Church Vehicle | $ 573.00 | $ 638.00 | $ 567.00 | $ 1,778.00 | ||||
| Maintanance | $ 2,774.00 | $ 1,733.00 | $ 3,835.00 | $ 8,342.00 | ||||
| Total | $ 5,649.00 | $ 4,475.00 | $ 6,330.00 | $ 16,454.00 | ||||
| Where do we need to increase or decrease ministry spending? | ||||||||
| Ministry Cost | January | February | March | |||||
| Local Missions | $ 230.00 | $ 420.00 | $ 446.00 | $ 1,096.00 | Remain the Same | Decrease Spending | Decrease Spending | |
| Global Missions | $ 460.00 | $ 330.00 | $ 450.00 | $ 1,240.00 | Decrease Spending | Remain the Same | Decrease Spending | |
| Children's Ministry | $ 359.00 | $ 372.00 | $ 293.00 | $ 1,024.00 | Remain the Same | Remain the Same | Remain the Same | |
| Youth Ministry | $ 448.00 | $ 131.00 | $ 288.00 | $ 867.00 | Decrease Spending | Increase Spending | Remain the Same | |
| College Ministry | $ 278.00 | $ 263.00 | $ 372.00 | $ 913.00 | Remain the Same | Remain the Same | Remain the Same | |
| Adult Ministry | $ 203.00 | $ 211.00 | $ 187.00 | $ 601.00 | Remain the Same | Remain the Same | Increase Spending | |
| Total | $ 1,978.00 | $ 1,727.00 | $ 2,036.00 | $ 5,741.00 | ||||
| TOTAL EXPENSES | $ 16,893.00 | $ 14,834.00 | $ 17,195.00 | $ 48,922.00 | ||||
| DIFFERENCE | $ 38.00 | $ 1,825.00 | $ (1,813.00) | $ 50.00 |
Group Members:
Johanna
George
Erin
Chart
Chart
| 9266 | 5649 | 1978 |
| 8632 | 4475 | 1727 |
| 8829 | 6330 | 2036 |
Admin Costs
Facility Costs
Ministry Costs
Monthly Expenses (Jan-Mar)
Purchase
| 10224 | 5739 | 968 |
| 8937 | 6683 | 1039 |
| 9336 | 4772 | 1274 |
Tithe
Donations
Investments
Monthly Income (Jan-Mar)
Members
| This spreadsheet analyzes the lease/purchase decision. In the case of a purchase, it is assumed | ||||||||||
| sales tax is paid on the negotiated price at the time of purchase, and property taxes are paid annually. | ||||||||||
| In the case of a lease, it is assumed sales tax is paid on the difference between the list price and the | ||||||||||
| payoff at the time of purchase, sales tax is paid on the payoff when the lease expires, and property taxes | ||||||||||
| are paid by the lessor. This spreadsheet assumes the item is purchased at the payoff price at the time | ||||||||||
| the lease expires. The lease has additional value to the lessee because of the option not to purchase. | ||||||||||
| The features of your lease may be different than assumed here. | ||||||||||
| Assumptions | ||||||||||
| List price | $ 26,000 | |||||||||
| Negotiated price | $ 24,000 | |||||||||
| Lease period (months) | 36 | |||||||||
| Payoff | $ 20,000 | |||||||||
| Interest rate (APR) | 7.00% | |||||||||
| Effective annual rate | 7.23% | |||||||||
| Sales tax rate | 6% | |||||||||
| Property tax (annual) | $ 300 | |||||||||
| Lease payment | $ 280 | |||||||||
| Results | ||||||||||
| Purchase | Lease | |||||||||
| Present value of payments | $ 24,000 | $ 25,343 | ||||||||
| Present value of sales tax | $ 1,440 | $ 1,333 | ||||||||
| Present value of property tax | $ 784 | |||||||||
| Total | $ 26,224 | $ 26,676 | Decision | Purchase | ||||||
| The following table provides a check on the lease calculations above. | ||||||||||
| Sales | PV | Cumul | ||||||||
| Month | Payment | Tax | Total | Factor | PV | PV | ||||
| 0 | $ 280 | 360 | $ 640 | 100.0% | 640.00 | 640.00 | ||||
| 1 | $ 280 | $ 280 | 99.4% | 278.38 | 918.38 | |||||
| 2 | $ 280 | $ 280 | 98.8% | 276.76 | 1195.14 | |||||
| 3 | $ 280 | $ 280 | 98.3% | 275.16 | 1470.29 | |||||
| 4 | $ 280 | $ 280 | 97.7% | 273.56 | 1743.86 | |||||
| 5 | $ 280 | $ 280 | 97.1% | 271.97 | 2015.83 | |||||
| 6 | $ 280 | $ 280 | 96.6% | 270.40 | 2286.23 | |||||
| 7 | $ 280 | $ 280 | 96.0% | 268.83 | 2555.06 | |||||
| 8 | $ 280 | $ 280 | 95.5% | 267.27 | 2822.33 | |||||
| 9 | $ 280 | $ 280 | 94.9% | 265.72 | 3088.04 | |||||
| 10 | $ 280 | $ 280 | 94.3% | 264.18 | 3352.22 | |||||
| 11 | $ 280 | $ 280 | 93.8% | 262.65 | 3614.87 | |||||
| 12 | $ 280 | $ 280 | 93.3% | 261.12 | 3875.99 | |||||
| 13 | $ 280 | $ 280 | 92.7% | 259.61 | 4135.60 | |||||
| 14 | $ 280 | $ 280 | 92.2% | 258.10 | 4393.71 | |||||
| 15 | $ 280 | $ 280 | 91.6% | 256.61 | 4650.31 | |||||
| 16 | $ 280 | $ 280 | 91.1% | 255.12 | 4905.43 | |||||
| 17 | $ 280 | $ 280 | 90.6% | 253.64 | 5159.07 | |||||
| 18 | $ 280 | $ 280 | 90.1% | 252.17 | 5411.24 | |||||
| 19 | $ 280 | $ 280 | 89.5% | 250.71 | 5661.94 | |||||
| 20 | $ 280 | $ 280 | 89.0% | 249.25 | 5911.19 | |||||
| 21 | $ 280 | $ 280 | 88.5% | 247.81 | 6159.00 | |||||
| 22 | $ 280 | $ 280 | 88.0% | 246.37 | 6405.37 | |||||
| 23 | $ 280 | $ 280 | 87.5% | 244.94 | 6650.31 | |||||
| 24 | $ 280 | $ 280 | 87.0% | 243.52 | 6893.83 | |||||
| 25 | $ 280 | $ 280 | 86.5% | 242.11 | 7135.93 | |||||
| 26 | $ 280 | $ 280 | 86.0% | 240.70 | 7376.64 | |||||
| 27 | $ 280 | $ 280 | 85.5% | 239.31 | 7615.94 | |||||
| 28 | $ 280 | $ 280 | 85.0% | 237.92 | 7853.86 | |||||
| 29 | $ 280 | $ 280 | 84.5% | 236.54 | 8090.40 | |||||
| 30 | $ 280 | $ 280 | 84.0% | 235.17 | 8325.57 | |||||
| 31 | $ 280 | $ 280 | 83.5% | 233.80 | 8559.37 | |||||
| 32 | $ 280 | $ 280 | 83.0% | 232.45 | 8791.82 | |||||
| 33 | $ 280 | $ 280 | 82.5% | 231.10 | 9022.92 | |||||
| 34 | $ 280 | $ 280 | 82.1% | 229.76 | 9252.68 | |||||
| 35 | $ 280 | $ 280 | 81.6% | 228.43 | 9481.11 | |||||
| 36 | $ 20,000 | $ 1,200 | $ 21,200 | 81.1% | 17194.87 | 26675.98 | ||||
| Scenario Summary | ||||||||||
| Current Values: | 10% | 11% | 8% | 7% | ||||||
| Created by Chetan on 2/22/2016 Modified by Chetan on 2/22/2016 | Created by Chetan on 2/22/2016 Modified by Chetan on 2/22/2016 | Created by Chetan on 2/22/2016 Modified by Chetan on 2/22/2016 | Created by Chetan on 2/22/2016 Modified by Chetan on 2/22/2016 | |||||||
| Changing Cells: | ||||||||||
| $D$15 | 7.00% | 10.00% | 11.00% | 8.00% | 7.00% | |||||
| Result Cells: | ||||||||||
| $F$27 | $ 26,676 | $ 24,835 | $ 24,255 | $ 26,045 | $ 26,676 | |||||
| Notes: Current Values column represents values of changing cells at | ||||||||||
| time Scenario Summary Report was created. Changing cells for each | ||||||||||
| scenario are highlighted in gray. |
&A
Page &P
| Last Name | First Name | Membership Date | Address | Phone | Small Group | Ministry Team | Automatic Offering Withdrawl | Staff Member | |
| Abdula | Fred | 8/7/14 | [email protected] | Foggy Autoroute, Elevenmile Homestead, Virginia, 24025-4868 | (571) 429-8776 | Hernandez | None | Y | Y |
| Abindo | Sara | 2/13/08 | [email protected] | Easy Quail Hill, False Pass, Virginia, 22529-0009 | (703)674-0842 | Baker | Greeter | N | N |
| Baker | Scott | 3/19/09 | [email protected] | Crystal Thicket, Condemned Bar, Virginia, 23269-1623 | (703) 812-9225 | Hernandez | Trustee | Y | N |
| Ballou | Micaela | 6/7/07 | [email protected] | Misty Fawn Field, Fizzben Heights, Virginia, 22333-5978 | (703) 261-5995 | Knight | Greeter | N | N |
| Batterson | James | 5/2/95 | [email protected] | High Range, Komandorski Village, Virginia, 23566-9376 | (804) 056-3950 | Baker | Greeter | N | N |
| Blue | Rebecca | 4/21/11 | [email protected] | Red Boulevard, Mars, Virginia, 23812-8182 | (540) 022-3559 | Baker | Nursery | Y | N |
| Collins | Frita | 5/6/12 | [email protected] | Silent Drive, Priest, Virginia, 22192-9063 | (757) 432-8504 | Hernandez | Greeter | N | N |
| Corwin | Tanner | 1/18/04 | [email protected] | Fallen Mall , Rough And Ready, Virginia, 22130-5748 | (804) 402-0992 | Lowe | Music | N | N |
| Corwin | Karson | 1/18/04 | [email protected] | Fallen Mall , Rough And Ready, Virginia, 22130-5748 | (703) 924-1128 | Lowe | Children | N | N |
| Florindo | Nina | 8/22/99 | [email protected] | Silver Cloud Byway, Recreation, Virginia, 24219-2902 | (804) 387-9452 | Lowe | Children | N | Y |
| Florindo | Troy | 2/27/06 | [email protected] | Silver Cloud Byway, Recreation, Virginia, 24219-2902 | (571) 871-0572 | Lowe | Youth | Y | N |
| Gains | Chelsea | 3/1/14 | [email protected] | Cotton Mountain Canyon, Humptulips, Virginia, 24408-4731 | (540) 599-5170 | Hernandez | None | Y | N |
| Harris | Sabrina | 6/17/90 | [email protected] | Velvet Freeway, Index, Virginia, 22445-0979 | (540) 582-0703 | Marcos | Outreach | N | N |
| Harrison | Rob | 6/17/90 | [email protected] | Sunny Autumn Passage, Planet, Virginia, 23023-6200 | (703) 048-6905 | Baker | Bus | Y | N |
| Hernandez | Kaitlyn | 6/7/08 | [email protected] | Stony Avenue, Goodpasture, Virginia, 22735-0664 | (571) 236-9402 | Hernandez | Children | Y | N |
| Hernandez | Jon | 8/4/13 | [email protected] | Stony Avenue, Goodpasture, Virginia, 22735-0664 | (434) 986-2037 | Hernandez | Trustee | N | N |
| Honeycut | Katie | 8/30/13 | [email protected] | Jagged Crescent, Swink, Virginia, 22321-9493 | (804) 237-7842 | Baker | None | Y | N |
| Jeffries | Sylvia | 9/17/15 | [email protected] | Grand Edge, Bugtown, Virginia, 22452-0297 | (571) 694-6374 | Marcos | None | N | N |
| Johnson | Jameel | 9/17/15 | [email protected] | Tawny Heights, Stovepipe, Virginia, 22209-6087 | (434) 028-6615 | Knight | None | N | N |
| Kapteyn | Lane | 4/12/13 | [email protected] | Wishing Park, Burnt Hill, Virginia, 24575-1739 | (540) 209-2915 | Baker | Trustee | N | Y |
| Knight | Maria | 2/21/01 | [email protected] | Quiet Village, Toad Suck, Virginia, 23418-9593 | (703) 021-5494 | Knight | Greeter | Y | Y |
| Lopez | Marco | 5/4/02 | [email protected] | Burning Walk, Twist, Virginia, 23192-2923 | (434) 505-6950 | Hernandez | Deacon | N | N |
| Lowe | Mike | 5/4/02 | [email protected] | Sleepy Wynd, Wolf Pen, Virginia, 23604-6066 | (804) 205-0490 | Lowe | Bus | Y | N |
| Lowe | Rachel | 7/15/06 | [email protected] | Sleepy Wynd, Wolf Pen, Virginia, 23604-6066 | (804) 380-4474 | Lowe | Greeter | N | N |
| Lowe | Robert | 7/15/06 | [email protected] | Sleepy Wynd, Wolf Pen, Virginia, 23604-6066 | (571) 499-7922 | Knight | Deacon | N | N |
| Lowe | Lynda | 5/22/10 | [email protected] | Noble By-pass, Gross, Virginia, 22303-5024 | (757) 227-8813 | Knight | Youth | Y | N |
| Marcos | Julianne | 8/9/05 | [email protected] | Dusty Bear Diversion, Dimple, Virginia, 22087-5847 | (703) 215-5070 | Marcos | Children | Y | N |
| Martin | Sanda | 5/1/06 | [email protected] | Shady Embers Route, Soft Shell, Virginia, 23434-3790 | (703) 350-2806 | Lowe | Music | N | Y |
| Martin | Andrew | 3/27/07 | [email protected] | Shady Embers Route, Soft Shell, Virginia, 23434-3790 | (571) 756-8857 | Lowe | Trustee | Y | Y |
| Matthews | Thomas | 11/7/11 | [email protected] | Rocky Dale, Pringle, Virginia, 23216-1609 | (571) 105-1908 | Baker | Deacon | N | N |
| Matthews | Corinne | 10/4/12 | [email protected] | Blue Rabbit Front, Greasy, Virginia, 22461-8702 | (757) 830-9584 | Knight | None | N | N |
| Matthews | Adrian | 10/4/12 | [email protected] | Blue Rabbit Front, Greasy, Virginia, 22461-8702 | (434) 245-0008 | Knight | None | Y | N |
| McKlain | Brianna | 3/6/12 | [email protected] | Cozy Landing, Sawdust, Virginia, 22725-7300 | (276) 193-4284 | Knight | Music | N | N |
| Moore | Dawna | 2/9/09 | [email protected] | Hidden Circuit, Zipperlandville, Virginia, 22519-4997 | (757) 329-6546 | Hernandez | Children | N | N |
| Morgan | Joseph | 7/5/01 | [email protected] | Amber Berry Vista, Breakneck, Virginia, 24688-9366 | (571) 169-1193 | Stroup | Bus | Y | N |
| Parker | Erin | 11/30/14 | [email protected] | Broad Glade, Bear, Virginia, 23754-3092 | (757) 795-9243 | Baker | None | N | N |
| Pearson | Sean | 9/19/91 | [email protected] | Hazy Apple Cape, Land O'Lakes, Virginia, 23821-9634 | (571) 504-6647 | Stroup | Bus | N | N |
| Peterson | Joy | 8/24/12 | [email protected] | Middle End, Faceville, Virginia, 23404-2567 | (540) 913-3734 | Lowe | Greeter | Y | N |
| Petree | Kimberly | 6/5/07 | [email protected] | Harvest Gate View, Sigsbee, Virginia, 22647-2243 | (276) 806-4930 | Stroup | Nursery | N | N |
| Porterfield | Josiah | 2/3/99 | [email protected] | Merry Key, Purgatory, Virginia, 23094-4406 | (571) 785-2499 | Hernandez | Children | Y | Y |
| Quento | Kristin | 6/4/98 | [email protected] | Pleasant Robin Beach, Robinhood, Virginia, 23776-1094 | (276) 895-2277 | Hernandez | Youth | Y | N |
| Ranco | Max | 3/1/06 | [email protected] | Gentle Brook Inlet, Square Lake, Virginia, 23331-7967 | (571) 293-8763 | Baker | Outreach | Y | N |
| Remino | Flavio | 11/18/05 | [email protected] | Dewy Trail, Dulls Corner, Virginia, 24217-3542 | (703) 716-1624 | Hernandez | Deacon | Y | N |
| Reynolds | Ashley | 4/22/06 | [email protected] | Thunder Elk Parade, Monumental, Virginia, 23516-7634 | (571) 090-9275 | Knight | Music | N | N |
| Sanders | Ruby | 7/2/10 | [email protected] | Clear Branch Row, Smooth Hummocks, Virginia, 23280-9628 | (757) 319-7330 | Stroup | Nursery | N | N |
| Saner | Jimmy | 6/9/10 | [email protected] | Bright Pines, Crafts, Virginia, 22749-9960 | (703) 443-4690 | Knight | None | N | N |
| Sears | Ronda | 2/17/98 | [email protected] | Honey Arbor, Yaphank, Virginia, 23914-6000 | (804) 576-5160 | Baker | Bus | Y | N |
| Sewell | Jesse | 8/11/13 | [email protected] | Heather Promenade, Pungo, Virginia, 23217-0603 | (540) 623-7607 | Lowe | None | N | N |
| Smart | Chandler | 10/4/07 | [email protected] | Emerald Meadow, Angel, Virginia, 22382-9433 | (703) 360-7497 | Stroup | Children | Y | N |
| Smith | Karen | 11/2/97 | [email protected] | Little Goose Swale, Concept, Virginia, 24468-1001 | (757) 321-3521 | Hernandez | Music | Y | N |
| Smith | Madison | 10/4/07 | [email protected] | Little Goose Swale, Concept, Virginia, 24468-1001 | (703) 171-6369 | Hernandez | None | N | N |
| Stroup | Sharon | 3/23/01 | [email protected] | Lost Via, Parachute, Virginia, 23904-2975 | (276) 585-4151 | Stroup | Nursery | Y | N |
| Stroup | Howard | 7/22/03 | [email protected] | Lost Via, Parachute, Virginia, 23904-2975 | (434) 640-8001 | Stroup | Music | N | N |
| Teryl | Megan | 4/11/95 | [email protected] | Old Arbor, Eightmile Saddle, Virginia, 22649-9982 | (540) 434-5986 | Baker | Bus | Y | N |
| Thomson | Matthew | 12/18/09 | [email protected] | Stony Deer Drive, Whiskey Bend, Virginia, 24056-5002 | (804) 041-7514 | Knight | Deacon | Y | N |
| Tuck | Phillip | 6/13/00 | [email protected] | High Gate Ridge, Negro Bend, Virginia, 23450-5613 | (757) 783-9642 | Lowe | Trustee | Y | N |
| Tyson | Mark | 12/2/94 | [email protected] | Umber View Jetty, Ohio, Virginia, 24566-4816 | (757) 341-2674 | Knight | Music | N | Y |
| Vandever | Amy | 9/28/15 | [email protected] | Blue Fox Orchard, Roachtown, Virginia, 24181-0815 | (757) 769-2364 | Stroup | None | N | N |
| Willis | Anna | 9/28/15 | [email protected] | Amber Lookout, Walkinghood, Virginia, 22582-2196 | (703) 811-8492 | Lowe | None | N | N |
| Wilson | Judith | 12/1/02 | [email protected] | Hazy Abbey, Bug, Virginia, 24079-0038 | (434) 775-6392 | Hernandez | Children | Y | N |
| Ministry | Team Members | Small Group | Members | ||||||
| None | 13 | Marcos | 3 | ||||||
| Children | 8 | Stroup | 8 | ||||||
| Greeter | 7 | Baker | 11 | ||||||
| Music | 7 | Knight | 12 | ||||||
| Bus | 6 | Lowe | 12 | ||||||
| Deacon | 5 | Hernandez | 14 | ||||||
| Trustee | 5 | Grand Total | 60 | ||||||
| Nursery | 4 | ||||||||
| Youth | 3 | ||||||||
| Outreach | 2 | ||||||||
| Grand Total | 60 |
