Getting complete power over your papers at any time is important to alleviate your day-to-day duties and enhance your productivity. Accomplish any objective with DocHub tools for document management and convenient PDF file editing. Gain access, adjust and save and incorporate your workflows along with other protected cloud storage services.
DocHub gives you lossless editing, the opportunity to work with any format, and safely eSign documents without searching for a third-party eSignature option. Make the most from the file management solutions in one place. Consider all DocHub capabilities right now with the free of charge account.
[Music] in this lesson were going to cover how to create an amortization schedule in google sheets so you can see here we have a 30 year fixed rate loan we have a loan amount of two hundred thousand dollars at a rate of three and a half percent and a term of 360 months or 30 years so the first thing we need to do is calculate our monthly payment amount so were going to use the payment function and the first input is our rate now this interest rate here is expressed annually but in order to calculate a monthly payment we need to divide this rate by 12 to convert it to a monthly rate the number of periods is the term of our loan we have this expressed as months already so this is good as is the final input thats required is the present value which is our loan amount there were two additional inputs for this function but they are optional and not required for this type of calculation so we have everything we need and this gives us a monthly payment of 898 now you can see there is a ne