Financial Modeling Tool

1) Combine both attached workbooks. This should take about 1 minute to do.

2) The financial modeling workbook needs to have every attached worksheet tie into the respective areas of the workbook. Please scroll entire worksheet pages.

3) The 2nd tab in the Financial Modeling Template is an Assumptions tab. These assumptions will need to be incorporated into the Excel workbook where needed. For examples row 21 is the AR Days Collected and it has 30 days noted. That means the cash amount in the balance sheet / cash flows statement should reflect that on all customers. I also want to know if we can also have it so that if a customer is set on 60 or 90 day terms, the cash balance would reflect that. I would imagine there would need to be an “If” “Then” formula but I could be wrong. The same would hold true for AP. If we can negotiate 30 day terms with a vendor or 60 day terms, I’d want to make sure the respective worksheets reflect the flow of money going out vendor by vendor so we can calculate cash properly and account for cash properly. Lines 15 and 16 take into consideration if we have fixed and/or revolving debt as well so that would need to be reflected in the workbook as well. I can explain the purpose of this worksheet more if you need additional notes.

4) The Notes worksheet has a note that we need to account for

5) Tab 5 is a use of proceeds tab so whatever is filled in here needs to flow into the financial modeling

6) The ratios tab is very simple and pulls in information from various areas of the workbook and should be set to change as items throughout the workbook changes.

7) The Conversion tab is to help manage cash flow and get a better understanding of where sales are. This takes into consideration things such as column 3 or 6. You will note column 4 is the actual close date and column 5 is the estimated so the respective areas on the worksheets need to reflect this. You will not the column headings explain what is needed and everything needs to carry over. WE SHOULD PERHAPS DISCUSS NOT USING THIS PARTICULAR SPREADSHEET

8) The Core P&L tab is the Profit and loss taking into consideration the actual for the past 12 months and then project out monthly for 5 years. You will note as you scroll down, percentages are applied to the line items to calculate the projected amounts above in the actual P&L.

9) The Core BS tab is the balance sheet tab. You will note if you scroll down, it calculates day sales and you can see info is pulled from the Core P&L for the actual months but pulled/calculated differently for the projected months. You will note that there are items being pulled for the days inventory calculation as well as days payable. Note Actual is different than projected.

10) The Core CFS is the core cash flow statement and formulas need to be added to correctly account for case based on the assumptions tab as well as info pulled from other areas such as the balance sheet and income statement.

11) The CFS-13 week is a 13 week cash flow statement and needs to calculate accordingly.

12) The 5 yr P&L Summary is no different that the Ratios worksheet. Simple formulas to pull in the respective items. The same for 5 YR BS and 5YR CFS. The information for these cells is simply pulled from the respective areas within the workbook.

13) Once you incorporate the KPI Metric – LTV – CAC Ratio worksheets which is simply just copying and pasting the worksheets from that workbook into the Financial Modeling Template 12-2018 Workbooks. The formulas will need to be verified to calculate properly and once you have that done for one column, all you have to do is copy and paste the other columns. This should hold true for much of the workbook where projections are done. The amounts in the actual columns will need to manually be entered. The data that needs to be input for the LTV-CAC worksheets will need to be pulled from the other worksheets.

Kemahiran: Excel, Financial Modeling, Perakaunan

Lihat lagi: financial modeling freelance, freelance financial modeling company, swing modeling tool, financial model generator, open source financial modeling software, financial modelling excel, financial modeling software excel, financial modeling course, automated financial modeling, financial modeling excel add-in, financial modeling software free, freelancer financial modeling, financial modeling contract work, freelance projects financial modeling, free financial modeling banking excell, financial modeling experts, sas data modeling tool, freelance financial modeling work, uml modeling tool ruby, freelancer ship modeling tool

Tentang Majikan:
( 0 ulasan ) Hudson, United States

ID Projek: #27913127

19 pekerja bebas membida secara purata $466 untuk pekerjaan ini

