Solution to mat 144 mission trip assignment details

Part 1: 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, I will need a minimum of three scholarly resources.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.