Answer:
4.58%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet. Â
The NPER represents the time period. Â
Given that, Â
Present value = ($1,000 × 7%) ÷ 5.74% = $1,219.52
Assuming figure - Future value or Face value = $1,000 Â
PMT = 1,000 × 7% = $70
NPER = 12 years
The formula is shown below: Â
= Rate(NPER,PMT,-PV,FV,type) Â
The present value come in negative Â
So, after solving this, the answer would be 4.58%