Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
) Suppose you are preparing a data set for CER development. Complete the table below; expressing all historical data points in constant year (FY17) dollars
) Suppose you are preparing a data set for CER development. Complete the table below; expressing all historical data points in constant year (FY17) dollars using the table on the next page.
System | Raw Data | FY17 $M |
System 1 | $166M (FY01) | |
System 2 | $140M (FY06) | |
System 3 | $184M (FY04) | |
System 4 | $182M (FY07) | |
System 5 | $122M (TY02) | |
System 6 | $170M (FY01) | |
System 7 | $198M (TY01) | |
System 8 | $116M (FY05) | |
System 9 | $106M (FY02) | |
System 10 | $100M (FY06) |
Base Year = 2017
100.00% 2 3 4.0000 500.00% Budget Year Index 0.3807 0.4247 Fiscal Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 Raw Index 0.3326 0.3712 0.4243 0.4625 0.4995 0.5165 0.5310 0.5453 0.5616 0.5852 0.6086 0.6348 0.6526 0.6702 0.6836 0.6966 0.7105 0.7233 0.7284 0.7342 0.7445 0.7579 0.7640 0.7716 0.7870 0.8091 0.8341 0.8567 0.8772 0.8904 Weighted Index 0.3938 0.4393 0.4770 0.5045 0.5249 0.5402 0.5589 0.5791 0.6019 0.6255 0.6471 0.6635 0.6802 0.6927 0.7063 0.7175 0.7264 0.7337 0.7423 0.7516 0.7617 0.7714 0.7796 0.7956 0.8192 0.8418 1994 Inflation Rate % 11.80% 11.6096 14.3095 9.00% 8.00% 3.40% 2.B0% 2.70% 3.00% 4.209 4.0096 4.30% 2.8096 2.70% 2.00% 1.909 2.00% 1.80% 0.70% 0.B0% 1.40% 1.80% 0.8096 1.0096 2.00% 2.80% 3.10% 2.70% 2.4096 1.50% 0.80% 2.00% 1.8095 1.50% 1.50% 1995 1996 Budget Year Inflation Rate % 10.17% 11.5596 8.57% 5.75% 4.05% 2.93% 3.46% 3.61% 3.92% 3.93% 3.46 2.53% 2.53% 1.839 1.96% 1.59% 1.2496 1.00% 1.17% 1.25% 1.3496 1.2896 1.06% 2.06% 2.97% 2.76% 51% 2.1896 1.58% 1.4496 1.7196 1.9196 1.50% 1.4296 1.38% 1997 0.4611 0.4877 0.5074 0.5223 0.5403 0.5599 0.5818 0.6047 0.6256 0.6414 0.6576 0.6697 0.6828 0.6936 0.7023 0.7093 0.7176 0.7266 0.7363 0.7458 0.7536 0.7691 0.7920 0.8138 0.8343 0.8524 0.8659 0.8784 0.8934 0.9104 0.9241 0.9373 0.9502 1998 1999 2000 2001 2002 2003 2004 2005 2006 630 egal 2007 0.BB18 0.8957 2008 2009 2010 2011 0.8975 0.9155 0.9319 0.9086 0.9241 0.9418 0.9559 0.9695 0.9829 2012 2013 0.9459 2014 0.9601 2015 2016 2017 2018 2019 2020 2021 0.9646 0.9813 1.0000 1.0196 1.0400 1.109 1.20% 1.80% 1.8096 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 0.9707 0.9823 1.0000 1.0180 1.0384 1.0591 1.0803 1.1019 1.1240 1.1464 1.1694 1.1927 0.9978 1.0151 1.0344 1.0547 1.0758 1.0973 1.1193 1.1417 1.1645 1.1878 1.2115 1.2358 1.0608 1.0820 1.51% 1.74% 1.90% 1.96% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2022 1.1037 2023 2024 2025 2026 1.1258 1.1483 1.1712 1.1947Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started