**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Could you create table with a compound interest of 5% monthly, If I input a capital it will automatically compute how much my borrower need to pay each semi monthly for the whole year.

Solved by I. W. in 22 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
04/05/2018 - 02:17

Hello
Welcome to Gotit pro,
your problem will be higly answered
here.

User
04/05/2018 - 02:17

thank you

Excelchat Expert
04/05/2018 - 02:17

May I ask if you have already a file or data?

User
04/05/2018 - 02:17

None so far

Excelchat Expert
04/05/2018 - 02:18

ok

Excelchat Expert
04/05/2018 - 02:18

base on your problem, do you want a table for compound interest right?

User
04/05/2018 - 02:19

yes exactly

Excelchat Expert
04/05/2018 - 02:19

ok, I will try on it first and will discuss you once done

User
04/05/2018 - 02:19

ok sure

Excelchat Expert
04/05/2018 - 02:20

do you want to display with this format?

User
04/05/2018 - 02:21

probably yes to easily check

Excelchat Expert
04/05/2018 - 02:21

ok :)

User
04/05/2018 - 02:23

could you also add additional column for the remaining capital per month? then make the month as semi monthly

Excelchat Expert
04/05/2018 - 02:23

ok this is noted

User
04/05/2018 - 02:23

but still the interest was based on a month

Excelchat Expert
04/05/2018 - 02:23

ok analyzing on it now :)

User
04/05/2018 - 02:23

thanks

Excelchat Expert
04/05/2018 - 02:29

Is it want you want to have?

User
04/05/2018 - 02:29

yeah thats looks great

User
04/05/2018 - 02:30

what was that the another column with the Principal Header?

Excelchat Expert
04/05/2018 - 02:30

oh that was your capital divided only into 24

Excelchat Expert
04/05/2018 - 02:31

since our table was payment for semi monthly for the whole year

Excelchat Expert
04/05/2018 - 02:31

in order to get the total payment per semi monthly we need to get that and add the interest

Excelchat Expert
04/05/2018 - 02:32

i made the interest as 2.5% since it was semi monthly, so it will be 5% for the whole month

User
04/05/2018 - 02:32

I see thanks it looks awesome

User
04/05/2018 - 02:33

does the table will change if I change the principal?

Excelchat Expert
04/05/2018 - 02:33

yes you may try it

User
04/05/2018 - 02:33

ok

User
04/05/2018 - 02:34

it was nice

Excelchat Expert
04/05/2018 - 02:34

thank you :)

Excelchat Expert
04/05/2018 - 02:35

payment there was the sum of the Pincipal coumn & the interest column

Excelchat Expert
04/05/2018 - 02:36

then for the Capital column, that was your remaining balance per semi monthly when we decrease the payment for the previous period

User
04/05/2018 - 02:36

yeah great I love this one

User
04/05/2018 - 02:36

I could i get this file?

Excelchat Expert
04/05/2018 - 02:36

you download it

Excelchat Expert
04/05/2018 - 02:36

just click the file

Excelchat Expert
04/05/2018 - 02:37

on the above tool

Excelchat Expert
04/05/2018 - 02:37

then download as

Excelchat Expert
04/05/2018 - 02:37

then select microsoft excel

User
04/05/2018 - 02:37

ok thank so much

Excelchat Expert
04/05/2018 - 02:37

no problem :)

Excelchat Expert
04/05/2018 - 02:38

Is there anything else you want to know regarding this issue?

User
04/05/2018 - 02:38

Nothing I'm good with this

Excelchat Expert
04/05/2018 - 02:38

great :)

Excelchat Expert
04/05/2018 - 02:38

Thanks for using Got It Pro. Please give your kind feedback for our service.
On your window, kindly don't just close the window, there is an end button there so you could end the
session properly & message will appear to ask for the feedback :) Have a good day ahead ^_^

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*