MN3194: Entrepreneurship Financial Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Profit and Loss Statement (PNL)
2
[Your company name]
3
4
FY2020Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
5
Gross profit total(9,250.00)(6,200.00)(7,334.00)(4,806.00)(5,417.00)(4,650.00)(4,403.00)(3,213.00)(4,074.00)1,274.002,340.002,699.00
6
7
Revenue total0.00500.00650.00700.001,850.002,100.003,850.003,900.005,150.006,950.008,750.008,250.00
8
9
Costs total(9,250.00)(6,700.00)(7,984.00)(5,506.00)(7,267.00)(6,750.00)(8,253.00)(7,113.00)(9,224.00)(5,676.00)(6,410.00)(5,551.00)
10
11
Operating costs
12
Fixed costs
13
Office lease(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)(1,500.00)
14
Internet, phones, etc(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)(300.00)
15
Website, server, data(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)(100.00)
16
Insurance(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)(150.00)
17
Salary co-founder 1(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)
18
Salary co-founder 2(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)(1,200.00)950.00(1,200.00)(1,200.00)
19
Part-time developer0.00(950.00)(950.00)0.000.00(950.00)(950.00)0.000.00(500.00)(500.00)(950.00)
20
Variable costs
21
Artwork branding(1,200.00)0.000.000.000.000.000.000.00(500.00)(200.00)0.000.00
22
Travel(500.00)0.00(1,500.00)0.000.000.00(1,500.00)0.000.00(1,000.00)0.000.00
23
Subsistence(50.00)(70.00)(60.00)(44.00)(63.00)(35.00)(93.00)(63.00)(62.00)(84.00)280.00(52.00)
24
Events(300.00)0.00(500.00)0.000.00(750.00)0.00(400.00)0.00(234.00)0.00(99.00)
25
Marketing freelancer(1,500.00)(1,200.00)(500.00)0.00(1,500.00)0.00(500.00)0.00(2,000.00)0.00(500.00)0.00
26
Sales freelancer0.000.000.000.000.00(500.00)(750.00)(1,000.00)(1,000.00)(1,300.00)(1,200.00)0.00
27
MVP user testing(1,200.00)0.000.00(1,000.00)(1,200.00)0.000.00(1,200.00)(1,200.00)0.000.000.00
28
Miscellaneous(50.00)(30.00)(24.00)(12.00)(54.00)(65.00)(10.00)0.00(12.00)(58.00)(40.00)0.00
29
0.000.000.000.000.000.000.000.000.000.000.000.00
30
Total Operating Costs(9,250.00)(6,700.00)(7,984.00)(5,506.00)(7,267.00)(6,750.00)(8,253.00)(7,113.00)(9,224.00)(5,676.00)(6,410.00)(5,551.00)
31
32
Operating Income0.00500.00650.00700.001,850.002,100.003,850.003,900.005,150.006,950.008,750.008,250.00
33
34
Recurring revenue0.00300.00450.00500.001,500.001,750.003,500.003,500.004,750.006,000.008,000.007,500.00
35
One-time revenue0.00200.00200.00200.00350.00350.00350.00400.00400.00950.00750.00750.00
Loading...