amortization schedule
Budget: $10 – $30 USD
I need a single comprehensive amortization schedule with a variable interest rate ( upper and lower caps for interest rates), under different payment frequency options with variable tenures in Excel. Also, the results of different scenarios are in graphical form.
Loan amount 30 M USD
Fixed Libor rate 12.00 %
(change in rate ) +2.5% to -2.5%
Tenure 5 to 20 years ( any time period)
payment frequency monthly/quaterly/semmiannualy/annulay
Loan amount 30 M USD
Fixed Libor rate 12.00 %
(change in rate ) +2.5% to -2.5%
Tenure 5 to 20 years ( any time period)
payment frequency monthly/quaterly/semmiannualy/annulay