Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

You must login to ask question.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

URGENT: Excel Spreadsheet-plan 5 year trip COST

Total 5 year Budget Projection
Transportation
Item
Truck
Plane Tickets
(Add rows as needed)
Qty Price each (Local)
2
10
Price each (US)
11,512.80S/ $
2,777.13S/ $
3,474.00
838.00
Lodging
Item
Hotel
Hotel
Hotel
(add rows as needed)
Qty Price each (Local)
1
7,084.01S/
1
5,440.46S/
1
3,006.46S/
Price each (US)
$
2,137.60
$
1,641.60
$
907.20
Food
Item
Lunch
Dinner
Water
Qty Price each (Local)
27
15S/
27
60S/
135
1.58S/
Price each (US)
$
4.52
$
18.08
$
0.48
Supplies and Misc
Item
Gas 19g tank
Hand Sanitizer x4
Medical Gloves x1000
Bug Spray x12
Body Wash
Qty Price each (Local)
474
13.48S/
20
2
3
30
Price each (US)
$
4.06
$
67.62
$
49.99
$
69.24
$
4.88
U.S. Currency
Formula
Conversion Rate
(see detail below)
Local currency
rtation
Number
Total price (US)
$
$
Projected Price (US)
6,948.00
8,380.00
Source
https://avis-int.com/res/prereservation.php
Inflation Rate
https://www.tripadvisor.com/CheapFlightsSearchResults?geo=294316&cos=0&no
CPI (Five Years Ago)
Number
ing
Total price (US) Projected Price
$
2,137.60 Formulas
$
1,641.60
$
907.20
https://www.booking.com/hotel/pe/parthenon-y-eventos.html?aid=356281;labe
d
Total price (US) Projected Price
122.04 Formulas
488.16
64.8
https://www.numbeo.com/cost-of-living/country_result.jsp?country=Peru
nd Misc
Total price (US) Projected Price
$
1,924.44 Formulas
$
1,352.40
$
99.98
$
207.72
$
146.40
https://www.numbeo.com/cost-of-living/country_result.jsp?country=Peru

https://www.amazon.com/
https://www.amazon.com/
https://www.amazon.com/
Conversion Rate
U.S. currency
Source
Number
Link or citation
Inflation Rate
CPI (Today)
Number
Inflation Rate
Formula
enon-y-eventos.html?aid=356281;label=metatripad-link-dmetaus-hotel-545781_xqdz-0b23cb4045b474b8528beb8f30c1462e_los-27_bw
ountry_result.jsp?country=Peru
ountry_result.jsp?country=Peru
/ref=twister_B07G98Q123?_encoding=UTF8&psc=1
28beb8f30c1462e_los-27_bw-002_dom-com_curr-USD_gst-05_nrm-02_clkid-W3nKlAoQJGgAALa8svoAAADC_aud-0000_mbl-M_pd-B_sc-
AADC_aud-0000_mbl-M_pd-B_sc-2_defdate-0;sid=c19053d3703a1392a421ce7790b2bf36;all_sr_blocks=132783403_103403146_0_41_0
=132783403_103403146_0_41_0%2C132783403_103403146_0_41_0%2C132783402_103403146_0_41_0%2C132783401_103403146_0
1_0%2C132783401_103403146_0_41_0%2C132783401_103403146_0_41_0;checkin=2018-08-22;checkout=2018-09-18;dest_id=-35003
kout=2018-09-18;dest_id=-350039;dest_type=city;dist=0;group_adults=10;group_children=0;hapos=1;highlighted_blocks=132783401_1
highlighted_blocks=132783401_103403146_0_41_0%2C132783402_103403146_0_41_0%2C132783403_103403146_0_41_0;highlighted
3_103403146_0_41_0;highlighted_facilites=2;hpos=1;nflt=mealplan%3D1%3Bhotelfacility%3D2;no_rooms=5;req_adults=10;req_children
ms=5;req_adults=10;req_children=0;room1=A%2CA;room2=A%2CA;room3=A%2CA;room4=A%2CA;room5=A%2CA;sb_price_type=total;
m5=A%2CA;sb_price_type=total;srepoch=1534708475;srfid=e9032d792268c8fdc6ca00b2148d3e595bdcfe58X1;srpvid=0b4f8bfc7505036
dcfe58X1;srpvid=0b4f8bfc75050362;type=total;ucfs=1&
Sponsorship
Fundraising
Invest 30% of budget balance for 5
years
Principal
Formula
r
number
n
number
t
number
Total in 5 years
Formula
Link or citation
$100 monthly for 5 years
Payment
r
number
n
number
t
number
Total in 5 years
Formula
100
Population Projection
Current population
Annual Growth Rate
Projected Population
Number
Number
Formula
Link or citation
Loan (remainder of trip expenses, or minimum of $10,000)
Link or citation
Principal
r
n
t
Payment
Total Paid
Total interest
Bank A
$
10,000.00
14.59% https://www.navyfederal.org/products-services/loans/
number
$
8
1,000.00
Formula
Formula
In complete sentences and with complete reasoning, please answer which bank
Answer:
ses, or minimum of $10,000)
Bank B
$
10,000.00
9.24% https://www.wellsfargo.com/personal-credit/rate-and-payment-calculator/#Good
Must be different rates
number
$
10
244.00
Formula
Formula
wer which bank gives the better loan deal? Why?
Must be different years
MAT-144 Mission Trip Assignment 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 will write a 1250 – 1500 word narrative describing the trip. This is a report, written in GCU
style. You will need a minimum of three scholarly resources (see the resource list below for ideas) and
needs to 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.
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 make a
projection about the target population in 5 years. The World Factbook provides population
growth data to help you here. See the Tips and formulas section below for information about
how to present this in your paper.
5. Aspects of the country that make it a suitable location for your trip. In particular, include
information about –
a. The economic situation in your country and how your project will improve this.
b. 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 five years in the future.
g. A grand total of all projected expenses five years from now.
2. Funding sources for your trip.
a. Sponsorship: You are going to assume that you can find a sponsor that 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 five years. Research current savings rates and calculate
what this amount will grow to over the next five 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 five 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 five 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: http://www.bls.gov/cpi/tables.htm
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.
http://travel.state.gov/content/travel/english.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
GCU Writing Center: your paper will need to be formatted in GCU style.
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.
Microsoft Word Equation Editor: required for formatting your population growth calculations
and any other mathematical calculations in your paper.
𝑟 𝑛𝑡
Compound interest formula: 𝐴 = 𝑃 (1 + 𝑛) .
o

Regular payments formula: A = 𝑃𝑀𝑇
o

A is the accrued amount after t years that the principal, P, grows to at interest rate, r%,
compounded n times each year.
.
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: 𝑃𝑀𝑇 =
o
𝑟 𝑛𝑡
−1
𝑛
𝑟
𝑛
(1+ )
𝑟
𝑛
𝑟 −𝑛𝑡
1−(1+ )
𝑛
𝑃( )
.
PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n
times per year for t years.


𝐶𝑃𝐼 𝑌𝑒𝑎𝑟 1
𝐶𝑃𝐼 𝑌𝑒𝑎𝑟 2
𝑃𝑟𝑖𝑐𝑒 𝑌𝑒𝑎𝑟 1
= 𝑃𝑟𝑖𝑐𝑒 𝑌𝑒𝑎𝑟 2
Inflation rate = relative change in Price.

Purchase answer to see full
attachment

aalan

Leave a comment