TIPS Interest and Par Value - Excel ? x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In IHI Calibri 11 I A Paste BIU % Alignment Number Conditional Format as Cell Formatting* Table Styles Styles Cells Editing Clipboard Font A1 B D E F . 1 J 2 3 4 A 3.125 percent TIPS has an original reference CPI of 185.1. If the current CPI is 210.4, what is the par value and current interest payment of the TIPS? (Do not round intermediate calculations and round your final answers to 2 decimal places.) 5 6 7 8 Interest rate Reference CPI Current CPI 3.125% 185.1 210.4 9 10 11 12 Complete the following analysis. Do not hard code values in your calculations. 13 14 15 Par value Interest payment 16 17 18 19 20 Sheet1 READY E EN + 70% Attemntis)