please show a formula on how to calculate each category to help understand where the numbers come from

4. Solve problem 3, assuming that 50% of the initial investment is borrowed at an annual interest rate of 8% to be paid back in three equal installments. I trest Loun Cash Fla Taxes Tunubletelor Year Dep. BICE 500,000 O 1 333.300 444,400 2 3 4 4 - 1000.000 300, 300,000 300,000 300,000 200,000 148,100 74,100 40000 - 73,300 27,680 -172,080 14,374 137.526 225,90 200,000 -29,376 -194000 -68.852 -194000 55,0 10 -194,000 90,360 80,000 Pw - 500.000 123,019 144, 494 ATCE 0-50, bu 1 135,320 2 174,852 3 50.996 4 : Total Loun Payments: 500,000 (Alp. 83) = 194,00 Frot your a: 569060Xous = 40,000 rerincipu poit: 194000 40.000 =154,000 Bulana : 50 000-154,000 = 346000 1. preest: 346, ODO 0.08 = 27660 plineipt poida 144000 27,680 - 166,320 Bulung - 346,660 166,320 = 147680 Interest: 179,680x, of = 14,374 38, 309 2329,640 225,144 4 $ 30,970 This is a good investment 4. Solve problem 3, assuming that 50% of the initial investment is borrowed at an annual interest rate of 8% to be paid back in three equal installments. I trest Loun Cash Fla Taxes Tunubletelor Year Dep. BICE 500,000 O 1 333.300 444,400 2 3 4 4 - 1000.000 300, 300,000 300,000 300,000 200,000 148,100 74,100 40000 - 73,300 27,680 -172,080 14,374 137.526 225,90 200,000 -29,376 -194000 -68.852 -194000 55,0 10 -194,000 90,360 80,000 Pw - 500.000 123,019 144, 494 ATCE 0-50, bu 1 135,320 2 174,852 3 50.996 4 : Total Loun Payments: 500,000 (Alp. 83) = 194,00 Frot your a: 569060Xous = 40,000 rerincipu poit: 194000 40.000 =154,000 Bulana : 50 000-154,000 = 346000 1. preest: 346, ODO 0.08 = 27660 plineipt poida 144000 27,680 - 166,320 Bulung - 346,660 166,320 = 147680 Interest: 179,680x, of = 14,374 38, 309 2329,640 225,144 4 $ 30,970 This is a good investment