Đã Đóng

Excel Financial form

The one I need now involves a finance sheet for costs, cash flow and predicted cash flow.

1) One part of the project is to create a form that can save new costs, revenue and deposits into a data base. Very similar to a data saving form with data base... but involving costs.

The spaces needed for creating and editing costs are:

Cost name

Cost type and subtype - see list below on 6)

Booked date

Value date (Value date is the date used in the Cash Flow).

Actual Value

Budget value

Paid by (Dropdown with list of employees' names)

Receipt (include attachment with miniature picture + hyperlink of the image file related to it)

Recurring every month - yes or no (if it is recurring, create the same cost everymonth, without the attachment. We should be able to edit a single one out of the series, without altering the whole series).

If HR cost, activate dropdown with name of employee (with the option ALL, in case is for all employees at once) and include the sub option: salary, bonus, extra or tax.

2) Input: Revenue form

Same as above but with different fields. It will feed the revenue side of the Cash Flow, while 1) feeds the costs.

Necessary fields:

Memberships sold

Total Revenue

Payment gateway commission: in %. This is then saved as cost - see 6)

Origin: PagSeguro, B2B.

If B2B is selected: name of the company.

If B2B is selected: responsible.

Booked Date (as default, "today" but can be edited)

Value date (is the correct date that goes to Cash Flow calculations).

Attachment: Receipt or contract - hyperlink to an image file in a different folder (show mniature of the image in the form).

3) Input: Deposits form

Same as above. However, it enters the Cash Flow as external deposit and goes to the total Cash of the company.

Value

Booked Date

Value Date.

Source: Angel Investor, VC, Partners, refund, interest rate.

** The next part is about creating a dynamic quarterly cash flow model.

This Cash Flow should take in consideration the costs we have saved in the data work sheet from 1), revenue in 2) and external deposits 3). However, the cash flow should only get data from the data base worksheets with costs, revenue and deposits, if the last day of Q1 is < than [url removed, login to view], the costs, revenue and deposits, for Q1 should be an estimation... same for Q2, Q3, Q4... etc.

Every cost that was done before Q1 started should be called initial investment cost. Therefore, there should be a place to choose a date for when Q1 starts. After that, every quarter starts every 3 months from that date.

4) On the next sheet we should have a "report worksheet". In this, we should be able to use dynamic buttons to

- change the conversion rate of google,

- conversion rate for facebook,

- Cost of acquisition for offline customer (should be a manual value indicating the cost per membership sold, not the total amount)

- % of the profit that will be reinvested next quarter in marketing

- % of HR costs compared to last quarter.

- Tax over revenue

- Tax over profit

- % of the revenue being reinvested in marketing that quarter (this is tricky since the quarter before we estimated how much would be reinvested in the next quarter and, therefore, it was deducted from profit and not taxed as profit. So, in the next quarter we can only use for marketing that money destinated from reinvestment. All the extra has to come from the revenue being generated during the same quarter).

Note, when including or editing the numbers above on "report worksheet", we should be presented with a dropdown option to change them for next quarter Q+1 or Q+2 or Q+3 or Q+4.

After choosing these above and filling the spaces (note that the spaces should already be filled with the numbers we have selected or written for that quarter previously. If not, then they are blank), we should be presented with a report overview of the expected results.

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel, Tài chính, Visual Basic

Xem thêm: excel financial form, visual work flow, visual basic cost, the basic cost flow model is, rate visual basic, out source tax, need marketing employee, names editing, marketing angel, i need employees now, i need employees for marketing, Google Partners, get paid to input data, get paid to edit, get financial, get external data, flow cost, excel out source, estimation in excel, employee of the month picture, data processing costs, data enters, creating use case, cost flow model, cost flow

Về Bên Thuê:
( 3 nhận xét ) Copenhagen, Brazil

Mã Dự Án: #1668324

26 freelancer đang chào giá trung bình $423 cho công việc này

Dhruvika111

Dear fabrizioserra, Highly Experienced and Expert Team Of Accountants [url removed, login to view] check your PM For Details. Thanks Dhruvika

$400 USD trong 5 ngày
(129 Đánh Giá)
7.0
bharanisrihari

Hello, Excel VBA expert ready to start. Please check PM for details. Thanks!

$400 USD trong 10 ngày
(67 Đánh Giá)
6.5
funnyhoney

MBA and PMP from PMI. Expert in financial analysis. Please check my reviews on freelancer. Looking forward to your response.

$400 USD trong 10 ngày
(22 Đánh Giá)
6.4
javed1705

dear sir please check pm

$400 USD trong 4 ngày
(102 Đánh Giá)
6.2
imranamin

Please Check PM

$400 USD trong 15 ngày
(37 Đánh Giá)
5.8
becomeexpert

Excel, access and vb expert here. Let's have the deal. Thanks.

$400 USD trong 21 ngày
(32 Đánh Giá)
5.7
binaryromel

##### Expert here! Please check PM. #####

$400 USD trong 6 ngày
(61 Đánh Giá)
5.5
winnet21

I have experience in this project, I am very interested in this project, hope to work with you in this project

$400 USD trong 20 ngày
(12 Đánh Giá)
5.0
kulhanekd

I have 15 years exp in excel and Access. I would like to bid. Thanks Donna

$400 USD trong 5 ngày
(13 Đánh Giá)
4.7
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Thêm

$400 USD trong 30 ngày
(1 Đánh Giá)
4.6
rohitpithisaria

Hi... I would like to apply for the job.

$400 USD trong 7 ngày
(20 Đánh Giá)
4.2
SaraHailes

UK qualified accountant with over twenty years financial modelling and Excel [url removed, login to view] see PMB for further details of bid.

$400 USD trong 5 ngày
(4 Đánh Giá)
3.9
shagoon2u

VBA Experts are ready to start immediately

$401 USD trong 5 ngày
(3 Đánh Giá)
2.9
marilor

Dear Sir, for a professional solution please consider our proposal. We consider that our experience with multinational companies like Clarks automotive and Carrier enriched our professional skills. Please do not heist Thêm

$400 USD trong 5 ngày
(0 Đánh Giá)
0.0
Aggie93

I have a MBA and spent 10 years as a programmer.

$400 USD trong 5 ngày
(0 Đánh Giá)
0.0
halliti

Senior statistician with good commands in Excel. Prior experience in global financial institutions.

$400 USD trong 25 ngày
(0 Đánh Giá)
0.0
ETNASoftware

Hello, Our developers have extensive experience in development of financial software and in customization of Excel. Examples of the work completed: [url removed, login to view] We would be glad to help you with thi Thêm

$400 USD trong 1 ngày
(0 Đánh Giá)
0.0
gadha2

As a Financial analyst of small and midsized firms i have helped lot a lot of businesses to access their cash flow and other financial performance which helped them to focus on their week points and capitalize on stren Thêm

$1000 USD trong 7 ngày
(0 Đánh Giá)
0.0
Dylanrock

HELLO SIR PLEASE CHECK PMB

$400 USD trong 3 ngày
(0 Đánh Giá)
0.0
Winoth

Hi, We could do this project within 5 days as per your requirement. Thanks, Vinoth

$400 USD trong 5 ngày
(0 Đánh Giá)
0.0