0% found this document useful (0 votes)

21 views67 pages

Contrôle de Gestion Finance

Uploaded by

Sandra Mokaba

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

21 views67 pages

Contrôle de Gestion Finance

Uploaded by

Sandra Mokaba

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

You are on page 1/ 67

by Said EL-Mzabi

Business Controller Partner -MH

Étape 1 - Entrez les informations sur votre entreprise dans les cases de couleur
jaune ci-dessous / Enter info about your company in yellow shaded boxes below.

Starting
Preparer Name Company Name Month Starting Year
Myjobs.ma 12 2023

Step 2 - Read the following instructions

Adaptez ce modèle Excel à votre langue et à votre devise. Ne modifiez aucune des fonctions, car les feuilles de
calcul ne pourront peut-être pas effectuer les calculs.

Adapt this Excel template to your language and currency. Do not modify any function, since it is possible that
spreadsheets can not perform calculations.
1

January February March April May June July

Option 1
Septembe
August October November December
r
Sales Forecst Year 1

Sales Forecast Year 1

Prepared By: Company Name:

Owner Myjobs.ma

Complete This Chart First:

COGS Per
Product Lines Units
Sales Price Unit
Per Unit Margin Per Unit
L'eau 4 $ 1.00 $ 0.80 $ 0.20
Maison 14 $ 10,000.00 $ 70,000.00 $ (60,000.00)
Vetements 9 $ 100.00 $ 850.00 $ (750.00)
Voiture 21 $ 5,000.00 $ 3,000.00 $ 2,000.00
$ -
$ -

=Directions! +Directions +Direction +Direction

Product Lines +Directions!B34 B35 !B36 +Directions!B37 s!B38 s!B39
L'eau
4 Sold
Total Sales - - - - - -
Total COGS - - - - - -
Total Margin - - - - - -

Maison
14 Sold
Total Sales - - - - - -
Total COGS - - - - - -
Margin - - - - - -

Vetements

819093860.xlsx Sales Forecast 11/24/2024 11:08:30

Sales Forecst Year 1

9 Sold
Total Sales - - - - - -
Total COGS - - - - - -
Margin - - - - - -

Voiture
21 Sold
Total Sales - - - - - -
Total COGS - - - - - -
Margin - - - - - -

Product 5
Units Sold
Total Sales - - - - - -
Total COGS - - - - - -
Margin - - - - - -

Product 6
Units Sold
Total Sales - - - - - -
Total COGS - - - - - -
Margin - - - - - -
Total Units Sold 0 0 0 0 0 0
Total Sales $ - $ - $ - $ - $ - $ -
Total Cost of Goods Sold $ - $ - $ - $ - $ - $ -
Total Margin $ - $ - $ - $ - $ - $ -

819093860.xlsx Sales Forecast 11/24/2024 11:08:30

Sales Forecst Year 1

+Direction +Direction +Directions! +Direction +Direction +Direction Category Category /

s!B40 s!B41 B42 s!B43 s!B44 s!B45 Annual Totals Breakdown Total

0 0.0%
- - - - - - $ - 0.0% 0.0%
- - - - - - $ - 0.0% 0.0%
- - - - - - $ - 0.0% 0.0%

819093860.xlsx Sales Forecast 11/24/2024 11:08:30

Sales Forecst Year 1

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%
- - - - - - $ - 0.0% 0.0%
0 0 0 0 0 0 0
$ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ -

819093860.xlsx Sales Forecast 11/24/2024 11:08:30

Sales Forecast Years 1-3

Sales Forecast Year 1-3

This sheet will populate based on information in the year
1 Sales Forecast.

Prepared By: Company Name: The included growth rate is just a starting point, if you
can provide a more accurate prediction for each month,
Myjobs.ma unlock the sheet (see Directions) and change the value
Owner
for that month. Please note that you will no longer have
a formula in that cell once you change the value, so you
may want to save a copy of this spreadsheet under a
Growth Rate Year 1 to Year 2: 10.00% different name before doing so.
Growth Rate Year 2 to Year 3: 10.00%

Product Lines Year 1 Totals #REF! #REF! #REF! #REF! #REF! #REF! #REF!
L'eau
4 Sold 0 0 0 0 0 0 0 0
Total Sales $ - - - - - - - -
Total COGS $ - - - - - - - -
Total Margin $ - - - - - - - -

