8.7.28 EaR Distribution by Year Forecasted

Table 8-17 EaR Distribution by Year Forecasted

Report Name(s)	EaR Distrubution By Year Forecasted
Description	Reports displays earnings results with each year of forecast aligned for comparison.
Dashboards Prompts	Prompt EAR_002 As of Date Prompt EAR Process Process Prompt EAR Bucket End Date Bucket End Date Prompt Earning at Risk Set # of Bins Prompt EAR Leg Type Product Type
Report Criteria	"Calendar - ALM Results"."Per Name Year" "Earnings-at-Risk".Earnings "Earnings-at-Risk"."Rate Path Num" floor(@{EAR_001}{20}*(Case when "Earnings-at-Risk".Earnings = min("Earnings-at-Risk".Earnings by "Calendar - ALM Results"."Per Name Year") then 0.01 when "Earnings-at-Risk".Earnings = max("Earnings-at-Risk".Earnings by "Calendar - ALM Results"."Per Name Year" ) then 0.99 else ("Earnings-at-Risk".Earningsmin(" Earnings-at-Risk".Earnings by "Calendar - ALM Results"."Per Name Year" )) / (max("Earnings-at-Risk".Earnings by "Calendar - ALM Results"."Per Name Year" ) -MIN("Earnings-at-Risk".Earnings by "Calendar - ALM Results"."Per Name Year" )) end))+1
Conditions	< None >
Compound Layout	Title Pivot Table Pivot Table (2) Graph