Total 5 year Budget Projection U.S. Currency Formula (see detail below) Local currency Conversion Rate U.S. currency Number Source Number Link or citation Projected Price (US) Source Formulas Link or citation Transportation Item Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Number or NA Formulas Plane Ticket 6 (Add rows as needed) Lodging Item Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Number or NA Formulas Inflation Rate CPI (Five Years Ago) CPI (Today) Number Number Inflation Rate Formula Take from Major Assignment 2 or follow instructions below Projected Price Formulas Link or citation (add rows as needed) Food Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Number or NA Formulas 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. Item Projected Price Formulas Link or citation CPI Data Link (add rows as needed) Supplies and Misc Item Qty Price each (Local) Price each (US) Total price (US) Numbers numbers number or NA Number or NA Formulas (add rows as needed) Projected Price Formulas Link or citation Like Major Assignment 2. 5 year projected budget Activate Windows Total 5 year Budget Projection U.S. Currency Formula (see detail below) Local currency Conversion Rate U.S. currency Number Source Number Link or citation Projected Price (US) Source Formulas Link or citation Transportation Item Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Number or NA Formulas Plane Ticket 6 (Add rows as needed) Lodging Item Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Number or NA Formulas Inflation Rate CPI (Five Years Ago) CPI (Today) Number Number Inflation Rate Formula Take from Major Assignment 2 or follow instructions below Projected Price Formulas Link or citation (add rows as needed) Food Qty Price each (Local) Price each (US) Total price (US) Description numbers number or NA Number or NA Formulas 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. Item Projected Price Formulas Link or citation CPI Data Link (add rows as needed) Supplies and Misc Item Qty Price each (Local) Price each (US) Total price (US) Numbers numbers number or NA Number or NA Formulas (add rows as needed) Projected Price Formulas Link or citation Like Major Assignment 2. 5 year projected budget Activate Windows
