5.- DO IT IN EXCEL, AND SHOW THE FORMULAS The company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments...

5.-

DO IT IN EXCEL, AND SHOW THE FORMULAS

The company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (annuities) that include principal and interest. What is the amount of the payment?

A) $185,674.92

B) None of these amounts

C) $311,662.137

D) $151,841.86

(Choose one option)

D) $151,841.86