Refer to Mission Project attachments (Major Assignment 3, Major Assignment 3 Details, and Country List)
Research the country using The World Factbook found on the Central Intelligence Agency website at https://www.cia.gov/library/publications/the-world…, other resources such as the U.S. Department of State website at https://travel.state.gov/content/travel.html, and the GCU Library.
Include three or more scholarly resources, including the textbook and The World Factbook.
Use the Country List to help you complete Mission Project.
Prepare this assignment according to the guidelines found in the GCU Style Guides and Templates, located in the Student Success Center.
This assignment uses a rubric. Review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.
Attempt Start Date: 15-Apr-2019 at 12:00:00 AM
Due Date: 21-Apr-2019 at 11:59:59 PM
Next week you have your major assignment due on Sunday. It is a very time consuming assignment, so I suggest looking ahead at the assignment. We have covered most of the calculations in our discussion questions or on past worksheets. Please look back through your work and the forum for assistance.
I wanted to give you the information early. Here are a few videos for the mission trip. Your assignment includes a PowerPoint and Excel calculations. When you submit your assignment, I need the Excel document with your work and then the PowerPoint.
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=PL07IvAesOPpdip3wED7eElC62KhL9DPD3
Major assignment 3 Try calculating the end balance for this donation. Then save your work for your major assignment 3 in week 6.(week 6 assignment)
In week 6 you will be asked to calculate the projected savings account for a company that is going to donate $100 per month for 5 years. Here is a similar problem.
- A corporate entity has pledged to make monthly contributions of $50. This money is to be invested in a savings account. Using information from an internet source, determine the current interest rate on savings accounts and use the information to figure out how much will be in the account at the end of 5 years.
A(t) = (PMT*((1+r/N)^(N*t)-1))/(r/n)
Here PMT = the monthly contributions, r = annual interest rate as a decimal, N = number of times compounded annually (12 times – once per month), t = time of the loan in years, A(t) = value of account after t years.
Resource video https://youtu.be/pu56tkU-c8Q
Population growth projection practice for major assignment 3
Go to The World Factbook on the CIA website at https://www.cia.gov/library/publications/the-world-factbook/geos/xx.html to find the current population and growth rate for a country of your choice. Use the population growth model below to predict the population of the country 1 year from now, 10 years from now, 100 years from now, and 1000 years from now. Are all of these predictions appropriate? Why?
Use the model = P0*(1 + r)^t where
P0 = current population
r = the population growth rate
t = time in years from now
P(t) = population t years from now
For your mission trip you need to submit a PowerPoint and an Excel document. Here are the directions for submitting two documents to the drop box.
The formula for annual compound interest is A = P*(1 + r/n) ^ (n*t). Please use Excel. Save work for mission project.
A = P*(1 + r/n) ^ (n*t)
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.