“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hi. Need help with how to find interest rate. I am trying to build a formula which calculates the amount of interest payable, based on a capital amount outstanding and a tiered interest rate. The tiered interest rate is based on a risk score.
For instance, Capital Amount is £x.
If risk score is <2.0 then the interest rate is 0%
If risk score is between 2.0 - 2.5, then the interest rate is 1.0%
If the risk score is between 2.5 - 3.0, then the interest rate is 2.0%
If the risk score is greater than 3.0, then the interest rate is 3.0%
Please can someone help me arrive at a formula I can use!!
Thank you...

Solved by Z. D. in 14 mins

Establishing a formula to calculate the quarterly interest cost of two different loans, with interest rates that are determined by a pre-determined leverage ratio.

Solved by K. L. in 14 mins

I have an investment tracking spreadsheet. I need help to create a two variable What- If Table using the NPER function using any two variables so I can determine how many periods it will take to reach an investment goal when making regular constant payments at a regular interest rate.

Solved by D. S. in 14 mins

You have decided to purchase an existing bakery and are comparing loan options. You will create a spreadsheet using the following instructions in order to analyze the data.
Create a spreadsheet and name it "W4 Loan Your Initials"
Entitle it "Loan Comparison" and merge and center across Row 1 (A-D)
Use Century Gothic Font, Size 12, Bold, Italicize
Create Headings in Cells B2 - D2: Loan 1, Loan 2, Loan 3
Use Arial Font, Size 12, Bold
Beginning in cell A3 and ending in cell A8, add the following categories:
Principal
Annual Interest Rate
Number of Monthly Payments
Monthly Payment
Interest
Total Payment
Use the following information
Lender 1
Lender 2
Lender 3
Principal
100,000.00
103,000.00
99,000.00
Annual Interest Rate
4.13%
4.05%
3.70%
Number of Monthly Payments
360
400
320
Add formulas for the
Monthly Payment =PMT((Annual Interest rate/12),Number of monthly payments,-Principal,0)
Interest =IPMT(Annual Interest rate,1,Number of monthly payments,-Principal)
Total Payment =Principl+Interest
Analyze the data and select the loan you feel is most beneficial for your circumstances. Justify your response with a short paragraph.

Solved by V. J. in 25 mins

I need to know the first step of finding the highest interest rate which chart should I pick the rate? There are three charts (Pay Off Sooner, Most Popular, Lower Payments) WHICH ONE?

Solved by C. Y. in 13 mins

Need to calculate straight line method for bonds discount. I need to help with finding interest to be paid, discount amortization schedule excel, interest expense, unamortized discount and bond carrying value. The information I have is Bond Issue Date, Face value, # of bonds, bond payable, # of years, Interest rate, Interest/bond, annual interest, Bond maturity date, bond price, and bond discount.

Solved by K. L. in 18 mins

4. Compute the Social Security benefit of a client and to advise on whether the client should take Early retirement or to wait for Full retirement. You will also determine the interest rate that will give the client the option to take either early or full retirement where they are the same value.

Solved by A. L. in 29 mins

After some research, you have decided that a brand new car is just not in your budget. So, a used car it is. Create scenarios for five used cars that you are considering buying. You have a $1000 trade-in. Use the interest rates in this table (used the highest rate in all cases).

Solved by G. H. in 18 mins

MY QUESTION IS ABOUT:
Other
DESCRIPTION:
After some research, you have decided that a brand new car is just not in your budget. So, a used car it is. Create scenarios for five used cars that you are considering buying. You have a $1000 trade-in. Use the interest rates in this table (used the highest rate in all cases).

Solved by B. B. in 11 mins

I have Excel 2013 but I do not have nor do I want to learn how to use it. I want someone to provide the following template that I can entered into for a loan I made to someone:
1)Interest Rate Change on date of Prime Rate Changing
2)Interest is Calculated Daily based off of date they pay
3)They can make additional principal payments at anytime

Solved by A. A. in 28 mins