MATH
iabepdadm
COMMENTS-MODULE-6MAJORASSIGNMENT_3-5yearsbudgetprojection12...2.xlsxExpenses
| U.S. Currency | |||||||||||||
| Total 5 year Budget Projection | Formula tc={9B8026C0-BCFC-4C63-A4E8-EB09E733682E}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: this will be the total of all the prjected prices | (see detail below) | Conversion Rate | ||||||||||
| Local currency | U.S. currency | Source | |||||||||||
| Transportation | 2300 | $1 | Link or citation | ||||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price (US) | Source | |||||||
| plane fare | 10 | 1,150,000 | $500 | $5,000 | $5,977.50 | Link or citation | Inflation Rate | ||||||
| bus fare | 10 | 460,000 | $200 | $2,000 | $467 | CPI (Five Years Ago) | CPI (Today) | Inflation Rate | Take from Major Assignment 2 or follow instructions below | ||||
| (Add rows as needed) | 237.5 | 257.05 | 0.1955 tc={6BD5387E-03C2-489D-B2C6-34A0C65E7A98}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Ok here we go. I am doing this from Denver airport. the formula here will be (k8-j8)/j8. the problem was that you dived by 100 |
||||||||||
| 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. | |||||||
| restaurant | 4 | 115,000 | $50 | $200 | $46.74 tc={1B17FB58-7AA0-478D-B71A-651608AF41C8}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: here the formula is this: curent price*(1+inflation) for this specific cell, that means f11*(1+L8). so you can follow the same process for all the projected price. |
tc={6BD5387E-03C2-489D-B2C6-34A0C65E7A98}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Ok here we go. I am doing this from Denver airport. the formula here will be (k8-j8)/j8. the problem was that you dived by 100 |
tc={9B8026C0-BCFC-4C63-A4E8-EB09E733682E}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: this will be the total of all the prjected prices | Link or citation | |||||
| host family | 6 | 161,000 | $70 | $420 | $98.16 | ||||||||
| (add rows as needed) | |||||||||||||
| Food | |||||||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price | ||||||||
| local resident food | 4 | 230000 | $100 | $400 | $93.49 | Link or citation | |||||||
| hotel food | 6 | 345000 | $150 | $900 | $1,075.95 | ||||||||
| (add rows as needed) | CPI Data Link | ||||||||||||
| Supplies and Misc | |||||||||||||
| Item | Qty | Price each (Local) | Price each (US) | Total price (US) | Projected Price | ||||||||
| 10 | 200 | 138000 | $60 | $120,000 | $23,460 | 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 | In this trip, the team has chosen to use sponsorship since it will allow them to have all thefinancial resources at the beginning of the trip. The team will be allowed to invest some of the money which will ensure that the money keeps on increasing within the given time frame. | ||||||||||
| Annual Growth Rate | Number | Link or citation | ||||||||||
| Projected Population | formula | |||||||||||
| Like Topic 6 DQ 1 | ||||||||||||
