Excel Genius Project

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.

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.

Kemahiran: Excel

Lihat lagi: excel genius, excel whiz, excel challenge, modeling in excel, whiz, genius, financial Model, excel solution to return, point excel, project pipeline, excel rows lines, create excel formulas, simple cash flows, create tab excel, elegant excel, value excel capture, modeling excel, excel project model, loan problem, draw built

Tentang Majikan:
( 42 ulasan ) San Francisco, United States

ID Projek: #6717898

Dianugerahkan kepada:


Dear Sir/Madam, I am happy to help you on this task. I went trough the attachments and its looks good for me ;-). I am an expert in advanced excel skills and have a strong financial background. Further, I have already Lagi

$250 USD dalam sehari
(129 Ulasan)

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

$736 USD dalam 5 hari
(172 Ulasan)

Hi dear sir, I can do this for you. Please refer to PMB for details. My experience and dedication in work will certainly help you to accomplish your project in accurate and timely [login to view URL] let me know if you need s Lagi

$526 USD dalam 10 hari
(95 Ulasan)

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

$350 USD dalam 2 hari
(48 Ulasan)

Hi, the project is descriptionis clear. But need to have a short discussion before. I can cod a VBA macro for the a, b and c tasks. Thanks

$250 USD dalam 3 hari
(64 Ulasan)

Hi: Here's what understand that you want to include the down payment and monthly installment for the loan in sheet "All Asset Pipeline" in the "Cash flow" sheet without using the "Working1" and "Working2" tab. Please c Lagi

$450 USD dalam 3 hari
(37 Ulasan)

I am a top ranking freelancer of statistics and mathematics in freelancer.com and excellent in both the subjects. I am M.Sc. in mathematics. I have done a lot of similar jobs before. Please, check employer's feedback o Lagi

$500 USD dalam 10 hari
(22 Ulasan)

Hi, I went through the project description. I am well versed with Excel and its various features and can provide the solution in Excel that you are looking for. I have more than 10 years of working experience to Lagi

$500 USD dalam 10 hari
(25 Ulasan)

Dear sir I see your project and i do it as your acceptation. I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO and Photoshop work would like to assure you that I will do Lagi

$388 USD dalam 3 hari
(74 Ulasan)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel file. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project b Lagi

$300 USD dalam 3 hari
(23 Ulasan)

Hi there! I'm an 'excel genius' and I would like to help you with your project. Please consider my proposal and contact me to discuss further details. Regards. I'm working on it. FYI, row 12 should be =SUMIFS('All A Lagi

$250 USD dalam sehari
(3 Ulasan)


$444 USD dalam 10 hari
(4 Ulasan)

Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, M Lagi

$277 USD dalam sehari
(3 Ulasan)

Dear sir, You give me this work no problem. I am doing this carefully. I inform you, I am working this site ruining 4 year. Then i have lot of experience. i am insure you, i finish this work time to time. I am waiting Lagi

$263 USD dalam 10 hari
(0 Ulasan)

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 :)

$250 USD dalam sehari
(0 Ulasan)

I work with complex financial models in excel as part of my day job. I can complete this project quickly and in low cost just because I am new to Freelancer and working to build my portfolio. I have skimmed through Lagi

$250 USD dalam sehari
(0 Ulasan)

Capacity to work on own initiative and demonstrate high level of team contribution. Quick and willing to assimilate and apply new work procedure and also expert in data entry clerk, Microsoft word, Microsoft excel, Mic Lagi

$555 USD dalam 4 hari
(0 Ulasan)

Hi, i see the, worksheet, that example, i can help you!, i`m developer in VBA with Excel, i can build your solution. Thanks.

$555 USD dalam sehari
(0 Ulasan)

Hi, My skills: I have worked in MS Excel as a Business Analyst for 2 years with an experience of dealing with similar complex problems like the one that you have posted. Clarification/Question: Do you want to s Lagi

$444 USD dalam sehari
(0 Ulasan)

I am great at excel, having 6+ years of experience on data mining and customizing excel formulas. Excel maestro!

$277 USD dalam 3 hari
(0 Ulasan)

Good day, I gone through the job details carefully and I am absolutely sure that I can do the project very well. Initial designs will be sent 24 hours or less * * with unlimited revisions until you are satisf Lagi

$333 USD dalam 3 hari
(0 Ulasan)