# Get instant live Excel expert help to learn how to apply financial function in Excel?

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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