We have a financial model that has been built over about 10 years. At some point, we need an entire overhaul, but for now, we need some modeling help from an Excel whiz!
So...on the Cash Flow tab of the attached model, there are two lines - Down Payments and Mod Payments, lines 12 and 13. Those currently have formulas in them that draw on two tabs named "Workings 1" and "Workings 2" this is not an elegant solution to our problem.
On the All Asset Pipeline tab are a set of loans. Column N is the Liquidation Date. Column AC is the Mod Date.
COlumn AB is an input flag for wherever we believe the loan will receive a modification or not (e.g. will it begin to cash flow for us? If yes, then we want to capture the cash flows, if no, then we don't).
So the challenge: create a simple excel solution in rows 12 and 13 of the Cash Flow tab that captures the following:
a) For all rows on the All Asset Pipeline tab with "Yes" in Column AB, then capture the Mod Down Pmt amount in Column AD in the month indicated in column AC. Return that value in row 12 of the Cash Flow tab, in the corresponding month in row 4 of the Cash Flow tab.
b) For these same loans, in the month AFTER the date indicated in column AC, then input the payment indicated in column AA in row 13 of the Cash Flow tab. BUT only input this payment for all months up to, and including the month indicated in column N of the All Asset Pipeline tab - which is the Liquidation Date, or the date we sell the loan
c) repeat (a) and (b) for all rows in All Asset Pipeline tab with a "Yes" in column AB
The solution should NOT have to include the use of the two extra tabs "Workings 1" and "Workings 2" which were developed for us, but are a clunky solution to our problem.
21 pekerja bebas membida secara purata $394 untuk pekerjaan ini
I am interested to do this work for you. can we discuss about this project. will wait for your reply, I completed your one project before Thanks, Sultan
Hi, I am interested in your project. I can help you capture the data as per your requirements. Feel free to check my profile and see my expertise. Thanks & Regards, Peter
make sure you will have all the work you request done 100% , am new on freelancer , but i have an experience with excel and data processing plus dealing with all the subjects you ask for it :)