loan

  1. S

    Converting Hidden Sheets to PDF

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

    Amortisation Schedule

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

    Loan Amortization Table with Extra Loan Payment Calculation

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

    Data validation

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

    XIRR not amortising

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

    Loan Amortisation

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

    Formula's for loan with no term but with interest

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

    Calculating APR & lease or loan

    (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...
  9. N

    Loan Payment Plan

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

    How to build loan accumulation spreadsheet?

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

    Loan Payment calculation

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

    Loan Calculation

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

    Loan calculation

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top