Excel Forum



Highline Excel Class 49: Spreadsheet To Compare Loans


Debt Analysis with input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Payment , Actual Cash Received, Adjusted APR, and PMT w Balloon.

Conditional Formatting For lowest PMt and lowest Adjusted Interest Rate.

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.