Personal Tax 1040 Simulator (TY2021)




The 1040 and supporting schedules tax simulator in Excel is a powerful tool that assists in estimating your tax liability for Tax Year 2021.
The file is completely unlocked and ready for you to tinker with and connect to you own sources of the data that could feed the appropriate forms.

Email updates will be periodic and more of the outstanding forms are added:

    The file currently supports the following forms and schedules:

Form 1040
Form 6251 Alternative Minimum Tax
Form 8812 Credits for Qualifying Children and Other Dependents
Sch 1 Additional Income and Adjustments to Income
Sch 2 Additional Taxes
Sch 3 Additional Credits and Payments
Sch A Itemized Deductions
Sch B Interest and Ordinary Dividends
Sch C Profit or Loss From Business
Sch D Capital Gains and Losses
Sch E Supplemental Income and Loss
Sch SE Self-Employment Tax
Form 8995 Qualified Business Income Deduction

    I plan on adding the following in the ongoing future

Form 1116 Foreign Tax Credit
Form 2106 Employee Business Expenses
Form 2439 Notice to Shareholder of Undistributed Long-Term Capital Gains
Form 2441 Child and Dependent Care Expenses
Form 2555 Foreign Earned Income
“Form 3520 Annual Return To Report Transactions With
Foreign Trusts and Receipt of Certain Foreign Gifts”
Form 3800 General Business Credit
Form 3903 Moving Expenses
Form 4137 Social Security and Medicare Tax on Unreported Tip Income
Form 4562 Depreciation and Amortization
Form 4684 Casualties and Thefts
Form 4797 Sale of Business Property
Form 4835 Farm Rental Income and Expenses
Form 4952 Investment Interest Expense Deduction
“Form 5329 Additional Taxes on Qualified Plans
(Including IRAs) and Other Tax-Favored Accounts”
Form 5405 Repayment of the First-Time Homebuyer Credit
Form 5695 Residential Energy Credits
Form 6198 At-Risk Limitations
Form 6252 Installment Sale Income
Form 6781 Gains and Losses From Section 1256 Contracts and Straddles
“Form 7202 Credits for Sick Leave and Family Leave
for Certain Self-Employed Individuals”
Form 8283 Noncash Charitable Contributions
Form 8582 Passive Activity Loss Limitations
Form 8611 Recapture of Low-Income Housing Credit
Form 8621 Information Return by a Shareholder of a Passive Foreign Investment Company or Qualified Electing Fund
“Form 8801 Credit for Prior Year Minimum Tax—
Individuals, Estates, and Trusts”
“Form 8815 Exclusion of Interest From Series EE and I
U.S. Savings Bonds Issued After 1989”
Form 8824 Like-Kind Exchanges
Form 8834 Qualified Electric Vehicle Credit
Form 8839 Qualified Adoption Expenses
Form 8853 Archer MSAs and Long-Term Care Insurance Contracts
Form 8859 Carryforward of the District of Columbia First-Time Homebuyer Credit
“Form 8863 Education Credits
(American Opportunity and Lifetime Learning Credits)”
Form 8866 Interest Computation Under the Look-Back Method for Property Depreciated Under the Income Forecast Method
Form 8880 Credit for Qualified Retirement Savings Contributions
Form 8889 Health Savings Accounts (HSAs)
Form 8910 Alternative Motor Vehicle Credit
“Form 8919 Uncollected Social Security and
Medicare Tax on Wages”
Form 8936 Qualified Plug-in Electric Drive Motor Vehicle Credit
Form 8949 Sales and Other Dispositions of Capital Assets
Form 8959 Additional Medicare Tax
“Form 8960 Net Investment Income Tax—
Individuals, Estates, and Trusts”
Form 8962 Premium Tax Credit
Form 8967 Paid Preparer’s Child Tax Credit Checklist
“Form 965 Inclusion of Deferred Foreign Income
Upon Transition to Participation Exemption System”
Sch F Profit or Loss From Farming
Sch H Household Employment Taxes
Sch Q CFC Income by CFC Income Groups
Sch R Credit for the Elderly or the Disabled

Contact me for questions/comments


There are no reviews yet.

Be the first to review “Personal Tax 1040 Simulator (TY2021)”

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.