Find Jobs
Hire Freelancers

Debt modelling: make a daily calculating monthly capitalising interest sheet for me

$30-250 AUD

Completed
Posted almost 4 years ago

$30-250 AUD

Paid on delivery
Please apply if you have financial modelling experience and can action today I would like a simple excel sheet built that does the following: 1. I lend out money at 22% a year with interest calculated daily but capitalised monthly (end of month) 2. I want to show the effects of daily drawdowns of $5k over a six month period 3. Interest is repaid at the end of 18 months (depending on date of drawdown). This implies end date will be 18 months after the last drawdown in 6 months I suspect a using a method similar to rolling offset for depreciation might solve for this but cant figure it out right now Please only serious applicants apply. Will be a lot of follow on work from this if you can solve it easily/quickly enough Ive attached rough workings that i started on using individual schedules but this makes the file unworkable so something that consolidates it easily will be better
Project ID: 25852085

About the project

19 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I can create a daily cash in for 6 months and cashflow from 18 months for an individual using simple future value or loan functions. If the purpose is to see the effect of daily cash drawn on the interests paid in the future. I have seen the attachments and can help you with simplifying the model. Please reach out to me to discuss further.
$67 AUD in 1 day
5.0 (24 reviews)
5.0
5.0
19 freelancers are bidding on average $125 AUD for this job
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Have expertise in excel and formulas. I am available and can start today. Willing and looking forward to working with you. Thank you, Regards.
$250 AUD in 4 days
5.0 (142 reviews)
6.7
6.7
User Avatar
Hey there! Your project jumped out at me, and I would love to help you out with it. I specialize in Excel and Custom Excel Sheet Creation. I'm a detail-oriented person who delivers given projects on deadlines. I read through the entire project and understood it. I am able to create your Excel sheet according to your requirements with 100% accuracy and quality. This is an ideal project for my capabilities. I'm looking forward to a long term commitment and for ongoing work with you. Check my reviews to get an idea about my work. I'm online at the moment, feel free to initiate a chat; we can discuss further regarding your project. Hope to hear from you. Best Regards, Ravindu :)
$200 AUD in 2 days
5.0 (42 reviews)
6.2
6.2
User Avatar
Dear Sir, I have read your project details and reviewed the attachment carefully. I can make Debt modelling by maintaining 100% accuracy of your data absolutely as you want. I am an Excel Formula Generation, VBA Macro Coding and Automation Process expert with 5* ratting. You don't have to pay upfront, we can work on milestone basis. I can start right now, please message me to discuss more. Regards, Anowar
$89 AUD in 2 days
5.0 (203 reviews)
6.1
6.1
User Avatar
Hello ,how r u , I' m mechanical engineer and i have a advance knowledge about economic and i can do this on time and perfect result
$100 AUD in 1 day
4.8 (45 reviews)
5.0
5.0
User Avatar
Hi, Good Day! I can help you building Automated Cash Flow tool using MS Excel and VBA macro. Most of client need an excel tool that has userforms to make more user friendly and organize. I can help you build that tool. Please message me to discuss more about the project and I can also send you some of my works to help you decide on hiring me. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$100 AUD in 3 days
4.9 (55 reviews)
5.0
5.0
User Avatar
hello! I have checked your excel spreadsheet. I know what was wrong with your formula. Just message me to discuss it further. thanks! ken
$40 AUD in 1 day
4.9 (45 reviews)
5.1
5.1
User Avatar
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; Excel Statistics Finance Mathematics Statistical Analysis 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 AUD in 3 days
4.9 (16 reviews)
4.8
4.8
User Avatar
Hi I am a Chartered Accountant and a finance expert. I understood your requirement and will be able to deliver as per your timing. If you add me to your chat we can discuss and finalize.
$167 AUD in 3 days
4.6 (14 reviews)
4.4
4.4
User Avatar
Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and data visualization. I promise you for a quality work at an effordable price on time. Expecting a reply soon. Thank you.
$79 AUD in 1 day
5.0 (10 reviews)
3.7
3.7
User Avatar
Hi there! I have read your job posting about lfinancial analysis amd modelling and i am interested to help you doing this job. As statistician who has 6 years experience in data analytic and statistics make me master a lot of statistics techniques especially especially on finance. i can start work now and If you're interested to discuss your project detail with me, feel free to message me, i'll be happy to solve your problem Best regards Ardiansyah
$165 AUD in 1 day
4.8 (4 reviews)
3.4
3.4
User Avatar
i have read you project title " Debt modelling: make a daily calculating monthly capitalising interest sheet for me " and i would like to help you . I have gone through you project requirements, and I’m willing to be the writer to handle the task for you. We could discuss the assignment further for more clarification and to share ideas which may help in managing the job. I will be giving you occasional updates and uploading drafts as the time frame counts on. Kindly don’t hesitate to message me if interested in my services. you can hire me directly though my profile link below in if the project is deleted https://www.freelancer.com/u/errandssolution
$140 AUD in 3 days
4.7 (5 reviews)
3.4
3.4
User Avatar
A Certified Public Accountant (CPA K), and Certified Investment & Financial Analyst (CIFA), with over 8 years’ experience in developing financial models and investment teasers for start ups and reputed organisation across all industries. As a qualified and registered accountant, I have been involving in,providing accounting services for several companies such as preparation of financial statements, strengthening of internal controls and installation and training of use of pastel and quickbooks software's. Am the one you are looking for!
$30 AUD in 1 day
0.0 (0 reviews)
3.0
3.0
User Avatar
The ability of work is mandate and also the interest towards it. I have those two things so through which i can do the work in on time
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please consider my portfolio for your BPO and Finance &Accounting projects. During my tenure till date I have been working as a BPO manager in F&A. I can benefit your projects as I have sound experience in Financial Accounting and Excel. I have the ability to work collegiality along with the team or as an independent freelancer. I look forward to being hired by you.
$30 AUD in 1 day
5.0 (2 reviews)
0.0
0.0
User Avatar
Hello, You need to take in consideration time decay. Lending performance is not the same wether you are at the middle of the year or at the beginning. I had built graphs and formulas for quatitative trading company. I'm your man for this project. Best regards Jason
$140 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
North Bondi, Australia
4.9
9
Payment method verified
Member since Feb 17, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.