Closed

Create custom excel for cash flow analysis from data set

Dear,

I have attached two excels. we need to customize it based on custom bank statement where it can read all the transactions and classify them into categories debt or income with its descriptions.

Operating Activities

Operating activities make up the day-to-day transactions, like buy products, purchasing inventory, paying rent, and paying operating expenses. This section of the statement is associated with the Current Assets and Current Liabilities sections of the Balance Sheet, as well as the Revenue and Expenses section of the Income Statement.

Investing Activities

Investing activities include buying and selling assets like property and equipment, lending money to others and collecting the principal, and buying/selling investment securities. This section of the statement is associated with the Long-Term Assets section of the balance sheet.

Financing Activities

Financing activities include borrowing from creditors and repaying loans, and collecting money from owners/investors, and payment of cash dividends. This section of the statement is associated with the Long-Term Liabilities and Owners'/Stockholders' Equity from the Balance Sheet.

Prepare and analyze the cash flow statement to say that if you have the records of all the cash transactions, then the preparation can be done using the simple method of categorizing the receipts and payments into the categories like Loans, Electricity, Rent, Fuel, ​etc. The indirect method can be used to create the statement of cash flows from the information in the balance sheet and income statement.

Skills: Accounting, Finance, Financial Research, Business Analysis, Financial Analysis

See more: free cash flow template, monthly cash flow statement template, monthly cash flow template excel, 12 month cash flow statement template, 3 year cash flow projection template, construction project cash flow template excel, daily cash flow template excel, personal cash flow template excel, create custom xml excel, create custom excel file type, cash flow analysis, create custom excel invoices import quickbooks pro, create custom excel spreadsheet, excel cash flow, analysis excel data set, create cash flow statement excel, excel cash flow forecast curve, excel cash flow liquidity, start cost cash flow analysis, cash flow timing table from raw data set

About the Employer:
( 9 reviews ) Dubai, United Arab Emirates

Project ID: #21333725

23 freelancers are bidding on average $37 for this job

topacademics

I have completed various kinds of a business plan, market research and academic projects. My core competencies focus on business planning and resolving business research problems in a unique way according to the specia More

$30 USD in 2 days
(493 Reviews)
8.0
NoelReubenMuturi

Hello. My name is Noel. I have read your brief; you need assistance with an accounting project. I am a BSc. in Accounting and ACCA, and a proficient accountant with over 10 years of experience in Finance and Accounting More

$30 USD in 5 days
(253 Reviews)
7.6
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan

$100 USD in 2 days
(77 Reviews)
6.4
usmanhassan123

MBA accounts and finance. I am also C.A finalist. I am a Financial and Business analyst having 7 years of experience in these skills: • Financial modeling and projections • Business valuation/Business plans • Financi More

$150 USD in 1 day
(72 Reviews)
5.9
smartbookaccount

Dear Sir, I trust you are well, I am a chartered accountant. I am an expert in Cash flow modeling as having supported some software developers to finish apps. I can first categorize them (Transactions) into P&L and More

$100 USD in 3 days
(5 Reviews)
2.4
ironstar20311

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Everyone calls me "PRINCESS of Excel". (. ❛ ᴗ ❛.) Here are projects I have done recent More

$20 USD in 1 day
(1 Review)
2.4
hajizafar541

sir we can done this well..........................................................................................................................................................

$10 USD in 2 days
(1 Review)
2.0
dreamtbusiness

Hi Dear, I have glanced around your Excel. I understand you are looking for an Excel tool where you put the transactions in one sheet and you get the diverse reports automatically. For this need to use Pivot Table and More

$30 USD in 7 days
(1 Review)
0.4
mohitgarg94

We are a team of qualified chartered accountant having experience in field of taxation ,accounting and financial mgt. Feel free to contact us at 8000380779

$20 USD in 2 days
(1 Review)
0.2
Aish91

Hey I have finance specialization as you can see from my profile. Hopefully, I can help you in a much better way. Regards Ayesha

$25 USD in 2 days
(1 Review)
0.2
CATHCORRE

I am an Licensed Accountant here in the Philippines. Knowledgeable in MS Suite (Excel, Word, PDF, Powerpoint). With experience in Bookkeeping, General and Financial Accounting, Cost Accounting and Business Analysis for More

$20 USD in 7 days
(0 Reviews)
0.0
alejosorgentini

I´m on my last year on Business School and looking forward to pursue a career on Finance. I have done valuation projects before (Big companies and start-ups as well) so I´m familiar with cash flow and time-value of mo More

$30 USD in 7 days
(0 Reviews)
0.0
ijazhussain67

Hi i am Ijaz Hussain from Pakistan and working as Finance Manager in well reputed organization with experience of more then 15 Years. I have done MBA Finance from well reputed organization and I have learnt the job des More

$15 USD in 7 days
(0 Reviews)
0.0
razvancotofana

Hello, I am interested in your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan

$50 USD in 7 days
(1 Review)
0.0
amirj4286

Dear I am working on the same from last 15 years. I hope to convince you as required. Regards Amir Relevant Skills and Experience Budgeting, Cash Flows, Periodic Analysis, Contracts Management

$55 USD in 5 days
(0 Reviews)
0.0
akumar40

I am quite good at working on financial statements. Delivery according to time schedule. Looking forward to reply.

$25 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
cherryfebaclig

$25 for this task. I could deliver this within 5days depending on my availability. I couldn't view the excel files you have attached but you may chat me so I could give you my personal e-mail. Relevant Skills and Exp More

$25 USD in 1 day
(0 Reviews)
0.0
wanzariah

Familiar with preparation financial statements/management accounts, including preparing monthly cash flow & cash flow projections

$25 USD in 2 days
(0 Reviews)
0.0
harbirgulia

I'm doing CA(Chartered Accountant) course . So i have knowledge of cash flow. You can i hire me and you get your work done in minutes. Relevant Skills and Experience Also done IT AND OP from ICAI. HAVING COMPUTER KNO More

$11 USD in 1 day
(0 Reviews)
0.0