Please write all THE CALCULtion for this using Microsoft SQL Query. Loan Calculation Overview To calculate the monthly repayments and closing balance for a loan of $$100,000$ at an interest rate of $11\%$ for $12$ months, we need to consider the following: Interest Rate Calculation: The monthly interest rate is calculated as: Monthly Interest Rate $=$ Annual Interest Rate $/12$ Monthly Interest Rate $=11\%/12=0\mathrm{.}91667\%$ First Payment Adjustment: Since the first payment is on $2025-04-30,$ which is not the $15$th$,$ we will calculate the interest for the first month based on the reduced term. Monthly Payment Calculation: The monthly payment can be calculated using the formula for an amortizing loan: M $=$ P$[$r$(1+$ r$)^$n$]/[(1+$ r$)^$n $1]$ Where: M $=$ monthly payment P $=$ principal loan amount $($$$100,000)$ r $=$ monthly interest rate $(0\mathrm{.}0091667)$ n $=$ number of payments $(12)$ Step$-$by$-$Step Calculation Calculate Monthly Payment: First, we need to calculate the monthly payment without considering the first month's adjustment. r $=0\mathrm{.}11/12=0\mathrm{.}0091667$ n $=12$ P $=100000$ M $=100000*[0\mathrm{.}0091667(1+0\mathrm{.}0091667)^12]/[(1+0\mathrm{.}0091667)^121]$ After calculating, we find: M $$ $$8,843\mathrm{.}131$ Adjust for First Month: Since the first payment is not on the $15$th$,$ we will calculate the interest for the first month only on the principal amount. Interest for Month $1=$ Principal $*$ Monthly Interest Rate Interest for Month $1=100000*0\mathrm{.}0091667$ $$916\mathrm{.}67$ The first payment will be the interest only: First Payment $=$ $$916\mathrm{.}67$ Calculate Remaining Balance: After the first payment, the remaining balance will be: Remaining Balance $=$ Principal $-$ First Payment Remaining Balance $=$ $$100,000-$ $$916\mathrm{.}67=$ $$99,083\mathrm{.}33$ Monthly Payments for Months $2-12$: For months $2$ to $12,$ the monthly payment will be the previously calculated M of $$8,843\mathrm{.}13.$ Closing Balance Calculation Month Payment Interest Principal Paid Closing Balance $1$ $$916\mathrm{.}67$ $$916\mathrm{.}67$ $$0$ $$99,083\mathrm{.}332$ $$8,843\mathrm{.}13$ $$908\mathrm{.}00$ $$7,935\mathrm{.}13$ $$91,148\mathrm{.}203$ $$8,843\mathrm{.}13$ $$835\mathrm{.}00$ $$8,008\mathrm{.}13$ $$83,140\mathrm{.}074$ $$8,843\mathrm{.}13$ $$761\mathrm{.}00$ $$8,082\mathrm{.}13$ $$75,057\mathrm{.}945$ $$8,843\mathrm{.}13$ $$686\mathrm{.}00$ $$8,157\mathrm{.}13$ $$66,900\mathrm{.}816$ $$8,843\mathrm{.}13$ $$611\mathrm{.}00$ $$8,232\mathrm{.}13$ $$58,668\mathrm{.}687$ $$8,843\mathrm{.}13$ $$536\mathrm{.}00$ $$8,307\mathrm{.}13$ $$50,361\mathrm{.}558$ $$8,843\mathrm{.}13$ $$460\mathrm{.}00$ $$8,383\mathrm{.}13$ $$41,978\mathrm{.}429$ $$8,843\mathrm{.}13$ $$384\mathrm{.}00$ $$8,459\mathrm{.}13$ $$33,519\mathrm{.}2910$ $$8,843\mathrm{.}13$ $$307\mathrm{.}00$ $$8,536\mathrm{.}13$ $$24,983\mathrm{.}1611$ $$8,843\mathrm{.}13$ $$229\mathrm{.}00$ $$8,614\mathrm{.}13$ $$16,369\mathrm{.}0312$ $$8,843\mathrm{.}13$ $$150\mathrm{.}00$ $$8,693\mathrm{.}13$ $$0\mathrm{.}00$ This amortization schedule ensures that the closing balance at month $12$ is zero, with the first month's payment adjusted for the late start date. The monthly payments from month $2$ to $12$ are equal, ensuring a consistent repayment plan.