Devam Ediyor

Cashflow model

I need a couple of formulas for a daily cash flow model

1. A formula for payment date based on a variable (see cell B9) for credit terms. Example if the supplier has 3 day credit term the delivery on 4/2/2013 (cell C9) would be payable on 4/5/2013 (cell F11). I would like to be able to adjust cell B9 based on the credit terms of different suppliers and to have the capability to have at least 14 days as options (multiple if statements ?). The next issue is that if the due date falls on a weekend (Sat & Sun), or a federal holiday (see row 6), the payment will occur on the next business day after a weekend or a holiday.

2. We have recurring expenses that are due on certain days of the month (see Cell B15). Like the prior formula if the payment date falls on a weekend or holiday the payment will occur on the next business day after the weekend or holiday

Beceriler: Excel

Daha fazlasını görün: excel model, excel recurring, excel 2013 formula, excel formula next month, model based excel, excel business expenses, model excel, expenses excel, magento multiple flat rate shipping options, recurring excel, cash flow excel, cashflow, excel cash flow, multiple flat rate shipping options magento, daily cash flow excel, cashflow excel, marquee multiple statements, daily payment excel, vba sum multiple statements, day day expenses excel, capability statements, days cash delivery, options model excel, variable excel, multiple formulas excel

İşveren Hakkında:
( 5 değerlendirme ) `Washington, United States

Proje NO: #4414219

Seçilen:

sasindiv

Hi, Please check your PM for my queries.

2 gün içinde 35$ USD
(3 Değerlendirme)
2.6

12 freelancer bu iş için ortalamada 52$ teklif veriyor

ethicalboy

This seems interesting project.

in 2 gün içinde30$ USD
(22 Değerlendirme)
4.4
seaanddream

Hello, I exactly understood what you need. your top-rated excel vba expert is ready to support you. regards,

in 3 gün içinde60$ USD
(17 Değerlendirme)
3.9
soikaushik2013

Hi, I'm interested to take your project. Thanks.

in 2 gün içinde30$ USD
(2 Değerlendirme)
2.0
isupportu

Hello, i can do this ., please check PM..

in 2 gün içinde55$ USD
(4 Değerlendirme)
2.0
caabdul

Have it done in 36 Hours! Perfect model, Thanks

in 2 gün içinde30$ USD
(1 Değerlendirme)
1.4
AsifAliSE

Let us discuss more !plz

in 3 gün içinde140$ USD
(0 Değerlendirme)
0.0
anamaria1979

Hy! I am a teacher and I want to work in this project.I. Thank You!

in 4 gün içinde66$ USD
(0 Değerlendirme)
0.0
mukki007

Greetings!! I'm ready to start. Please send me [url removed, login to view]

in 3 gün içinde35$ USD
(0 Değerlendirme)
0.0
Lauri007

I have all the necessary abilities to rapidly fulfill your request. Please check you PMB

in 2 gün içinde88$ USD
(0 Değerlendirme)
0.0
davecoleman

Hi, happy to assist with request.

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
SCRdataPro

Hello, as a management accountant I face excel related challenges like the one you describe on a daily basis. So, if you´re interested in getting a professional solution within 24h, please let me know. Kind reg Daha fazlası

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0
CreativeInfusion

I understand your problem statement and working on the solution. Please read PM

in 4 gün içinde100$ USD
(0 Değerlendirme)
0.0