Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started