Joint Borrower Sole Proprietor Calculator

Step 1 of 6

Welcome to the Joint Borrower, Sole Proprietor (JBSP) Calculator

Tax Year 2022-2023

Please fill out the required information accurately, and our calculator will provide you with a clear assessment of affordability. If you have any questions or need assistance, please reach out to our team.

Application Information

Broker Name

Date

Applicant Name	Current Age	Actions

There are no Occupying Borrowers.

Occupying Borrower 1: Age

Occupying Borrower 2: Age

Occupying Borrower Household Size

The household size must be selected from the dropdown options before proceeding. Please ensure that the number of adults matches the number of Occupying Borrower applicants you have added.

Number of Adults

Number of Children

Hidden

How Many Occupying Borrowers are Retired?

Occupying Borrowers: Basic Monthly Essential Expenditure

Would you like to use ONS data?

If 'Yes' is selected, the fields will be automatically populated with ONS expenditure data, which can be over-typed.

Hidden

Household Code

Hidden

Electricity

Hidden

Gas

Hidden

Water

Food & Groceries

Please enter a number greater than or equal to 0.

Utilities Including Gas, Electricity & Water

Please enter a number greater than or equal to 0.

Other Heating

Please enter a number greater than or equal to 0.

Council Tax

Please enter a number greater than or equal to 0.

Home & Protection Insurance Premiums

Please enter a number greater than or equal to 0.

Mobile Phone Contracts

Please enter a number greater than or equal to 0.

Please Select Any Types of Transport Used

Personal Transport

Public Transport

Essential Motoring Costs

Please enter a number greater than or equal to 0.

Essential Public Transport Costs

Please enter a number greater than or equal to 0.

Life & Health Assurance

Please enter a number greater than or equal to 0.

Other Essential Expenditure

Please enter a number greater than or equal to 0.

Occupying Borrowers: Quality of Living Costs

Lifestyle Costs/Recreation

Please enter a number greater than or equal to 0.

Personal Goods (e.g. Luxury Toiletries)

Please enter a number greater than or equal to 0.

Smoker or non-smoker?

Cigarettes

Please enter a number greater than or equal to 0.

Holidays

Please enter a number greater than or equal to 0.

Childcare (Nursery/School/University Fees)

Please enter a number greater than or equal to 0.

Clothing

Please enter a number greater than or equal to 0.

Household Goods & Repairs

Please enter a number greater than or equal to 0.

Other Quality of Living Costs

Please enter a number greater than or equal to 0.

Occupying Borrowers: Affordability Totals

Essential & Quality of Life Monthly Total

Essential & Quality of Life Annual Total

Hidden

Total Annual Expenditure of Occupying Borrower/s

Hidden

Total Monthly Net Income of Occupying Borrower/s

Hidden

Total Annual Net Income of Occupying Borrower/s

Hidden

Annual - Less total expenditure & ONS figures

Hidden

Monthly - Less total expenditure & ONS figures

Hidden

Annual Disposable Left Over Income of Occupying Borrower/s

Hidden

Monthly Disposable Left Over Income of Occupying Borrower/s

Hidden

Less 10% Monthly Disposable Left Over Income of Occupying Borrower/s

Hidden

Less 10% Annual Disposable Left Over Income of Occupying Borrower/s

90% Monthly Disposable Left Over Income of Occupying Borrower/s

Hidden

90% Annual Disposable Left Over Income of Occupying Borrower/s

Hidden

Maximum Loan Available Based on Occupying Borrower Income Multiple

Hidden

Occupiers' Total Annual Income

Hidden

Income Multiple

Based on just the occupying borrower's income the maximum loan we would be able to consider on a repayment basis is approximately:

Applicant Name	Actions

There are no Supporting Borrowers.

Supporting Borrower Household Size

The household size must be selected from the dropdown options before proceeding. Please ensure that the number of adults matches the number of Supporting Borrower applicants you have added.

Number of Adults(Required)

Number of Children(Required)

Hidden

How Many Supporting Borrowers are Retired?

