please help

my salary is 60000

pleaae use the salary as 60000 and age as 19 everything else is included in the question and please use formula and no excel fuctiona

Mini-Project 3: Home Mortgage Please watch the lecture video from class introducing the project. Submissions should be uploaded on Canvas as an MS Word document or PDF. Show all calculations and write solutions in complete sentences. Do not show the instructions with your work. This assignment will help you to determine the salary you need to purchase a home that is suitable for you. It will also help you consider other factors when purchasing a home. Problem 1: Find your salary (3) Look up your salary here based on the entry level job or future occupation you intend to pursue upon graduation. If you cannot find your starting salary using this website, do some research online to see if you can find an estimate. If your starting salary is below $40,000, use the median salary instead. Provide a brief description (at least 3 sentences) of your future educational and career plans, along with the starting salary of your future occupation. Problem 2: Estimate your maximum mortgage (3) Considering the rule of thumb that your mortgage payment should be no more than 28% of your gross monthly income, what is the maximum monthly mortgage payment that you can afford? Show your calculations and state your answer using a complete sentence Problem 3: Estimate maximum home price (1) Use this mortgage calculator to determine the maximum home price that you can afford based on a 30-year mortgage, a 5% interest rate, and a 20% down payment. Problem 4: Find a home (3) Use this real estate search and enter the location of where you plan to live. Find a house that is suitable for you considering your living needs and budget (do not quickly choose the cheapest house, but take some time to find what would be ideal for you or your family). Consider the number of bedrooms/bathrooms, square footage age of the home, location, and other amenities such as a pool, landscaping, gated community, etc. Once you find a home that you can afford and meets your criteria, use the snipping tool or screenshot function to provide a picture of the home in your report. Be sure to include a detailed description (at least 4 sentences) of what you like about the house and why you chose it. Problem 5: Calculate your mortgage (2) Report the price of the home and monthly mortgage payments based on a 30-year mortgage, 5% interest rate, and 20% down payment. Repeat this using the same parameters for a 15-year mortgage. Present solutions using complete sentences. Problem 6: Mortgage + Escrow (4) Sunnose home insurance is 5600 per wear and the annual Mini-Project 3: Home Mortgage Please watch the lecture video from class introducing the project. Submissions should be uploaded on Canvas as an MS Word document or PDF. Show all calculations and write solutions in complete sentences. Do not show the instructions with your work. This assignment will help you to determine the salary you need to purchase a home that is suitable for you. It will also help you consider other factors when purchasing a home. Problem 1: Find your salary (3) Look up your salary here based on the entry level job or future occupation you intend to pursue upon graduation. If you cannot find your starting salary using this website, do some research online to see if you can find an estimate. If your starting salary is below $40,000, use the median salary instead. Provide a brief description (at least 3 sentences) of your future educational and career plans, along with the starting salary of your future occupation. Problem 2: Estimate your maximum mortgage (3) Considering the rule of thumb that your mortgage payment should be no more than 28% of your gross monthly income, what is the maximum monthly mortgage payment that you can afford? Show your calculations and state your answer using a complete sentence Problem 3: Estimate maximum home price (1) Use this mortgage calculator to determine the maximum home price that you can afford based on a 30-year mortgage, a 5% interest rate, and a 20% down payment. Problem 4: Find a home (3) Use this real estate search and enter the location of where you plan to live. Find a house that is suitable for you considering your living needs and budget (do not quickly choose the cheapest house, but take some time to find what would be ideal for you or your family). Consider the number of bedrooms/bathrooms, square footage age of the home, location, and other amenities such as a pool, landscaping, gated community, etc. Once you find a home that you can afford and meets your criteria, use the snipping tool or screenshot function to provide a picture of the home in your report. Be sure to include a detailed description (at least 4 sentences) of what you like about the house and why you chose it. Problem 5: Calculate your mortgage (2) Report the price of the home and monthly mortgage payments based on a 30-year mortgage, 5% interest rate, and 20% down payment. Repeat this using the same parameters for a 15-year mortgage. Present solutions using complete sentences. Problem 6: Mortgage + Escrow (4) Sunnose home insurance is 5600 per wear and the annual