This is a long question set so be sure to scroll all the way through it before uploading a picture of your work answers. Also, be sure to include the use of appropriate formulas within your work. Label the parts respectively for each of grading to receive full credit. 1. You decided to start looking for a home and consider a prequalification for a home loan. After talking with a lender, you are informed that the lending company uses the qualifying ratios of 26/42. You have a monthly salary of $5,300, while your partner has a monthly income of $2,050. You also have income from interest in an investment of approximately $54.17 a month. You and your partner both your own car loans, yours has a $650 monthly car payment and your partner has a $598 monthly car payment. You have two credit cards with $25 minimum payment and $17 minimum payment each month. If you estimate that property taxes will cost about $1,225 a year and insurance will cost about $550 a year, what is an approximated maximum monthly payment that you can qualify for? Be sure to include the work for finding payments based on each ratio while answering the question. 2. After doing the prequalification and see what you can afford at maximum, you find a home that has a price of $200,000 at 4.08% compounded monthly for 30 years. A. Based on your answer from part A, will you be able to afford the monthly payment? Answer with a yes or no and justify your answer by finding the monthly payment. Provide an explanation as to why you can or cannot afford the house. B. Find the total amount of interest that will be paid back after the 30 years. C. Amortization the first 3 months of the mortgage by filling in an amortization schedule table (regardless of being able to afford the mortgage). Be sure to show the work needed for each cell...don't just provide a filled in table