principal

Hi I have a table with 12 columns which is used for tracking Receipts and Payment for Individual CLient. (I have a sample file. But this forum doesnt seem to allow me to attache it to the post) I am trying to create a automated consolidated snapshot as of current date i.e. Total Principal...

I am unable to get sum total for the following dataset: the columns are as follows: NO. PAYMENT AMOUNT INTEREST PRINCIPAL (D11:D1054) DATE WHEN PAYMENT IS DUE (I11:I1054) MY FOLLOWING FORMULA FAILS AND I AM OUT OF LUCK! =SUMIFS(D11:D1054,I11:I1054,"YEAR(2017)") I AM TRYING TO CALCULATE...

I am trying to work out the interest rate of the below given cash flows. I have a principal balance of 1000 and I am paying interest quarterly, at the dates where the 1 is denoted. The interest amount is the sum of the previous quarters cash flows. So for example in the 30/09/2018 date, I will...

I tried Mail Merge but because of the complexity/amount of the data it did not work so I have created a pivot table filtered by school / Principal email - all the data is there as requested I now have about 80 sheets that I would like to automatically email to each of the principals Is there a...

My employer recently upgraded to Office 2016. I'm getting an odd result in PowerQuery. When I update a particular query from a macro file using ActiveWorkbook.Connections("Query - Financing").Refresh The connection window tells me that every row - 190 - has errors. But when I click on...

Hi All, Thank you in advance, I have a of sheet organizations and designations - NEW sheet In this sheet some of the organizations may have only one designation or Combo of more than one for a given organization I have another Sheet named Old - which contains information with designation...

All I am having issues with embedding multiple if scenarios with OR/and logic. In sheet1, column A = system titles in sheet 1, column B = # of years in sheet1, column C = if statement required (client titles) in reference sheet, column A = system titles in reference sheet, column B = client...

Hi, First time poster. I'm trying to back into the principal amount of a self amortizing loan with varying interest and cash flow. The interest rate will be 5% for the first year and 2% for years 2 - 6. There is no payment in year 1 and let's use $100 for payments in years 2 - 6. Any...