smart watch

profileMoh-993
FinancialModelv011.xlsx
Home>Business & Finance homework help>Accounting homework help>smart watch

12 months

REVENUES
January February March April May June July August September October November December TOTAL
Number of items 1 10 10 10 10 10 10 10 10 10 10 10 10 120
Price of item 1 10 10 10 10 10 10 10 10 10 10 10 10
COGS of item 1 9 9 9 9 9 9 9 9 9 9 9 9
Number of items 2 1 1 1 1 1 1 1 1 1 1 1 1 12
Price per item 2 5 5 5 5 5 5 5 5 5 5 5 5
COGS of item 2 4 4 4 4 4 4 4 4 4 4 4 4
Revenues Item 1 100 100 100 100 100 100 100 100 100 100 100 100 1200
COGS Item 1 90 90 90 90 90 90 90 90 90 90 90 90 1080
Revenues Item 2 5 5 5 5 5 5 5 5 5 5 5 5 60
COGS Item 2 4 4 4 4 4 4 4 4 4 4 4 4 48
Total Revenues 105 105 105 105 105 105 105 105 105 105 105 105 1260
Total COGS 94 94 94 94 94 94 94 94 94 94 94 94 1128
Gross Profit 11 11 11 11 11 11 11 11 11 11 11 11 132
COSTS
Rent 1 1 1 1 1 1 1 1 1 1 1 1 12
Salaries 1 1 1 1 1 1 1 1 1 1 1 1 12
Electricity 1 1 1 1 1 1 1 1 1 1 1 1 12
Water 1 1 1 1 1 1 1 1 1 1 1 1 12
Internet 1 1 1 1 1 1 1 1 1 1 1 1 12
Marketing 1 1 1 1 1 1 1 1 1 1 1 1 12
Insurance 1 1 1 1 1 1 1 1 1 1 1 1 12
Fuel 1 1 1 1 1 1 1 1 1 1 1 1 12
App maintenance 1 1 1 1 1 1 1 1 1 1 1 1 12
Lawyer fees 1 1 1 1 1 1 1 1 1 1 1 1 12
Total Costs 10 10 10 10 10 10 10 10 10 10 10 10 120
PROFIT 1 1 1 1 1 1 1 1 1 1 1 1 12

3 years

REVENUES
% Year 1 % Year 2 % Year 3
Number of items 1 120 150 170
Price per item 1 10 10 10
COGS of item 1 9 9 9
Number of items 2 12 20 30
Price per item 2 5 5 5
COGS of item 2 4 4 4
Revenues Item 1 1200 1500 1700
COGS Item 1 1080 1350 1530
Revenues Item 2 60 100 150
COGS Item 2 48 80 120
Total Revenues 100 1260 100 1600 100 1850
Total COGS 89.52% 1128 89.38% 1430 89.19% 1650
Gross Profit 10.48% 132 10.63% 170 10.81% 200
COSTS
Rent 0.95% 12 0.94% 15 1.35% 25
Salaries 0.95% 12 0.94% 15 1.35% 25
Electricity 0.95% 12 0.94% 15 1.35% 25
Water 0.95% 12 0.94% 15 1.35% 25
Internet 0.95% 12 0.94% 15 1.35% 25
Marketing 0.95% 12 0.94% 15 1.35% 25
Insurance 0.95% 12 0.94% 15 1.35% 25
Fuel 0.95% 12 0.94% 15 1.35% 25
App maintenance 0.95% 12 0.94% 15 1.35% 25
Lawyer fees 0.95% 12 0.94% 15 1.35% 25
Total Costs 9.52% 120 9.38% 150 13.51% 250
PROFIT 0.95% 12 1.25% 20 -2.70% -50