Lukket

Create a simple to understand P&L spreadsheet template

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

Evner: Excel, Regnskab, Google Sheets, Finansanalytiker

Se mere: create simple flash roll button, create simple text graphic jpg, create simple email submition page, create simple business text logo photoshop, create simple php website, create simple flash video jukebox, create simple flash website, create simple chart vbnet using dundas, create simple banner using css, create simple hello world component joomla, create simple opencart theme template scratch, create simple excel spreadsheet template macros, excel macro create spreadsheet template list data, create simple page html template, create simple wordpress template, create simple email template

Om arbejdsgiveren:
( 1 bedømmelse ) Rzeszów, Poland

Projekt ID: #27845796

15 freelancere byder i gennemsnit $40 timen for dette job

BAVarun

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 o Flere

$20 USD in 7 dage
(41 bedømmelser)
4.8
Amrsamra

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 dage
(41 bedømmelser)
4.7
JohnRikz

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 requ Flere

$80 USD in 7 dage
(22 bedømmelser)
4.1
Pratikshakartik8

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, Finan Flere

$10 USD på 1 dag
(11 bedømmelser)
3.0
alvijag

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 Flere

$20 USD in 5 dage
(4 bedømmelser)
2.8
popcon205

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 dage
(3 bedømmelser)
2.4
manishsihag1993

Dear Hiring Manager, Thank You for posting the job opening in as p&l summary in excel spreadsheet. I have 4 years of accounting experience with advance Excel working. I have perform all of the duty listed in your job Flere

$20 USD på 1 dag
(4 bedømmelser)
1.4
sabihkhalid77

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 inclu Flere

$15 USD på 1 dag
(1 bedømmelse)
1.0
Jawad0312

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

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 ana Flere

$20 USD in 10 dage
(0 bedømmelser)
0.0
ansakhan259

Solution is here as per your data Expected units sold in 5 years = 100000 Per unit price = $9.99 Total Revenue = $999000 1-year (12 month) revenue = $199800 Gross Profit/Per month revenue= $16650 Per unit re Flere

$12 USD in 3 dage
(0 bedømmelser)
0.0
rye0026

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 th Flere

$20 USD in 7 dage
(0 bedømmelser)
0.0
SoniaCepollina

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 h Flere

$250 USD på 1 dag
(0 bedømmelser)
0.0
cakajalmunjal

I can provide a clean, simple, and easy to understand excel template to provide solution for the task offered.

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