Delayed Construction Starting Date

  • Anonymous
    Inactive
    7 years, 3 months ago #2690

    Hi Spencer,
    Great work and a hell of initiative! Congratulations!
    It seems I´ve got a problem in the Budget tab of All in 1 Model.
    I start with my analysis in a given month, let’s say today, Feb2018 and, due to licensing time delays, my construction works are just planned for getting started 6 months later. However, I have to secure my plot: my first disbursement is next month, Mars 2018.
    In Summary tab, I have registered all those different dates: Feb for Analysis Start Date; Development Lenght, Development Start and Dev End Dates. In Budget tab, I´ve chosen a S-curve model distribution. However, the monthly distribution does not recognized the pace of my scheduled development. And when I try to force it, reports and error and shut down excel, altogether.
    Thanks in advance for your tips,
    Joaquín

    Spencer Burton
    Keymaster
    7 years, 2 months ago #3218

    Hi Joaquin,

    Wow, I missed this question – I really apologize for not getting to it sooner! I’m guessing the issue is related to the Start Month and Budget Item length assumptions in your Budget tab, but I find it strange it’s shutting Excel down.

    I know it’s been a month since your inquiry, but if you’re still running into this issue, I’d be happy to take a look at your file and see if I can’t troubleshoot the issue. Post the file in your response and set the reply to private, and I’ll take a look and get right back to you.

    Spencer

    Anonymous
    Inactive
    7 years, 2 months ago #3220

    Many thanks for your response Spencer.
    Apparently in the last update of A.CRE the shutdown problem has been solved. The model shows a red warning “Error in Budge Timing: See red cells below”. That’s not a big deal, cause it does not affect the rest of calculations, namely Dev- Interest Calculations tab.
    In any case, herein I enclose the file for your consideration.

    Again, congratulations for your initiative and your spirit on maintain it.
    Joaquín

    Spencer Burton
    Keymaster
    7 years, 2 months ago #3222

    Joaquin,

    The red “Error in Budget Timing” alert is part of the error checking feature I’ve added to the Budget tab. Essentially, this tool checks the periodic budget cash flows (shown along the right-hand side of the page) and confirms that the sum of each exactly matches the amount budgeted for each item along the left-hand side. When the cash flows don’t match or the draws are schedule for periods beyond the pre-set construction period length (set on the Summary tab), then a red alert appears along the top of the page as well as next to each incorrectly modeled item.

    So in the case of your model, the reason the alert is triggering is that several items are modeled to draw beyond the 16 months construction period you set on the Summary tab. Make sure your ‘Start Month’ plus ‘Length (in Months)’ does not exceed your construction period and/or increase your ‘Development Length’ assumption in cell M13 of the Summary tab so that you’re not attempting to make draws beyond your construction period.

    Let me know if you have any other questions!

    Spencer

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.