Seeking a MS Excel mortgage template(s) to be created. The template(s) can be either one tab or two for input and viewing purposes. This spreadsheet will be used marketing a house purposes that will be both emailed and also printed. I am open to the idea of the easiest format.
The spreadsheet will have:
• My picture / contact information & another field for my business partners picture / contact
• Subject property information; such as address, city, state and zip code
• Subject area where a picture can be copied and pasted
• Purchase price and loan amount fields including down payment section based on purchase price
• Mortgage insurance also called private mortgage insurance (if applicable)
• Compare 3 different mortgage type options; such as 30 year fixed, 15 year fixed, annual rate mortgage with an interest only option
• Section for a 2nd mortgage if applicable
• Either annual or monthly tax or insurance fields
• Total breakdown of monthly costs for each of the above options
• Estimate closing costs
• Area below each field that will calculate APY for each of the 3 fields above and also a little disclosure section
Here is a web site that has multiple calculators already put together for your review: Mortgagor dot com
This is a simple project, should not take a lot of time to complete nor cost a lot of money.