whats the formulas that i should use for this?

Below is an ATCF for MACRS -5 year GDS machinery whose initial cost plus installation is $100,000. The company is borrowing half the purchase price. The loan is to be paid back over three years using equal annual payments at an interest rate of 10%. The company's MARR is 15% and they use a 35% combined tax rate. Tax Inc. Deprec Taxes EOY B4TCF Principal Interest ATCF -100000 45,000 45,000 40000 3 40000 4 25000 15000 7 25000 Payment EOY Principal Interest Owed EOY 50000 20105.5 20105.5 20105.5