At this time, the fill handle will appear.Following, place your cursor in the bottom right position of your cell. As a result, you will get the weekly compounding discount factor for 1 year.You can do this by simply pressing the F4 key. As our interest rate is fixed in our dataset, we made the interest rate cell absolute by putting dollar signs.Here, we have used 52 as n’s value, because we are calculating the weekly compounding discount factor here and there are 52 weeks in a year.Initially, click on the D5 cell where you want to put the required formula.If you are given a compound rate per week, then you have to calculate the discount factor as weekly compounding. Compute Discount Factor Compounding on Weekly Basis And, the result sheet will look like this. Thus, we can calculate discount factors for any year in Excel. Subsequently, drag the fill handle below to copy the formula below for all. Following, the fill handle will appear.Now, place your cursor in the bottom right position of your cell. At this time, you have got the daily compounding discount factor for 1 year.As our interest rate is fixed here, that’s why we made the interest rate cell absolute by putting dollar signs.Here, we have used 365 as n’s value, as it is the daily compounding discount factor calculation and there are 365 days in a year.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |