managment information system and app excel
Mo7ammedaziz 
e02h1Loans.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 | 5/1/11 | |||||
| 453000 | $ 350,000 | $ 60,000 | 3.940% | 30 | 11/3/11 | |||||
| 453025 | $ 175,500 | $ 30,000 | 3.550% | 25 | 4/10/12 | |||||
| 452600 | $ 265,950 | $ 58,000 | 2.500% | 15 | 10/14/12 | |||||
| 452638 | $ 329,750 | $ 65,000 | 3.250% | 30 | 2/4/13 | |||||
| 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: | 12/11/12 | 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 |
