math
Carterslife
MajorAssignment3.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 | |||||||||
| (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:
