Scribd
Upload
7 views10 pages

Loan Payment Calculators and Costs

This document contains information about a $100,000 loan with an initial interest rate of 2% over 30 years. The monthly payment is $369.62. It then shows how the monthly payment would change if the interest rate increased annually in 0.25% increments up to a maximum of 4%. It also includes charts showing standard production units and costs for a manufacturing process, as well as revenue, costs and gross margins for a company in 2016. Finally, it provides details on a $1,000,000 loan with an interest rate of 6% and monthly payment of $102,770.57 over 10 months, along with how the payment would vary with different loan amounts, terms and interest rates.

Uploaded by

arushi dutt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
7 views10 pages

Loan Payment Calculators and Costs

This document contains information about a $100,000 loan with an initial interest rate of 2% over 30 years. The monthly payment is $369.62. It then shows how the monthly payment would change if the interest rate increased annually in 0.25% increments up to a maximum of 4%. It also includes charts showing standard production units and costs for a manufacturing process, as well as revenue, costs and gross margins for a company in 2016. Finally, it provides details on a $1,000,000 loan with an interest rate of 6% and monthly payment of $102,770.57 over 10 months, along with how the payment would vary with different loan amounts, terms and interest rates.

Uploaded by

arushi dutt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Loan Amount 100000

Interest Rate (yearly) 2.00%


Term (years) 30 Changing R
Monthly Payment ($369.62) ($369.62)

Changing Rate ($369.62)


1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
2.75%
3.00%
3.25%
3.50%
3.75%
4.00%
1.00% 1.25% 1.50% 1.75% 2.00% 2.25% 2.50% 2.75% 3.00% 3.25%
3.50% 3.75% 4.00%
Changing Units 3.211804
Direct materials 580,000 425,000
Direct labor 880,552 450,000
Overhead 145,350 475,000
Total Cost 1,605,902 500,000
550,000
Standard Production Units 500,000 575,000

Cost per unit 3.211804


Revenue for 2016 20,000
Cost of goods sold 30%
Fixed cost 5000

Gross Margins 9000

Changing cost of goods 9000


15%
20%
25%
30%
35%
40%
45%
Selling Price $125.00
Unit Sold 500
Revenue $62,500.00

Selling Price
$62,500.00 125 150
500
750
1000
Unit Sold 1250
1500
1750
2000
Total Loan Amount 1,000,000
Interest Rate (Yearly) 6%
Number of month for payment 10
Monthly Payment ($102,770.57)

Loan Amount
($102,770.57) 1000000 1500000 2000000
10
15
20
25
30
Month 35
40
45
50
55
60
Loan Amount
2500000 3000000 3500000 4000000
Total Loan Amount 1,000,000
Interest Rate (Yearly) 2%
Number of month for payment 10
Monthly Payment ($100,918.96)

($100,918.96) 1000000
2.00%
2.50%
3.00%
3.50%
4.00%
Interest
Rate 4.50%
5.00%
5.50%
6.00%
6.50%
7.00%
Loan Amount
1500000 2000000 2500000 3000000 3500000 4000000

You might also like