DSCR Loan worksheet

1. DSCR: 2.79

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 300 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$320,000.00}\times 0.0075}{1-{\left(1+0.0075\right)}^{\mathrm{-300}}}$$=\mathrm{\$2,685.43}$

2. Find the yearly debt payments: 12 loan payments plus your other loan payments

   $\mathrm{\$2,685.43}\times 12+\mathrm{\$0.00}$$=\mathrm{\$32,225.14}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$90,000.00}}{\mathrm{\$32,225.14}}$$=2.7929$

4. Find the most the debt payments can be at your target: income ÷ 1.1

   $\frac{\mathrm{\$90,000.00}}{1.1}$$=\mathrm{\$81,818.18}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\frac{\mathrm{\$81,818.18}-\mathrm{\$0.00}}{12}$$=\mathrm{\$6,818.18}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$6,818.18}}{0.00839196}$$=\mathrm{\$812,465.61}$

2. DSCR: 0.69

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 240 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$360,000.00}\times 0.0075}{1-{\left(1+0.0075\right)}^{\mathrm{-240}}}$$=\mathrm{\$3,239.01}$

2. Add the tax and insurance (yearly amounts ÷ 12) and any HOA dues. Lenders count these with the payment

   $\mathrm{\$3,239.01}+\mathrm{\$200.00}+\mathrm{\$162.50}+\mathrm{\$0.00}$$=\mathrm{\$3,601.51}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$2,500.00}}{\mathrm{\$3,601.51}}$$=0.6942$

4. Find the most the debt payments can be at your target: income ÷ 1.25

   $\frac{\mathrm{\$2,500.00}}{1.25}$$=\mathrm{\$2,000.00}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\mathrm{\$2,000.00}-\mathrm{\$362.50}$$=\mathrm{\$1,637.50}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$1,637.50}}{0.00899726}$$=\mathrm{\$181,999.86}$

3. DSCR: 0.61

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 360 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$380,000.00}\times 0.00916667}{1-{\left(1+0.00916667\right)}^{\mathrm{-360}}}$$=\mathrm{\$3,618.83}$

2. Add the tax and insurance (yearly amounts ÷ 12) and any HOA dues. Lenders count these with the payment

   $\mathrm{\$3,618.83}+\mathrm{\$300.00}+\mathrm{\$154.17}+\mathrm{\$0.00}$$=\mathrm{\$4,073.00}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$2,500.00}}{\mathrm{\$4,073.00}}$$=0.6138$

4. Find the most the debt payments can be at your target: income ÷ 1.35

   $\frac{\mathrm{\$2,500.00}}{1.35}$$=\mathrm{\$1,851.85}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\mathrm{\$1,851.85}-\mathrm{\$454.17}$$=\mathrm{\$1,397.69}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$1,397.69}}{0.00952323}$$=\mathrm{\$146,765.81}$

4. DSCR: 2.03

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 360 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$400,000.00}\times 0.00708333}{1-{\left(1+0.00708333\right)}^{\mathrm{-360}}}$$=\mathrm{\$3,075.65}$

2. Find the yearly debt payments: 12 loan payments plus your other loan payments

   $\mathrm{\$3,075.65}\times 12+\mathrm{\$0.00}$$=\mathrm{\$36,907.85}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$75,000.00}}{\mathrm{\$36,907.85}}$$=2.0321$

4. Find the most the debt payments can be at your target: income ÷ 1

   $\frac{\mathrm{\$75,000.00}}{1}$$=\mathrm{\$75,000.00}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\frac{\mathrm{\$75,000.00}-\mathrm{\$0.00}}{12}$$=\mathrm{\$6,250.00}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$6,250.00}}{0.00768913}$$=\mathrm{\$812,835.27}$

5. DSCR: 0.93

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 240 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$275,000.00}\times 0.00516667}{1-{\left(1+0.00516667\right)}^{\mathrm{-240}}}$$=\mathrm{\$2,002.05}$

2. Add the tax and insurance (yearly amounts ÷ 12) and any HOA dues. Lenders count these with the payment

   $\mathrm{\$2,002.05}+\mathrm{\$270.83}+\mathrm{\$141.67}+\mathrm{\$0.00}$$=\mathrm{\$2,414.55}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$2,250.00}}{\mathrm{\$2,414.55}}$$=0.9319$

4. Find the most the debt payments can be at your target: income ÷ 1.1

   $\frac{\mathrm{\$2,250.00}}{1.1}$$=\mathrm{\$2,045.45}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\mathrm{\$2,045.45}-\mathrm{\$412.50}$$=\mathrm{\$1,632.95}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$1,632.95}}{0.00728017}$$=\mathrm{\$224,301.74}$

6. DSCR: 2.97

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 240 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$275,000.00}\times 0.00708333}{1-{\left(1+0.00708333\right)}^{\mathrm{-240}}}$$=\mathrm{\$2,386.51}$

