Law Class Excel #2: Child Support Payments Template - Jessica's Law Class

Learn how to create a template for Child Support Payments that shows formulas for Support Due, Support Paid, Accrued Arrearage, Monthly Interest. See how to apply formatting and formulas to a template. Learn about Absolute and Relative Cell References. - Jessica Neilson Law Class.

Category:

Education

Tags:

• Excel
• Law
• Child
• Support
• Payments
• Template
• Due
• Paid
• Accrued
• Arrearage
• Monthly
• Interest
• Absolute
• and
• Relative
• Cell
• References
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Jessica
• Neilson
• Class

[abdulmenaam]

please could you show me how to add a new currency in the table ? instead of Dollar $ i would like to put in DL my currency actually, thanks in advance, your vidoes very helpful

[ExcelIsFun]

@abdulmenaam , highlight cells, Ctrl + 1, select Number tab, Select Currency, Change unit on right.

[abdulmenaam]

@ExcelIsFun thanks soooo much i did it successfully

[ExcelIsFun]

@abdulmenaam , EXCELlent!!!!

[shondavictoria]

Could you please help me with a template to calculate interest daily on unpaid child support balance. I am a single mother and would like to track payments and daily interest, please.

[ExcelIsFun]

You can post your Excel question to this site:

mrexcel[dot]com/forum

This is THE best site for getting your Excel question answered

[ExcelIsFun]

Yes, click on the "excelisfun" blue link below video and go to the excelisfun channel at YouTube. Then watch the video that automatically plays and it will show you how to download.

[shondavictoria]

Is there any way I can possibly download this spreadsheet to use?

[ExcelIsFun]

Almost all contracts that involve money owed have language that describes what the interest is if payments are late - child support is no different.

In my opinion, the rate of interest rate on child support should be ten times that of normal bank rates.

There is almost no more paramount duty than to take care of one's offspring.

[UNKPCRIDE]

Interest on child support? never heard of that.