Vehicle Renting Business Financials 20.27.05

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

Show Results for 28 Day

Car Contribution in Revenue


23%
Modelwise Earnings for Selected Period
Car Amount Profit; $2,801.33
Revenue $13,860.00 SR+ 2022
SR+ 2022 $3,220.00 Expe 80% $11,058.67 43%
Performance 2022
Performance 2022 $4,620.00 Profit 20% $2,801.33
Y-2022 $6,020.00 Profit; 20%
Y-2022
Total Earnings or Inflows $13,860.00

33%
Expenses or Outflows
Type Amount Profit
Installments
Insurance
$5,693.33
$700.00
&
Marketing $1,400.00 Expenses Outflows Breakup
Utilities $65.33
Labors $3,200.00 Labors Labors;
$3,200.00
Expe; 80%
Total Expenses or Outflows $11,058.67 Utilities Utilities;
$65.33

Marketing Marketing;
Net Profit or Balance $2,801.33 Expe; $11,058.67 $1,400.00

Insurance Insurance;
$700.00

Installments Installments;
$5,693.33
Show Results for 28 Day Total Expenses Comparison
SR+ 2022
5%
SR+ 2022 PerformancY-2022 SR+ 2022
Description SR+ 2022 Performance 2022 Y-2022 Y-2022 31%
36% $3,655.11 $4,028.44
$3,375.11
Revenue $3,220.00 $4,620.00 $6,020.00
Performance 2022
31%
Expenses Description SR+ 2022 Performance 2022 Y-2022 Profit
Installments $1,586.67 $1,866.67 $2,240.00 SR+ 2022 Comparison
PerformancY-2022
Insurance $233.33 $233.33 $233.33 -$155.11
Y-2022 $964.89 $1,991.56
64%
Marketing $466.67 $466.67 $466.67
Utilities $21.78 $21.78 $21.78
Performance 2022
Labors $1,066.67 $1,066.67 $1,066.67 33%

Total Expenses or Outflows $3,375.11 $3,655.11 $4,028.44 $1,066.67


$21.78
Y-2022 $466.67
Net Profit or Balance -$155.11 $964.89 $1,991.56 SR+ 2022 Performance 2022 Y-2022 $233.33

EXPENSES BREAKUP
$2,240.00
$1,066.67
Cars Revenues Breakup $21.78
Performance 2022 $466.67
$6,020.00 $233.33
$1,866.67
$4,620.00
$1,066.67
$21.78
$3,220.00 SR+ 2022 $466.67
$233.33
$1,586.67
0 500 1000 1500 2000 2500

Labors Utilities Marketing Insurance Installments


SR+ 2022 Performance 2022 Y-2022
Cash Inflows Installments Insurance
Descripton Days Amount 1 Day Days Amount 1 Day
Model 3 sr+ 2022 30 $1,700.00 $56.67 30 $250.00 $8.33
Model 3 Performance 2022 30 $2,000.00 $66.67 30 $250.00 $8.33
Model Y-2022 30 $2,400.00 $80.00 30 $250.00 $8.33
Note:
Please change the Values in "GREEN" Cells

Marketing Maintainers Labors Telephone


Days Amount 1 Day Days Amount 1 Day Days Amount 1 Day
30 $500.00 $16.67 7 $266.67 $38.10 30 $23.33 $0.78
30 $500.00 $16.67 7 $266.67 $38.10 30 $23.33 $0.78
30 $500.00 $16.67 7 $266.67 $38.10 30 $23.33 $0.78
Day SR+ 2022 Performance 2022 Y-2022
1 $250.00 $300.00 $350.00
2 $245.00 $295.00 $345.00
3 $240.00 $290.00 $340.00
4 $235.00 $285.00 $335.00
5 $230.00 $280.00 $330.00
6 $225.00 $275.00 $325.00
7 $220.00 $270.00 $320.00
8 $215.00 $265.00 $315.00
9 $210.00 $260.00 $310.00
10 $205.00 $255.00 $305.00
11 $200.00 $250.00 $300.00
12 $195.00 $245.00 $295.00
13 $190.00 $240.00 $290.00
14 $185.00 $235.00 $285.00
15 $180.00 $230.00 $280.00
16 $175.00 $225.00 $275.00
17 $170.00 $220.00 $270.00
18 $165.00 $215.00 $265.00
19 $160.00 $210.00 $260.00
20 $155.00 $205.00 $255.00
21 $150.00 $200.00 $250.00
22 $145.00 $195.00 $245.00
23 $140.00 $190.00 $240.00
24 $135.00 $185.00 $235.00
25 $130.00 $180.00 $230.00
26 $125.00 $175.00 $225.00
27 $120.00 $170.00 $220.00
28 $115.00 $165.00 $215.00
29 $110.00 $160.00 $210.00
30 $105.00 $155.00 $205.00

You might also like