### Question Description

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)**

**Hello Class,**

**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 = P_{0}*(1 + r)^t where

P_{0} = 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**)

**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.

_{}^{}

_{}^{}_{}^{}

## Final Answer

Attached.

population

growth rate

population in 5 years

6,312,212

2.40%

7106919 7,106,919

invest 30% of budget balance for 5 years

Principal

12,000

r=

2.40%

n=

1

t=

5

total in 5 years

$13,511

workings

1.024

1.1259

13510.8

fundraising

$100 monthly for 5 years

payment

r=

n=periods per year

t=# of years

total in 5 years

workings

112.74%

12.74%

6368.087

total costs

sponsorship

fundraising

balance

A sponsor has offered to cover 30% of the project cost (

100

2.40%

12

5

6,368.09

0.002

$39,126

$13,511

$6,368

$19,247

loan minimum $19,247

principal

r=APR

n=# periods per year

t= # of years

payment

total paid

total interest

workings

Wells Fargo

19,247

5.25%

1

10

Bank of America

19,247

4%

1

10

21,770

2523

20,480

1233

1010.468

1.0525

0.599486

0.400514

2522.926

769.88

1.04

0.675564

0.324436

2372.981

link

to cover 30% of the project cost ($12,000) as part of their CSR initiatives. This amount will be put in a savings account.

decision

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.

Budget

transportation

item

Qty

plane fare

minibus

taxicabs

driver

total

price each (local)

$10

1

3

3

lodging

Freetown

Makeni

price each (US)

950

$300

$30/day

$15/day

total price (US)

$19,000

$600

840

420

10

10

$130

$10

$2,600

$3,000

$3,073.20

$3,546.0

$6,619.20

10

$20

$6,000

$7,092.0

$1

$500

$2,000

$2,500

$2,700.0

total

food

3 meals

supplies & misc

safe water system

other equipment

total

total costs

projected price (US)

$20,520

$708

991.2

495.6

$22,715

100litres

4

$39,126.00

source

link

Link

link

description

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

link

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...

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors