Working with Google Sheets
EK17
Loans.xlsxDetails
| Townsend Mortgage Company | ||||||||||
| Input Area | ||||||||||
| Today's Date: | ||||||||||
| Pmts Per Year: | 12 | |||||||||
| Loan # | House Cost | Down Payment | Amount Financed | Mortgage Rate | Rate Per Period | Years | # of Pmt Periods | % Financed | Date Financed | Payoff Year |
| 452786 | $ 400,000 | $ 80,000 | 3.625% | 25 | 0.0% | 5/1/16 | 2041 | |||
| 453000 | $ 350,000 | $ 60,000 | 3.940% | 30 | 0.0% | 11/3/16 | 2046 | |||
| 453025 | $ 175,500 | $ 30,000 | 3.550% | 25 | 0.0% | 4/10/17 | 2042 | |||
| 452600 | $ 265,950 | $ 58,000 | 2.500% | 15 | 0.0% | 10/14/17 | 2032 | |||
| 452638 | $ 329,750 | $ 65,000 | 3.250% | 30 | 0.0% | 2/4/18 | 2048 | |||
| Summary Statistics | ||||||||||
| Statistics | House Cost | Down Payment | Amount Financed | |||||||
| Total | ||||||||||
| Average | ||||||||||
| Median | ||||||||||
| Lowest | ||||||||||
| Highest | ||||||||||
| # of Mortgages |
Payment Info
| Townsend Mortgage Company | ||||||||
| Input Area | Years | Rate | ||||||
| Today's Date: | 5/6/21 | 15 | 3.250% | |||||
| # Pmts Per Year: | 12 | 25 | 3.625% | |||||
| PMI Rate: | 0.38% | 30 | 3.750% | |||||
| Down Pmt Rate: | 20.0% | |||||||
| Loan # | House Cost | Down Payment | Amount Financed | % Down | Years | APR | Monthly Payment | Monthly PMI |
| 392786 | $ 425,750 | $ 86,000 | $ 339,750 | 20.2% | 25 | |||
| 393000 | $ 335,900 | $ 75,500 | $ 260,400 | 22.5% | 30 | |||
| 393025 | $ 205,500 | $ 30,000 | $ 175,500 | 14.6% | 25 | |||
| 392600 | $ 285,900 | $ 50,000 | $ 235,900 | 17.5% | 15 | |||
| 392638 | $ 329,900 | $ 70,000 | $ 259,900 | 21.2% | 30 |