Maison
14 Sold 0 0 0 0 0 0 0 0
Total Sales $ - - - - - - - -
Total COGS $ - - - - - - - -
Margin $ - - - - - - - -

Vetements
9 Sold 0 0 0 0 0 0 0 0
Total Sales $ - - - - - - - -
Total COGS $ - - - - - - - -
Margin $ - - - - - - - -

Voiture

819093860.xlsx Sales Forecast 2 11/24/2024 11:08:30

Sales Forecast Years 1-3

21 Sold 0 0 0 0 0 0 0 0
Total Sales $ - - - - - - - -
Total COGS $ - - - - - - - -
Margin $ - - - - - - - -

Product 5
Sold 0 0 0 0 0 0 0 0
Total Sales $ - - - - - - - -
Total COGS $ - - - - - - - -
Margin $ - - - - - - - -

Product 6
Sold 0 0 0 0 0 0 0 0
Total Sales $ - - - - - - - -
Total COGS $ - - - - - - - -
Margin $ - - - - - - - -
Total Units Sold 0 0 0 0 0 0 0 0
Total Sales $ - $ - $ - $ - $ - $ - $ - $ -
Total Cost of Goods Sold $ - $ - $ - $ - $ - $ - $ - $ -
Total Margin $ - $ - $ - $ - $ - $ - $ - $ -

819093860.xlsx Sales Forecast 2 11/24/2024 11:08:30

Sales Forecast Years 1-3

on in the year

oint, if you
each month,
ge the value
longer have
value, so you
et under a

Category Category /
#REF! #REF! #REF! #REF! #REF! Year 2 Totals Breakdown Total #REF! #REF! #REF!

0 0 0 0 0 0 0.0% 0 0 0
- - - - - $ - 0.0% 0.0% - - -
- - - - - $ - 0.0% 0.0% - - -
- - - - - $ - 0.0% 0.0% - - -

819093860.xlsx Sales Forecast 2 11/24/2024 11:08:30

Sales Forecast Years 1-3

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 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 0 0 0
$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ - $ - $ -

819093860.xlsx Sales Forecast 2 11/24/2024 11:08:30

Sales Forecast Years 1-3

Year 3 Category Category /

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Totals Breakdown Total

0 0 0 0 0 0 0 0 0 0 0.0%
- - - - - - - - - $ - 0.0% 0.0%
- - - - - - - - - $ - 0.0% 0.0%
- - - - - - - - - $ - 0.0% 0.0%

819093860.xlsx Sales Forecast 2 11/24/2024 11:08:30

Sales Forecast Years 1-3

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 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 0 0 0 0 0 0
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

819093860.xlsx Sales Forecast 2 11/24/2024 11:08:30

Additional Inputs

Prepared By: Company Name:

Owner Myjobs.ma

Accounts Receivable (A/R) Days Sales Outstanding

Percent of Collections Year 1 Year 2 Year 3
Paid within 30 days 30% 30% 30%
Paid between 30 and 60 days 30% 30% 30%
Paid in more than 60 days 40% 40% 40%
Allowance for bad debt 0% 0% 0%
This should equal 100% ----> 100% 100% 100%

Accounts Payable (A/P)

Percent of Disbursements Year 1 Year 2 Year 3
Paid within 30 days 0% 0% 0%
Paid between 30 and 60 days 100% 100% 100%
Paid in more than 60 days 0% 0% 0%
This should equal 100% ----> 100% 100% 100%

Line of Credit Assumptions

Desired Minimum Cash Balance 0
Line of Credit Interest Rate 8.00%

Additional Fixed Assets Purchases

Fixed Assets Depreciation (years) #REF! #REF! #REF! #REF! #REF! #REF!

Real Estate 20 #REF!

Leasehold Improvements 7 #REF!

819093860.xlsx 4-AdditionalInputs 11/24/2024 11:08:30

Additional Inputs

Equipment 7 #REF!
Furniture and Fixtures 5 #REF!
Vehicles 5 #REF!
Other Fixed Assets 5 #REF!
Total Additional Fixed Assets #REF! $ - $ - $ - $ - $ -

Income Tax Assumptions

Effective Income Tax Rate - Year 1 20.0%
Effective Income Tax Rate - Year 2 20.0%
Effective Income Tax Rate - Year 3 20.0%

Amortization of Start-Up Costs

Amortization Period in Years 3

