This video tutorial will show you how to make a fixed rate loan or mortgage calculator in excel. It is actually quite easy to do and after watching this step-by-step example and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the required payments and it is also explained in the tutorial.
To follow along with the spreadsheet seen in the tutorial or to get some free excel macros or tips & tricks, go to the website:
View next lesson:
Missed the last tutorial? Watch right here: https://www.khanacademy.org/economics-finance-domain/core-finance/housing/renting-v-buying/v/renting-vs-buying-detailed-analysis?utm_source=YT&utm_medium=Desc&utm_campaign=financeandcapitalmarkets
Finance and money areas on Khan Academy: a lot of people purchasing a property need a mortgage to take action. This guide explains what a home loan is and in fact does some mathematics to determine exacltly what the repayments tend to be (the final video is fairly mathy so ponder over it recommended).
About Khan Academy: Khan Academy provides rehearse workouts, instructional movies, and a tailored understanding dashboard that empower learners to review at their particular pace in and outside of the class. We tackle mathematics, science, education, record, art history, business economics, and more. Our math missions guide students from preschool to calculus utilizing state-of-the-art, adaptive technology that identifies strengths and learning spaces. We’ve also partnered with establishments like NASA, The Museum of Modern Art, The Ca Academy of Sciences, and MIT to supply specific content.
Free of charge. For everybody. Forever. #YouCanLearnAnything
Subscribe Khan Academy’s Finance and Capital Markets station: https://www.youtube.com/channel/UCQ1Rt02HirUvBK2D2-ZO_2g?sub_confirmation=1
Donate to Khan Academy: https://www.youtube.com/subscription_center?add_user=khanacademy