TY - JOUR T1 - Using Google Sheets to Determine Mortgage Information JF - The Journal of Wealth Management SP - 128 LP - 131 DO - 10.3905/jwm.2017.19.4.128 VL - 19 IS - 4 AU - Tom Arnold AU - John H. Earl AU - Cassandra D. Marshall Y1 - 2017/01/31 UR - https://pm-research.com/content/19/4/128.abstract N2 - 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 ER -