Closed

Need an excel sheet created to calculate past due amounts and interest and penalties -- 3

Hi.

I ok on excel, but just hit a brick wall trying to create a sheet to calculate compounded late fees and yearly interest on about 14 accounts that are 10 to 14 years behind in monthly payments. I need to have an excel sheet that calculates the current balance for principle, late fee and interest as per:

accounts are 14 years past due.

monthly amount due was one amount($35) and changed to a different amount ($50). I need to be able to enter the original date of non payment, the monthly amount that should have been paid on that date, the date the monthly amount changed and what that amount changed to, the end date that the whole period should be calculated to.

10% penalty on deliquent amount after first 10 days of non payment.

12% interest per annum from date of deliquency until paid.

the attached image is the contract verbiage defining the penalty and interest.

Does not need to be fancy or full of graphs and such. Just need to get total amounts. creating separate sub excel sheets with amatrozation tables would be useful, but not a requirment

Skills: Accounting, Excel, Finance

See more: how to calculate remaining principal on a loan in excel, pmt function excel, excel formula to calculate days past due, how to calculate principal and interest on a loan in excel, outstanding balance formula excel, how to calculate loan amount in excel, outstanding loan balance formula excel, excel amortization schedule with irregular payments, need 393 produtcts excel sheet, pre created excel sheet quality center, need excel spreadsheet created, need excel sheet, calculate zigzag indicator excel sheet, calculate profit amazon excel sheet, excel sheet calculate entries exits, need excel sheet created pdf, need data prepare excel sheet, i have 60 business cards which i need the data to be entered into an excel sheet each category to have, i have about 225 emails from which i need to have certain information transferred to an excel sheet there are 4 fields that i ne, i need you to fill in a spreadsheet with data its an easy task to enter the data in excel sheet

About the Employer:
( 0 reviews ) Los Angeles, United States

Project ID: #26808309

36 freelancers are bidding on average $123 for this job

asin1987

Dear Employer, I am an Excel expert and have been working on process automation projects since a decade now. Please consider me for this job, I will deliver a highly professional project. Please do check my previous More

$200 USD in 2 days
(203 Reviews)
7.8
schoudhary1553

Hello, I can create excel sheet created to calculate past due amounts and interest and penalties I have gone through your job posting and become very much interested to work with you. I am an expert in this field. More

$180 USD in 4 days
(355 Reviews)
8.0
P0L

(409 Reviews)
7.6
(279 Reviews)
7.1
(109 Reviews)
6.5
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$100 USD in 3 days
(78 Reviews)
5.8
kanchana1974

Hi, I am a Finance & Accounting Professional with MBA Finance, CMA qualification and have experience in Finance & Accounting functions. I have knowledge & working experience in MS Excel / Spreadsheets and would be More

$100 USD in 7 days
(49 Reviews)
5.6
Orientwork

Dear Sir/ Madam How are you?? I am ready to do your job right now, please give a chance to serve you. https://www.freelancer.pk/projects/excel/Need-calculations-done-inserted-into/details Thanks

$50 USD in 7 days
(60 Reviews)
5.1
ShereenaWP

Hello I recently did a very similar work. I am a certified accountant with an engineering background in computer science. Kindly message me to discuss further. Regards, Shereena Wilson P

$222 USD in 2 days
(18 Reviews)
4.6
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create invo More

$150 USD in 3 days
(6 Reviews)
4.4
SIBTEHASSANBUTT

Hi there, I am a professional accountant dealing with PowerBi and well versed with data analytics using excel and other data visualization platforms. I have already done numerous projects of this sort. https://youtu. More

$140 USD in 7 days
(11 Reviews)
4.1
ajaykumar0701

I can create the calculator which provides the interest, dues and penalties as per user's input of amount, default date etc. It can be done within the day itself. Please reach out to me to discuss further.

$50 USD in 1 day
(8 Reviews)
4.3
sdroberts

Hello I'd love to help with your debt repayment spreadsheet. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I worked with a variety of cashflow p More

$125 USD in 1 day
(8 Reviews)
4.0
braincenter

Hello, Hope this message finds you well, I checked your details and I believe that my experience is what you are looking 4. I have been working on similar projects for the past eight years, and I have the essential sk More

$150 USD in 7 days
(8 Reviews)
3.9
oldaccountant

Already do many similar project and completed it within your budget, time My Qualifications as under-: #Chartered Accountant(ACCA/CPA) #Laywer/advocate #Masters in commerce #Certified Auditor #Certified Valuer #Certif More

$30 USD in 1 day
(11 Reviews)
2.9
jordigual3

Hello. I can have this done in a short time and with excellent quality (10/10) My name is Jordi Gual, founder and owner of XPRO, a mexican company dedicated to Excel & VBA applications development which currently prov More

$60 USD in 1 day
(6 Reviews)
2.3
PoojaGupta002

Hi there, I am an expert in excel formulas, dashboards, macros. I have gone through the description on your project and will be able to finish before the deadline. Thanks Pooja

$50 USD in 2 days
(1 Review)
1.3
maisuradzeeka5

I am a high qualified accountant. I love my job

$156 USD in 3 days
(0 Reviews)
0.0
sscbe

Hi,, I can do thi project for you. Look very interesting & challenging . I am good at Excel and have done similar jobs. Give me an opportunity and you will be provided with an error free package. Thanks

$135 USD in 7 days
(0 Reviews)
0.0
regsaccounting

Hi I am Renato G. Salicsic a Certified Public Accountant (CPA) Phils and Certified Management Accountant (CMA) Australia, having more than 18 years of experience in accounting and financial management. I have read you More

$30 USD in 7 days
(1 Review)
0.0