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. Albania Algeria Andorra * Argentina Armenia Belarus Bosnia & Herzegovina Burkina Faso * Chad Djibouti * Gabon * Guatemala Indonesia Iran Lesotho * Macedonia Malawi * Mali Mongolia Morocco Nauru * Niger Niue Papua New Guinea * Seychelles * Sierra Leone Sri Lanka Suriname Yemen Zimbabwe * Total 5 year Budget Projection Transportation Item Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Formulas Number or NA (Add rows as needed) Lodging Item Description Qty numbers Price each (Local) Price each (US) number or NA Number or NA Total price (US) Formulas (add rows as needed) Food Item Description Qty numbers Price each (Local) Price each (US) number or NA Number or NA Total price (US) Formulas (add rows as needed) Supplies and Misc Item Qty Numbers numbers (add rows as needed) Price each (Local) Price each (US) number or NA Number or NA Total price (US) Formulas U.S. Currency Formula Conversion Rate (see detail below) Projected Price (US) Source Formulas Link or citation Local currency U.S. currency Number Number Inflation Rate CPI (Five Years Ago) Number Projected Price Formulas Link or citation Projected Price Formulas Link or citation CPI (Today) Number You should just use information from Major Assignment 2, but if you are the instrructions again. Step 1: Go to the Bureau of Labor Statistics website at the link below Step 2: Check U.S. All items, 1982-84=100 Step 3: Click "Retrieve Data" Use the most recent CPI value and the CPI for the same month but fi of your trip in five years and the five year inflation rate. CPI Data Link c Projected Price Formulas Link or citation Like Major Assignment 2. 5 year projected budget on Rate Source Link or citation n Rate Inflation Rate Formula Take from Major Assignment 2 or follow instructions below from Major Assignment 2, but if you want to retrieve fresh CPI data, here or Statistics website at the link below. 82-84=100 nd the CPI for the same month but five years earlier to estimate the price five year inflation rate. CPI Data Link Sponsorship Fundraising Invest 30% of budget balance for 5 years Principal formula r = APR number n = # periods per year number t = # of years number Total in 5 years formula Link or citation $100 monthly for 5 years Payment r = APR number n = # periods per year number t = # of years number Total in 5 years formula Like Topic 6 DQ 1 100 Like Topic 5 DQ 2 Population Projection Current population Annual Growth Rate Projected Population Number Number formula Like Topic 6 DQ 1 Link or citation Loan (remainder of trip expenses, or minimum of $10,000) Link or citation Principal r = APR n = # periods per year t = # of years Payment Bank A Formula number number number formula Total Paid Total interest formula formula Link or citation Like Major Assignment 1 Loan Tab Discuss the reasons for choosing one loan over the other. ses, or minimum of $10,000) Bank B Formula number number number formula formula formula ignment 1 Loan Tab Link or citation Must be different rates Must be different years Mission Project BUDGETING AND FINANCE Budgeting  Start with the CPI data.  1. Follow the link. https://www.bls.gov/re gions/southwest/data/ consumerpriceindexhis torical_us198284_table.pdf This is a safe file. ☺  2. Notice the latest data for 2018.  3. See the picture on the left for the data column to use. Currency  Let’s continue.  1. Find the currency for the country you are visiting.  2. Don’t forget the link for the citation. Projected Budget Value 1. Column G is where you projected budget value goes.. 2. The 5-year projected formula is to the right. 3. Don’t forget the budget total goes in cell G2. Sponsorship.  Let’s get started.  1. Calculate the principal in C4 with the given formula.  2. Use the future value formula that we have used in previous assignments in Cell C8.  Don’t forget the link. You can use the same one from worksheet 1 if you like. Fundraising  Let’s get started.  1. Use the formula given for the total value in 5 years  2. Don’t forget the parenthesis. ☺  3. Your value will be around $6000 depending on the interest rate chosen.  Video https://youtu.be/pu56t kU-c8Q Loans  Let’s get started.  1. The value in Cell I4 should be positive.  2. The value for the payment uses the formula below.  3. The total paid and the total interest is the same as from worksheet 1.  Video https://youtu.be/RnNW xIQmSOQ Choice of Banks  Don’t forget to answer the question concerning the choice of banks. Population Projection.  Let’s get started.  1. Enter the current population and the annual growth rate.  2. Don’t forget the link or citation as your reference.  3. The growth rate is annual so what is n?  4. t is 5 in this case. Video Resources  Excel document of the mission project. https://youtu.be/ZOYTLSx6VoM  This video addresses the PowerPoint https://youtu.be/gxCAZ4GXv2I  Calculating monthly payments https://youtu.be/RnNWxIQmSOQ  Calculating the fundraising https://youtu.be/pu56tkU-c8Q  Population growth example. Start at 1:50 min mark https://www.youtube.com/watch?v=Hv9OqiG3b70&index=2&list=PL07IvA esOPpdip3wED7eElC62KhL9DPD3 MAT-144 Major Assignment #3 Details Overview: You and some of your friends want to travel to another country to provide aid in the form of a mission trip. You have been chosen as the team leader, and your job is to provide a plan for the trip, including a financial plan. This is a big job, and you want to do it right, so you and your team have agreed that the trip will take place 5 years from now. Requirements for the trip: Who: You and 5-10 other individuals will travel to provide aid. When: 5 years in the future. The trip will last 2-4 weeks. This is not a large scale, so you should think carefully about what you can accomplish with a team of this size and time frame. What: This trip’s main purpose will be to fill some sort of tangible need to improve the day-to-day life of the people you meet. Therefore, your first job will be to decide what your team has to offer and to find a location where there is a need for your talents. You should think about what you can do to alleviate human suffering by working in an area of education, health care, basic supplies (such as clothing or home goods), housing, food or clean water, or work to repair the local environment. If you want to include evangelism as a secondary goal, that is fine, but the criteria you will be graded on is how you make a difference in the day-to-day lives of the people you work with. Where: You will travel overseas. To keep your project manageable, you must choose one of the locations on the Country List, which is included as an attachment to this assignment. Because of the size of the team and your time frame, you should narrow down your area within the country to fit your project. For example, you can’t expect to provide vaccines to the entire country of Brazil, but you could reasonably expect to provide this service to a small town in the country. So you will need to find an area within your chosen country to focus on. The people that you serve in this area are members of your target population. Requirements for the assignment: This assignment will have two parts. Part 1: You create a PowerPoint presentation describing the trip and explaining why the specific country has been chosen. The presentation should have a minimum of eight slides – a title slide, one for each category below, and a reference slide. All important information should be on the face of the slides but you can submit speaker notes for greater detail. In addition, you will need a minimum of three scholarly resources (see the resource list below for ideas) and the presentation should address the following areas: 1. An overview of your purpose for the project: Where are going, and what service will you be providing? Remember, evangelism cannot be the sole purpose of your trip or even the primary purpose. 2. Cultural and social aspects of the country and its population that led you to choose this area of the world. 3. How your choice of project works toward fulfillment of the Judeo-Christian-Islamic ideal to love your neighbor as yourself: How does your personal worldview and the possible worldviews of your target population influence your plans for the trip? 4. Information about your target population: Who are you planning to serve? How does this population compare to the population of the country as a whole? You will also need to do a calculation to project either the general or the target population in 5 years in the spreadsheet but it does not need to be discussed in the presentation. The World Factbook provides population growth data to help you here. 5. Information about the economic situation in your country and how your project will improve this. 6. Possible concerns that you need to keep in mind to keep your team and your target population safe. This could be safety from violence or from health problems (for example, will your team need inoculations to travel to the country). Part 2: A financial plan for your trip, which you will include in the provided Excel spreadsheet. Your financial plan needs to include the following information: 1. A list of expenses for all members of your trip. This must include the following: a. Travel expenses, such as plane or bus fare, passports/visas, local travel within the country. Plane fare can be in U.S. dollars, but the local travel will need to be in the local currency of the country you visit. b. Lodging expenses. If you plan to camp, you will include expenses for your camping gear. If you are planning to stay with a host church or host family, you should research the cost of lodging in your target area and provide a per diem donation that is commensurate with the local lodging rates. This will be in the local currency. c. Food expenses while you are overseas. Again, if you are being fed by local residents, you will research the approximate cost to feed your group and provide a per diem donation to cover expenses. One way to do this is to research cost of living in your country to find out what a local family would expect to budget to pay for food. Again, these costs will be in the local currency. d. Supplies for your project. Provide at least four items that you will need to complete your project. Depending on the nature of your project, these might be in U.S. dollars, or in the local currency, or they may be a mix. e. For your expenses that are given in the local currency, a conversion to U.S. dollars. f. For each expense, you will use the CPI data from the Bureau of Labor Statistics to calculate your estimated expense 5 years in the future. g. A grand total of all projected expenses 5 years from now. 2. Funding sources for your trip. a. Sponsorship: You are going to assume that you can find a sponsor who can provide 30% of your grand total of all expenses for seed money, and you will invest that money in a savings account for the next 5 years. Research current savings rates and calculate what this amount will grow to over the next 5 years. b. Savings: Your team will work on various fundraisers to save for the trip, and you estimate that you can raise $100 a month every month over the next 5 years, which you will also put into a savings account. Using the savings rates you found in part a., calculate what these regular savings amounts will grow to over the next 5 years. c. Loan: If your sponsorship and savings totals do not cover your expenses, then you will need to take out a loan for the remainder of your expenses. Even if your sponsorship and savings total do cover all expenses, then you will take out a $10,000 loan for an additional emergency cushion. Research loan rates from two banks, and calculate the monthly payment, total that you pay back to the bank and total interest you will pay for each loan. You will indicate in the spreadsheet which of the two loans is a better choice for you and your reasons why. Resources You should plan to use the following resources to help you with your plan. You can also use other resources, but at a minimum, you will need the Excel Budget Spreadsheet, BLS CPI data, and CIA World Factbook. Additionally, your paper requires three scholarly sources. • • • • • • • Country list.docx: Includes the list of countries you are allowed to choose from for this project, along with some important facts about the country’s make up. Bureau of Labor Statistics Consumer Price Data information: https://data.bls.gov/cgibin/surveymost?cu which is the same as on Worksheet 2. CIA World Fact Book: You must use this source. You will find that it contains a wealth of demographic, economic, and cultural information about your country. https://www.cia.gov/library/publications/the-world-factbook/ U.S. Department of State website: This site will give you important information about your country, as well as information about travel overseas. https://travel.state.gov/content/travel/en/international-travel/International-Travel-CountryInformation-Pages.html Excel Budget Spreadsheet: Attached to the assignment directions, and provides a compact way to explain your budget and funding. Your course textbook GCU Library Tips and formulas: • • • • This assignment uses a rubric. Please be sure to look at the grading criteria and point values for each area of the rubric to see how you will be graded on this assignment. Compound interest formula (also called the Lump Sum Investment formula) formatted for EXCEL: A = P * ((1 + r/n)^(n * t). o A is the accrued amount after t years that the principal, P, grows to at interest rate, r%, compounded n times each year. Regular payments formula (also called the Savings Plan formula) formatted for EXCEL: A = PMT * ((1 + r/n)^(n * t)-1)/(r/n). o A is the accrued amount after t years of making regular payments, PMT, into an account at interest rate, r%, compounded n times each year. Loan payment formula formatted for EXCEL: PMT = P * (r/n)/(1 – (1 + r/n)^(-n*t)). o • PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years. Percent change IR = (new CPI – old CPI)/old CPI where IR is inflation rate. A = P*(1 + r/n) ^ (n*t) Where: A = the future value of the investment/loan, including interest P = the principal investment amount (the initial deposit or loan amount) r = the annual interest rate (decimal) n = the number of times that interest is compounded per year t = the number of years the money is invested or borrowed for Your mission trip will require you to calculate the account balance of a savings account from a sponsorship. You will invest a certain percent of your budget. The investment calculation you show should be the same process you are discussing in this discussion question. Complete your discussion question in Excel so you can copy and paste the work to your mission trip Excel document.
Purchase answer to see full attachment