819093860.xlsx 4-AdditionalInputs 11/24/2024 11:08:30

Additional Inputs

Year 2 Year 3
#REF! #REF! #REF! #REF! #REF! #REF! Year 1 Totals
Total Total

#REF!
#REF!

819093860.xlsx 4-AdditionalInputs 11/24/2024 11:08:30

Additional Inputs

#REF!
#REF!
#REF!
#REF! $ - $ -
$ - $ - $ - $ - $ - $ - #REF! $ - $ -

819093860.xlsx 4-AdditionalInputs 11/24/2024 11:08:30

Operating Expenses Years 1-3

Prepared By: Company Name:

Owner Myjobs.ma

Line Item 2023 Growth Rate 1 to 2 2024 Growth Rate 2 to 3

Expenses - 3.0% - 3.0%
Car and Truck Expenses - 3.0% - 3.0%
Commissions and Fees - 5.0% - 5.0%
Contract Labor (Not included in payroll) - 3.0% - 3.0%
Insurance (other than health) - 3.0% - 3.0%
Legal and Professional Services - 3.0% - 3.0%
Licenses - 5.0% - 5.0%
Office Expense - 3.0% - 3.0%
Rent or Lease -- Vehicles, Machinery, Equipment - 3.0% - 3.0%
Rent or Lease -- Other Business Property - 3.0% - 3.0%
Repairs and Maintenance - 5.0% - 5.0%
Supplies - 3.0% - 3.0%
Travel, Meals and Entertainment - 3.0% - 3.0%
Utilities - 3.0% - 3.0%
Miscellaneous - 3.0% - 3.0%
Total Expenses $ - $ -

Other Expenses
Depreciation #REF! #REF!
Interest
#REF! #REF! #REF!
#REF! #REF! #REF!
#REF! #REF! #REF!
#REF! #REF! #REF!

819093860.xlsx opex 11/24/2024 11:08:30

Operating Expenses Years 1-3

#REF! #REF! #REF!

Line of Credit #REF! #REF!
Bad Debt Expense -
Total Other Expenses #REF! #REF!
Total Operating Expenses #REF! #REF!

819093860.xlsx opex 11/24/2024 11:08:30

Operating Expenses Years 1-3

2025
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
$ -

#REF!

#REF!
#REF!
#REF!
#REF!

819093860.xlsx opex 11/24/2024 11:08:30

Operating Expenses Years 1-3

#REF!
#REF!

819093860.xlsx opex 11/24/2024 11:08:30

Operating Expenses Year 1

Prepared By: Company Name:

Owner Myjobs.ma

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

Expenses
Expenses
Car and Truck Expenses
Commissions and Fees
Contract Labor (Not included in payroll)
Insurance (other than health)
Legal and Professional Services
Licenses
Office Expense
Rent or Lease -- Vehicles, Machinery, Equipment
Rent or Lease -- Other Business Property
Repairs and Maintenance
Supplies
Travel, Meals and Entertainment
Utilities
Miscellaneous
Total Expenses $ - $ - $ - $ - $ - $ - $ -

Other Expenses
Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Interest
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx opex Y1 11/24/2024 11:08:30

Operating Expenses Year 1

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit - #REF! #REF! #REF! #REF! #REF! #REF!
Bad Debt Expense - - - - - - -
Total Other Expenses #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Total Fixed Operating Expenses #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx opex Y1 11/24/2024 11:08:30

Operating Expenses Year 1

#REF! #REF! #REF! #REF! #REF! Annual Totals

$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ - $ - $ - $ - $ - $ -

#REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx opex Y1 11/24/2024 11:08:30

Operating Expenses Year 1

#REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF!
- - - - - $ -
#REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx opex Y1 11/24/2024 11:08:30

Cash Flow Forecast Year 1

Prepared By: Company Name:

Owner Myjobs.ma

+Directio =Directio +Directio +Directio +Directio +Directio +Directio +Directio

ns!B34 ns!B35 ns!B36 ns!B37 ns!B38 ns!B39 ns!B40 ns!B41
Beginning Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Cash Inflows
Cash Sales - - - - - - - -
Accounts Receivable - - - - - - - -
Total Cash Inflows $ - $ - $ - $ - $ - $ - $ - $ -

