MATH
iabepdadm
MajorAssignment3OFTF0826193.xlsxExpenses
| U.S. Currency | ||||||||||||
| Total 5 year Budget Projection | Formula | (see detail below) | Conversion Rate | |||||||||
| Local currency | U.S. currency | Source | ||||||||||
| Transportation | Number | Number | Link or citation | |||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price (US) | Source | ||||||
| Description | numbers | number or NA | Number or NA | Formulas | Formulas | Link or citation | Inflation Rate | |||||
| CPI (Five Years Ago) | CPI (Today) | Inflation Rate | Take from Major Assignment 2 or follow instructions below | |||||||||
| (Add rows as needed) | Number | Number | Formula | |||||||||
| Lodging | ||||||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price | You should just use information from Major Assignment 2, but if you want to retrieve fresh CPI data, here 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 five years earlier to estimate the price of your trip in five years and the five year inflation rate. | ||||||
| Description | numbers | number or NA | Number or NA | Formulas | Formulas | Link or citation | ||||||
| (add rows as needed) | ||||||||||||
| Food | ||||||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price | |||||||
| Description | numbers | number or NA | Number or NA | Formulas | Formulas | Link or citation | ||||||
| (add rows as needed) | CPI Data Link | |||||||||||
| Supplies and Misc | ||||||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price | |||||||
| Numbers | numbers | number or NA | Number or NA | Formulas | Formulas | Link or citation | ||||||
| (add rows as needed) | ||||||||||||
| Like Major Assignment 2. 5 year projected budget | ||||||||||||
Funding-Population Projection
| Sponsorship | Fundraising | Loan (remainder of trip expenses, or minimum of $10,000) | ||||||||||
| Invest 30% of budget balance for 5 years | $100 monthly for 5 years | Bank A | Bank B | |||||||||
| Principal | formula | Payment | 100 | Principal | Formula | Formula | ||||||
| r = APR | number | Link or citation | r = APR | number | Link or citation | r = APR | number | Link or citation | number | Link or citation | Must be different rates | |
| n = # periods per year | number | n = # periods per year | number | n = # periods per year | number | number | ||||||
| t = # of years | number | t = # of years | number | t = # of years | number | number | Must be different years | |||||
| Total in 5 years | formula | Total in 5 years | formula | Payment | formula | formula | ||||||
| Like Topic 6 DQ 1 | Like Topic 5 DQ 2 | |||||||||||
| Total Paid | formula | formula | ||||||||||
| Total interest | formula | formula | ||||||||||
| Like Major Assignment 1 Loan Tab | ||||||||||||
| Population Projection | Discuss the reasons for choosing one loan over the other. | |||||||||||
| Current population | Number | |||||||||||
| Annual Growth Rate | Number | Link or citation | ||||||||||
| Projected Population | formula | |||||||||||
| Like Topic 6 DQ 1 | ||||||||||||
