loan

Hi, This appeared to be a simple vlookup and match task but I kind of ran into a roadblock. I'm working on a financial report that shows amounts of aid students will receive for the year and semester. In sheet 1, I have a list of students that are coded with a unique ID number and an item type...

Hi guys, Hoping you can help me with this problem. I'm looking at some loan data. There are some concentration limits (3 examples below) in place for the loan portfolio: 1: Sum of outstanding loans larger than 400k, cannot be greater than 5% of the total portfolio 2: Sum of outstanding loans...

How do i post an xls file? thanks

Please help with a formula I'm trying to work out. I'm trying to return a 'Pass' or 'Fail result based on the following. My criteria is below. A = Loan + Interest B = Loan to Value (%) inc Interest C = Max Loan @ 75% (£750,000) D = Max Loan @ 70% (£1,000,000) E = Max LTV 75% F = Max LTV...

Hello all! I am trying to make a simple calculation to work out a property value. If a bank is willing to loan 360k with the understanding that you must put down a 10% deposit on a house, then you can buy a house up to 400k in value. I want to be able to enter the loan amount, and the deposit...

The revised calculation engine for Excel365 includes new functions that spill and allow for dynamic arrays. Using this new technology, it's easy to create a loan amortisation schedule that omits the need to create the correct number of rows or complex formulas to account for the correct number...

Can anyone please make a loan mortgage table for maximum 10 years @ 9.75% interest p.a. calculated monthly Actually there are a lot of templates for this. But I need the following features 1. there should be provision for extra loan repayment by the borrower in any month possible 2...

Dear All, it is a humble request if anybody has excel sheet to maintain record of Employee Loan.

I have a table of data that contains the following columns. I am trying to count the number of loans each officer has made. In order to have a slicer on the dashboard to switch between combinations of New/Refi funds some loans can be duplicates. Can someone help me with a formula to count the...

Hi Below is the table where i need the number of days to be calculated. Its basically loan days to be calculated. I have given the values manually but requesting all if anyone can give me common formula to put in cell to give me this value (counting of days). <tbody> MONTH END MONTH END...

I am creating a pivot table that feeds from a loan data table to track some installment loan data. In the rows I have "Type" (Auto, Motorcyle, RV, etc.) and "Model Year". In the columns I have customer credit score. I am wanting to group the credit scores in the following ranges: >=726 725-691...

Hello, I need some help with the below code. I know its pretty messy, but hopefully someone can help me clean it up and get it working. The first portion works. The code is assigned to a checkbox. If the checkbox is ticked my activesheet (Status of Closing) range D5 value changes to...

I need to create a loan amortization schedule using Access. My challenge comes as we are using compound interest and I need to determine the monthly payments. I am able to get the total to be repaid using the formula: =[LoanAmount]*((1+[InterestRate]/[CompoundType)^([LoanTerm]*CompoundType))...

I have a spreadsheet with a whole lot of different finance contract details and I would like a formula which auto calculates the outstanding loan balance as at today, or even just at the beginning of the current month, whichever is easier. The information in the spreadsheet is; -loan repayment...

Hi!! Need some help. I have an amortization table for a loan. The rate can be variable with the option for lump sum payments. When a lump sum payment is made, I need the payments to stay the same with the end result being the loan is just paid off faster. Here is my calculation...

An organization has provided a loan to an staff. She pays her loan in installments whose principle amount is constant and the interest changes. What is the formula to calculate present value of future inflows if the interest at which the organization is providing the loan and discount factor is...

Hi All Looking forward for your advice and help in calculating interest on loan given at various date. Details as below a) I have below data as loan disbursement date during the period <tbody> Party Date of Loan Loan Amount A 3-Jan-2016 $ 1,500.00 B 3-Jan-2016 $ 200.00 C...

I have a 'save record' button on one of my forms. When clicked, I want it to show a confirmation message box saying something like "Your loan is approved", only if it saves the record without any error messages. Is this possible?

I am creating a library database system which contains a table called "loan". The loan table contains the book id, borrower, and date/time. How would I create a query to show me the books that were loaned between yesterday's 5pm and today's 9am?

hope someone can help, trying to work out how much I would need to pay each month for a loan/mortgage loan value 32,5000,000 interest rate 3% term 15 years I'm trying to work out what the formula would be to work out how much interest payments only would be each month also would the formula...