Find Jobs
Hire Freelancers

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

$30-250 USD

Mbyllur
Postuar over 3 years ago

$30-250 USD

Paguhet në dorëzim
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
ID e Projektit: 26808309

Rreth projektit

33 propozime
Projekt në distancë
Aktive 4 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
33 freelancers are bidding on average $121 USD for this job
Avatari i Përdoruesit
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 reviews here for your kind consideration: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks, Ashish
$200 USD në 2 ditë
5,0 (281 përshtypje)
8,3
8,3
Avatari i Përdoruesit
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 në 3 ditë
4,8 (81 përshtypje)
5,9
5,9
Avatari i Përdoruesit
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 provides services to over 15 different businesses internationally. Over 7 years of proffesional experience using Excel and Visual Basic. Currently managing a catalog of more than 100 different templates and applications.
$60 USD në 1 ditë
5,0 (34 përshtypje)
5,7
5,7
Avatari i Përdoruesit
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 able to build up Excel sheet / Dashboard for calculation of interest and penalties, as per your requirements. The above would be delivered with high integrity within agreed timelines. Quality is the essence of my delivery and I get into specific details for clarity and efficiency. Looking forward to work with you, Thank you
$100 USD në 7 ditë
4,9 (61 përshtypje)
6,0
6,0
Avatari i Përdoruesit
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 në 7 ditë
4,4 (60 përshtypje)
5,2
5,2
Avatari i Përdoruesit
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 në 2 ditë
5,0 (18 përshtypje)
4,6
4,6
Avatari i Përdoruesit
Hi, I am an excel expert and very interested to do this work. I read your requirement very carefully and understand everything.I have completed many entry project similar to yours for other platform. If you select me for this project I will try my best to complete your project with full of accuracy.
$156 USD në 1 ditë
5,0 (14 përshtypje)
4,7
4,7
Avatari i Përdoruesit
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 në 1 ditë
5,0 (12 përshtypje)
4,7
4,7
Avatari i Përdoruesit
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 projections and my daily job entailed calculating pension payments and investment coupons which falls under the same methodology as your work. I'm sure I will be able to provide you with a fast and efficient solution. I look forward to work with you soon. Kind regards Steve
$125 USD në 1 ditë
5,0 (9 përshtypje)
4,2
4,2
Avatari i Përdoruesit
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 skills including; Accounting Excel Finance I will prove to be of great help to you. SEND MESSAGE/CHAT, so that discuss more on the details including budget and deadlines… Please REMEMBER to; Wash your hands frequently, Maintain social distancing, Avoid touching eyes, nose and mouth..., Practice respiratory hygiene, Stay home and if you feel unwell seek medical care early. Regards, BrainCenter Inc
$150 USD në 7 ditë
4,7 (8 përshtypje)
4,0
4,0
Avatari i Përdoruesit
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 në 2 ditë
5,0 (3 përshtypje)
2,1
2,1
Avatari i Përdoruesit
Hello, my name is Umer. Thanks for taking the time to review my proposal! I have read your specific requirement as to the project (Computation of current balance for principle, late fee and interest). Please read my detailed service proposal below. I have more than 5 years of experience in the Use of MS. Excel I work very well with Microsoft Word and Excel, as well as other data programs. I am well acquainted with administrative tasks and can identify errors and deficiencies in data as well as get them correct quickly and efficiently. I'm available to work on your project ASAP, If you are interested please don't hesitate to contact me Thanks in advance for your consideration Umer
$70 USD në 2 ditë
5,0 (3 përshtypje)
1,8
1,8
Avatari i Përdoruesit
Hello, my name is Claudiu Vladislav, I am an Erasmus student in Spain, right now. I would like to work for you, because I like to diversify things. Best regards !
$36 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have been in the field of Accounting for over eight years in the Government Sector. I also capable of typing 150 word per minutes, therefore the level of diversity in my skills and knowledge will prove be valuable to the given task. I consider myself as a hard working individual, with a solid work ethics who applies optimal effort to ensure all task at hand are given utmost priority and are completed on time to the highest standards. I have a great appreciation for diversity because with each individual difference we are able to reshape the workplace to achieve efficiency and effectiveness in productivity. With such diverse view I’m adaptive to changes and a strong ability to work in team. During my current job, I have developed strong competences for team collaboration, the ability to work with minimal supervision, strong problem solving and analytical skills and high personal and professional integrity
$140 USD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Excel expertise of over 10 years from finance background. Contact me in the chat to discuss further.
$55 USD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello I am University Professor of Finance, Financial Mathematics and Engineering Economy. Therefore i am sure I could help you with your project in Excel,, which I use in my classes. Also I have done many Industrial Valuations, and past debts Valuation, Consequently i can deliver a high quality output for you project. Regards.
$60 USD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi! I can solve your problem and build an automated calculation system and organize the tables. I have a master in office packages. regards
$100 USD në 3 ditë
0,0 (0 përshtypje)
1,2
1,2
Avatari i Përdoruesit
I have read and understood the job. I worked in the field of pensions so I am familiar with this stuff. I'm also an expert in excel and vba. Please let me know if my skill set suits your needs. Best regards.
$200 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello., I have experiance on working with a chartered accountant and does these type of work normally. Hope you need a profesional in these type of works.
$100 USD në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have work experience in ms excel of 3 years such as audits working, Taxation, accounting and interest calculation etc.
$150 USD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Los Angeles, United States
0,0
0
Anëtar që nga gush 2, 2020

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.