My formula set doesn't work, can't see any problem. HELP!

I have no extensive knowledge of EXCEL so when I needed to create a tool I searched Google and collected information from several sources. I entered the formulas and it doesn't work. I went back and researched again, looking at several additional sources and came up with the same formulas that don't work. If somebody can tell me where I'm going wrong or that this is just not possible, either way, I'll be grateful.

COLUMN A COLUMN B (COLUMN B FORMULAS USED)
START DATE 11/03/2017
END DATE 12/31/2017
TOTAL DAYS 59 =SUM(B3-B2)+1
PRINCIPAL $620,000
ANNUAL RATE 10%
ANNUAL COMPOUNDING PERIODS 1
LENGTH OF TERM – YEARS 0.16166 =SUM(B4*0.00274)
NOTE TOTAL $629,626.84 =B5*(1+B6/B7)^(B7*B8)
INTEREST EARNED $9,626.84 =SUM(B9-B5)
____________________________________________________________________________________
However: $620K, 10% = $62K. $62K / 365 = $169.86. $169.86*59 = $10,021.74

I have not had a reason to test the multiple compounding yet since I can't even figure out how to get a simple
problem accurate result.

THANKS!

That did't format when I posted, maybe this will make it easier to understand:

CALC SCREEN SHOT.jpg

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks, John.
The example shows the data I need (column A), and column B is the data inputs unique to each instance or the calculations from the formulas. If it is a formula field, that formula is illustrated to the right. In this case, the result shows as (interest earned) $9626.84. Right underneath that I show that the result should be $10,021.74 if calculated manually. Hopefully, I've answered your question?