Cash Outflows
Investing Activities
New Fixed Asset Purchases - - - - - - - -
Additional Inventory
Cost of Goods Sold - - - - - - - -
Operating Activities
Operating Expenses - - - - - - - -
Payroll #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Taxes - - #REF! - - #REF! - -
Financing Activities
Loan Payments #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Owners Distribution
Line of Credit Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit Repayments
Dividends Paid
Total Cash Outflows #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Net Cash Flows #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Operating Cash Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit Drawdown #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1 11/24/2024 11:08:30

Cash Flow Forecast Year 1

Ending Cash Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1 11/24/2024 11:08:30

Cash Flow Forecast Year 1

+Direction +Directio +Directio +Directio

s!B42 ns!B43 ns!B44 ns!B45 Totals
#REF! #REF! #REF! #REF!

- - - - $ -
- - - - $ -
$ - $ - $ - $ - $ -

- - - - $ -
$ -
- - - - $ -

- - - - $ -
#REF! #REF! #REF! #REF! #REF!
#REF! - - #REF! #REF!

#REF! #REF! #REF! #REF! #REF!

$ -
#REF! #REF! #REF! #REF! #REF!
$ -
$ -
#REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1 11/24/2024 11:08:30

Cash Flow Forecast Year 1

#REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1 11/24/2024 11:08:30

Cash Flow Forecast Years 1-3

NOTE: To only view the annual total side-by-side, highlight columns C through N
Prepared By: Company Name: and right-click. Then select "Hide". Use the same procedure to Hide columns P through AA
columns B, O and AB, right-click and select "Unhide".
Owner Myjobs.ma

+Directio =Directio +Directio +Directio +Directio +Directio +Directio +Directio

Year 1 Totals ns!B34 ns!B35 ns!B36 ns!B37 ns!B38 ns!B39 ns!B40 ns!B41
Beginning Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Cash Inflows
Cash Sales $ - - - - - - - - -
Accounts Receivable $ - - - - - - - - -
Total Cash Inflows $ - $ - $ - $ - $ - $ - $ - $ - $ -

Cash Outflows
Investing Activities
New Fixed Asset Purchases $ - - - - - - - - -
Additional Inventory $ -
Cost of Goods Sold $ - - - - - - - - -
Operating Activities
Operating Expenses $ - - - - - - - - -
Payroll #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Taxes #REF! - - #REF! - - #REF! - -
Financing Activities
Loan Payments #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Owners Distribution $ -
Line of Credit Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit Repayments $ -
Dividends Paid $ -
Total Cash Outflows #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Net Cash Flows #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Operating Cash Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit Drawdown #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1-Y3 11/24/2024 11:08:30

Cash Flow Forecast Years 1-3

Ending Cash Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1-Y3 11/24/2024 11:08:30

Cash Flow Forecast Years 1-3

mns C through N
o Hide columns P through AA. To show them again, highlight

+Direction +Directio +Directio +Directio +Directio =Directio +Directio +Directio +Directio +Directio +Directio
s!B42 ns!B43 ns!B44 ns!B45 Year 2 Totals ns!B34 ns!B35 ns!B36 ns!B37 ns!B38 ns!B39 ns!B40
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

- - - - $ - - - - - - - -
- - - - $ - - - - - - - -
$ - $ - $ - $ - $ - - - - - - - -

- - - - $ - - - - - - - -
$ -
- - - - $ - - - - - - - -

- - - - $ - - - - - - - -
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! - - #REF! - - #REF! - - #REF! -

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
$ -
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
$ -
$ -
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1-Y3 11/24/2024 11:08:30

Cash Flow Forecast Years 1-3

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1-Y3 11/24/2024 11:08:30

Cash Flow Forecast Years 1-3

+Directio +Directio +Directio +Directio +Directio

ns!B41 ns!B42 ns!B43 ns!B44 ns!B45 Year 3 Totals
#REF! #REF! #REF! #REF! #REF!

- - - - - $ -
- - - - - $ -
- - - - - $ -

- - - - - $ -
$ -
- - - - - $ -

- - - - - $ -
#REF! #REF! #REF! #REF! #REF! #REF!
- #REF! - - #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF!

$ -
#REF! #REF! #REF! #REF! #REF! #REF!
$ -
$ -
#REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1-Y3 11/24/2024 11:08:30

Cash Flow Forecast Years 1-3

#REF! #REF! #REF! #REF! #REF!

819093860.xlsx CASH FLOW Y1-Y3 11/24/2024 11:08:30

Income Statement Year 1

Prepared By: Company Name:

Owner Myjobs.ma

#REF! #REF! #REF! #REF! #REF! #REF!

Revenue
L'eau - - - - - -
Maison - - - - - -
Vetements - - - - - -
Voiture - - - - - -
Product 5 - - - - - -
Product 6 - - - - - -
Total Revenue $ - $ - $ - $ - $ - $ -
Cost of Goods Sold
L'eau - - - - - -
Maison - - - - - -
Vetements - - - - - -
Voiture - - - - - -
Product 5 - - - - - -
Product 6 - - - - - -
Total Cost of Goods Sold $ - $ - $ - $ - $ - $ -
Gross Margin $ - $ - $ - $ - $ - $ -
Payroll #REF! #REF! #REF! #REF! #REF! #REF!
Operating Expenses
Expenses - - - - - -
Car and Truck Expenses - - - - - -
Commissions and Fees - - - - - -
Contract Labor (Not included in payroll) - - - - - -
Insurance (other than health) - - - - - -
Legal and Professional Services - - - - - -

819093860.xlsx etats financiers 11/24/2024 11:08:30

Income Statement Year 1

Licenses - - - - - -
Office Expense - - - - - -
Rent or Lease -- Vehicles, Machinery, Equipment - - - - - -
Rent or Lease -- Other Business Property - - - - - -
Repairs and Maintenance - - - - - -
Supplies - - - - - -
Travel, Meals and Entertainment - - - - - -
Utilities - - - - - -
Miscellaneous - - - - - -
Other Expense 1
Other Expense 2
Total Operating Expenses $ - $ - $ - $ - $ - $ -
Income (Before Other Expenses) #REF! #REF! #REF! #REF! #REF! #REF!
Other Expenses
Amortized Start-up Expenses #REF! #REF! #REF! #REF! #REF! #REF!
Depreciation #REF! #REF! #REF! #REF! #REF! #REF!
Interest
Commercial Loan #REF! #REF! #REF! #REF! #REF! #REF!
Commercial Mortgage #REF! #REF! #REF! #REF! #REF! #REF!
Credit Card Debt #REF! #REF! #REF! #REF! #REF! #REF!
Vehicle Loans #REF! #REF! #REF! #REF! #REF! #REF!
Other Bank Debt #REF! #REF! #REF! #REF! #REF! #REF!
Line of Credit - #REF! #REF! #REF! #REF! #REF!
Bad Debt Expense - - - - - -
Total Other Expenses #REF! #REF! #REF! #REF! #REF! #REF!
Net Income Before Income Tax #REF! #REF! #REF! #REF! #REF! #REF!
Income Tax #REF! #REF! #REF! #REF! #REF! #REF!
Net Profit/Loss #REF! #REF! #REF! #REF! #REF! #REF!

Income Tax Calculations

Monthly Taxable Income #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx etats financiers 11/24/2024 11:08:30

Income Statement Year 1

Cumulative Taxable Income #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx etats financiers 11/24/2024 11:08:30

Income Statement Year 1

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
$ - $ - $ - $ - $ - $ - $ -

- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
$ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ - $ - $ -
#REF! #REF! #REF! #REF! #REF! #REF! #REF!

- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -

819093860.xlsx etats financiers 11/24/2024 11:08:30

Income Statement Year 1

- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -
- - - - - - $ -

$ - $ - $ - $ - $ - $ - $ -
#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
- - - - - - $ -
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx etats financiers 11/24/2024 11:08:30

Income Statement Year 1

#REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx etats financiers 11/24/2024 11:08:30

Income Statement Years 1-3

Prepared By: Company Name:

Owner Myjobs.ma

Revenue 2023 2024 2025

L'eau - - -
Maison - - -
Vetements - - -
Voiture - - -
Product 5 - - -
Product 6 - - -
Total Revenue $ - 100% $ - 100% $ - 100%
Cost of Goods Sold
L'eau - - -
Maison - - -
Vetements - - -
Voiture - - -
Product 5 - - -
Product 6 - - -
Total Cost of Goods Sold - 0% - 0% - 0%
Gross Margin - 0% - 0% - 0%
Payroll #REF! #REF! #REF!
Operating Expenses
Expenses - - -
Car and Truck Expenses - - -
Commissions and Fees - - -
Contract Labor (Not included in payroll) - - -
Insurance (other than health) - - -
Legal and Professional Services - - -

