Excel Equation

Hello,

Add equations to calculate the total cost of the loan by multiplying the number of payments (minus 1) by the monthly payment and adding the amount of the last payment. The following suppose to be the correct amounts of the loan in order:

$303,735.41
$321,697.14
$295,341.92
$310,838.49

Big Blue Bank: $250,000 Loan Amount + $53,735.41Total interest = $303,735.41

I keep getting these totals:

$303,735.60
$321,697.80
$295,342.08
$310,838.40

Which is very close with the equation that I am using:

=B4*C4+D4-D4

Please help.

Thanks,

Donna Winder
E-Mail ID removed for your security