Task 1 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 20 years with quarterly payments in a year. The annual interest for this loan is 12%. This loan will have equal payments. Task 2 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 18 years with monthly payments in a year. The annual interest for this loan is 12%. This loan will have equal payments. Task 3 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 20 years with quarterly payments in a year. The annual interest for this loan is 12%. This loan will have equal principal payments. Task 4 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 18 years with monthly payments in a year. The annual interest for this loan is 12%. This loan will have equal principal payments. Further Instructions: If you do not follow these guidelines, you will automatically get zero: Entering hardcoded numbers except for the array B2:B4 Not following file submission guideline: StdName(Std no) Late assignments will not be accepted. No excuses will be accepted. Submitting a file format other than Microsoft Template provided to you. M AR FIRE AL Bu hal Excel and not using the Microsoft Excel "40" of "50" M 0","20" da u

Task 1 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 20 years with quarterly payments in a year. The annual interest for this loan is 12%. This loan will have equal payments. Task 2 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 18 years with monthly payments in a year. The annual interest for this loan is 12%. This loan will have equal payments. Task 3 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 20 years with quarterly payments in a year. The annual interest for this loan is 12%. This loan will have equal principal payments. Task 4 A Corporation is planning to buy a loan that is worth $12,000,000. This loan will be repaid in 18 years with monthly payments in a year. The annual interest for this loan is 12%. This loan will have equal principal payments. Further Instructions: If you do not follow these guidelines, you will automatically get zero: - Entering hardcoded numbers except for the array B2:B4 - Not following file submission guideline: StdName(Std no) - Late assignments will not be accepted. No excuses will be accepted. - Submitting a file format other than Microsoft Excel and not using the Microsoft Excel Template provided to you