Skip to main content

Main menu

  • Home
  • Current Issue
  • Past Issues
  • Videos
  • Submit an article
  • More
    • About JWM
    • Editorial Board
    • Published Ahead of Print (PAP)
  • IPR Logo
  • About Us
  • Journals
  • Publish
  • Advertise
  • Videos
  • Webinars
  • More
    • Awards
    • Article Licensing
    • Academic Use
  • LinkedIn
  • Twitter

User menu

  • Sample our Content
  • Subscribe Now
  • Log in

Search

  • ADVANCED SEARCH: Discover more content by journal, author or time frame
The Journal of Wealth Management
  • IPR Logo
  • About Us
  • Journals
  • Publish
  • Advertise
  • Videos
  • Webinars
  • More
    • Awards
    • Article Licensing
    • Academic Use
  • Sample our Content
  • Subscribe Now
  • Log in
The Journal of Wealth Management

The Journal of Wealth Management

ADVANCED SEARCH: Discover more content by journal, author or time frame

  • Home
  • Current Issue
  • Past Issues
  • Videos
  • Submit an article
  • More
    • About JWM
    • Editorial Board
    • Published Ahead of Print (PAP)
  • LinkedIn
  • Twitter
Article

Using Google Sheets to Determine Mortgage Information

Tom Arnold, John H. Earl and Cassandra D. Marshall
The Journal of Wealth Management Spring 2017, 19 (4) 128-131; DOI: https://doi.org/10.3905/jwm.2017.19.4.128
Tom Arnold
is a professor at the University of Richmond’s Robins School of Business in Richmond, VA.
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • For correspondence: tarnold@richmond.edu
John H. Earl
is an associate professor at the University of Richmond’s Robins School of Business in Richmond, VA.
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • For correspondence: jearl@richmond.edu
Cassandra D. Marshall
is an assistant professor at the University of Richmond’s Robins School of Business in Richmond, VA.
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • For correspondence: cmarshal@richmond.edu
  • Article
  • Info & Metrics
  • PDF (Subscribers Only)
Loading

Click to login and read the full article.
Don’t have access? Sign up today to begin your trial to the PMR platform 

Abstract

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.

  • © 2017 Pageant Media Ltd
View Full Text

Don’t have access? Register today to begin unrestricted access to our database of research.

Log in using your username and password

Forgot your user name or password?
PreviousNext
Back to top

Explore our content to discover more relevant research

  • By topic
  • Across journals
  • From the experts
  • Monthly highlights
  • Special collections

In this issue

The Journal of Wealth Management: 19 (4)
The Journal of Wealth Management
Vol. 19, Issue 4
Spring 2017
  • Table of Contents
  • Index by author
Print
Download PDF
Article Alerts
Sign In to Email Alerts with your Email Address
Email Article

Thank you for your interest in spreading the word on The Journal of Wealth Management.

NOTE: We only request your email address so that the person you are recommending the page to knows that you wanted them to see it, and that it is not junk mail. We do not capture any email address.

Enter multiple addresses on separate lines or separate them with commas.
Using Google Sheets to Determine Mortgage Information
(Your Name) has sent you a message from The Journal of Wealth Management
(Your Name) thought you would like to see the The Journal of Wealth Management web site.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Citation Tools
Using Google Sheets to Determine Mortgage Information
Tom Arnold, John H. Earl, Cassandra D. Marshall
The Journal of Wealth Management Jan 2017, 19 (4) 128-131; DOI: 10.3905/jwm.2017.19.4.128

Citation Manager Formats

  • BibTeX
  • Bookends
  • EasyBib
  • EndNote (tagged)
  • EndNote 8 (xml)
  • Medlars
  • Mendeley
  • Papers
  • RefWorks Tagged
  • Ref Manager
  • RIS
  • Zotero
Save To My Folders
Share
Using Google Sheets to Determine Mortgage Information
Tom Arnold, John H. Earl, Cassandra D. Marshall
The Journal of Wealth Management Jan 2017, 19 (4) 128-131; DOI: 10.3905/jwm.2017.19.4.128
del.icio.us logo Digg logo Reddit logo Twitter logo CiteULike logo Facebook logo Google logo LinkedIn logo Mendeley logo
Tweet Widget Facebook Like LinkedIn logo

Jump to section

  • Article
    • Abstract
    • BUILDING A MORTGAGE CALCULATOR IN GOOGLE SHEETS (OR EXCEL)
    • USING THE MORTGAGE CALCULATOR
    • CONCLUSION
  • Info & Metrics
  • PDF (Subscribers Only)
  • PDF (Subscribers Only)

Similar Articles

Cited By...

  • An Excel Calculator for Determining Student Loan Information
  • Excel Calculators for Determining Retirement Accumulation and Disbursement Information
  • Google Scholar

More in this TOC Section

  • Well-Being Advisers
  • Editor’s Letter
  • Editor’s Letter
Show more Article
LONDON
One London Wall, London, EC2Y 5EA
United Kingdom
+44 207 139 1600
 
NEW YORK
41 Madison Avenue, New York, NY 10010
USA
+1 646 931 9045
pm-research@pageantmedia.com
 

Stay Connected

  • LinkedIn
  • Twitter

MORE FROM PMR

  • Home
  • Awards
  • Investment Guides
  • Videos
  • About PMR

INFORMATION FOR

  • Academics
  • Agents
  • Authors
  • Content Usage Terms

GET INVOLVED

  • Advertise
  • Publish
  • Article Licensing
  • Contact Us
  • Subscribe Now
  • Log In
  • Update your profile
  • Give us your feedback

© 2021 Pageant Media Ltd | All Rights Reserved | ISSN: 1534-7524 | E-ISSN: 2374-1368

  • Site Map
  • Terms & Conditions
  • Cookies
  • Privacy Policy