819093860.xlsx etats financiers Y1-Y3 11/24/2024 11:08:30

Income Statement Years 1-3

Licenses - - -
Office Expense - - -
Rent or Lease -- Vehicles, Machinery, Equipment - - -
Rent or Lease -- Other Business Property - - -
Repairs and Maintenance - - -
Supplies - - -
Travel, Meals and Entertainment - - -
Utilities - - -
Miscellaneous - - -
Other Expense 1
Other Expense 2
Total Operating Expenses $ - 0% $ - 0% $ - 0%
Income (Before Other Expenses) #REF! 0% #REF! 0% #REF! 0%
Other Expenses
Amortized Start-up Expenses #REF! #REF! #REF!
Depreciation #REF! #REF! #REF!
Interest
Commercial Loan #REF! #REF! #REF!
Commercial Mortgage #REF! #REF! #REF!
Credit Card Debt #REF! #REF! #REF!
Vehicle Loans #REF! #REF! #REF!
Other Bank Debt #REF! #REF! #REF!
Line of Credit #REF! #REF! #REF!
Bad Debt Expense - - -
Total Other Expenses #REF! 0% #REF! 0% #REF! 0%
Net Income Before Income Tax #REF! #REF! #REF!
Income Tax #REF! #REF! #REF!
Net Income/Loss #REF! 0% #REF! 0% #REF! 0%

819093860.xlsx etats financiers Y1-Y3 11/24/2024 11:08:30

Income Statement Years 1-3

Income Tax Calculations Month 1 Month 2 Month 3 Month 4 Month 5 Month 6

Taxable Amount Year 2 #REF! #REF! #REF! #REF! #REF! #REF!
Total #REF! #REF! #REF! #REF! #REF! #REF!
Income Taxes #REF! #REF! #REF! #REF! #REF! #REF!

Taxable Amount Year 3 #REF! #REF! #REF! #REF! #REF! #REF!

Total #REF! #REF! #REF! #REF! #REF! #REF!
Income Taxes #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx etats financiers Y1-Y3 11/24/2024 11:08:30

Income Statement Years 1-3

Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total

#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!

819093860.xlsx etats financiers Y1-Y3 11/24/2024 11:08:30

Balance Sheet Years 1-3

Prepared By: Company Name:

Owner Myjobs.ma

ASSETS 2023 2024 2025

Current Assets
Cash #REF! #REF! #REF!
Accounts Receivable - - -
Inventory #REF! #REF! #REF!
Prepaid Expenses #REF! #REF! #REF!
Other Initial Costs #REF! #REF! #REF!
Total Current Assets #REF! #REF! #REF!

Fixed Assets
Real Estate -- Land #REF! #REF! #REF!
Real Estate -- Buildings #REF! #REF! #REF!
Leasehold Improvements #REF! #REF! #REF!
Equipment #REF! #REF! #REF!
Furniture and Fixtures #REF! #REF! #REF!
Vehicles #REF! #REF! #REF!
Other #REF! #REF! #REF!
Total Fixed Assets #REF! #REF! #REF!
(Less Accumulated Depreciation) #REF! #REF! #REF!
Total Assets #REF! #REF! #REF!

LIABILITIES & EQUITY

Liabilities
Accounts Payable - - -
Commercial Loan Balance #REF! #REF! #REF!

819093860.xlsx Bilan 11/24/2024 11:08:30

Balance Sheet Years 1-3

Commercial Mortgage Balance #REF! #REF! #REF!

Credit Card Debt Balance #REF! #REF! #REF!
Vehicle Loans Balance #REF! #REF! #REF!
Other Bank Debt Balance #REF! #REF! #REF!
Line of Credit Balance #REF! #REF! #REF!
Total Liabilities #REF! #REF! #REF!
Equity
Common Stock #REF! #REF! #REF!
Retained Earnings #REF! #REF! #REF!
Dividends Dispersed/Owners Draw - - -
Total Equity #REF! #REF! #REF!
Total Liabilities and Equity #REF! #REF! #REF!

#REF! #REF! #REF!

Balance sheet in or out of balance?
#REF! #REF! #REF!

819093860.xlsx Bilan 11/24/2024 11:08:30

Breakeven Analysis

Breakeven Analysis Year 1

Prepared By: Company Name:

Owner Myjobs.ma

Gross Margin % of Sales

Gross Margin $ - Breakeven Sales Level

Total Sales $ - The breakeven sales level represents the number of units
Gross Margin/Total Sales 0.0% that must be sold in order to break even. This means that
revenues are equal to expenses. Any units sold beyond this
Total Fixed Expenses quantity will allow the company to generate net income.

#REF! One of the best uses of breakeven analysis is to play with

Payroll various scenarios. For instance, if you add another person
to the payroll, how many extra sales dollars will be needed
#REF! to recover the extra salary expense? If you borrow, how
Operating Expenses
much will be needed to cover the increased principal and
Operating + Payroll #REF! interest payments? Many owners, especially retailers, like
to calculate a daily breakdown. This gives everyone a
Breakeven Sales in Dollars (Annual) target to shoot at for the day.
0.0% Equation:
Gross Margin % of Sales

#REF! Breakeven Point = Total Fixed Costs/ (Gross Margin/Total

Total Fixed Expenses Sales)

$ -
Yearly Breakeven Amount
Monthly Breakeven Amount $ -

819093860.xlsx BreakevenAnalysis 11/24/2024 11:08:30

Financial Ratios - Year 1

Prepared By: Company Name:

Owner Myjobs.ma

Ratios Year One Year Two Year Three Industry Norms Notes
Liquidity
Current Ratio #REF! #REF! #REF!
Quick Ratio #REF! #REF! #REF!
Safety
Debt to Equity Ratio #REF! #REF! #REF!
Debt-Service Coverage Ratio - DSCR #REF! #REF! #REF!
Profitability
Sales Growth 0.0% 0.0% 0.0%
COGS to Sales 0.0% 0.0% 0.0%
Gross Profit Margin 0.0% 0.0% 0.0%
SG&A to Sales 0.0% 0.0% 0.0%
Net Profit Margin 0.0% 0.0% 0.0%
Return on Equity (ROE) #REF! #REF! #REF!
Return on Assets #REF! #REF! #REF!
Owner’s Compensation to Sales 0.0% 0.0% 0.0%
Efficiency
Days in Receivables 0.0 0.0 0.0
Accounts Receivable Turnover 0.0 0.0 0.0
Days in Inventory 0.0 0.0 0.0
Inventory Turnover #REF! #REF! #REF!
Sales to Total Assets #REF! #REF! #REF!

819093860.xlsx KPI 11/24/2024 11:08:30

Financial Ratios - Year 1

This sheet shows some

common financial
ratios. There is a
column where you can
enter industry norms. To
get these, contact your
local library or bank to
see if they have copies
of the Risk Management
Association (RMA)
Annual Statement or
refer to industry
publications and trade
magazines. Speak with
your mentor to ensure
you are using the
appropriate resources.

819093860.xlsx KPI 11/24/2024 11:08:30

Diagnostic Tools - Year 1

Prepared By: Company Name:

Owner Myjobs.ma

General Financing Assumptions Value Findings

Owner’s Cash Injection into the Business #REF! #REF!
This sheet
Cash Request as percent of Total Required Funds #REF! #REF! if they see
Remembe
projections
Loan Assumptions Value Findings do that. Bu
Commercial Loan Interest rate #REF! #REF! are critical

Commercial Loan Term in Months #REF! #REF!

Commercial Mortgage Interest rate #REF! #REF!
Commercial Mortgage Term in Months #REF! #REF!
Debt-Service Coverage #REF! #REF!

Income Statement Value Findings

Gross Margin as a Percent of Sales 0.0% Gross margin percentage seems very low
Owner’s Compensation Lower Limit Check #REF! #REF!
Owner’s Compensation Upper Limit Check #REF! #REF!
Advertising Expense Levels as a Percent of Sales 0.0% Advertising as a percent of sales may be too low
Profitability Levels #REF! #REF!
Profitability as a Percent of Sales 0.0% The projection does not seem highly unreasonable

Cash Flow Statement Value Findings

Desired Operating cash Flow Levels #REF! #REF!
Line of Credit Drawdowns #REF! #REF!
Accounts Receivable Ratio to Sales 0.0% Accounts receivable amount as a percent of sales seems reasonable

Balance Sheet Value Findings

Does the Year 1 Balance Sheet Balance? #REF! #REF!

819093860.xlsx DiagnosticTools 11/24/2024 11:08:30

Diagnostic Tools - Year 1

Debt to Equity Ratio #REF! #REF!

