#Name Error on Budget Sheet

  • Lizzie Boyer
    Keymaster
    7 years, 9 months ago #2440

    Not sure what this issue is in the All in One Underwriting Model for Development & Acquisition. The Budget sheet shows #NAME? in the first seven columns and the Forecast Method does not allow the drop down changes. Error Check is not working and costs are not spreading across the months. I’m guessing there is a simple explanation.

    Spencer Burton
    Keymaster
    7 years, 9 months ago #2804

    Thanks for the heads up! It probably is a simple fix but tough to say without seeing the Workbook. Would you shoot me over your file and I’ll take a look.

    Lizzie Boyer
    Keymaster
    7 years, 9 months ago #2806

    I have Microsoft Office Excel 2007 if that makes a difference.

    I’m sending you the original download and a version I added some information to.

    Spencer Burton
    Keymaster
    7 years, 9 months ago #2808

    I don’t believe your Excel version is the issue, although I’d suggest you upgrade at some point. Looking through your file, you added a few new rows on the budget tab under Soft Costs. I believe this created the error as the S-Curve calculations are done in a separate tab (‘Dev-SCurve Calc’). Without adding new rows to the Dev-SCurve Calc tab to match the new rows on the Budget tab, the model will error out.

    I’m developing instructional videos for each tab and will be sure to mention this issue when I get to the Budget tab training. I might also add functionality to add more budget rows, but for the meantime I’d suggest you move a few of your items such as Insurance and Misc. Costs to the ‘Other’ section of the Budget.

    As a side note, your model also helped me identify another small issue. Your construction period is starting a couple months after the start of your analysis period (March vs May) creating two months of zero unlevered cash flows. This is causing the Avg. Free and Clear return metric to error out on the Summary tab (cell T8). I’m releasing a new version with a host of bug fixes today (I’ll shoot you a copy when it’s done) and I’ll include a fix for that one as well.

    Lizzie Boyer
    Keymaster
    7 years, 9 months ago #2810

    What is confusing is I just again went back to my download folder and opened the untouched version of the spreadsheet delivered to me by your email system and opened up an original clean file.

    1. Open original file (no data entered)
    2. Activate Macros
    3. Went to Summary Tab
    4. Turned on Development Module
    5. Changed Construction Length to 12 Months (development tabs appear)
    6. Go to Budget Tab and none of your prefilled budget numbers are spread. Same problem as I described before.

    I attached your original file which has not been saved over. Any additional thoughts. Maybe this copy was corrupted somehow otherwise it seem Office 2007 may not be compatible for some reason.

    Does it work for you if you open the attached file?

    Spencer Burton
    Keymaster
    7 years, 9 months ago #2812

    Working on my end – sounds like it is incompatible with Excel 2007. I wonder if the NORM.DIST() I use in the S-Curve calculation isn’t supported by Excel 2007? If you have a second, open your Excel 2007 and type in =NORM.DIST and see if it shows up in Excel’s formula list.

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

You must be logged in to reply to this topic.