Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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.1947

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions