Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Develop formula for cash flow
Hi All,
I am developinga spreadsheet where the user will enter the following data for each entry which will accumulate in a table. Start Date 15-Jan-07 End Date 22-Oct-07 Total days 281 (calculation) Hire Payment per day 10,000 Total Hire Received 2,810,000 (calculation) Payable every (Days) 15 Hire Paid in Advance (this could also be in arrears) How can I develop a formula that will automatically calculate, in a tabulated format going across in months, what is payable and what should be allocated to each specific month. Thank you and a Happy, Peaceful and Productive New Year to all of you/sgl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NPV of Cash Flow Payments | Excel Worksheet Functions | |||
Cash Flow | Charts and Charting in Excel | |||
Cash Flow | Excel Discussion (Misc queries) | |||
Cash Flow by Week | Excel Worksheet Functions | |||
Cash Flow Set-Up | Excel Worksheet Functions |