RM$711$: Homework for Module $4$

Imagine that you borrowed $$10,000$ on a credit card with a variable rate. Imagine you will make interest payments only and the principal will be paid separately at the end.

The monthly interest only payment will be based on the larger of:

$1)$ The prime rate, or$,$

$2)21\mathrm{.}25\%$ APR

Create a VBA function to calculate the loan$$s payment. Test it out on the dataset provided.

When finished, send your file to me via GMAIL $($as an XLSM file$).$