LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default Position Input data in Cash Flow table

I hope I can explain myself clearly!!

I am setting up a worksheet to enable the construction of a cash flow chart
relating to property development. I have an input section where I can select
the month in which an activity will commence, how long it will run for and
when it will end. I can also select the months in which payments should be
made, as a percentage of the total payments.

For example, I might input that the construction stage commences in month 3
and run for 10 months. I am struggling to get my mind around how to set up
worksheet so that the relevant costs for construction are shown in the cash
flow as commencing in month 3 and as continuing for 10 months.

I also wish to show costs as being apportioned at stages along the 10 month
period again as per data entered into input section.

I really hope this makes sense. Can anybody give me any advice as to how I
might be able to link the input data with the Cash Flow as per my rough
explanation above?

Many thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to index the closest data(cash flow)? [email protected] Excel Worksheet Functions 5 June 12th 07 08:34 PM
Cash Flow Lindy-Jane Charts and Charting in Excel 1 November 28th 06 02:19 PM
Cash Flow Omalley Excel Discussion (Misc queries) 2 July 28th 05 01:16 PM
Cash Flow [email protected] Excel Programming 1 July 27th 05 06:19 PM
Cash Flow Set-Up Gary T Excel Worksheet Functions 0 January 13th 05 05:07 PM


All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"