Business Plan DEMO
Business Plan DEMO
Business Plan DEMO
Complement 155
Email contato@luz.vc
EXECUTIVE
MARKETING FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
TEAM
Legal aspects
Details -
partner 1
Formation Administration
Responsibility CEO
Email daniel@luz.vc
Notes: Experience 10+ years of consulting for micro and small businesses with
clients such as COPPE UFRJ, Rio creative, Youth Initiative, among others.
partner 3
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
Comments:
partner 5
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
partner 7
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
partner 9
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
EXECUTIVE
MARKETING FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
TEAM
yy this
this Spreadsheet
Spreadsheet
partner 2
Formation economy
Email filippo@luz.vc
partner 4
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
Comments:
partner 6
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
partner 8
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
partner 10
Name
Date of birth
Formation
Responsibility
telephone
ownership percentage
Comments:
UCTIONS
GENERAL INFO MODELING STRATEGY MARKETING
Commercial
Financial
Production
Marketing
Technology
EXECUTIVE
ARKETING FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
TEAM
is Spreadsheet
his Spreadsheet
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
Employee Registration
TEAM
readsheet
preadsheet
R$48,000.00
2018
2019
2020
2021
2022
Concatenate Month Start
1 Dec2021 48 R$48,000.00
JAN FEB MAR APR MAY
No adjustm 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 32 33
34 35 36 37 38 39 40
41 42 43 44 45 46 47
48 49 50 51 52 53 54
55 56 57 58 59 60
- - - - -
- - - - -
Attendance
Simplicity
Efficiency
Content
Quality
LIGHT OF IDEAS LAB 5 4 4 5 4
competitor 3
competitor 4
competitor 5
Strategy Canvas
5 5 5
4 4 4 4
3 3 3 3
2 2
1 1 1 1
0 0
Quality Efficiency Simplicity Content Attendance
! Of the 15 possible attributes, you only used 5. Make an analysis and try
X Your biggest weakness is Efficiency. Perhaps this may be the first point o
:) Your biggest strenght is Content. This may be your main selling point and
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
eadsheet
eadsheet
d 5. Make an analysis and try to identify if the attributes used are sufficient for the analysis.
be your main selling point and there should be an effort to take advantage of this strength.
average Total
Strategy Canvas
Conccorentes Its main attribute tiebreaker sum
competitor 3 0 6E-05
0 7E-05
0 8E-05
0 9E-05
0 0.0001
0 0.00011
0 0.00012
0 0.00013
0 0.00014
0 0.00015
repet Pos Rank Your worst attribute Rank
Efficiency
Simplicity
Content
Attendance
GENERAL INFO MODELING
STATEMENTS PORTER
Company Info
Name
Mission
View
agile
Quality of spreadsheets
educational courses
MODELING STRATEGY MARKETING FINANCES REPORTS DASHBOARDS
2018
of your business
3
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
In the industry you want to enter / acts are already established competitors?
The (s) competitor (s) present can already meet the entire market?
The price of the supplies needed for your business varies greatly?
The quality of substitute products is higher than the quality of your product or service?
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
STRATEGY
Spreadsheet
Spreadsheet
Somewhat disagree 2
Strongly disagree 0
Threat of substitutes 27
Factor Points
5 2
4 1.5
3 2
4 1
0 1.5
2 2
3 1.5
2 1.5
4 1.5
5 1.5
5 1.5
2 1.5
0 1
0 1.5
3 1
2 2
0 1
2 1
5 1.5
4 2
5 2
4 1
2 1.5
5 2
4 1
3 1.5
3 1.5
2 2
4 1.5
2 2
GENERAL INFO MODELING STRATEGY MARKETING
STRATEGY
is Spreadsheet
his Spreadsheet
Weakness Important 5
Threat Important 5
Opportunity Little important 2.5
Description 0
Possibility o Threat
Interests fo Opportunity
Launches ne Opportunity
Opportunit Threat tiebreaker repeats ranking Force
1E-06 The company has innovative 1 The cost is low and it help
The cost is low and it help 1 The infrastructure is sui 1 There are untapped mark
The product is quality 2 There are funds availabl 2 Interests for environment
The company has innovativ 3 The means to make sales 3 The company carries out
ranking Threat
Action plans
STRATEGY
dsheet
dsheet
10 10 10 11 10 10
Foreseen Accomplished
10 11
$ 300,000 $ 300,000
4.00%
Not Started
In Progress
Completed on Time
Overdue
GENERAL INFO MODELING
PRODUCT PRICE
See what has been defined by you about the product or service.
You have opted for a business model in which the best attribute is Content.
Quality
Creating spreadsheets much better and more practical compared to what is available today
ODELING STRATEGY MARKETING FINANCES
oduct / service?
to day business
estions
MARKET
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
The client values the quality of the product over the price
Premium Strategy - For high-quality products. In this case, you can practice a high price, in order to reach the high
High Value Strategy - For high-quality products. is practiced an average price trying to get a quick market penetrati
Supreme Value Strategy - High Quality at low price. Recommended to get a quick introduction to the market.
High price strategy - Product of medium and high price quality. It is a strategy that values the product through the
Average Price strategy - price commensurate with the quality of the product, aiming at an acceptable market share
Medium Value Strategy - Product of average quality at low price. Recommended to get a quick introduction to the
Discount strategy - High price low quality. It has an initial edge and there is a rapid withdrawal from the market.
False Economy Strategy - price for a low quality product. You can with this strategy seek to take advantage of the b
Economy Strategy - Low quality and low prices. It wanted to sell this lot strategy.
EXECUTIVE
FINANCES REPORTS DASHBOARDS
SUMMARY
PROMOTION MARKET
preadsheet
preadsheet
Average price
rice, in order to reach the high end of the market with a prestigious image in the market.
Partially agree
Partially agree
Partially agree
Somewhat disagree
Totally agree
Low price
Economy Strategy
Premium strategy Premium Strategy - For high-quality products. In this case, you can practice a high pric
High Value strategy High Value Strategy - For high-quality products. is practiced an average price trying to
Supreme Value Strategy Supreme Value Strategy - High Quality at low price. Recommended to get a quick intro
High price strategy High price strategy - Product of medium and high price quality. It is a strategy that val
Average Price Strategy Average Price strategy - price commensurate with the quality of the product, aiming a
Medium Value Strategy Medium Value Strategy - Product of average quality at low price. Recommended to ge
Discount Strategy Discount strategy - High price low quality. It has an initial edge and there is a rapid wit
False Economy Strategy False Economy Strategy - price for a low quality product. You can with this strategy se
Economy Strategy Economy Strategy - Low quality and low prices. It wanted to sell this lot strategy.
Price strategies
alto médio baixo Premium strategy
High price strategy
alto 0 0 1
Discount Strategy
médio 0 0 0
High Value strategy
baixo 0 0 0
Average Price Strategy
ou can practice a high price, in order to reach the high end of the market with a prestigious image in the market.
u can with this strategy seek to take advantage of the brand or a false image created.
n the market.
GENERAL INFO MODELING
PRODUCT PRICE
site - - - -
In what locations (or types of media) the customer is looking for your product?
partnering
site
working, etc.)
oogle search"
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
MARKET
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
On the Internet (Google, site, social networking, etc.) - partnering - site - In some other sites and spread "in the Go
Investment value at
Media description Investment Year 1
launch
Investment value at
Media description Investment Year 1
launch
MOTION MARKET
sheet
dsheet
$30,000.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total investment
$ 113,000.00
$ 12,000.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
GENERAL INFO MODELING STRATEGY MARKETING
On customers
Who and how much suffers from this problem or would benefit from the
solution
On new entrants
What are the resources needed for business? (Check as available resources you already have)
Resources
PROMOTION MARKET
Buy
Buy this
this Spreadsheet
Spreadsheet
1,000,000
20%
200,000
Availability
Available
Available
Missing
Available
GENERAL INFO MODELING STRATEGY MARKETING
pricing
Cost of Raw
description Labor Cost Packing Cost
Materials
y this
uy this Spreadsheet
Spreadsheet
$22.22 $100.00
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
PRICING PROJECTION
S INITIAL INVESTMENTS OTHERS
Analysis of revenue projections (filling made according to pricing and projection values of 1-5 years)
Revenue Projection 1
description Sale price direct cost
year
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
sheet
sheet
Year 4 Year 5
$2,106,666.67
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
Insert the quantity of sales for each product or service in the months below
s Spreadsheet
Spreadsheet
year 4 year 5
Insert the quantity of sales for each product or service in the months below
s Spreadsheet
is Spreadsheet
year 4 year 5
Insert the quantity of sales for each product or service in the months below
is Spreadsheet
his Spreadsheet
year 4 year 5
Insert the quantity of sales for each product or service in the months below
s Spreadsheet
is Spreadsheet
year 4 year 5
Insert the quantity of sales for each product or service in the months below
Spreadsheet
Spreadsheet
year 4 year 5
Initial investment
Item Value
Ex .: Land $ 50,000.00
Buy
Buy this
this Spreadsheet
Spreadsheet
1.50%
$ 70,000.00
10.00%
EXECUTIVE
INSTRUCTIONS
SUMMARY
Depreciation
R$7,000.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
R$0.00
GENERAL INFO MODELING STRATEGY MARKETING
other investments
computers 10.00%
description $0.00
EXECUTIVE
MARKETING FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
his
his Spreadsheet
Spreadsheet
$20,000.00
$20,000.00 $0.00 $0.00 $0.00
TRUCTIONS
Total investment
Depreciation
$50,000.00
year 1 year 2 year 3
$20,000.00
R$0.00 R$2,000.00 R$2,000.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$0.00
R$0.00 R$0.00 R$0.00
$20,000.00
year 4 year 5 January February March
R$2,000.00 R$2,000.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
R$0.00 R$0.00
April May June July August September October
November December January February March April May
June July August September October November December
January February March April May June July
August September October November December January February
March April May June July August September
October November December January February March April
May June July August September October November
December
GENERAL INFO MODELING STRATEGY MARKETING
overhead costs
y this
uy this Spreadsheet
Spreadsheet
Total
$ 48,000.00 0
Cost of Final
Year
Start Year Column beginning Corresp final column Corresp
2019
2018 1 24
2019
2020
2021
2022
2018 2018 2018 2018 2018
No adjustment 1 2 3 4 5
Monthly 1 2 3 4 5
Quarterly 1 2 3 4 5
1 NÃO NÃO NÃO NÃO NÃO
semiannual 1 2 3 4 5
Yearly 1 2 3 4 5
6 7 8 9 10 11 12
6 7 8 9 10 11 12
6 7 8 9 10 11 12
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
6 7 8 9 10 11 12
6 7 8 9 10 11 12
13 14 15 16 17 18 19
13 14 15 16 17 18 19
13 14 15 16 17 18 19
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
13 14 15 16 17 18 19
13 14 15 16 17 18 19
20 21 22 23 24 25 26
20 21 22 23 24 25 26
20 21 22 23 24 25 26
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
20 21 22 23 24 25 26
20 21 22 23 24 25 26
27 28 29 30 31 32 33
27 28 29 30 31 32 33
27 28 29 30 31 32 33
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
27 28 29 30 31 32 33
27 28 29 30 31 32 33
0 0 0 0 0 0 0
2020 2020 2020 2021 2021 2021 2021
34 35 36 37 38 39 40
34 35 36 37 38 39 40
34 35 36 37 38 39 40
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
34 35 36 37 38 39 40
34 35 36 37 38 39 40
0 0 0 0 0 0 0
2021 2021 2021 2021 2021 2021 2021
41 42 43 44 45 46 47
41 42 43 44 45 46 47
41 42 43 44 45 46 47
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
41 42 43 44 45 46 47
41 42 43 44 45 46 47
0 0 0 0 0 0 0
2021 2022 2022 2022 2022 2022 2022
48 49 50 51 52 53 54
48 49 50 51 52 53 54
48 49 50 51 52 53 54
NÃO NÃO NÃO NÃO NÃO NÃO NÃO
48 49 50 51 52 53 54
48 49 50 51 52 53 54
0 0 0 0 0 0 0
2022 2022 2022 2022 2022 2022
55 56 57 58 59 60
55 56 57 58 59 60
55 56 57 58 59 60
NÃO NÃO NÃO NÃO NÃO NÃO
55 56 57 58 59 60
55 56 57 58 59 60
0 0 0 0 0 0
JAN2017 FEV2017 MAR2017 ABR2017 MAI2017
readjustment Monthly 1 2 3 4 5
readjustment Quarterly 1 2 3 4 5
1
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
JUN2017 JUL2017 AGO2017 SET2017 OUT2017 NOV2017 DEZ2017
6 7 8 9 10 11 12
6 7 8 9 10 11 12
JAN2018 FEV2018 MAR2018 ABR2018 MAI2018 JUN2018 JUL2018
13 14 15 16 17 18 19
13 14 15 16 17 18 19
AGO2018 SET2018 OUT2018 NOV2018 DEZ2018 JAN2019 FEV2019
20 21 22 23 24 25 26
20 21 22 23 24 25 26
MAR2019 ABR2019 MAI2019 JUN2019 JUL2019 AGO2019 SET2019
27 28 29 30 31 32 33
27 28 29 30 31 32 33
OUT2019 NOV2019 DEZ2019 JAN2020 FEV2020 MAR2020 ABR2020
34 35 36 37 38 39 40
34 35 36 37 38 39 40
MAI2020 JUN2020 JUL2020 AGO2020 SET2020 OUT2020 NOV2020
41 42 43 44 45 46 47
41 42 43 44 45 46 47
DEZ2020 JAN2021 FEV2021 MAR2021 ABR2021 MAI2021 JUN2021
48 49 50 51 52 53 54
48 49 50 51 52 53 54
JUL2021 AGO2021 SET2021 OUT2021 NOV2021 DEZ2021
55 56 57 58 59 60
55 56 57 58 59 60
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
Be aware, because the competitive force that least influences your business is
:) Bargaining Power of Suppliers. It is important to know how to potentiate it..
You need to watch out for of New Entrants risk, because this is the force that can most
:( influence your business, according to the Porter methodology.
Tx improve conversion 0% 0%
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
preadsheet
preadsheet
SWOT Summary
The cost is low and it helps to get higher profit The infrastructure is suited to the n
The company has innovative differential The means to make sales are divers
0% 0% 0% Completed on Time
Overdue
Total
Sum of Porter's 5 Forces
weaknesses
Rivalry am 30
nfrastructure is suited to the needs
Bargaining 31.5
e are funds available
Bargaining 9
means to make sales are diversified
of New Entr 42.5
hreats
Substitutes 27
advantage of technological advancement
ogress 1
pleted on Time 1
due 0
3
year 1 year 2 year 3 year 4 year 5
On customers
Who and how much suffers from this problem or would benefit from the solution
investments
offline marketing investments
Price Strategy
Buy
Buy this
this Spreadsheet
Spreadsheet
1,000,000
20.0%
200,000
Analysis of Resources
available 3
missing 1
Total 4
$0.00 $30,000.00
$33,500.00 $125,000.00
Low price
Economy Strategy
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
Fixed expenses
Payback In 3 years
Marketing expenses
Depreciation
breakeven In 3 years
Net Income / Loss
Gross investment
Free income
EBITDA
Percentage of Profitability
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
adsheet
adsheet
$0 $ 20,000 $0 $0
$0 $ 270,323
Analysis of payback
$ 33,500 $ 125,000
$ 9,000 $ 43,000
$ 257,500 $ 509,678
$0 $ 20,000
$ 266,500 $ 532,678
IRR calculation
$ 333,167 $ 743,344
-R$100,000.00 -R$11,450.00
40.0% 25.3%
47%
year 2 year 3 year 4 year 5
Calculation of PAYBACK
0 0 1 1 1
0 0 1
1 1
In 4 years In 5 years
Net present value Economic Cash Flow Analysis
$266,500
$ 228,056 $140,500
$161,000
Gross revenue
year 3
In 3 years
$166,177.50
Breakeven $5,177.50
- -
year 0
$100,000.00 year 1 - year 2 year 3 year 4 year 5
$111,450.00 $135,322.50
In 3 years
Payback
Gross revenue Total expenses Free income profitability
$266,500.00 $300,000.00
$161,000.00 $192,000.00
$140,500.00 $168,000.00
$18,127.50
-$11,450.00 -$450.00
-$23,872.50
year 1 year 2 year 3 year 4 year 5 year 1 year 2 year 3 year 4 year 5
Gross revenue Expenses Free income Contribution Margin overhead costs Result
Gross revenue Total expenses Free income profitability
$15,217
$266,500
10%
$161,000
$140,500
overhead costs
47% Variable costs
Taxes
43%
-$11,450 -$11,450
year 1 year 2
-$23,873 year 3 year 4 year 5
Analysis of Return
$960,142
$546,942
$282,142
$49,742
-$29,160
year 0 year 1 year 2 year 3 year 4 year 5
-$100,000 -$94,787
-$193,740 -$214,587
-$320,387 -$271,787
Optimistic scenario Pessimistic scenario
SWOT graphic Radar Chart Radar Porter 5 Forces Completion Strategies average effectiveness of the strategy
70% 70%
67%
40
Rivalry among competitors
30
60%
Opportunity
0 0
not started In progress Completed on Time Completed out of Time Overdue
Total spent on Online Marketing Spending on Marketing Division Spending
$125,000 $31,000.00
$33,500.00
$30,000.00 offline
19%
$27,500.00
Total spending on Offline Marketing
$22,000.00
$30,000
$11,000.00
$155,000 $0.00
year 0
$0.00
year 1
$0.00
year 2
$0.00
year 3
$0.00
year 4
$0.00
year 5
offline online
EXECUTIVE SUMMARY
available 3
missing 1
Total 4
On customers
As they explore this opportunity? With sites - weakness is often the quality of the product offered
And what are your weaknesses?
On new entrants
Who and how to exploit this People who work with Excel
opportunity today?
What are the Gaps of these Service and product quality
solutions?
2. Modeling
- Website Maintenance Excel online courses teaching Chat Online Managers and entrepreneurs
Key features
- Who you are and what you - Distribution Channels -
have As you give and receive
- - - - -
- - - - -
5 5 5
4 4 4 4
3 3 3 3
2 2
1 1 1 1
0 0
Quality Efficiency Simplicity Content Attendance
LIGHT OF IDEAS LAB Other spreadsheets sites free spreadsheets "Google" competitor 3 competitor 4 competitor 5
3. Strategy
Summary of five competitive forces of Porter SWOT Summary
23% Bargaining Power of Customers The cost is low and it helps to get The infrastructure is suited to the
higher profit needs
6% Bargaining Power of Suppliers The product is quality There are funds available
Strenght
40
Rivalry among competitors
30
17.5
42.5
threat of entry of new competitors Bargaining power of suppliers
Opportunity
See the results of the goals and action plans
Tx improve conversion 0% 0% 0% 0% 0%
Mission Help managers to develop their business View Be the largest site to support entrepreneurs and managers in Brazil
not started 1
In progress 1
Completed within 1
Done late 0
not completed 0
Total 3
4. Marketing
Product
Quality
Creating spreadsheets much better and more practical compared to what is available today
Price
A estratégia de preço utilizada foi a: Supreme Value Strategy - High Quality at low price. Recommended to get a quick introduction to the market.
Square
In what locations (or types of media) the customer is looking for your product?
partnering
site
Investment value at launch Investment Year 1 Investment Year 2 Investment Year 3 Investment Year 4 5 year investment
Investment value at launch Investment Year 1 Investment Year 2 Investment Year 3 Investment Year 4 5 year investment
Spending on Marketing
$33,500.00
$30,000.00 $31,000.00 offline
$27,500.00 19%
$22,000.00
$11,000.00
offline online
$22,000.00
$11,000.00
offline online
5. Finance
NPV (Net Present Value) TIR Payback Initial investment breakeven
Return indicators
$228,056.36 46.56% In 3 years $100,000.00 In 3 years
$266,500.00
$161,000.00
$140,500.00
-$11,450.00
-$23,872.50
$300,000.00
$192,000.00
$168,000.00
$18,127.50
-$450.00
Step 1 GENERAL INFORMATION Part of General Assumptions is where you will set t
Step 2 MODELING The model aims to explain in a clear and visual way
Step 3 STRATEGY In this tab, you make some external and internal en
Step 5 FINANCES In this part of the spreadsheet you will make invest
Step 6 REPORTS Here you can see the results of all that has been fill
ABOUT
eadsheet
eadsheet
PLAN 4.0
e method, filling and analysis of each tab!
ptions is where you will set the basic information of your company and responsible to start your business plan.
plain in a clear and visual way the main aspects of business / project, it is divided into Business Model Canvas and Curve value.
ome external and internal environment analysis of the company and define aspects such as mission, vision, values, goals and macroaç
g is where you will define the 4 P's of your company (Marketing Mix). Product, Price, Place and Promotion. This technique known
explain all aspects of your marketing strategy
adsheet you will make investments projections, costs and revenue projections.
adsheet results are organized in a more visual and precise way with their results.
adsheet will be answered some basic questions about the business, taking into account all that has been answered and planned. This p
plan from the start!
your business plan.
Go on the top tab REVIEW and, within the group of amendments choose option UNPROTECT
SPREADSHEET.Spreadsheets do not have passwords, erve lock only to improve its use. See more here -
ajuda.luz.vc/article/100-como-desproteger-uma-planilha-da-luz
With the unlocked tab, the tab check INSERT and, within the group ILLUSTRATIONS choose option
IMAGES.Just select the file with your logo, position and resize as you want. See more on this link -
ajuda.luz.vc/article/91-como-retirar-ou-mudar-a-logo-de-sua-planilha
We recommend that you just use the CURRENT STRUCTURESince various formulas are linked to
criadosmos longer intervals. If you need to make changes, I recommend that details see this link -
http://ajuda.luz.vc/article/101-como-adicionar-mais-linhas-nos-lancamentos-da-planilha-de-fluxo-de-
caixa
REPORTS
ABOUT
EXECUTIVE INSTRUCTION
REPORTS DASHBOARDS
SUMMARY S
BOUT
With the unlocked spreadsheet (see question 1), click on the line number with the diretiro button and
choose the row height option in the case of lines or the column letter with the right button and choose
the column width option in case columns.
To use any list in a combo box (box for selecting the months or chart of accounts) in Excel for Mac, just
click and press in the box, select the desired item and release the button. If you try to give just one
click, the list will not work.
Select the fields you want to change the currency. Click the right button and choose the
optionFORMAT CELLS. Change the symbol for the desired format tabNUMBER. See more on this link -
http://blog.luz.vc/excel/como-transformar-valores-excel-de-real-para-dolar-euro-ou-kwanza/
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
3 SWOT worksheet
ONS ABOUT
Spreadsheet
Spreadsheet
see more
PACOTE DE
PLANILHAS LUZ
see more
Veja mais detalhes
see more
CURSOS ONLINE DE
see more DE EXCEL DA LUZ
Veja mais detalhes
see more
S LUZ
NE DE
DA LUZSHEETS LIGHT
GENERAL INFO MODELING STRATEGY MARKETING FINANCES
LIGHT is a company specializing in the development of digital products for business. Since 2005 we help business o
Learn a little more of the Light and discover how we can help!
luz.vc cursos.luz.vc
Planilhas Empresariais Cursos de Excel Online
EXECUTIVE
FINANCES REPORTS DASHBOARDS INSTRUCTIONS
SUMMARY
ABOUT
Spreadsheet
Spreadsheet
s. Since 2005 we help business owners and managers to overcome their challenges in their respective areas of work.
c slidesprontos.com.br blog.luz.vc
Online Apresentações em PPT Conteúdo de Excel e Gestão