Federal Income Tax schedule (instead of flat rate) error

10 posts / 0 new
Last post
oavaldezi
oavaldezi's picture
Federal Income Tax schedule (instead of flat rate) error

I've entered a Federal Income Tax schedule, with the rate at 0% for the first 10 years, and 30% afterwards. When I export to Excel with formulas, the values for "After-tax value of energy generated by system" and "After-tax cash flow" are in error, because their formulas reference the "federal_tax_rate" name, and they should reference the "AnnualTaxFederal" name.

Paul Gilman

Hello,

That issue should be resolved in the current version of SAM, which is SAM 2017.1.17 Revision 4. Are you using an older version of SAM?

If you are using the current version of SAM, please email me a copy of the .sam file that causes that problem, or attach it to your original post above.

Best regards,
Paul.

Paul Gilman

Hello,

That issue should be resolved in the current version of SAM, which is SAM 2017.1.17 Revision 4. Are you using an older version of SAM?

If you are using the current version of SAM, please email me a copy of the .sam file that causes that problem, or attach it to your original post above.

Best regards,
Paul.

oavaldezi
oavaldezi's picture

Paul, I've attached the .sam file to my original post. I'm on SAM 2017.1.17, 64 bit, updated to revision 4

oavaldezi
oavaldezi's picture

Terrific product, BTW. Congratulations on an excellent effort.

Paul Gilman

Thank you for attaching the file.

It seems to be working correctly for me in SAM 2017.1.17 r4. Are you seeing something different than this?

Best regards,
Paul.

oavaldezi
oavaldezi's picture

Sorry for my late reply. The data is correct in the 'Inputs and Outputs' sheet. It's the formulas in rows 108 and 115 in the 'Cash Flow' sheet that produce errors because they reference the 'federal_tax_rate' name and value in cell 'Inputs and Outputs'!B42 instead of the 'AnnualTaxFederal' name and values that are begin in cell 'Inputs and Outputs'!C103.

Thanks for your help!

Paul Gilman

Hello,

Thank you for the clarification -- that is a bug in the Cash Flow "send-to-Excel with equations" feature for the Residential and Commercial financial models. The bug only affects the spreadsheet formulas when you use an annual schedule for the state or federal income tax rate instead of a single fixed rate on the Financial Parameters input page. It does not affect SAM's internal calculations.

We will fix it in the next update to SAM 2017.9.5.

For now, you can fix your version of SAM as follows:

  1. If SAM is running, close it.
  2. In your SAM installation folder, find the runtime/spreadsheets folder. In Windows, the installation folder is C:\SAM\2017.9.5. For Mac, see Installation files on OS X.
  3. Download this version of residential_commercial.xlsx from the SAM GitHub repository.
  4. Replace the file in the SAM installation folder with the copy you downloaded.

Thank you for pointing out this issue, and for your patience explaining it to me!

Best regards,
Paul.

oavaldezi
oavaldezi's picture

I tested today with SAM Version 2017.9.5, 64 bit, updated to revision 2, and the bug is fixed! Thanks!

Paul Gilman

Thanks for letting us know!

Best regards,
Paul.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer