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

Completed Posted 3 years ago Paid on delivery
Completed 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

Excel Mathematics Statistics Statistical Analysis Finance

Project ID: #25852085

About the project

19 proposals Remote project Active 3 years ago

Awarded to:

ajaykumar0701

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

$67 AUD in 1 day
(24 Reviews)
5.0

19 freelancers are bidding on average $125 for this job

periyannas

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

$250 AUD in 4 days
(142 Reviews)
6.7
RavinduJayzz

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

$200 AUD in 2 days
(42 Reviews)
6.2
AnowarRatul

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

$89 AUD in 2 days
(203 Reviews)
6.1
enghamza12

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
(45 Reviews)
5.0
paulodayto08

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

$100 AUD in 3 days
(55 Reviews)
5.0
sevillajk01

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
(45 Reviews)
5.1
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 AUD in 3 days
(16 Reviews)
4.8
caharshadshinde

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
(14 Reviews)
4.4
faiiz

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 dat More

$79 AUD in 1 day
(10 Reviews)
3.7
analystardi

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

$165 AUD in 1 day
(4 Reviews)
3.4
errandssolution

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

$140 AUD in 3 days
(5 Reviews)
3.4
AmazingEngr76386

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

$30 AUD in 1 day
(0 Reviews)
3.0
phani1133

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 Reviews)
0.0
basheerpassela

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

$30 AUD in 1 day
(2 Reviews)
0.0
nerdd97

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 More

$140 AUD in 1 day
(0 Reviews)
0.0