Debt modelling: make a daily calculating monthly capitalising interest sheet for me
$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
Awarded to:
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 More
19 freelancers are bidding on average $125 for this job
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 c More
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 More
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 More
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
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. More
hello! I have checked your excel spreadsheet. I know what was wrong with your formula. Just message me to discuss it further. thanks! ken
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
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.
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 More
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 More
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 acr More
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
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 Ac More