Skip navigation
1603 Views 2 Replies Latest reply: Jun 25, 2011 1:03 PM by A.Non RSS
MarkMcMullan Copper 13 posts since
Jun 15, 2011
Currently Being Moderated

Jun 24, 2011 3:37 AM

Cash Flow Calculations

Hello All,

 

I am currently working on a project, and would like to graphically show the cash flow for the project over its lifetime (N years) on the x-axis. I have calculated the capital costs, annual costs and revenues, and a one off cost which happens in K-years time. I would like to be able to vary the various parameters (K,N, etc.) and the graph to update automatically. I imagine I need a matrix of N numbers, but am lost as to how to implement this.

 

Any help would be greatly appreciated.

 

Mark

Attachments:
  • A.Non Diamond 10,404 posts since
    May 11, 2010
    Currently Being Moderated
    Jun 25, 2011 1:03 PM (in response to MarkMcMullan)
    Re: Cash Flow Calculations

    The underlying cause of your problem is that you are doing things in what I would call the "spreadsheet way". You start with a vector of numbers, and at every step of the calculation you calculate a new set of numbers. That's usually not the best way to do things in Mathcad. It's better to start by defining variables that really will be constant (i.e. they have one value, and you will never want to change that value). Then make every expression a function of the variable(s) you may want to change. Then you can evaluate the functions at any point in the sheet, and you can do so for different values at different points in the sheet.

     

    To solve your immediate problem, make everything functions of N and K. So the definition of PVFmp becomes

     

    PVFmp(K):=delta^K

     

    The definition of PVmp becomes

     

    PVmp(K):=Cmp*PVFmp(K)

     

    and so on. Similarly for functions that depend on N, such as ACcap. Eventually you will have a function that depends on K and N, and then you can vary them at will.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 3 points
  • Helpful Answers - 1 points