Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

are you good with access? this is my last question im not quite sure how to do it because i dont have the acess program

image text in transcribed

are you good with access?

this is my last question im not quite sure how to do it because i dont have the acess program on my computer

it doesnt take long its very short

this is the question:

  • Create a Report that will allow you to print mailing labels for all members in the database. Name the report Mailing Labels.
image text in transcribed Income Donations Offerings Tithes Total January February March April May June July August September October November December $ 6,225.00 $ 5,654.00 $ 5,587.00 $ 4,944.00 $ 5,211.00 $ 5,598.00 $ 6,614.00 $ 4,858.00 $ 6,328.00 $ 6,511.00 $ 4,625.00 $ 5,546.00 $ 6,552.00 $ 4,354.00 $ 5,365.00 $ 5,845.00 $ 4,698.00 $ 5,621.00 $ 6,132.00 $ 5,562.00 $ 6,585.00 $ 5,789.00 $ 7,640.00 $ 7,865.00 $ 7,968.00 $ 6,986.00 $ 7,662.00 $ 7,988.00 $ 6,396.00 $ 7,489.00 $ 7,789.00 $ 8,984.00 $ 7,687.00 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Expenses Pastor Expenses Automaobile Courses Eateries Materials Salary Travel Total January $ 250.00 $ 150.00 $ 400.00 $ 95.00 Err:509 $ 500.00 Err:508 February $ 198.00 ### $ 258.00 $ 105.00 Err:509 $ 700.00 Err:508 March $ 125.00 $ 150.00 $ 350.00 $ 75.00 Err:509 $ 685.00 Err:508 April May $ 130.00 $ 75.00 $ 150.00 $ 150.00 $ 225.00 $ 375.00 $ 68.00 $ 95.00 Err:509 Err:509 $ 585.00 $ 1,350.00 Err:508 Err:508 Admininstations Expenses Bus Expenses Computers Maintenance Property Maintenance Publicity Salaries Supplies Total January $ 200.00 $ 85.00 $ 200.00 $ 75.00 Err:509 $ 100.00 Err:508 February $ 250.00 $ ### ### Err:509 $ 85.00 Err:508 March $ 175.00 $ $ 200.00 $ 75.00 Err:509 $ 60.00 Err:508 April May $ 85.00 $ $ - $ $ 200.00 $ $ 75.00 $ Err:509 $ 72.00 $ Err:508 June July 125.00 $ 225.00 $ - $ - $ 200.00 $ 200.00 $ 75.00 ### $ Err:509 Err:509 58.00 $ 95.00 $ Err:508 Err:508 185.00 85.00 200.00 75.00 Err:509 64.00 Err:508 Program Expenses Music Worship Youth Total January $ 250.00 $ 325.00 $ 200.00 Err:508 February $ 125.00 $ 250.00 $ 150.00 Err:508 March $ 150.00 $ 185.00 $ 200.00 Err:508 April May $ 150.00 $ $ 325.00 $ $ 200.00 $ Err:508 June 125.00 $ 250.00 $ 150.00 $ Err:508 Other Expenses Building Fund Electricity Supplies Total January February March $ 1,100.00 ### $ 1,100.00 $ 672.00 $ 580.00 $ 600.00 $ 125.00 $ 200.00 $ 225.00 Err:508 Err:508 Err:508 April $ 1,100.00 $ 650.00 $ 125.00 Err:508 June $ $ $ $ $ 250.00 150.00 400.00 125.00 Err:509 500.00 Err:508 July August $ 100.00 $ 155.00 $ 150.00 $ 150.00 $ 455.00 $ 387.00 $ 55.00 $ 85.00 Err:509 Err:509 $ 450.00 $ 950.00 Err:508 Err:508 July 250.00 $ 190.00 $ 175.00 $ Err:508 September $ 185.00 $ 150.00 $ 296.00 $ 78.00 Err:509 $ 655.00 Err:508 October $ 150.00 $ 150.00 $ 345.00 $ 96.00 Err:509 $ 355.00 Err:508 September $ 155.00 $ $ 200.00 $ 75.00 Err:509 $ 46.00 Err:508 October $ 205.00 $ $ 200.00 $ 75.00 Err:509 $ 105.00 Err:508 November December $ 100.00 $ $ 200.00 $ 75.00 Err:509 $ 68.00 Err:508 Err:508 August 225.00 $ 125.00 250.00 $ 250.00 225.00 $ 200.00 Err:508 Err:508 September $ 250.00 $ 185.00 $ 150.00 Err:508 October $ 225.00 $ 190.00 $ 275.00 Err:508 November December $ 150.00 $ 300.00 $ 175.00 Err:508 Err:508 September October $ 1,100.00 ### $ 677.00 $ 598.00 $ 151.00 $ 165.00 Err:508 Err:508 November December $ 1,100.00 ### $ 602.00 $ 180.00 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Pastor Expense Admin Expense Program Expense Other Expense Expense Average Err:508 Err:508 Err:508 Err:508 $ 16,692.62 November December $ 175.00 $ 150.00 $ 250.00 $ 89.00 Err:509 $ 250.00 Err:508 Err:508 August $ 150.00 $ 25.00 $ 200.00 $ 75.00 Err:509 $ 90.00 Err:508 Donation Average Offering Average Tithes Average Income Average May June July $ 1,100.00 ### $ 1,100.00 $ 578.00 $ 598.00 $ 602.00 $ 250.00 $ 140.00 $ 205.00 Err:508 Err:508 Err:508 August $ 1,100.00 $ 694.00 $ 130.00 Err:508 Chart $10,000.00 $9,000.00 $8,000.00 $7,000.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $- $6,225.00 $5,654.00 Offerings Courses Row 17 Supplies Total $5,587.00 $4,944.00 Tithes Eateries Bus Expenses Total Row 32 $5,211.00 $5,598.00 Total Materials Computers Maintenance Row 26 Building Fund $6,614.00 $4,858.00 Row 6 Salary Property Maintenance Music Electricity $6,328.00 Pastor Expenses Travel Publicity Worship Supplies $6,511.00 Automaobile Total Salaries Youth Total $4,625.00 Answer: Assuming that the church plans to purchase a building, where the church would be organizing different functions Assuming that the cost of the buildi The cost of capital Interest 75000 12% 3% Let us assume that the first option is to take the complete loan for 15 years First option Loan from the bank Loan repayment Annual Time period of loan repayment 15 years Loan interest 7% Let us assume that in the second option, a proportion of amount is raised through funds and remaining proportion is financed by bank Second option Raising funds 75% Loan taken 25% Loan repayment Annual Time period of loan repayment 5 years Let us assume that the third option is to issue bonds Third option Issuing bonds Brokerage 7500 Membership fees Expected increase 250000 4% First option Year Loan Membership fees Depreciation (20 years SLM) Maintenance and other expenses Repayment Cash flows NPV 0 -75000 $ -75000 $ $ Second Option Year Loan Membership fees Depreciation (20 years SLM) Maintenance and other expenses Repayment Cash flows NPV 1 $ -18750 $ 260000.00 3750 7500 8,234.6 $ 240,515.4 $ 3 270400.00 3750 7500 8,234.6 $ 250,915.4 $ 4 281216.00 3750 7500 8,234.6 $ 261,731.4 $ 5 292464.64 3750 7500 8,234.6 $ 272,980.0 $ 6 304163.23 3750 7500 8,234.6 $ 284,678.6 $ 7 316329.75 3750 7500 8,234.6 $ 296,845.2 $ 8 328982.94 3750 7500 8,234.6 $ 309,498.3 $ 9 342142.26 3750 7500 8,234.6 $ 322,657.7 $ 10 355827.95 3750 7500 8,234.6 $ 336,343.4 $ 250000 3750 8000 4,094.15 $ 234155.85 2 260000.00 3750 8000 4,094.15 $ 244155.85 3 270400.00 3750 8000 4,094.15 $ 254555.85 4 281216.00 3750 8000 4,094.15 $ 265371.85 5 292464.64 3750 8000 4,094.15 276620.49 940,164.34 0 -75000 -7500 $ -75000 $ $ 250000 3750 7500 8,234.6 $ 230,515.4 $ 2 1,889,087.91 0 -18750 Third option Year Bond Brokerage Membership fees Depreciation (20 years SLM) Maintenance and other expenses Interest Cash flows NPV 1 1,595,474.37 1 250000 3750 8000 7,500.0 $ 230,750.0 $ 2 260000.00 3750 8000 7,500.0 $ 240,750.0 $ 3 270400.00 3750 8000 7,500.0 $ 251,150.0 $ 4 281216.00 3750 8000 7,500.0 $ 261,966.0 $ 5 292464.64 3750 8000 7,500.0 $ 273,214.6 $ 6 304163.23 3750 8000 7,500.0 $ 284,913.2 $ 7 316329.75 3750 8000 7,500.0 $ 297,079.8 $ 8 328982.94 3750 8000 7,500.0 $ 309,732.9 $ 9 342142.26 3750 8000 7,500.0 $ 322,892.3 $ 10 355827.95 3750 8000 7,500.0 336,578.0 11 370061.07 3750 7500 8,234.6 $ 350,576.5 $ 12 384863.51 3750 7500 8,234.6 $ 365,378.9 $ 13 400258.05 3750 7500 8,234.6 380,773.5 14 $ $ 416268.38 3750 7500 8,234.6 $ 396,783.8 $ 15 432919.11 3750 7500 8,234.6 413,434.5 Members Name Oaks, Sandra Dubois, Renea Slemp, Charles Swindle, Pat Shepherd, MaryLou Mitchell, Leslie Towles, Patrick Covington, Jack Stewart, Martha Wells, James Anderson, Chrissy Snodgrass, Pam Courtney, Joan Jones, Amillia Williams, Fred Covington,Shelly Williams, James Walters, Nancy Fannon, Felicia Adams, Lola Boatwright, Jen Oakes, Milly Martin, Rocky Lindsy, Chelle Franklin, Ben Daughtry, Stella DelRio, Jack Yoakham, Dwight Adams,Steve Hughes, Sam Chatsworth, Glen Shortt, Nancy Johnson, Glen Jones, Mark Couch, Sandra Busch, Kyle Stillwater, Rick Calipari, John Johnson, Pat Little, Lisa Hightower, Glen McDavid, James Shortt, Ned Chatsworth, Mary Absher, Steven Zimmerman, Frank Jordan, Michael Little, John Plaster, Frankie Stoops, Mark Fairfax, Betty Members Age 20 21 22 24 25 26 28 29 30 32 35 36 37 39 42 43 44 45 47 49 51 54 55 64 65 Members Phone 276 679-3290 276 328-8879 276 395-5645 276 395-5934 276 679-2011 276 328-6047 276 679-4556 276 395-3785 276 328-5849 276 395-6785 276 328-8275 276 328-4598 276 328-3478 276 679-3435 276 523-5669 276 523-5656 276 523-5679 276 523-5679 276 523-8384 276 523-5689 276 523-4445 276 679-3309 276 523-6688 276 679-5555 276 328-3472 276 523-3332 276 328-5571 276 679-4980 276 523-4443 276 523-7112 276 523-0987 276 523-6907 276 679-4900 276 395-0945 276 679-3110 276 679-3331 276 679-3335 276 328-8865 276 679-1010 276 395-9067 276 523-6648 276 679-3390 276 523-8909 276 523-7980 276 395-4389 276 328-9922 276 395-8811 276 395-5623 276 679-2209 276 395-9944 276 328-8055 Members Residence City Norton Wise Coeburn Coeburn Norton Wise Norton Coeburn Wise Coeburn Wise Wise Wise Norton Big Stone Gap Big Stone Gap Big Stone Gap Big Stone Gap Big Stone Gap Big Stone Gap Big Stone Gap Norton Big Stone Gap Norton Wise Big Stone Gap Wise Norton Big Stone Gap Big Stone Gap Big Stone Gap Big Stone Gap Norton Coeburn Norton Norton Norton Wise Norton Coeburn Big Stone Gap Norton Big Stone Gap Big Stone Gap Coeburn Wise Coeburn Coeburn Norton Coeburn Wise Data Average - Length of Membership Average - Members Age 1 1 2 2.5 4 4.5 3 5.5 7.3333333333 6 10.75 8 15 13 11.5 13 9 5 14 13 24 21.3333333333 17 21.5 22.6666666667 Members Age 20 21 22 24 25 26 28 29 30 32 35 36 37 39 42 43 44 45 47 49 51 54 55 64 65 M/F 20 F 21 F 22 M 24 F 22 F 24 F 28 M 25 M 26 F 26 M 29 F 30 F 45 F 29 F 32 M 35 F 35 M 39 F 30 F 36 F 44 F 30 F 44 M 42 F 49 M 65 F 35 M 39 M 42 M 43 M 49 M 47 F 64 M 37 M 49 F 35 M 55 M 54 M 39 F 54 F 64 M 64 M 65 M 51 F 54 M 73 M 64 M 67 M 80 M 65 M 82 F Church Staff No No No No No No No No No Yes No No No No No No No Yes No No No No No No No Yes No No No No No No No No No No No No No No No No No No Yes No No No No Yes Yes Length of Membership 1 1 1 2 3 3 3 4 4 5 5 5 5 6 6 7 7 7 8 8 8 9 10 11 11 11 12 12 12 13 13 14 14 15 15 17 17 19 20 20 22 22 23 24 25 25 28 30 32 34 34 GROUP PROJECT Kori White Part 1 Maurice Johnson Part 2 Asya McClelland Part 3 Steven Anderson Part 4 67 73 80 82 Total Result 30 25 32 34 13 67 73 80 82 43.5882352941 Jessica Fisher

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Susan V. Crosson, ‎ Belverd E. Needles

11th Edition

0538742801, 978-0538742801

More Books

Students also viewed these Accounting questions

Question

Give the reliability function of the structure of Exercise 8.

Answered: 1 week ago

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago