# 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.

Evner: Excel, Financial Modeling, Regnskab

Om arbejdsgiveren:
( 0 bedømmelser ) Hudson, United States

Projekt ID: #27913127

## 19 freelancere byder i gennemsnit \$466 timen for dette job

(67 bedømmelser)
7.5
(136 bedømmelser)
7.4
daniyal3214

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 Flere

\$250 USD på 1 dag
(220 bedømmelser)
6.6
kanchana1974

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 Flere

\$350 USD in 10 dage
(48 bedømmelser)
5.6
sevillajk01

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 in 10 dage
(43 bedømmelser)
5.0
smartbookaccount

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 Flere

\$325 USD in 3 dage
(34 bedømmelser)
4.9

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 in 7 dage
(85 bedømmelser)
5.0
JSAConsultants

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 Flere

\$300 USD in 9 dage
(16 bedømmelser)
4.4
Goodfreelancer1

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 Flere

\$500 USD in 15 dage
(13 bedømmelser)
3.9
Aryanman007

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 Flere

\$650 USD in 7 dage
(1 bedømmelse)
3.7
theprowriter50

\$283 USD på 1 dag
(8 bedømmelser)
3.3
Raghuvir20

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 Flere

\$500 USD in 7 dage
(0 bedømmelser)
0.0
vijayvala522

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 Flere

\$300 USD in 5 dage
(0 bedømmelser)
0.0
Aashis007

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 Flere

\$300 USD in 7 dage
(0 bedømmelser)
0.0
shreerang1806

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 Flere

\$500 USD in 7 dage
(0 bedømmelser)
0.0
IASInsight

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 in 7 dage
(0 bedømmelser)
0.0
jkty99expert

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 in 4 dage
(0 bedømmelser)
2.8
muditams

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 Flere

\$500 USD in 7 dage
(0 bedømmelser)
0.0
mfmirza

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 Flere

\$667 USD in 20 dage
(0 bedømmelser)
0.0