Federal tax benefit (liability)

  • Christopher J Castro
  • Topic Author
More
12 Sep 2022 19:49 #11446 by Christopher J Castro
Federal tax benefit (liability) was created by Christopher J Castro
I am running a Sole owner solar farm model. When looking at the Cash Flow I notice after year 7 my After Tax returns shows a negative return. This seems incorrect as the input variable for Federal income tax rate does not equal Pre tax return multiplied by the fed tax rate. What am I missing here?
For example on the Cash flow:
Fed income tax rate = 21%
Total Pre tax return = $158,180
Federal tax benefit (liability) = $136,786

However,  $158,180 x .21 = $33,217.8
Thank you,

Please Log in or Create an account to join the conversation.

  • Paul Gilman
More
12 Sep 2022 20:37 #11447 by Paul Gilman
Replied by Paul Gilman on topic Federal tax benefit (liability)
Hi Christopher,

If you are using a Windows version of SAM (and have Microsoft Excel installed on your computer) you can use Send to Excel with Equations from the Cash Flow tab to export the cash flow data from SAM to a special Excel file that replicates SAM's cash flow calculations. That may help you troubleshoot the cash flow calculations.

If that doesn't help, please attach a copy of your .sam file so I can investigate.

Best regards,
Paul.

Please Log in or Create an account to join the conversation.

Moderators: Paul Gilman
Powered by Kunena Forum