Create a simple to understand P&L spreadsheet template


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

Taidot: Excel, kirjanpito, Google Sheets, Sijoitusanalyysi

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Rzeszów, Poland

Projektin tunnus: #27845796

15 freelanceria on tarjonnut keskimäärin $40 tähän työhön


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 Lisää

$20 USD 7 päivässä
(41 arvostelua)

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 7 päivässä
(41 arvostelua)

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 Lisää

$80 USD 7 päivässä
(22 arvostelua)

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 Lisää

$10 USD 1 päivässä
(11 arvostelua)

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 Lisää

$20 USD 5 päivässä
(4 arvostelua)

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 3 päivässä
(3 arvostelua)

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 Lisää

$20 USD 1 päivässä
(4 arvostelua)

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 Lisää

$15 USD 1 päivässä
(1 arvostelu)

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 7 päivässä
(0 arvostelua)
(0 arvostelua)

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 Lisää

$20 USD 10 päivässä
(0 arvostelua)

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 Lisää

$12 USD 3 päivässä
(0 arvostelua)

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 Lisää

$20 USD 7 päivässä
(0 arvostelua)

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 Lisää

$250 USD 1 päivässä
(0 arvostelua)

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

$20 USD 3 päivässä
(0 arvostelua)