Term Deposit Interest Calculator Can You Help Me Make An Excel Equation?

Can you help me make an excel equation? - term deposit interest calculator

Hello! I try to create a simulator of interest for certificates of deposit in Microsoft Excel.

For those who are not familiar, accounts of CD interest rates for a specified period. For example, a CD $ 100 would earn at a rate of 8% over 8 U.S. dollars within 12 months. He earns about $ 4 for a period of 6 months.

The worksheet is designed to enter the amount of openness, speed, and then the days of each month term.

My problem, however, I get the right formula for different conditions. With what I have now, the gap will be only the total amount of interest for 12 months for many months, however, introduced.

Q: *** You know, what formula could be used to make this work well?

To be a bit clearer now, the formula which says that if you enter a zero for "day" in the area next month, the interest payment divided by the proportion that account for this term. not only reduces the output in a month, but all