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 […]

U.S Treasury Daily Yield Curves From 1/2/1990-Present

Warning: Some MS 365 formulas that might not work with prior versions of Excel. Back in April I publish a post called Daily Treasury Security Rates. That post featured an Excel workbook that downloaded U.S. Treasury rates for the current month. This new workbook has Treasury rates starting 1/2/1990 and can be updated daily, when the […]