Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel help with spreadsheet

    Can anyone figure out what is going on with this spreadsheet? It is a development model used in Real Estate. Any help would be appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    At a glance, the function EOMONTH used on the worksheet Cash Flow Summary worksheet isn't working. That will likely be because you don't have the Analysis ToolPak add-in.

    There may be other function and/or name issues but I have not done an exhaustive check.
    Last edited by MartinM; 2013-12-04 at 15:44.

  3. #3
    New Lounger
    Join Date
    Dec 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Martin, Thanks for the feedback. I've installed the Analysis ToolPak now, but still having trouble on the Cash Flow Summary and on the Assumptions worksheets. There are some values in red if you scroll to the right of the Assumptions page that reference a table. Do you know what that is about?

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    On the cash flow, line 60 is a problem because of the N/As generated in line 59.
    M47, etc. is missing the numerator in the division calculation, which leads to the problem in M49.

    The budget sheet has a circular reference.

    Just a few I caught.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •