payments

Hi All, I used the follwing forumla: =(FV(Int,NPER,0,-NPV(Int,PMT*(1+Grw)^(ROW(INDIRECT("1:"&NPER))-1))*(1+Int) to work out my future investment value. I wanted to start paying £20 every month into an investment portfolio for the next 40 years, wit a fixed interest rate of 2.5%. However, every...

I am trying to write a formula to show quarterly payments for the next 5 years. The payment table is from starts in 2018. First payment is not until Feb 2019. A7: Feb-19 (payment start date) A8: $25,000 (qtrly payment amount) D4: 1/31/18 (across columns, 2/28/18, 3/31/18...etc to 2022) D5: 1...

I am attempting to bulid a formula that will determine rate on an "end of the period" loan where the only knowns are: Starting Balance Term and frequency of payments Number of payments made Current Balance For example: On a $100,000 30yr mortgage, 12 payments have been made, and the current...

Hi, Presently i am working on data that seems like this which relates to payment <tbody> Payment date Document no. Amount Interest Due date 12-Apr-17 120401 10000 1000 1-Apr-2017 10-May-17 120402 20000 2000 1-Apr-2017 30-Jun-17 120403 10000 1000 30-May-17 </tbody> Now we have...

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

Hi, This is my first time posting, hopefully someone can help. I have a list of times and a matching list of payments - Times in cells C4:C14 and payments in cells D4:D14. I have formulas to show the time of the next payment in cell F4 {=MIN(IF(C4:C14>(NOW()-TODAY()),C4:C14))} and one to...

I have a problem where I am looking to calculate the Initial Outlay required to meet a given IRR with 10 periods of the same payments. Desired IRR = 15% Periods= 10 Payments= $219,174.93 Initial Outlay = x Is there a function or formula that will calculate this for me in Excel? Thank you!

Hi Guys! Below is a link to my "debt tracker spreadsheet". What I want is a current total of all my debt balances after taking into account my last payment. I think I could use the FV function but I was trying to get away with not having to input the number of payments because I'm not sure...

My company has a loan taken out on 8/25/17 for $122,100.00 with a purchase amount of $170,940 (this is the total payment amount). The payments of $1,187.09 start on 8/28/17 and are Monday through Friday, except for holidays. The number of payments is 144 (with the last payment being $1,186.13. I...

Hi, I have a spreadsheet with a set of dates and payments, each date does not mean there is a payment. Each month I update a cell which contains the month (eg. April, May, June etc) I want a formula to display the next payments' month. <tbody> Date of report April-18 Next payment date...

I have a table of annual payments and I want to calculate the net present value of future payments (NPV) as of the “nth” year from now, where “n” is a number that I enter into another cell. I’m trying to calculate a payoff amount at some date in the future. Let’s say I have 10 years of...

I am in desperate need of some assistance. I'm trying to teach myself VBA in Excel 2010 and am building an application for a friend. I've come to a point where I'm at a standstill until I can figure this piece out. I've posted this question a couple of times and haven't received any...

I'm teaching myself VBA, using Excel 2010 and have come up against a brick wall. I have a workbook with 4 sheets. ws1 = Bios (holds generic info such as DoB, Email) ws2 = Stats (holds physical measurements such as height, weight, bicep, thigh, etc) ws3 = Services (holds Status, Start Date...

Hello, I need to calculate a commission based on following rates for different bank. Rates are as follows: Please help me calculate the commission based on below conditions: Conditions: Wells Fargo: 70% of total reserve below (column F) Ally Bank : 75% of total reserve below (column F)...

Hi All, I hoping someone may be able to help. I'm creating a purchase ledger and would like to include at the top all a total of: Total Unpaid Payments that are now overdue Payments that fall within 30 days Payments that fall within 14 days Payments that fall within 7 days Below I have tried...

Excel Version: Office for Mac 2016 Good day, I have a project that requires three rounds of equity investment (Tranche A, B, and C) and several loans (Loan 1, 2, 3, and 4). The project is expected to start generating a constant income on a monthly basis which will need to be divided in the...

Hello Guys, I work for a auto dealership and my boss asked me to calculate a reserve on finance deals. I have total 5 finance deals and total amount of financed is: $169,819. My spread is always 2% ( buy rate-sell rate) The reserve is the difference between buy rate and sell rate. How do I...

I am attempting to calculate CRF from the inputs of Interest Rate(B4) and Number of Annuities(B5). This should be doable in excel, but I am struggling. I tried simply having a cell with the formula =(B4(1+B4)^B5)/((1+B4)^B5)-1 and I get a Value error. Is there possibly a function for...

I'm working on a simple spreadsheet that tracks dues and payments. Everything is done an works great except the following: When a payment comes in, I need to apply that payment in a certain order. First its applied to interest, then to late fee and lastly to the dues. Can anyone help me...

Hi, The issue I'm facing is quite complicated to explain so please bear with me. Hopefully the example at the end will help. For accounting purposes I need have a few financial instruments (which you can think of simply as loans with an interest amount paid either annually or quarterly or...