move values from one spread sheetto another
helpmeout11
20170906200702copy_of_misson_trip_part_2.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 | ||||||
| Breakfast | 5 | 12 | Number or NA | 60 | 0 | 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:
1
2
3
4
5
6
7
8
9
10
A
B
C
D
E
Total 5 year Budget Projection
Item
Qty
Price each (Local)
Price each (US)
Description
numbers
number or NA
Number or NA
(Add rows as needed)
Item
Qty
Price each (Local)
Price each (US)
Transportation
Lodging
