Federal Income Tax Templates

Download Schedule B Calculator Apple Numbers Template

Schedule B Calculator Apple Numbers Template is a tool used for federal income tax calculations. This template helps to calculate your taxable interest and ordinary dividends that a taxpayer receives during the tax year.

This template has been made for our readers who use Mac operating system. Schedule B is a part of Form 1040 and Form 1040A of Federal Income Tax.

You just need to enter your income in the form of interests and dividends from the respective sources. Schedule B Calculator Apple Numbers Template will automatically calculate the amount for you.

Who needs to file Schedule B?

According to IRS, you require to file Schedule B (Form 1040A or 1040) if any of the following applies to you:

  1. had over $1,500 of taxable interest or ordinary dividends.
  2. received interest from a seller-financed mortgage and the buyer used the property as a personal residence.
  3. have accrued interest from a bond.
  4. reporting original issue discount (OID) in an amount less than the amount shown on Form 1099-OID.
  5. reducing your interest income on a bond by the amount of amortizable bond premium.
  6. claiming the exclusion of interest from series “EE” or “I” U.S. savings bonds issued after 1989.
  7. received interest or ordinary dividends as a nominee.
  8. had a financial interest in, or signature authority over, a financial account in a foreign country or you received a distribution from or were a grantor of, or transferor to, a foreign trust. Part III of the schedule has questions about foreign accounts and trusts.

To avoid mistake and for the purpose of estimating your tax liability, we have created and simple and easy to use Schedule B Calculator Apple Number Template.

This template can be useful to individuals, couples filing jointly and even freelancers doing taxation work.

Click here to download Schedule B Calculator Apple Number Template.

To download the same calculator in Excel click the link below:

Schedule B Calculator Excel Template

In addition to the above, you can also download other Numbers Templates like Simple Tax Estimator, Itemized Deduction Calculator, AGI Calculator and Section 179 Deduction Calculator

Let us discuss the contents of the template in details.

Contents of Schedule B Calculator Apple Numbers Template

Schedule B Calculator Apple Number Template reports of 3 types of incomes; Interests, Ordinary Dividends and Foreign Account and Trusts.

You can also find this Schedule B Calculator as a fillable PDF on IRS website. Click below to download the fillable pdf.

Schedule B – Interests and Ordinary Dividends

Part I – Interests

Income from interest from banks and corporate bonds are subject to income tax. The only exception it has is the interest from Series I and EE savings bonds issued after 1989.

Banks and companies issuing bonds who paying interests report them in form 1099-INT. The brokerage firm can provide you with Form 1099-INT, Form 1099-OID or such other relevant document.

You just need to enter the firm name and respective amount of interests received in Form 1099-INT.

Part II – Ordinary Dividends

Income from dividends is reported in this section. You need to report the name of the company along with the dividend amount in Part II.

Enter the name of the organization/company paying the dividend and amounts in Part II. The system will automatically subtotal the amount for you.

Part III – Foreign Accounts and Trusts

It is necessary to file Part II of Schedule B, if:

  •  has the taxable interest or ordinary dividends over $1,500
  •  has a foreign account; or
  • has received a distribution from, or were a grantor of, or a transferor to, a foreign trust.

Part-III consists of only yes and no options. Amounts will be reported in respective forms details of which is given below.

FinCEN Form 114 must be filed if you have interest from foreign accounts during the tax year. Form 3520 must be filed if you have been receiving a distribution from or were the grantor of, or transferor to, a foreign trust.

Disclaimer: Interpretation of the above topic is for education purpose and cannot be considered as a legal advice. It is highly recommendable to consult a CPA or tax consultant.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Share
Published by
Shabbir Bhimani

Recent Posts

Download UK VAT Taxable Turnover Calculator Excel Template

To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…

4 years ago

Step By Step Guide TO UK VAT Registration Process

Every business has to register for VAT with HM Revenue and Customs if their VAT…

4 years ago

Download UK VAT Dual Currency Invoice Excel Template

We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…

4 years ago

Download UK VAT Purchase Register Excel Template

We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…

4 years ago

Download UK VAT Sales Register Excel Template

We have created a simple and easy UK VAT Sales Register Excel Template with predefined…

4 years ago

Download UK VAT Progress Billing Invoice Excel Template

We have created a ready to use UK VAT Progress Billing Invoice template in excel…

4 years ago