please give me step by step for these

Display the Loan worksheet. In cell B$8,$ type a reference formula to cell B$1.$ The balance before the first payment is identical to the loan amount. Do not type the value; use the cell reference instead. In cell B$9,$ subtract the principal from the beginning balance on the previous row. Copy the formula to the range B$10$:B$19.$

Now, you will calculate the interest for the first payment.

In cell C$8,$ calculate the interest for the first payment using the IPMT function. Copy the function to the range C$9$:C$19.$

Next, you will calculate the principal paid.

In cell D$8,$ calculate the principal paid for the first payment using the PPMT function. Copy the function to the range D$9$:D$19.$

Rows $21-23$ contain a summary section for cumulative totals after the first year.

In cell B$22,$ insert the CUMIPMT function that calculates the cumulative interest after the first year. Use references to cells A$8$ and A$19$ for the period arguments.

The next summary statistic will calculate the principal paid after the first year.

In cell B$23,$ insert the CUMPRINC function that calculates the cumulative principal paid after the first year. Use references to cells A$8$ and A$19$ for the period arguments.

Rows $25-28$ contain a section for what$-$if analysis.

In cell B$27,$ use the RATE financial function to calculate the periodic rate using $$1,400$ as the monthly payment $($cell B$26),$ the NPER, and loan amount in the original input section.

In cell B$28,$ calculate the APR by multiplying the monthly rate $($cell B$27)$ by $12.$