Supporting Borrowers: Basic Monthly Essential Expenditure

Would you like to use ONS data?

If 'Yes' is selected, the fields will be automatically populated with ONS expenditure data, which can be over-typed.

Hidden

Household Code

Hidden

Electricity

Hidden

Gas

Hidden

Water

Food & Groceries

Utilities Including Gas, Electricity & Water

Other Heating

Council Tax

Home & Protection Insurance Premiums

Mobile Phone Contracts

Please Select Any Types of Transport Used

Personal Transport

Public Transport

Essential Motoring Costs

Essential Public Transport Costs

Life & Health Assurance

Other Essential Expenditure

Supporting Borrowers: Quality of Living Costs

Lifestyle Costs/Recreation

Personal Goods (e.g. Luxury Toiletries)

Smoker or non-smoker?

Cigarettes

Holidays

Childcare (Nursery/School/University Fees)

Clothing

Household Goods & Repairs

Other Quality of Living Costs

Supporting Borrowers: Affordability Totals

Essential & Quality of Life Monthly Total

Essential & Quality of Life Annual Total

Total Annual Expenditure of Supporting Borrower/s

Total Annual Net Income of Supporting Borrower/s

Total Monthly Net Income of Supporting Borrower/s

Hidden

Annual - Less total expenditure & ONS figures

Hidden

Monthly - Less total expenditure & ONS figures

Annual Disposable Left Over Income of Supporting Borrower/s

Monthly Disposable Left Over Income of Supporting Borrower/s

Hidden

Less 10% Annual Disposable Left Over Income of Supporting Borrower/s

Hidden

Less 10% Monthly Disposable Left Over Income of Supporting Borrower/s

Hidden

90% Annual Disposable Left Over Income of Supporting Borrower/s

90% Monthly Disposable Left Over Income of Supporting Borrower/s

Hidden

Product Limit

Loan Details

Loan Type

Purchase Price/Estimated Value

For Part & Part loans, please complete both the Capital Repayment and Interest-Only sections.

Deposit Details

Traditional Deposit

Cash Security

Collateral

Total Deposit

Net Deposit LTV (%)

Hidden

Average Retention Rate

Capital Repayment

Amount

Loan Term in Years

Plus Months

Hidden

Loan Term (Years/12 + Months)

Product Rate (%)

Please enter a number greater than or equal to 0.

Loan Type

Product Term

Hidden

Is Five-Year Fixed?

Hidden

Loan Term

Hidden

Frequency

Product CMS

Hidden

CR: Product CMS Int

Hidden

CR: Stress Rate

Hidden

CR: Rep Stress CMS

Hidden

CR: IO Stress CMS

Interest-Only

Amount

Loan Term in Years

Plus Months

Hidden

Loan Term

Hidden

Frequency

Product Rate (%)

Please enter a number greater than or equal to 0.

Loan Type

Product Term

Hidden

Is Five-Year Fixed?

Product CMS

Hidden

IO: Rept CMS

Hidden

Stress Rate (%)

Hidden

IO: IO Stress CMS

Hidden

IO: Rep Stress CMS

Hidden

Part & Part Total Product CMS

Hidden

CMS Totals

Hidden

Total Interest-Only CMS

Hidden

Total Rept CMS

Hidden

Stress Rate (%)

Hidden

Stressed CMS

Hidden

Total IO Stress CMS

Hidden

Total Product CMS

Hidden

Total Loan Amount

Hidden

Combined 90% Figures

Combined 90% of Monthly Disposable Income for Supporting & Occupying Borrowers

Hidden

Combined 90% of Monthly Disposable Income for Supporting & Occupying Borrowers Rounded Down to Nearest 10

Coverage of Repayment Type Chosen

Hidden

Capital Repayment: Combined Percentage Coverage at Stress Rate (%)

Hidden

Interest-Only: Combined Percentage Coverage at Stress Rate (%)

Hidden

Part & Part: Combined Percentage Coverage at Stress Rate (%)

Coverage (%)

Hidden

U91/S143 Coverage Pass/Fail/Review

