Answer:
4.13%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet. Kindly find the attachment below
The NPER represents the time period.
Given that,
Present value = ¥100,000 × 91.53% = ¥91,530
Future value or Face value = ¥100,000
PMT = ¥100,000 × 3.4% = ¥3,400
NPER = 16 years
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
After solving this, the yield to maturity is 4.13%