2. Find the yearly debt payments: 12 loan payments plus your other loan payments

   $\mathrm{\$2,386.51}\times 12+\mathrm{\$0.00}$$=\mathrm{\$28,638.17}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$85,000.00}}{\mathrm{\$28,638.17}}$$=2.9681$

4. Find the most the debt payments can be at your target: income ÷ 1.35

   $\frac{\mathrm{\$85,000.00}}{1.35}$$=\mathrm{\$62,962.96}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\frac{\mathrm{\$62,962.96}-\mathrm{\$0.00}}{12}$$=\mathrm{\$5,246.91}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$5,246.91}}{0.00867823}$$=\mathrm{\$604,606.26}$

7. DSCR: 1.02

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 300 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$300,000.00}\times 0.00791667}{1-{\left(1+0.00791667\right)}^{\mathrm{-300}}}$$=\mathrm{\$2,621.09}$

2. Add the tax and insurance (yearly amounts ÷ 12) and any HOA dues. Lenders count these with the payment

   $\mathrm{\$2,621.09}+\mathrm{\$416.67}+\mathrm{\$108.33}+\mathrm{\$0.00}$$=\mathrm{\$3,146.09}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$3,200.00}}{\mathrm{\$3,146.09}}$$=1.0171$

4. Find the most the debt payments can be at your target: income ÷ 1.1

   $\frac{\mathrm{\$3,200.00}}{1.1}$$=\mathrm{\$2,909.09}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\mathrm{\$2,909.09}-\mathrm{\$525.00}$$=\mathrm{\$2,384.09}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$2,384.09}}{0.00873697}$$=\mathrm{\$272,873.99}$

8. DSCR: 1.56

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 360 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$320,000.00}\times 0.00583333}{1-{\left(1+0.00583333\right)}^{\mathrm{-360}}}$$=\mathrm{\$2,128.97}$

2. Add the tax and insurance (yearly amounts ÷ 12) and any HOA dues. Lenders count these with the payment

   $\mathrm{\$2,128.97}+\mathrm{\$187.50}+\mathrm{\$116.67}+\mathrm{\$0.00}$$=\mathrm{\$2,433.13}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$3,800.00}}{\mathrm{\$2,433.13}}$$=1.5618$

4. Find the most the debt payments can be at your target: income ÷ 1.25

   $\frac{\mathrm{\$3,800.00}}{1.25}$$=\mathrm{\$3,040.00}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\mathrm{\$3,040.00}-\mathrm{\$304.17}$$=\mathrm{\$2,735.83}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$2,735.83}}{0.00665302}$$=\mathrm{\$411,216.45}$

9. DSCR: 1.09

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 360 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$375,000.00}\times 0.00516667}{1-{\left(1+0.00516667\right)}^{\mathrm{-360}}}$$=\mathrm{\$2,296.76}$

2. Add the tax and insurance (yearly amounts ÷ 12) and any HOA dues. Lenders count these with the payment

   $\mathrm{\$2,296.76}+\mathrm{\$312.50}+\mathrm{\$141.67}+\mathrm{\$0.00}$$=\mathrm{\$2,750.93}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$3,000.00}}{\mathrm{\$2,750.93}}$$=1.0905$

4. Find the most the debt payments can be at your target: income ÷ 1.1

   $\frac{\mathrm{\$3,000.00}}{1.1}$$=\mathrm{\$2,727.27}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\mathrm{\$2,727.27}-\mathrm{\$454.17}$$=\mathrm{\$2,273.11}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$2,273.11}}{0.00612469}$$=\mathrm{\$371,138.15}$

10. DSCR: 4.07

1. Find the monthly loan payment. A standard formula finds the one amount that clears the loan in 240 months, where the monthly rate is the yearly rate ÷ 12

   $\frac{\mathrm{\$245,000.00}\times 0.00666667}{1-{\left(1+0.00666667\right)}^{\mathrm{-240}}}$$=\mathrm{\$2,049.28}$

2. Find the yearly debt payments: 12 loan payments plus your other loan payments

   $\mathrm{\$2,049.28}\times 12+\mathrm{\$0.00}$$=\mathrm{\$24,591.34}$

3. Divide the income by the debt payments. Above 1 means the income covers them, and below 1 means it falls short

   $\frac{\mathrm{\$100,000.00}}{\mathrm{\$24,591.34}}$$=4.0665$

4. Find the most the debt payments can be at your target: income ÷ 1.35

   $\frac{\mathrm{\$100,000.00}}{1.35}$$=\mathrm{\$74,074.07}$

5. Take off the costs that aren't this loan's payment, then find the monthly payment left

   $\frac{\mathrm{\$74,074.07}-\mathrm{\$0.00}}{12}$$=\mathrm{\$6,172.84}$

6. Turn that payment back into a loan: find the amount that payment would clear over the same term and rate

   $\frac{\mathrm{\$6,172.84}}{0.0083644}$$=\mathrm{\$737,989.45}$