PT - JOURNAL ARTICLE AU - Tom Arnold AU - John H. Earl AU - Cassandra D. Marshall TI - Using Google Sheets to Determine Mortgage Information AID - 10.3905/jwm.2017.19.4.128 DP - 2017 Jan 31 TA - The Journal of Wealth Management PG - 128--131 VI - 19 IP - 4 4099 - https://pm-research.com/content/19/4/128.short 4100 - https://pm-research.com/content/19/4/128.full AB - Google Sheets, a spreadsheet software similar to Microsoft’s Excel software, is available to anyone who has a Gmail account. Gmail is available for free by Google and allows users to have access to Google’s Drive, which contains Google Sheets. With very little programming, one can compute many different aspects of a mortgage, given knowledge of three out of the four possible mortgage inputs (i.e., loan amount, monthly payment, maturity, interest rate). It does not matter which three inputs are supplied—the spreadsheet will produce the missing fourth item.TOPIC: MBS and residential mortgage loans