Can someone please help with this? Thank you in advance!

Lab Insight: For the alternate lab, you are to make a similar amortization schedule to Lab 1-3 Excel for a $200,000 mortgage loan at 6 percent interest for two additional time periods, 15 years and 6 years. So, instead of 360 months (30 years), use 180 months (15 years) and 72 months (6 years). There is no data file for this lab. Required: 1. Calculate the monthly payment for a 15 -year (180-month) and a 6-year (72-month) mortgage loan based on a $200,000 loan. 2. Create a mortgage amortization schedule. 3. Calculate the amount of interest that you'd pay for a 15-year (180-month) mortgage loan and a 6-year (72-month) mortgage loan based on a $200,000 loan. 4. How would the amortization schedule differ if you used a $205,000 or $220,000 loan? Ask the Question: How much interest do you pay over the life of a 30-year mortgage? Master the Data: There is no data file for this lab. We will make the needed calculations and input the data as we go. To compute the mortgage payments, we'll need to know a few things: 1. The size of the mortgage loan 2. The interest rate 3. The length of the loan (number of months) Let's suppose you would like to buy a home for $250,000. But like most U.S. citizens, you don't have enough cash on hand to pay in full for the house. But we're in luck! Signature Bank has agreed to offer you a 30-year mortgage loan, but requires that you pay 20 percent down ($50,000=20% of $250,000) to qualify for their mortgage loan of $200,000 in this way: $250,000 Cost of home 50,000 Required 20% down payment ($50,000=20% of $250,000) - the required cash you pay upfront when buying a home $200,000 Amount of the mortgage loan Software needed - Excel - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Perform the Analysis: Refer to original Lab 1-3 in the text for instructions and steps for each of the lab parts. Answer the following questions based the details provided. Note: Round your answers to 2 decimal places. Enter all answers as positive numbers