Using the PMT function, calculate the annual blended payment obligations on the new proposed $$1MM$ loan $($in the "Credit Facilities" section of the Financial Worksheet$)$:

$$193,618\mathrm{.}32$

$$52,460\mathrm{.}28$

$$197,647\mathrm{.}98$

$$629,523\mathrm{.}31$

Please find the below information

$[$New debt:$1,000,000\mathrm{.}00]$

$[$Amortization $($months$)$:$72]$

$[$Rate: $5\mathrm{.}10\%]$

$[$Credit Line: $3,000,000]$

$[$Prime:$3\mathrm{.}0\%]$