hello

1) when we take life= (maturity-value)/365 what does it mean

2)what is pending amount left after 21/7/2019(explain equation)

3) there is something wrong with pending amount... because issue two matured thus it should have zero pendimg amount ... but it doesnot

;((((Please I want clear explanations ..

thanks

1. 

Excel File Edit View Insert Format Tools Data Window Help Je 77 DA Sat 7:45 AM Q DE question Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View "+ Share ~ Calibri (Body) 11 A- A- Number Conditional Formatting Insert Format as Table x Delete Q Paste BI U A P.0 DE 9 % .00 00 .0 Cell Styles Format Editing $6 A X V fx =(N6-(P6*R6)) B C D E F G H I J K L M N P Q R S T 7/21/19 Yearly # of life*= coupon Interest(coupon Total coupon |# of years we | Remaining # pending issue value maturity| life bond rate coupon (maturity- number of payment payments= days 1st 6mth (1st payment ) for the life payment(intere | paid coupon of coupon amount(out life * 2 value)/365 6mth+2nd whole life st) alredy paid payments payments standing till today (years) (years) amount) 6 mth) W N - 1/1/16 4/21/21 5 20.000 2.5000 10 5.30684932 181 0.248 0.496 2.653 2.65 -2.653 7/13/16 5/5/19 3 30.000 2.0000 6 2.8109589 190 0.312 0.625 1.687 1.69 N 1.687 7/27/16 7/19/23 40.000 3.0000 14 6.98082192 180 0.592 1.184 8.377 3.38 -33.508 6/6/19 9/19/25 50.000 3.2500 14 6.29315068 190 0.846 1.692 10.226 .0.23 ON W W 61.358 1) when we take life= (maturity-value)/365 what does it mean 2)what is pending amount left after 21/7/2019(explain equation) 3) there is something wrong with pending amount... because issue two matured thus it should have zero pending amount ... but it doesnot ;(((( Please I want clear explanations .. 21 22 Sheet1 Sheet2 Sheet3 Sheet4 jan feb Ready + 78% JUL 20 .... W X Ai EXESX