loan

I need help on what formula I can use to work out an APR for a loan where the pay back is loan plus full interest divided by equal number of payments over the period. So, If a loan is £1,000 say at a simple monthly interest rate of 3% over 12 months, the payments are £113.33 each month to cover...

In scenario summery, excel would show cell reference not cell title. for example if I have in cell A1 = Loan, B1= 15000 In the scenario summery excel will show $B$1 1500 I was thinking if there is a way to replace $B$1 with word Loan automatically? I know I can do the report and change that...

Hi, I have to create a sequence number for employee's cooperative loan. The sequence number should be written in Column B, with an order as below : - start with "L" - Running year "2018" - Running month "02" - and sequence number 0001 So it will be like : L2018-02-0001 and for the next loan...

I have issues with this formula that is very hard to write. The formula is: If G111 is YES and F21= normal loan use one formula otherwise 0. If G111 is YES and F21= interest only loan use another formula otherwise 0. That is my formula like now. (my excel is in Italian)...

So I work for a hedge fund/private equity administrator. We have a client that provided us with a loan portfolio and asked us to provide a spreadsheet showing the IRR for each deal. Simple enough. But all his loans are paid back, with interest, in a single payment within weeks to months. I...

Hi, I figured I would make a new thread since I wrote too much confusing stuff in the other one, so hopefully this explain it better. I want to have a formula that will automatically yield an adjusted balance on the same day each month. Here is what I tried: =D6 - FV(D4/12, DATEDIF(D3...

Hey guys. I was recommended you guys by my friend, who said you guys were geniuses - Hopefully you can help me with my problem! :) Question: I have a cash flow question within the subject of financing. In here I have a time series of Costs in my cash flow with -6m in each period (Could be...

Hi All, can anyone assist with a formula for the following : <tbody> 609 C E F G H i J K L S T U V 610 Description Prop. Vat Dr Amount Vat Cr Amt Vat Total Days 5% Total 611 2,668,666.46 612 2017-01-30 Loan - In Eaton n 200,000.00 200,000.00 115...

My current code is: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 And Target.Row = 7 Then If Target.Value = "Loan $" Then Target.Offset(2, 0).Formula = "=F14/F8": Target.Offset(2, 0).Interior.Color = RGB(217, 217, 217) If Target.Value = "Loan to Cost" Then...

I would like to figure out the total payout figure for a loan. I have the initial amount in column b Date of loan in column c Interest rate in column d I need the total amount of the loan today with compounding interest without having made any payments. For instance: $10k loan from 6th July...

Hey Guys, Below is the scenario to write VBA code:- > If Score is > 900 > If Income is > 600000 > If Occupation = "Salaried" and Income > 500000 > If Marital Status = "Single" > If Own house = "yes" 1, If any one of the above criteria met result should be "Loan Eligible" 2, If any one of the...

I am trying to use the median function to return a value only when the result of a vlookup is a specific value. I am using the formula = Median(IF(P4:P51="Commercial",C4:C51)) Where column P contains the vlookup resulting in either "Commercial" or "Consumer" and column C contains the loan...

Hi, I have to create a date step, meaning that I have a start date of a loan but there is also a "grace period" between these two no instalment is paid but the interest is calculated. For example: There is a var rate loan amount of 10.000$. The compounding is happening two times per year (so...

I was replicating the loan amount calculator VBA. Now I have created a button to get a calculated value. the calculation process is listed in the sub 'Calculate' which is in a module. However, there is always an error message when i click the botton. i click debug and it yellow highlight...

I lend 1000 on Jan 1 '17 what I want is that if 1 year later there is an opening balance meaning that the loan is not paid off it should automatically charge a penalty of 1% of the loan and the same should be on the next year if there is still an outstanding balance, I have some ideas on how to...

Criteria for the query include: Transaction ID, Loan ID, First Name, Last Name, State, Loan Date, Loan Purpose, Loan Amount, Loan Term, Interest Rate, Loan Type, Loan Age(months), Loan Use, New Interest Rate, and Loan Maturity Date. Query Question: What percent of all loans are of amount at...

Hi there, i have recently realized how much fun & time saving it is to use VBA macro writing for reporting purposes. i am an operations analyst, and would like to automate all my reports :) (if i could). I need help writing a macro to pull in info from multiple sheets with each #ed sheet's...

I need help with a formula in Excel to work out the annual percentage to increase payments for a loan. So if a loan of £2,000,000 is given, the loan payment term is 15 years and the interest rate is 12%. The PMT would be £24,003.36 per month. But what I need to do is allow the lender to pay...

Hi. I have a chart that looks like below. It is the price of Samsung Electronics, inc with loan transaction. The blue one is the change of the stock price and the orange one is loan transaction. I want to flip the whole graph horizontally. I mean, what I need to do is sort the X-axis...

HELLO EVERYBODY!!:( CAN YOU GUYS HELP ME HOW TO SOLVE THIS QUESTIONS?? REALLY NEED YOUR HELP GUYS COZ I'M NOT GOOD IN EXCEL ESPECIALLY ABOUT RAND AND PMT FUNCTIONS. SO I HOPE YOU CAN HELP ME TO SOLVE THIS QUESTIONS...