This video shows how to use the RATE function to find the maximum interest rate a borrower can tolerate and using the NPER function to determine the number of periods needed to pay off a loan given the size and annual rate for the loan.
These are the two files needed to follow along to this video:
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
