Question

Ques 1. Write a Macro – Function in MS
Excel to find the Simple Interest for the
given values of principle, rate and time.
(Hint: Use the function to access the values from the cell directly.
formula-PXRXT % 100)
​

Answer 1

• A = Total Accrued Amount (Principal + Interest)
• P = Principal Amount.
• I = Interest Amount.
• r = Rate of Interest per year (r = R/100)
• R = Rate of Interest per year as a percent; R = r * 100.
• t = Tenure (the time period in months or year)