Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Build out the P&L by month below using the notes for this theoretical social media company Must be detailed by Month Notes: 1. Assume the

Build out the P&L by month below using the notes for this theoretical social media company

Must be detailed by Month

Notes:
1. Assume the company did not exist before Jan 1 2021
2. On Jan 1st they signed $7M in annual contracts (assume these were the only ones signed all year)
3. The $7M in cash from the annual contracts is received on July 31 2021
4. The company's software runs on a Cloud platform and on Jan 1st 2021 they pre-paid their entire year of COGS which was $1M
5. S&M expense is 5% of revenue from Jan to June'21 and then increases to 10% of revenue
6. R&D and G&A are 10% of revenue all year
7.Depreciation is $0. Income Tax is 20% of EBITDA
8. On Jan 1 2021 they took out a $3M loan with 5% annual interest

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.0
COGS $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 0
GM $ $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
GM% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
S&M $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
R&D $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
G&A $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
Total OpEx $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
EBITDA $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
Interest $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.00
Depreciation $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
Tax $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
Net Income $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Managerial Finance

Authors: Scott Besley, Eugene F. Brigham

13th Edition

0324258755, 9780324258752

More Books

Students also viewed these Finance questions

Question

Differentiate. f (x) = x 2 ex/x 2 + e x

Answered: 1 week ago