Solve for Monthly Payments with Actual/365 and Actual/360 Loans

Calculating the monthly payment on loans with dates can be tricky, unless the loan assumes all months have 30 days and there are 12 months in a year (30/360). In that case you can use the Excel PMT function. It is more difficult however to calculate a monthly payment that will pay off a loan […]

Simple Break-Even for Solar Installation. (Excel)

This Excel spreadsheet is the result of a reader asking for help creating a simple method of determining the break-even point for a solar power installation. It involves taking out a loan and applying the expected savings on the utility bill against the loan payments. The critical variables are: How much will initially be saved […]