In purchasing a house that is worth $175,000, you need to obtain a mortgage. Suppose you choose a 30- year fixed rate mortgage with an interest rate/year of 9.74%. What is the annual payment required? How much of each years payment goes to paying interest and how much to reducing the principal balance for the first 15 years?

Please work on excel and show excel formulas!

EL E F M N O P 1 Inputs 2 Preserve 3 estre Number of your 5 2 3 5 5 9 10 11 12 1) 14 15 Outputs BY 9 Bea Princo Bence 11 Inter Component 12 Pencil Component End Principalance 16 15 Tool Pay 17 10