please do it on excel and show formulas.

Q2 - Remaining Balance Suppose you have taken out a $1,648,145 fully amortizing fixed rate mortgage loan that has a term of 25 years and an interest rate of 5.15\%. After your first mortgage payment, how much of the original loan balance is remaining? Q3-Remaining Balance Assume you have taken out a partially amortizing loan for $7,158,435 that has a term of five years but amortizes over 20 years. Calculate the balloon payment if the interest rate on this loan is 4.75%