banking

Hi! I'm trying to create a FIFO (First in, First Out) Revolving Line of Credit Tracker in Excel. We buy "short-term" notes (aka, lines of credit) and pay back P&I throughout the month which gets applied to the oldest note first. The rates for each note fluctuates with WSPRIME. I've attached a...

I have a workbook that analyzes 3-5 years worth of bank information, I need to identify when money is being transferred from one account to another. IE. I move $10.00 out of account A and put it into account B. Currently I have a formula that will Identify duplicates that occur on the same...

Hi all, Have to generate 640 files basis district name. The output sheets are formula based , they pull the data from input sheets. Mostly the sumifs formula is used. It takes almost 5 minutes to generate one single file. Perhaps with each change of district the calculation features takes time...

I have a data set containing dates and amounts for upcoming, cash flow causing accounts payable and accounts receivable transactions. Those are exported from accounting software and I use them for cash flow forecast. Other transactions are added manually to the forecast. Problem with those...

Hi everyone - First off, I want to say thank you all for being such great resources - I have received a lot of help from some of you on here! I'm hoping someone can help me with this particular request. I have a file with daily banking activity that I download every day. The report has tons...

Hi everyone - First off, I want to say thank you all for being such great resources - I have received a lot of help from some of you on here! I'm hoping someone can help me with this particular request. I have a file with daily banking activity that I download every day. The report has tons...

Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...

I am creating an Excel spreadsheet designed to manage my company's accounts. Spreadsheet 1 is used like a bank statement to show payments going in and out of the company's bank account. Spreadsheet 2 is used as a cash flow chart. The sheet sis divided into left and right. Columns on the left...

GOAL: Create table of debit card transactions, by month and organized into summed categories (food, entertainment, education, etc.), each of which being compared to income for that month (percentage of) WHAT I KNOW: - If statements (haven't ever used them in excel though) - basics of excel -...

Windows XP, Excel 2007 Okay, Column A is filled with bank transaction descriptions like: 123456789 ACCOUNT WITHDRAWL CHECK CARD 1234 GOODY'S CLOTHING CHECK CARD 5678 APPLEBEES RESTAURANT 123456789876 SOU WAL-MART 092834750298 SOU JCPENNYS STORE 20938209837 ... AND SO ON Column B is the...