Coverage Pass/Fail/Review 0 is blank 2 is pass 3 is fail 4 is review

Result: Please complete all of the form fields to display the current loan coverage.

Result:Pass

Result: Fail

Result: Review

Current Affordability

Hidden

Capital Repayment

Capital Repayment: Loan Available Based on Combined Affordability

Hidden

Interest Only

Hidden

Stress Rate: Interest Only

Interest-Only: Loan Available Based on Combined Affordability

Hidden

Part & Part

Hidden

Interest Only Element

=B73

Hidden

Interest Only Payment

=SUM(S5*O132)/12

Hidden

Remaining Free Income

=SUM(O96-O133)

Hidden

Rounded Down to Nearest £100

Use CSS rounding

Hidden

Stress Rate for Part & Part

=S5

Hidden

Mortgage Term

=C73

Hidden

Max available before 10% Int-only deducted

=PV(O136/12,(O137)*12,-O134)*90% O137 is O136 is O134 is

Hidden

Less 10% of Interest Only element

=SUM(O132*10%)

Hidden

Max Cap Rep element available (Part & Part)

Part & Part: Loan Available Based on Combined Affordability

Hidden

Stressed Payments

Hidden

X88 Maximum Loan Cap Based on Occupying Borrower - testing but think done Income Multiple

Hidden

S90 Total Maximum Income Multiple for occupant(s) & support borrower(s): Maximum Loan Available

=IF(P29-M36+Q65-M72<0,0,P29-M36+Q65-M72)*S88 If (occupiers total annual income - total ependiture + supporting borrowers total annual income - supporitng borrowers annual expenditure) is less than zero return 0 else (occupiers total annual income - total ependiture + supporting borrowers total annual income - supporitng borrowers annual expenditure) * income multiple

Hidden

x90 Maximum Loan Available

Hidden

Max. Multiple / Product Criteria (T136/S110)

occ.borr. afford tab ='Income & Committed Expenditure'!N152 =T132 on this sheet = max loan we can consider =MIN(X90,X92)

Hidden

Multiple/Product Criteria for Capital Repayment (U132)

Hidden

Multiple/Product Criteria for Interest Only (U133)

=IF(T133>T136,T136,T133)

Hidden

Multiple/Product Criteria for Part & Part (U134)

=IF(T134>T136,T136,T134) T134 = F470 T136 = F335

Hidden

U139 Maximum Loan We Can Consider

=IF(R139=R132,FLOOR(U132,1000),IF(R139=R133,FLOOR(U133,1000),IF(R139=R134,FLOOR(U134,1000))))

Hidden

Stress Rate: Capital Repayment (%)

Hidden

Stress Rate (%)

Hidden

Monthly Stress Rate: Capital Repayment (%)

Hidden

Is Loan Amount Greater Than Maximum Loan We Can Consider?

1 is Yes 0 is No if(F322>F523 ): 1 else: 0 endif;

Hidden

Current Affordability: Pass/Fail/Review

Result: Please complete all of the form fields to display the current affordability.

Result: Please review the loan amount.

Result:The loan is currently affordable.

Result: Review

Important: The maximum loan permitted on a Capital Repayment basis cannot exceed:

Important: The maximum loan permitted on a Part & Part basis cannot exceed:

Important: The maximum loan permitted on a Interest-Only basis cannot exceed:

Affordability at Retirement

Occupying Borrower 1 Retirement Coverage

Hidden

Anticipated Affordability to All Borrowers at Retirement: Pass/Fail/Review

0 is Not Applicable 1 is Review 2 is Pass

Hidden

Anticipated Affordability to All Borrowers at Retirement: (D85)

=IF(I80=0,"",BA186) BA186 is =IF(BC186=0,"Not applicable",IF(BC186=BC182,BA182,IF(BC186=BC183,BA183,IF(BC186=BC181,BA181,IF(BC186=BC180,BA180,(LOOKUP(BC186,BA180:BA183,BC180:BC183)))))))

Retirement Affordability Summary

OB1: Years Until Retirement

