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.
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.
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.
invest 30% of budget balance for 5 years
total in 5 years
$100 monthly for 5 years
n=periods per year
t=# of years
total in 5 years
A sponsor has offered to cover 30% of the project cost (
loan minimum $19,247
n=# periods per year
t= # of years
Bank of America
to cover 30% of the project cost ($12,000) as part of their CSR initiatives. This amount will be put in a savings account.
I would take the Bank of America loan over the Wells Fargo loan as the former has a lower interest charge than the latter.
nterest charge than the latter.
price each (local)
price each (US)
total price (US)
supplies & misc
safe water system
Delta Airlines provides competitive flight rates from different cities in the US to Freetown.
the minibus will ferry the ten group members together with their luggage to our residence in Makena
the cabs will carry the project team from the residence to the village everyday over the four week per
the drivers will stay with the team for the period of the trip and will serve as cultural translators.
the rate of inflation in the US is 8% and was used for the projected freight cost while the rate in Sierra
the team will stay at the hotel for on the night of arrival and the night of departure.
the team will stay at a private residence that we have leased for 30 d...