MAT Major Assignment 3
Expenses
| 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 | |||||
| (Add rows as needed) | Number | Number | Formula | ||||
| Lodging | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) |
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 | number | Link or citation | r | number | Link or citation | r | number | Link or citation | number | Link or citation | Must be different rates |
| n | number | n | number | n | number | number | |||||
| t | number | t | number | t | number | number | Must be different years | ||||
| Total in 5 years | Formula | Total in 5 years | Formula | Payment | Formula | Formula | |||||
| Total Paid | Formula | Formula | |||||||||
| Total interest | Formula | Formula | |||||||||
| Population Projection | |||||||||||
| Current population | Number | ||||||||||
| Annual Growth Rate | Number | Link or citation | |||||||||
| Projected Population | Formula |
In complete sentences and with complete reasoning, please answer which bank gives the better loan deal? Why? Answer: