Suoritettu

loan factoring modeling in excel

Excel loan calculator for merchant cash advance (factoring) that allows me to do the following:

enter term in days (weekdays only, no federal holidays)

use money factor rather than interest rate (ex. 1.29 instead of 29% apr)

allow me to calculate funds out is I start another loan of the reuse of the receivables in from existing loans

be able to enter servicing % or fee for each loan/advance

be able to enter management % or fee for each loan/advance

allow to enter a bad debt % based off of previous loans (to model out or project actual payback)

calculate IRR over 18months

The idea is to loan/advance a customer #1 $10,000 @ 1.29 = $12,900. Have them pay back in 100 days (or 5 months if you calculate 20 business days per month). The payment would be $129 per day ($100/day in principal and $29/day in interest). So if a customer has had the loan for 39 "payment" days (or approximately 2 months) then they would have paid $5,031. That means I can "redeploy (or loan/advance a different customer) Customer#2 $5,000 @ 1.29 for 50 (or X number of) days = $129/day. If you add customer #1 $129 with customer #2 $129 that means we are at $258/day. So in 20 "payment days (or 1 month) we can loan customer #3 $5000. And the cycle continues. The maturity date starts from the initial loan/advance to customer #1. That means regardless of how many "redployments" we make all the money needs to be back in the bank by the 18th month. Also, we want to be able to inject additional cash at anytime. Meaning if the payment for customer #2 and customer #3 is $258/day; after 20 days we have $5k. If we were to add $10k to that, we could loan/advance customewr #4 $15k.

I have an example of what I'm looking for. It was built off of a mortage calculator.

Taidot: kirjanpito, tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: real estate development modeling excel, financial modeling excel outsourced, commercial real estate modeling excel, finance modeling excel, financial modeling excel specialist freelancing, financial modeling excel, loan replayment foumla excel, loan modification software excel, bank modeling excel, data modeling excel, best loan versus rent excel, loan modification worksheet excel, modeling excel xcelsius, pro forma modeling excel, examples test loan repayments using excel

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15491966

Myönnetty käyttäjälle:

polarjin2017

..........................................................................................................................................................................

250 $ USD 1 päivässä
(6 arvostelua)
3.6
ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) Habilidades y experiencia relevante I guarantee you an accurate job, full functionality Lisää

250 $ USD 2 päivässä
(15 arvostelua)
3.2

19 freelanceria on tarjonnut keskimäärin 393 $ tähän työhön

wsh2

Greetings Tim, Highly experienced (25+ years) EXCEL Programming and Database expert. Strong Automation, Data Integration, Modeling, and User (friendly) Interface skills. Confidentiality guaranteed Relevant Skills Lisää

555 $ USD 10 päivässä
(34 arvostelua)
6.0
400 $ USD 10 päivässä
(47 arvostelua)
5.9
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills an Lisää

250 $ USD 1 päivässä
(39 arvostelua)
5.0
rumarahman

Hi, I am an expert excel worker and I do programming on VBA Excel to gather data from internet automatically. So that I am the suitable one you are searching for, Sir. Thanks. Relevant Skills and Experience Web Sear Lisää

250 $ USD 3 päivässä
(26 arvostelua)
4.8
c4cuteconain

As far Excel is concerned can do anything you want, I am an ACCA with enough knowledge to complete this project Relevant Skills and Experience Accounting, Data Entry, Data Processing, Excel Proposed Milestones $250 U Lisää

250 $ USD 10 päivässä
(16 arvostelua)
3.9
VangHaleena17

Hello You can see also my France client e-commerce site url [url removed, login to view] and [url removed, login to view] site for my HONG KONG client. Relevant Skills and Experience I will send y Lisää

500 $ USD 10 päivässä
(1 arvostelu)
3.4
naseefo

Hi there! I am an expert on MS Excel and has experience in using advanced VBA functionalities and coding. I can fully dedicate my time to complete your work within the next two days. Relevant Skills and Experience - E Lisää

560 $ USD 2 päivässä
(6 arvostelua)
3.4
anzarulislam

Hello, I am Expert in Data Entry Who knows the value of time, Very hard working and always delivers the work on time. If you are looking for data entry or search work, I am the Right person for you. available Lisää

500 $ USD 10 päivässä
(4 arvostelua)
3.5
mikhailkozalski

I am a great mathematician. Relevant Skills and Experience Office, math,VBA Proposed Milestones $666 USD - One

666 $ USD 10 päivässä
(1 arvostelu)
2.4
hsingla85

Available Immediately | CFA level III | Only $50 for the calculator | MS Excel Relevant Skills and Experience MBA in finance Proposed Milestones $277 USD - file

250 $ USD 1 päivässä
(4 arvostelua)
2.1
sufiabdulstar4

Hi Sir,I am happy with your description and looking forward to work with you. Since i am a fresh freelancer with few reviews, i would like to work with you for any budget and expecting a good review Relevant Skills an Lisää

250 $ USD 10 päivässä
(0 arvostelua)
0.0
555 $ USD 10 päivässä
(0 arvostelua)
0.0
UMESH54321

A proposal has not yet been provided

555 $ USD 10 päivässä
(0 arvostelua)
0.0
prateekkara

I have done the similar modelling for Micro Financing and Small Banks to manage the cash flows and estimates the cash flows to re-lend the money to a new customer based on the inflows Relevant Skills and Experience I Lisää

250 $ USD 3 päivässä
(0 arvostelua)
0.0
lplowu

This is exactly what I did for an emoyer for over 11 years. This is my comfort zone. Relevant Skills and Experience I created spreadsheets for various accounting processes that calculated expenses, payments, commissio Lisää

566 $ USD 10 päivässä
(0 arvostelua)
0.0
JEmanuelSousa

Bid is for 5 days work. Relevant Skills and Experience I am a math teacher with experience in working in excel. I am confident i can create the excel calculator you wish and deliver on time. Proposed Milestones $283 Lisää

283 $ USD 5 päivässä
(0 arvostelua)
0.0
xlbymalix

Excel VBA and Financial Exepet Relevant Skills and Experience Excel VBA and Financial Expert Proposed Milestones $333 USD - Full Price

333 $ USD 10 päivässä
(0 arvostelua)
0.0