loan

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...

Hi All, I have 5 Sheets in a workbook named "Loan Appraisal Form", "Loan DSR", "RLEs", "Welcome" and "Main Menu". All sheets are protected with some cells unlocked for editing. The "Main Menu" sheet is the only sheet visible. "Loan Application Form" and "Loan DSR" are only visible when a...

I am currently building an amortisation schedule for a property mortgage and am having difficulty filling the time series according to the length of year (Number of Payments). Any help would be greatly appreciated. I would like the period to update automatically based on a monthly payment...

I designed a amortization table (see link below). The top portion provides a summary of the loan, where the green color cells are hard coded input cells (except cell B8, because I do not know how to calculate the last year of a loan when a fixed extra amount is paid monthly). Once the input...

Hello excel gurus. I have struggled with datavalidation. I am preparing a spreadsheet for a serving and credit scheme. I am preparing a spreadsheet with the following layout in cell C5 to G5: Person, date, muamala (saving, credit, loan, repayment), and amount. I want to use datadatavalidation to...

Hello all. I've been wrestling with this spreadsheet for a while now. I am trying to take a series of interest payments and loan receipts/repayments on varying dates and a rate based on Libor and calculate the XIRR. The loan is received net of financing fees. I need to amortise the net loan at...

I have a unique requirement, Suppose I loan to a friend $1000, He agrees to pay me back the same with say 9% interest in 10 years Now the amortisation table for this is available for this freely on many sites. SO the monthly payment he needs to make to me is $12.67 for 120 months. Some also...

I am trying to create a spread sheet that will calculate the balance of a loan that does not require a minimum payment or even a payment for any certain amount of time, but will still add interest to the loan on a monthly bases. So to put it simple I have loaned someone $2843.87 they have no...

(2 questions in this post btw) I'm purchasing new computer equipment for my dad's graphic company... The equipment costs $105,000 up front, but I can lease it for 3 years at $4,500 (monthly). The vendor I am going through is actually waiving the first month for me so it is 35 months, but he...

I have several loans that I want to pay off in order of smallest to largest. When the smallest is paid off I want to take that payment and add it to the next one and so on. I figured out the end date of the first loan and I want a formula that would make normal payments until the first one is...

Not sure what the correct name is for this kind of spreadsheet - which makes it difficult to do effective searches for it. But how would I build a spreadsheet to record loans made monthly (at diff. interest rates) without a fixed repayment date and also keep running total due? Since the time...

Hi Team, I was going through your videos and had a small query, that needed some answers. Hope you could help. Query : 1) if employees are paying loan amount with different yearly interest rates with every new request, whereas the fixed amount is 35,000, and the amount to be paid to the...

I need to find a formula to help with the following.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> If i loan money in the following manner and if the loan amount of loan one is a variable amount, as is the interest and the laon period, how can...

Hi there, I am needing to do some calculations on a loan, the tricky part is that the interest and the payment is not the same. Lets see how to explain PV = 200.000 PMT = ?? (added monthly) Interest = 10% pro anno (but added quaterly) FV = 0 Can excel with out making a tabel calculate the...