OB2: Years Until Retirement

SB1: Years Until Retirement

SB2: Years Until Retirement

OB1: Years Until Retirement If "0"

OB2: Years Until Retirement If "0"

SB1: Years Until Retirement If "0"

SB2: Years Until Retirement If "0"

SB1: Years Until 85

SB2: Years Until 85

OB1: Years Until Review

OB2: Years Until Review

OB1: Annual Net Income

OB2: Annual Net Income

SB1: Annual Net Income

SB2: Annual Net Income

OB1: Retirement Income Applicant 1

OB1: Retirement Income Applicant 2

SB1: Retirement Income Applicant 1

SB2: Retirement Income Applicant 2

OB1: Incremental 2% Applicant 1

OB1: Incremental 2% Applicant 2

OB1: Income Used Applicant 1

OB1: Income Used Applicant 2

OB1: Income Used Family No. 1

OB1: Income Used Family No. 2

OB1: Combined Income Used

OB1: Combined Monthly Income

OB1: Applicant’s Current Monthly House Expenditure

OB1: Family Current Monthly House Expenditure

OB1: Current Monthly Stressed Payment

OB1: Retirement Coverage

OB1: Retirement Coverage Status

Not Applicable (0)/Pass (1)/Fail (2)

Lending Into Retirement Requirements

If any of the below conditions fail, the maximum LTV permitted is 70%.

Current LTV (%)

Maximum Loan Permitted

Hidden

If LTV is over 70% and occupying borrower(s) still reliant on supporting borrower's income in retirement?

IF(Q67<=70%,AD91,IF(Q67>70%,IF(BK172>=110%,AD89,IF(BK172<110%,AD90)))))) if supporting borrowers age added up is zero, return blank if supporting borrower planned retirement age added up is zero, return blank if

Hidden

Supporting borrower(s) 70 or over at start of mortgage

Are either or both supporting borrowers over 70 at the start of the mortgage? 0 is no, 1 or 2 is yes.

Hidden

Loan LTV Greater Than 70% & SBs 70 or over

0 = total loan amount not filled in 1 = LTV below or equal to 70 2 = N/A, Supporters below 70 3 = Fail, LTV over 70%, SBs 70+

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

Please fill out the loan amount to display the result.

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

Not applicable: LTV is equal to or less than 70%

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

Not applicable: Supporting borrower(s) under age of 70.

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

Fail: Maximum LTV 70% - supporting borrower(s) are age 70 or over at the start of the mortgage.

Hidden

If the LTV is over 70% & the occupying borrower(s) will reach the age 70 before mortgage ends?

=IF(AF7+AF8=0,"Not applicable",AG9) AG9 is =IF(B80=0,"",IF(AN2<=70%,AM5,IF(AF9=1,AM4,IF(AF9=0,AM3))))

Number

Joint Borrower Sole Proprietor Calculator

Welcome to the Joint Borrower, Sole Proprietor (JBSP) Calculator

Tax Year 2022-2023

Application Information

Occupying Borrowers' Income & Committed Expenditure

Occupying Borrower Household Size

Occupying Borrowers: Basic Monthly Essential Expenditure

Occupying Borrowers: Quality of Living Costs

Occupying Borrowers: Affordability Totals

Maximum Loan Available Based on Occupying Borrower Income Multiple

Supporting Borrowers' Income & Committed Expenditure

Supporting Borrower Household Size

Supporting Borrowers: Basic Monthly Essential Expenditure

Supporting Borrowers: Quality of Living Costs

Supporting Borrowers: Affordability Totals

Loan Details

Deposit Details

Capital Repayment

Interest-Only

CMS Totals

Combined 90% Figures

Coverage of Repayment Type Chosen

Current Affordability

Capital Repayment

Interest Only

Part & Part

Stressed Payments

Affordability at Retirement

Occupying Borrower 1 Retirement Coverage

Retirement Affordability Summary

Lending Into Retirement Requirements

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?

If the LTV is over 70% & the supporting borrower(s) are age 70 or over at the start of the mortgage?