As part of a new program to advance engineering solutions for the commercialization of fusion energy, the Dallas engineering firm 'SRV Engineering' will get a loan of $40 million. To pay this loan back, the firm will make monthly payments of $447,000 during 12 years. You're helping the firm assess the impact of this loan on their finances. Using your Excel skills and understanding of financial functions, calculate the following:

- The monthly rate for this loan

- The annual rate for this loan

- The effective annual rate for this loan

- Total amount paid after 12 years

Loan Amount	$40,000,000
Monthly Payment	$447,000
Number of Payments	144
MONTHLY RATE
ANNUAL RATE
EFFECTIVE RATE
TOTAL PAID