Question: How do you calculate the answer in column D as in 'where did the number 15 or 20 come from? (as shown in the formula

How do you calculate the answer in column D as in 'where did the number 15 or 20 come from? (as shown in the formula bar like 15+21/30) Could you please explain? I understand it's the date divided by the number ofb days in the month, but the what about that 15 or 20 come from?https://www.asx.com.au/documents/products/ASX_Bond_Monthly_Update_June_2019.pdf

D7 X V fx =15+21/30 A B C D 1 Government Bonds as at June 30" 2019 https://www.asx.com.au/documents/products/ASX Bond Mo 2 ASX Code Description Maturity Date Months from June 30, 2017 3 GSBS19 Treasury Bond 2.75 % 21-10-19 Semi 21-Oct-19 0.68 4 Interpolation 6.00 5 GSBG20 Treasury Bond 4.50% 15-04-20 Semi 15-Apr-20 6.50 6 Interpolation 12.00 7 GSBU20 Treasury Bond 1.75% 21-11-20 Semi 21-Nov-20 15.70 8 Interpolation 18.00 9 GSB121 Treasury Bond 5.75% 15-05-21 Semi 15-May-21 20.48 10 Interpolation 24.00 11 GSBW21 Treasury Bond 2.00% 21-12-21 Semi 21-Dec-21 27.68 12 Interpolation 30.00 13 GSBM22 Treasury Bond 5.75% 15-07-22 Semi 15-Jul-22 33.48 14 Interpolation 36.00 15 GSBU22 Treasury Bond 2.25% 21-11-22 Semi 21-Nov-22 40.70 16 Interpolation 42.00 17 GSBG23 Treasury Bond 5.50% 21-04-23 Semi 21-Apr-23 46.70 18 Interpolation 48.00 19 GSBG24 Treasury Bond 2.75% 21-04-24 Semi 21-Apr-24 53.70 20 Interpolation 54.00 21 Interpolation 60.00 22 GSBG25 Treasury Bond 3.25% 21-04-25 Semi 21-Apr-25 60.70D9 X V fx =20+15/31 A B C D Government Bonds as at June 30" 2019 https://www.asx.com.au/documents/products/ASX_Bond Mon 2 ASX Code Description Maturity Date Months from June 30, 2017 3 GSBS19 Treasury Bond 2.75 % 21-10-19 Semi 21-Oct-19 0.68 4 Interpolation 6.00 5 GSBG20 Treasury Bond 4.50% 15-04-20 Semi 15-Apr-20 6.50 6 Interpolation 12.00 7 GSBU20 Treasury Bond 1.75% 21-11-20 Semi 21-Nov-20 15.70 8 Interpolation 18.00 9 GSB121 Treasury Bond 5.75% 15-05-21 Semi 15-May-21 20.48 10 Interpolation 24.00 11 GSBW21 Treasury Bond 2.00% 21-12-21 Semi 21-Dec-21 27.68 12 Interpolation 30.00 13 GSBM22 Treasury Bond 5.75% 15-07-22 Semi 15-Jul-22 33.48 14 Interpolation 36.00 15 GSBU22 Treasury Bond 2.25% 21-11-22 Semi 21-Nov-22 40.70 16 Interpolation 42.00 17 GSBG23 Treasury Bond 5.50% 21-04-23 Semi 21-Apr-23 46.70 18 Interpolation 48.00 19 GSBG24 Treasury Bond 2.75% 21-04-24 Semi 21-Apr-24 53.70 20 Interpolation 54.00 21 Interpolation 60.00 22 GSBG25 Treasury Bond 3.25% 21-04-25 Semi 21-Apr-25 60.70

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Your tax senior has e-mailed you Oh Gnome You Didn't, Inc.'s GAAP-basis trial balance and financial statements for the 2018 calendar year, prepared using Microsoft Excel, and has asked you to convert...

File Home Insert Page Layout Formulas Data Review View Help Share Con Split View Side by Side Default Ruler Formula Bar Normal Page Break Page Custom New Arrange Freeze Hide IDI Synchronous Scrolling...

QUESTION 1 The following data on the weekly online gaming time (in hours) of a sample of college students is as follows: 5, 11, 25, 19, 18, 20, 27, 13, 8, 10, 15, 19, 18, 9, and 12. Compute the...

question 2 The following data represent the weekly working hours of a sample of 25 employees: 31, 43, 56, 23, 49, 42, 33, 61, 44, 28, 48, 38, 44, 35, 40, 64, 52, 42, 47, 39, 53, 27, 36, 35, and 20....

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Please answer questions 1-4 with provided information Required information (The following information applies to the questions displayed below.) The Munchkin Theater is a nonprofit organization...

Figure 3. GPA study data. You can download the GPAs spreadsheet and use it for the exercises. Step 1: Analyzing the Grades Sue thinks that students are more motivated to do well in their major...

Don't answer my question if you are not going to attach the excel file! thank you Excel 2016 Skills Skill Review 1.1 X + -ox E C O File...

The payroll register for Ritchie Manufacturing Co. for the week ended September 14, 2012, is presented in the working papers. Instructions 1. Journalize the entry to record the payroll for the week....

Question 15 The reaction of chlorine molecule with potassium iodide yields iodine molecule and potassium chloride. Write a balanced chemical equation for this reaction. Cl2(g) + KI(s) I(s) + KCl2(s)...

The balance sheet shows what assets the firm controls at a point in time and how it financed the assets Question 1 options: TrueFalse

Specifically, how to calculate the ending balance? How did theyarrive at the interest income value? Please show the working notes.Thank you! :) Amy and Mitchell share equally (50\\%) in the profits,...