Having complete power over your files at any moment is vital to relieve your daily tasks and improve your efficiency. Achieve any objective with DocHub tools for document management and practical PDF editing. Gain access, adjust and save and incorporate your workflows along with other safe cloud storage.
DocHub offers you lossless editing, the chance to work with any formatting, and securely eSign papers without having looking for a third-party eSignature option. Maximum benefit from the file management solutions in one place. Consider all DocHub capabilities right now with the free profile.
today were going to be talking about loan amortization tables uh specifically with an extra payments added feature within excel all right so a loan amortization table is super useful in determining how much principal or how much interest youll be paying for a loan each month or the lifetime of a loan the total amount that youd be paying and and so on so to kind of start a loan amortization table you need to know three things you need to know the the loan the loan amount the the interest rate and the periods are the number of years that that loan is going to be lasting for right so lets say we want to take out 150 000 loan um with a 5.5 percent interest rate over 30 years all right um so with this information what we need to do is calculate the payment in order to start this table um so we need to know the present value the rate and the number of periods or in this case that will be monthly and the rate also needs to be translated to monthly because were trying to find the payment