Chevron Phillips has put into place new laboratory equipment for the production of chemicals: the initial cost is $1,200,000 installed. Chevron Phillips borrows 45% of all capital needed, and the borrowing rate is 12.5% over 4 years. The throughput rate for in-process test samples has increased the capacity of the lab with a net savings of SX per year. Depreciation follows MACRS-GOS, MARR is 1196, and the planning horizon is 6 years with a salvage value of $130,000 at that time. Use Goal Seekor Solver in Excele to determine the value of such that MARRis exactly achieved, no more and no less, it: a. The loan is paid back using Method 1 Onterest only at the end of each year of the loan, plus principal at the end of the last year). b. The loan is paid back using Method 2 (equal annual principal payments plus Interest on the unpaid loan balance), c The loan is paid back using Method 3 lequal annual principal plus interest payments during each year of the loan). d. The loan is paid back using Method 4 (principal plus interest is paid at the end of the loan period). An important step in this problem is determining the principal and interest payments on the loan for the laboratory equipment Method 1 has interest only at the end of each year of the loan plus principal at the end of the last year. Method 2 has equal principal payments plus interest on the unpaid loan balance Method 3 has equal annual principal plus interest payments during each year of the loan Method 4 has principal plus interest is paid at the end of the loan period. They financed 45% of the $1.200,000 at 12.5% per year over 4 years and keep it for 6 years. Based on this information, fill in the following chart: Method Method 2 Methad 3 Method 4 EOY Principal Interest Principal Interest Principal Interest Principal Interest 0 $0.00 567 500.00 $112.162 27 $67,500.00 $0.00 $0.00 2 $0.00 $126,18256 553.479.72 $0.00 $0.00 3 $0.00 1b $33.750.00 3b $0.00 $0.00 4 16 2a $26,875.00 $159,699 79 $0.00 4 4b 5 $0.00 SOLO $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 6 $0.00 50.00 $0.00 50.00 SO_00 $0.00 $0.00 50.00 1 2a 15 16 2 25 2a 38 $ $ 2. as 6. S 3.5 b. 4.3.$ DS Chevron Phillips has put into place new laboratory equipment for the production of chemicals: the initial cost is $1,200,000 installed. Chevron Phillips borrows 45% of all capital needed, and the borrowing rate is 12.5% over 4 years. The throughput rate for in-process test samples has increased the capacity of the lab with a net savings of SX per year. Depreciation follows MACRS-GOS, MARR is 1196, and the planning horizon is 6 years with a salvage value of $130,000 at that time. Use Goal Seekor Solver in Excele to determine the value of such that MARRis exactly achieved, no more and no less, it: a. The loan is paid back using Method 1 Onterest only at the end of each year of the loan, plus principal at the end of the last year). b. The loan is paid back using Method 2 (equal annual principal payments plus Interest on the unpaid loan balance), c The loan is paid back using Method 3 lequal annual principal plus interest payments during each year of the loan). d. The loan is paid back using Method 4 (principal plus interest is paid at the end of the loan period). An important step in this problem is determining the principal and interest payments on the loan for the laboratory equipment Method 1 has interest only at the end of each year of the loan plus principal at the end of the last year. Method 2 has equal principal payments plus interest on the unpaid loan balance Method 3 has equal annual principal plus interest payments during each year of the loan Method 4 has principal plus interest is paid at the end of the loan period. They financed 45% of the $1.200,000 at 12.5% per year over 4 years and keep it for 6 years. Based on this information, fill in the following chart: Method Method 2 Methad 3 Method 4 EOY Principal Interest Principal Interest Principal Interest Principal Interest 0 $0.00 567 500.00 $112.162 27 $67,500.00 $0.00 $0.00 2 $0.00 $126,18256 553.479.72 $0.00 $0.00 3 $0.00 1b $33.750.00 3b $0.00 $0.00 4 16 2a $26,875.00 $159,699 79 $0.00 4 4b 5 $0.00 SOLO $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 6 $0.00 50.00 $0.00 50.00 SO_00 $0.00 $0.00 50.00 1 2a 15 16 2 25 2a 38 $ $ 2. as 6. S 3.5 b. 4.3.$ DS