Breakeven Analysis Value Findings

Do Sales Exceed the Breakeven Level? $ - The sales projection is less than the break-even amount

819093860.xlsx DiagnosticTools 11/24/2024 11:08:30

Diagnostic Tools - Year 1

This sheet performs a few tests on your numbers to see

if they seem within certain reasonable ranges.
Remember, no computer can tell whether your
projections are truly well-constructed, only a human can
do that. But these tests can at least look for values that
are critically out of range.

819093860.xlsx DiagnosticTools 11/24/2024 11:08:30

COGS Calculator

Prepared By: Company Name:

Owner Myjobs.ma

Variable Costs of Products

Timeframe: Month
Product Line: Widget
Raw materials
Labor used to produce product
Costs associated with shipping and storing raw materials
Production facility expenses (use fraction of total if facility is used for other
items)
Total Product Expenses $ -
Number Units Sold in timeframe used
Cost of Goods Sold Per Unit Please enter all information.

Variable Costs of Services

Timeframe: Month
Product Line: Project
Amount spent on labor during timeframe
Amount spent on materials during this timeframe

List any other variable costs associated with the delivery of your service during
this timeframe.
Total Service Expenses $ -
Number Units Sold During Timeframe
Cost of Goods Sold Per Unit Please enter all information.

Return to Sales Forecast Year 1

819093860.xlsx COGS Calculator 11/24/2024 11:08:30

Amortization and Depreciation Schedule

Amortization & Depreciation Schedule

Prepared By: Company Name:

Owner Myjobs.ma Return to Starting Point

Commercial Loan
Principal Amount #REF!
Interest Rate #REF!
Loan Term in Months #REF!
Monthly Payment Amount #REF!
+Directions!B34
=Directions!B35
+Directions!B36
+Directions!B37
+Directions!B38
+Directions!B39
+Directions!B40
+Directions!B41
Year One
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Commercial Mortgage
Principal Amount #REF!
Interest Rate #REF!
Loan Term in Months #REF!
Amortization and Depreciation Schedule

Monthly Payment Amount #REF!

+Directions!B34
=Directions!B35
+Directions!B36
+Directions!B37
+Directions!B38
+Directions!B39
+Directions!B40
+Directions!B41
Year One
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Credit Card Debt

Principal Amount #REF!
Interest Rate #REF!
Loan Term in Months #REF!
Monthly Payment Amount #REF!
+Directions!B34
=Directions!B35
+Directions!B36
+Directions!B37
+Directions!B38
+Directions!B39
+Directions!B40
+Directions!B41
Year One
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Amortization and Depreciation Schedule

Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Vehicle Loans
Principal Amount #REF!
Interest Rate #REF!
Loan Term in Months #REF!
Monthly Payment Amount #REF!
+Directions!B34
=Directions!B35
+Directions!B36
+Directions!B37
+Directions!B38
+Directions!B39
+Directions!B40
+Directions!B41
Year One
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Other Bank Debt

Year One
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Interest #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Principal #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Loan Balance #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Depreciation
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
+Directions!B34
=Directions!B35
+Directions!B36
+Directions!B37
+Directions!B38
+Directions!B39
+Directions!B40
+Directions!B41
Year One
Starting Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Additional Depreciation - - - - - - - -
Ending Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Starting Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Additional Depreciation - - - - - - - -
Ending Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Amortization and Depreciation Schedule

Starting Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Additional Depreciation - - - - - - - -
Ending Deprecation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Amortization of Start-Up
Costs Monthly
Prepaid Expenses #REF!
Total Expensed each Year #REF! #REF!
Other Initial Costs #REF!
Total Expensed each Year #REF! #REF!
Prepaid Expenses +Directions!B34
=Directions!B35
+Directions!B36
+Directions!B37
+Directions!B38
+Directions!B39
+Directions!B40
+Directions!B41
Year One
Amount Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Total Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Amount Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Total Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Amount Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Total Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

=Directio +Directio +Directio +Directio +Directio +Directio +Directio

Other Initial Costs +Directions!B34 ns!B35 ns!B36 ns!B37 ns!B38 ns!B39 ns!B40 ns!B41
Year One
Amount Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Total Amortized #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Two
Starting Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Ending Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Year Three
Starting Depreciation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Ending Deprecation #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Amortization and Depreciation Schedule

+Directions!B42
+Directions!B43
+Directions!B44
+Directions!B45Totals