Monthly loan payment
A small calculator: type the rate, years and amount in B1:B3 and see the monthly payment in B4.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Annual rate” in A1
- Write “Years” in A2
- Write “Loan amount” in A3
- Write “Monthly payment” in A4
- Payment formula in B4
- Show B4 as currency
- Bold A4:B4
Use it in MacroRoni: open the Starter gallery, search for "Monthly loan payment", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More calculations macros
CalculationsAdd a totals rowAdd a bold total under column B and show it as currency.Changes data · backup onCalculationsRunning totalAdd a running total of column B in column C.Changes data · backup onCalculationsCount and total one categoryCount the rows where column A says Sales and add up their amounts from column B.Changes data · backup on