Finance test (P&L, BS, CF)

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

Need to be done in 4-5 hours. 10$

1. Develop and offer the management of the company, which is engaged in the creation and promotion of its own information portals, three forms of reporting: P&L, CF, BS by projects and by the types of expenses.

ATTENTION! Assignments completed in Excel documents will not be accepted, only in Google Sheets that are open for viewing.

2. Fill in the reports developed in clause 1 with data based on the operations indicated below. The reporting period is 12 months.

Operations:

a) Received money from clients for 6 months of providing services by the company in the amount of $ 6,000 (postpaid).

b) The company rendered services to the client in the amount of $ 1000 for the current month.

c) We received an advance payment from a client in the amount of $ 1200 for services that will be provided within the next 12 months.

d) The company paid for marketing services from a supplier in the amount of $ 2000 (prepayment).

e) The company paid salaries to employees for the current month in the amount of $ 2,500 ($ 500 for a marketer, $ 600 for a director and an accountant, $ 600 for sales managers, $ 800 for developers and designers).

f) The company purchased a 3-month subscription to use the CRM system in the amount of $ 300 (prepayment).

g) The company paid dividends to the owners in the amount of $ 500.

h) The company purchased the software for $ 1000. Payment will be made within 2 months according to the terms of the software purchase agreement.

i) The company received an interest-free financial assistance from the owner in the amount of $ 5000 in the current month.

j) The balance at the beginning of the month on the company's accounts is $ 5,000.

Please calculate the company's net profit, its margin and profitability.

3. Give comments to the company's reporting for its management, make your suggestions for optimizing business expenses, if any.

4. A foreign company pays an employee remuneration to his individual entrepreneur / sole proprietor account. Describe the entire procedure for interaction between a foreign company and an employee from the point of view of finances and workflow.

5. What are the main business indicators that should be calculated to assess the efficiency of using the business owner's funds within the framework of the company that creates and promotes its own information portals (monetization models: advertising, affiliate income)?

Excel Accounting Finance Financial Accounting Financial Modeling

Project ID: #27462079

About the project

16 proposals Remote project Active 3 years ago

16 freelancers are bidding on average $36 for this job

Baderah

I am an expert financial analyst with +7 years of experience in financial modeling. I am also CFA (Chartered Financial Analyst) qualified. Therefore, I can aptly undertake your work. For more details, contact me.

$15 USD in 1 day
(98 Reviews)
5.6
SIBTEHASSANBUTT

Hi there, I have read your project entitled “ Finance test (P&L, BS, CF) ” I am a Certified Chartered Accountant and a duly certified mentor of ACCA (UK). I have already done numerous projects of this sort. You can see More

$250 USD in 1 day
(14 Reviews)
4.4
cpapreston

Hi, I will give you excellent results on this test. I am a lecturer and consultant in Accounting and Finance with (20) years’ experience, CPA, Bcomm (Accounting), MBA (Finance) and a professionally trained business t More

$15 USD in 1 day
(11 Reviews)
3.9
vaibhavwork10

Hi team, You are currently on a profile of a person who has strong expertise in financial analysis & projections, accountancy, financial modeling, and financial research. I have more than 4 years of experience in this More

$10 USD in 1 day
(5 Reviews)
3.2
ashishborar

Hello, I'm an MBA in Finance and CFA (cleared all 3 levels in first attempts), with 10+ years of work experience which have helped me develop expertise in Financial/Management/Cost Accounting, Stock/Bond Valuation, Cap More

$30 USD in 1 day
(4 Reviews)
3.4
xtianzent

Dear client. I have read your proposal carefully. I am able to do this project successfully. I am expert for this task. Please give me a chance. I ensure you that I can complete your work and I will 100% satisfied you More

$10 USD in 7 days
(5 Reviews)
3.1
Syedamir007

Hello, I am Chartered certified Accountant ( ACCA ). I have more than Six Years Experience as an Accountant. I will do finance test of your company ( P&L , BS,CF ) I highly value professionalism and hold myself strict More

$50 USD in 1 day
(5 Reviews)
3.0
GoravDogra

hi i am master degree holder in commerce and i have all the required skills for you're project i love to work with you on this project as a full time job thanks in advance

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

Good morning I've gone through your project and i'm interested. I'll do my best to complete the project you offer.

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

Hi! I am an Tally, Excel, Word (M.S. Office & More Softwares) Expert with Professional experience working with Excel both with Formulas and Macro, Working with complicated formula and Developing Macro programs are par More

$20 USD in 3 days
(0 Reviews)
0.0
shivanshtiwari04

Hello sir, i have enough experience of handling day to day today accounting and finance related work as i am a finace intern in a ca firm i assure you that i will complete your project in less time than i have claimed. More

$12 USD in 4 days
(0 Reviews)
0.0
AdinarayanaCA1

Hi Sir, I am a Finance & Accounting Professional with CA& CMA qualifications and have experience in Finance & Accounting functions. I have expert knowledge & working experience in Accounting Software and would be able More

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

I can assist you in a Finance and Accounting field. I used to make the whole FS Report. Please tell me about the project timeline. Thanks

$30 USD in 5 days
(0 Reviews)
0.0
MuhammadAfzal209

I am a Chartered Accountant from Pakistan. I can perfectly help you with that. I am a professional Financial Accountant with more than a decade of experience in managing the accounting and finance division for top tier More

$22 USD in 7 days
(0 Reviews)
0.0