Find Jobs
Hire Freelancers

Create a simple to understand P&L spreadsheet template

$10-30 USD

Closed
Posted over 3 years ago

$10-30 USD

Paid on delivery
PLEASE READ & UNDERSTAND BEFORE REPLY. Create a simple P&L spreadsheet template that summarizes the net revenue, cost, and expenses incurred during a 5-year period. The P&L Must include the following values, which can be edited: - unit NET price in USD - number of forecasted units sold - forecasted sales (per month and total period, NET & GROSS) - depreciation value expressed in % - VAT % - sales events (number of promotions per year and discount percentage) - marketing cost expressed in USD - development budget expressed in USD - additional expenses expressed in USD - platform royalties (like Google, Apple, or Steam) - what is T-REX? - chargebacks expressed in % - revenue share split % (developer <> publisher, example 50/50) - sales curve (example): 10% after one week, 30% after three months, 55% after one year, 75% after two years, 90% after three years, 95% after four years Keep in mind; this P&L is designed for the non-accountant, so it must be clean, simple, and easy to understand. Case Example: The game is expected to sell 100000 units at $9.99 over a 5-year period. What will be the NET revenue per month and at the end of each 12-month period less all operating costs, taxes, fees, 4 different sales events (15%f, 20%, 30%, 50% off), etc. Begin your reply with the answer to the question posed within this job description. All replies without the answer will be disqualified. IMPORTANT NOTE: This project is not for creating fake social engagement
Project ID: 27845796

About the project

14 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $42 USD for this job
User Avatar
T-REX is a dinosaur type. I have read your requirements, can create a dynamic dashboard with charts and graphs that summarizes the company's numbers as needed( included the list mentioned) Let's us discuss your request please John
$80 USD in 7 days
5.0 (197 reviews)
6.4
6.4
User Avatar
what is T-REX? Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 54 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done on personal finance applications. Looking forward to hearing from you. Thank you BAVarun PS: Please have a look at the reviews given to me on this platform.
$20 USD in 7 days
4.7 (64 reviews)
5.4
5.4
User Avatar
your example doesn`t have enough details but this is the template for u example revenue per month 16650 minus COGS Gross profit minus other expenses minus tax
$20 USD in 7 days
4.8 (62 reviews)
5.2
5.2
User Avatar
Hi, With regards to the requirement of the Project, I would like to apply for the project. I am Pratiksha Vyas (MBA finance), expert in Managerial Accounting, Academic project writing, tutoring, excel expertise, Financial Calculations etc. I have already completed many project here as well. You can further check my profile for my dedication towards my work. I would assure you the best work with reasonable price. Thanks.
$10 USD in 1 day
5.0 (12 reviews)
2.9
2.9
User Avatar
The game is expected to sell 100000 units at $9.99 over a 5-year period. What will be the NET revenue per month and at the end of each 12-month period less all operating costs, taxes, fees, 4 different sales events (15%f, 20%, 30%, 50% off), etc. The total revenue would be 999 000 $ if everything sold at 9.99 $. However, it's impossible to provide the NET revenue per month and at the end of each 12-month period with only the information given. We are missing exact sales details, so we can't know how many items were sold at the discounted price, what were the operating costs and taxes, etc. In case all required values were provided, for example number of sales per month, or sales growth per month it would be possible to manipulate the numbers and provide the reports. Feel free to contact me to discuss this in more detail. I have worked in multiple reporting teams in big international companies, so I'm pretty sure I could cover your needs.
$20 USD in 5 days
4.7 (4 reviews)
2.9
2.9
User Avatar
Hey I am a CPA and I have understood this task. I can surely solve this. I am an excel expert too. Be rest assured. Let us discuss over chat. I will do ASAP.
$35 USD in 3 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi, Greetings! I have read your project description perfectly understood your job requirement. I am qualified chartered accountant (ACA) and I have more than 10 years of experience of working in Microsoft Excel including more than 4 years of working in professional accounting firms. This makes me the perfect candidate for this project. I can assure you that my work will be of the highest standards and strictly as per your requirement. If you are interested, we can further discuss in detail via chat. Hope to hear from you soon. Thanks and regards, Sabih Khalid
$15 USD in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
Question: Expected Sale 100000 at $9.99 Period 5 Years Per month Revenue is? Answer: $0.1665 after deduction of 15% Revenue is=$0.141525 After 15% deduction per unit monthly cost = $00000.141525
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a qualified professional accountant (CA) with more than 15 years of experience and having the experience to timely completion of tasks. Previously and presently, I am taking care and completely responsible for analysis and presenting the profit and loss account for the management in simplest and understandable way with proper remarks. So in view of the above, I am completely suitable to handle this project in an efficient and accurate way. Best Regards, Rahul Sharma
$20 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am Ryan Enrile and I am from Philippines. I graduated Bachelor of Science in Computer Science at Wesleyan University-Philippines. I used to work at Dubai, United Arab Emirates for more than 10 years. I worked there as Data Entry Operator for more than 5 years and my main duties is to make all kinds of sales report and sales projection. Please see the sample calculation I have made based on the case problem above. $9.99 Regular Price 100,000 Unit Sold (5 years) 1,667 Average Unit Sold per month $16,650 Average Gross Sales per MONTH $199,800 Average Groos Sales per YEAR AVERAGE SALES per MONTH $16,650 Average GROSS Sales per MONTH $4,163 Approx. Operating Cost (25%) $1,165.50 Approx. Taxes (12%) $832.50 Approx Fees (5%) - Marketing Cost, Platform Royalties, Additional Expenses, etc. $10,490 Average NET Sales per month $5,244.75 Revenue Share Split (50% of NET Sales) AVERAGE SALES per YEAR $199,800 Average GROSS Sales per YEAR $49,950 Approx. Operating Cost (25%) $13,986.00 Approx. Taxes (12%) $9,990.00 Approx Fees (5%) - Marketing Cost, Platform Royalties, Additional Expenses, etc." $125,874 Average NET Sales per year $62,937.00 Revenue Share Split (50% of NET Sales) The other calculations (15% sales, 20% sales 30% sales, etc.), I can send it to you upon your request.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
T-REX should be a big extinct animal. I don't understand who is providing cost details? I understand that you need a P&L in which you can edit input data and P&L moves based on that. Anyway I can build it in a few hours
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can provide a clean, simple, and easy to understand excel template to provide solution for the task offered.
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of POLAND
Rzeszów, Poland
5.0
1
Member since Oct 23, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.