I'm a commercial solar sales rep and our proposal tool just updated the way they show tax effects. I'm hoping you guys can tell me if this looks accurate?

Its the first few years, but thats what looks odd to me.

........https://drive.google.com/a/sooryaunl...ew?usp=sharing.......




https://drive.google.com/a/sooryaunl...ew?usp=sharing

Attached Images

Capture.jpg (151 Bytes, 3 views)

Years Upfront Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Cash
Project Costs -$6,061,440 - - - - - - -
O&M / Equipment Replacement - - - - - - - -
Electric Bill Savings - $420,083 $432,612 $445,503 $458,767 $472,414 $486,453 $500,897
Cash -$6,061,440 $420,083 $432,612 $445,503 $458,767 $472,414 $486,453 $500,897
State Taxes
Income Decrease (O&M / Equipment Replacement) - - - - - - - -
Income Decrease (Project Costs) $6,061,440 - - - - - - -
Income Decrease (State (CA) 10-yr Depreciation) - $606,144 $606,144 $606,144 $606,144 $606,144 $606,144 $606,144
Income Increase (Electric Bill Savings) - -$420,083 -$432,612 -$445,503 -$458,767 -$472,414 -$486,453 -$500,897
Change in Taxable Income $6,061,440 $186,061 $173,532 $160,641 $147,377 $133,730 $119,691 $105,247
Change in State Tax Liability $510,979 $15,685 $14,629 $13,542 $12,424 $11,273 $10,090 $8,872
Federal Taxes
Income Decrease (Federal - MACRS Bonus Depreciation) - $2,679,156 $989,227 $593,536 $356,019 $356,019 $178,267 -
Income Decrease (O&M / Equipment Replacement) - - - - - - - -
Income Decrease (Project Costs) $6,061,440 - - - - - - -
Income Increase (Electric Bill Savings) - -$420,083 -$432,612 -$445,503 -$458,767 -$472,414 -$486,453 -$500,897
Change in State Tax Liability -$510,979 -$15,685 -$14,629 -$13,542 -$12,424 -$11,273 -$10,090 -$8,872
Change in Taxable Income $5,550,461 $2,243,389 $541,987 $134,491 -$115,172 -$127,668 -$318,276 -$509,770
Federal Tax Liability $1,942,661 $785,186 $189,695 $47,072 -$40,310 -$44,684 -$111,397 -$178,419
Federal Tax Credit - $1,818,432 - - - - - -
Change in Federal Tax Liability $1,942,661 $2,603,618 $189,695 $47,072 -$40,310 -$44,684 -$111,397 -$178,419
Total Cash Flow -$3,607,799 $3,039,386 $636,936 $506,117 $430,881 $439,003 $385,147 $331,350
Cumulative Cash Flow -$3,607,799 -$568,414 $68,522 $574,639 $1,005,520 $1,444,523 $1,829,669 $2,161,020