Devam Ediyor

Cashflow model - repost

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: Veri Girişi, Excel, Photoshop, Powerpoint, Word

Daha fazlasını görün: excel model, excel recurring, excel 2013 formula, excel formula next month, model based excel, excel business expenses, excel formulas data daily, model excel, suppliers data entry excel, expenses excel, magento multiple flat rate shipping options, data entry formula, recurring excel, data entry sat, cash flow excel, cashflow, excel cash flow, sat data entry, weekend data entry, multiple flat rate shipping options magento, daily cash flow excel, cashflow excel, repost business terms, marquee multiple statements, daily payment excel

İşveren Hakkında:
( 0 değerlendirme ) Vavuniya, Sri Lanka

Proje NO: #4414261

Seçilen:

mukki007

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

$2 USD / hour
(1 Değerlendirme)
2.3

7 freelancers are bidding on average $5/hour for this job

sharly001

Ready to initiate the project and willing to deliver the best. Details in PM.

$5 USD / hour
(6 Değerlendirme)
3.1
ranaaq039

ready to start

$5 USD / hour
(1 Değerlendirme)
0.0
jonyup

Dear Hiring Manager, I'm very interested in your job post involving these skills. I have recently worked in another company, where my responsibilities included developing the design I am an expert in ms office, Daha fazlası

$5 USD / hour
(0 Değerlendirme)
0.0
mariusch1641

I am confident in my skills in order to complete the project.

$7 USD / hour
(0 Değerlendirme)
0.0
PPTExcelExpert

I am well experienced in Excel, more than 10 years. I can finish this job within the time frame

$4 USD / hour
(0 Değerlendirme)
0.0
ascomp

I am new on [url removed, login to view] but I'm good, determined and I'm not expensive.

$5 USD / hour
(0 Değerlendirme)
0.0
Franszzp13

Thanks for the opportunity to bid on your project. I'm just retired from working within the Dutch Army. I made many specific programs with MSACCESS/Excell. Please send me more information/files via a private message. E Daha fazlası

$5 USD / hour
(0 Değerlendirme)
0.0