@article {Arnold128, author = {Tom Arnold and John H. Earl and Cassandra D. Marshall}, title = {Using Google Sheets to Determine Mortgage Information}, volume = {19}, number = {4}, pages = {128--131}, year = {2017}, doi = {10.3905/jwm.2017.19.4.128}, publisher = {Institutional Investor Journals Umbrella}, abstract = {Google Sheets, a spreadsheet software similar to Microsoft{\textquoteright}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{\textquoteright}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{\textemdash}the spreadsheet will produce the missing fourth item.TOPIC: MBS and residential mortgage loans}, issn = {1534-7524}, URL = {https://jwm.pm-research.com/content/19/4/128}, eprint = {https://jwm.pm-research.com/content/19/4/128.full.pdf}, journal = {The Journal of Wealth Management} }