(67 Ulasan)
(136 Ulasan)

I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data A Lagi

$250 USD dalam sehari
(218 Ulasan)

Hi, I am a Finance & Accounting Professional with MBA Finance, CMA qualifications and have experience in Financial Accounting functions. I have expert knowledge & working experience in financial modeling and would Lagi

$350 USD dalam 10 hari
(48 Ulasan)

Hello! I can help you with your Excel Financial Model Tool. You can be assured of a high quality and accurate output. To better assess my capabilities please do see reviews from my previous projects. thanks!

$300 USD dalam 10 hari
(40 Ulasan)

Dear Employer, I am a qualified accountant and financial analyst with having ten years of experience. I have done many projects like your one. please have a look on my profile for my skills set check. I am glad to off Lagi

$325 USD dalam 3 hari
(34 Ulasan)

I am an experienced financial analyst with the expertise in financial modeling. I am also CFA (Chartered Financial Analyst) qualified. Therefore, I can aptly undertake your work. For more details, contact me.

$250 USD dalam 7 hari
(85 Ulasan)

Hey! I will do financial modelling in the provided detailed as required. I am a qualified chartered accountant and working in a Consultancy firm from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 4 Lagi

$300 USD dalam 9 hari
(15 Ulasan)

Hello, I am expert in Finance and Excel. I have prepared spread sheet ERP system. Please have a look: https://www.freelancer.com/projects/excel/High-Level-google-access-excel/reviews https://www.freelancer.com/proje Lagi

$500 USD dalam 15 hari
(11 Ulasan)

Hi, I have gone through your job description and I am interested in working on it. I am CFA charter holder and I have more than 9 years of work experience in financial modeling for valuation of diff. financial produc Lagi

$650 USD dalam 7 hari
(1 Ulasan)

I have read your description onFINANCE and would like to work for you.I can complete your task within the deadline. For further details please inbox [login to view URL] you

$283 USD dalam sehari
(7 Ulasan)

Hello I have a Background of Financial Accounting Auditing Apart From that Cfa study give me a Boost to Do a financial modeling by Ratio Analysis also i have 1.6 year of Experience in Broking Industry [login to view URL] its great Lagi

$500 USD dalam 7 hari
(0 Ulasan)

Hello, Dear i have read your project and i have undestood your project. i have the experience to do this type of project earlier. i have worked many platform [login to view URL] i have the confidence to do this. if you want w Lagi

$300 USD dalam 5 hari
(0 Ulasan)

As I main domain of work is related to finance and this project is also related to finance only. And this kind of work preparing report is already i have done in past. As is my current job i have lot of work I have to Lagi

$300 USD dalam 7 hari
(0 Ulasan)

Hi! I am an MBA grad from one of the premier B-schools in India and am experienced in financial modeling, accounting, MIS and valuation. I believe that I would be a great fit for this job, and am looking forward to dis Lagi

$500 USD dalam 7 hari
(0 Ulasan)

I will complete it in 4 days Do you need dashboard analytics for this as well? The actual 12 months data to be needed in order verify that the final financial model work properly.

$750 USD dalam 7 hari
(0 Ulasan)

Hi, I can help you to realise your project because of Masters degree in Financial ingeneering and 5 years of experience in modeling department of banking industry. Please let me know if ok. Kind regards, Julia

$778 USD dalam 4 hari
(0 Ulasan)

Hi, I am a PhD in Economics and would be assisted by my spouse ,who is a hard core financial reporting person . We shall draw a palpable and an impeccable cash flow model and dashboard focusing on keeping it as much Lagi

$500 USD dalam 7 hari
(0 Ulasan)

Sir, I am a finance professional having more than twenty years of experience in the field of Accountancy & Finance. I have been using different ERP like QuickBooks, ACCPAC, SAP Business One etc. and Excel for Financial Lagi

$667 USD dalam 20 hari
(0 Ulasan)