Excel Financial Sampel
Excel Financial Sampel
Excel Financial Sampel
Payload Payload
Income Statement
Revenue
Total Revenues -
Gross Income -
% of Revenues 0.0%
Depreciation Expense -
EBITDA -
% of Revenues 0.0%
Interest Expense -
Interest Income -
Pre-Tax Profit (Loss) -
% of Revenues 0.0%
Balance Sheet
Assets
Cash - 400,000
Accounts Receivable - -
Inventory - -
- 400,000
Gross PP&E - -
Accumulated Depreciation - -
Net PP&E - -
Intangibles - -
Long-Term Debt - -
Total Liabilities - -
Debt
Summary
Total Revenues -
Total Cost of Goods Sold -
Total Operating Expenses (61,383)
EBITDA -
Interest Expense -
Net Income -
Cash 400,000
Total Assets 400,000
Revolver (Short-Term Debt) -
Long-Term Debt -
Total Shareholder's Equity 400,000
Total Headcount 3
Total Salaries & Benefits 35,458
1st Year
Q1 2019 Q2 2019 Q3 2019
Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - 1,000,000 - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - 3,667 3,667 3,667 3,667
- - - - - - - -
- - - - 3,667 3,667 3,667 3,667
- - - - 1 1 1 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.0% 0.0%
- - - - - - - -
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
- - - - - - - -
- - - - - - - -
(55,633) (55,633) (55,633) (55,633) (55,633) (55,633) (55,633) (46,258)
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
- - - - - - - -
- - - - - - - -
(56,383) (56,383) (56,383) (56,383) (60,075) (60,075) (60,075) (50,700)
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - (1,500) - - -
- - - - - - - -
- - - - - - - -
- - - - (1,500) - - -
- - - - - - - -
- - - - - - - -
- - - - - 1,000,000 - -
- - - - - - - -
- - - - - 1,000,000 - -
400,000 343,617 287,233 230,850 174,467 112,917 1,052,867 992,817
(56,383) (56,383) (56,383) (56,383) (61,550) 939,950 (60,050) (50,675)
343,617 287,233 230,850 174,467 112,917 1,052,867 992,817 942,142
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
(56,383) (56,383) (56,383) (56,383) (60,075) (60,075) (60,075) (50,700)
(56,383) (56,383) (56,383) (56,383) (60,050) (60,050) (60,050) (50,675)
- - - - - - - -
(56,383) (56,383) (56,383) (56,383) (60,075) (60,075) (60,075) (50,700)
3 3 3 3 4 4 4 4
35,458 35,458 35,458 35,458 39,125 39,125 39,125 39,125
2nd Yea
Q4 2019 Q1 2020 Q2 2020
Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - -
- - -
- - - 3,667 3,667 3,667 3,667 3,667
- - -
- - - 3,667 3,667 3,667 3,667 3,667
- - - 1 1 1 1 1
- - - - - - - -
- - - - - - - -
(50,700) (50,700) (50,700) (10,095) (10,095) (10,095) (10,095) (10,095)
0.0% 0.0% 0.0% (2.7%) (2.7%) (2.7%) (2.7%) (2.7%)
- - - - - - - -
- - - - - - - -
- - - 262,500 262,500 262,500 262,500 262,500
- - - 262,500 262,500 262,500 262,500 262,500
- - - - - - - -
- - - 262,500 262,500 262,500 262,500 262,500
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
942,142 891,467 840,792 790,117 1,042,546 1,032,476 1,022,405 1,012,335
(50,675) (50,675) (50,675) 252,430 (10,070) (10,070) (10,070) (10,070)
891,467 840,792 790,117 1,042,546 1,032,476 1,022,405 1,012,335 1,002,265
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
4 4 4 14 14 14 14 14
39,125 39,125 39,125 91,987 91,987 91,987 91,987 91,987
2nd Year
2 2020 Q3 2020 Q4 2020 Q1 2021
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - -
5,750
3,667 3,667 3,667 3,667 3,667 3,667 3,667 3,777
3,667
3,667 3,667 3,667 3,667 3,667 3,667 3,667 13,193
1 1 1 1 1 1 1 3
- - - - - - - -
- - - - - - - -
(10,095) (10,095) (10,095) (10,095) (10,095) (10,095) (10,095) 67,510
(2.7%) (2.7%) (2.7%) (2.7%) (2.7%) (2.7%) (2.7%) 9.0%
- - - - - - - -
- - - - - - - -
262,500 262,500 262,500 262,500 262,500 262,500 262,500 525,000
262,500 262,500 262,500 262,500 262,500 262,500 262,500 525,000
- - - - - - - -
262,500 262,500 262,500 262,500 262,500 262,500 262,500 525,000
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
1,002,265 992,194 982,124 972,053 961,983 951,913 941,842 931,772
(10,070) (10,070) (10,070) (10,070) (10,070) (10,070) (10,070) 330,035
992,194 982,124 972,053 961,983 951,913 941,842 931,772 1,261,807
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
14 14 14 14 14 14 14 16
91,987 91,987 91,987 91,987 91,987 91,987 91,987 104,908
3rd Year
Q1 2021 Q2 2021 Q3 2021
Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
67,510 67,510 67,510 67,510 67,510 67,510 67,510 67,510
9.0% 9.0% 9.0% 9.0% 9.0% 9.0% 9.0% 9.0%
- - - - - - - -
- - - - - - - -
525,000 525,000 525,000 525,000 525,000 525,000 525,000 525,000
525,000 525,000 525,000 525,000 525,000 525,000 525,000 525,000
- - - - - - - -
525,000 525,000 525,000 525,000 525,000 525,000 525,000 525,000
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
1,261,807 1,329,342 1,396,878 1,464,413 1,531,948 1,599,484 1,667,019 1,734,554
67,535 67,535 67,535 67,535 67,535 67,535 67,535 67,535
1,329,342 1,396,878 1,464,413 1,531,948 1,599,484 1,667,019 1,734,554 1,802,090
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
16 16 16 16 16 16 16 16
104,908 104,908 104,908 104,908 104,908 104,908 104,908 104,908
4th Yea
Q4 2021 Q1 2022 Q2 2022
Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - -
- - - - - - - -
- - - - - - - -
67,510 67,510 67,510 240,727 240,727 240,727 240,727 240,727
9.0% 9.0% 9.0% 16.0% 16.0% 16.0% 16.0% 16.0%
(67,510) (54,600) - - - - - -
- 12,910 67,510 240,727 240,727 240,727 240,727 240,727
- (3,873) (20,253) (72,218) (72,218) (72,218) (72,218) (72,218)
67,510 63,637 47,257 168,509 168,509 168,509 168,509 168,509
9.0% 8.5% 6.3% 11.2% 11.2% 11.2% 11.2% 11.2%
- - - - - - - -
- - - - - - - -
525,000 525,000 525,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000
525,000 525,000 525,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000
- - - - - - - -
525,000 525,000 525,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000
Ok Ok Ok Ok Ok Ok Ok Ok
54,600 - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
1,802,090 1,869,625 1,933,287 1,980,570 2,674,104 2,842,637 3,011,171 3,179,705
67,535 63,662 47,282 693,534 168,534 168,534 168,534 168,534
1,869,625 1,933,287 1,980,570 2,674,104 2,842,637 3,011,171 3,179,705 3,348,239
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
16 16 16 16 16 16 16 16
104,908 104,908 104,908 108,837 108,837 108,614 108,614 108,614
4th Year
2 2022 Q3 2022 Q4 2022 Q1 2023
Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
240,727 240,727 240,727 240,727 240,727 240,727 240,727 579,924
16.0% 16.0% 16.0% 16.0% 16.0% 16.0% 16.0% 19.3%
- - - - - - - -
240,727 240,727 240,727 240,727 240,727 240,727 240,727 579,924
(72,218) (72,218) (72,218) (72,218) (72,218) (72,218) (72,218) (173,977)
168,509 168,509 168,509 168,509 168,509 168,509 168,509 405,947
11.2% 11.2% 11.2% 11.2% 11.2% 11.2% 11.2% 13.5%
- - - - - - - -
- - - - - - - -
1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 2,100,000
1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 2,100,000
- - - - - - - -
1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 1,050,000 2,100,000
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
3,348,239 3,516,773 3,685,307 3,853,841 4,022,375 4,190,909 4,359,443 4,527,977
168,534 168,534 168,534 168,534 168,534 168,534 168,534 1,455,972
3,516,773 3,685,307 3,853,841 4,022,375 4,190,909 4,359,443 4,527,977 5,983,948
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
16 16 16 16 16 16 16 17
108,614 108,614 108,614 108,614 108,614 108,614 108,614 119,568
5th Year
Q1 2023 Q2 2023 Q3 2023
Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
579,924 579,924 579,924 579,924 579,924 579,924 579,924 579,924
19.3% 19.3% 19.3% 19.3% 19.3% 19.3% 19.3% 19.3%
- - - - - - - -
579,924 579,924 579,924 579,924 579,924 579,924 579,924 579,924
(173,977) (173,977) (173,977) (173,977) (173,977) (173,977) (173,977) (173,977)
405,947 405,947 405,947 405,947 405,947 405,947 405,947 405,947
13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5%
- - - - - - - -
- - - - - - - -
2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000
2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000
- - - - - - - -
2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000 2,100,000
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
5,983,948 6,389,920 6,795,891 7,201,863 7,607,835 8,013,806 8,419,778 8,825,749
405,972 405,972 405,972 405,972 405,972 405,972 405,972 405,972
6,389,920 6,795,891 7,201,863 7,607,835 8,013,806 8,419,778 8,825,749 9,231,721
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
17 17 17 17 17 17 17 17
119,568 119,568 119,568 119,568 119,568 119,568 119,568 119,568
1st Year 2nd
Q4 2023
Oct-23 Nov-23 Dec-23 Q1 2019 Q2 2019 Q3 2019 Q4 2019 Q1 2020
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - 1,000,000 - -
- - - - - - - -
- - - - - - - -
579,924 579,924 579,924 (112,767) (172,842) (170,850) (152,100) (30,286)
19.3% 19.3% 19.3% 0% 0% 0% 0% (2.7%)
- - - - - - - -
- - - - - - - -
2,100,000 2,100,000 2,100,000 - - - - 262,500
2,100,000 2,100,000 2,100,000 - - - - 262,500
- - - - - - - -
2,100,000 2,100,000 2,100,000 - - - - 262,500
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - (1,500) - - -
- - - - - - - -
- - - - - - - -
- - - - (1,500) - - -
- - - - - - - -
- - - - - - - -
- - - 400,000 - 1,000,000 - -
- - - - - - - -
- - - 400,000 - 1,000,000 - -
9,231,721 9,637,692 10,043,664 - 287,233 112,917 942,142 790,117
405,972 405,972 405,972 287,233 (174,317) 829,225 (152,025) 232,289
9,637,692 10,043,664 10,449,636 287,233 112,917 942,142 790,117 1,022,405
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
17 17 17 3 4 4 4 14
119,568 119,568 119,568 35,458 39,125 39,125 39,125 91,987
2nd Year 3rd Year 4th Yea
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
(30,286) (30,286) (30,286) 202,531 202,531 202,531 202,531 722,181
(2.7%) (2.7%) (2.7%) 9.0% 9.0% 9.0% 9.0% 16.0%
- - - - - - - -
- - - - - - - -
262,500 262,500 262,500 525,000 525,000 525,000 525,000 1,050,000
262,500 262,500 262,500 525,000 525,000 525,000 525,000 1,050,000
- - - - - - - -
262,500 262,500 262,500 525,000 525,000 525,000 525,000 1,050,000
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
1,022,405 992,194 961,983 931,772 1,396,878 1,599,484 1,802,090 1,980,570
(30,211) (30,211) (30,211) 465,106 202,606 202,606 178,480 1,030,602
992,194 961,983 931,772 1,396,878 1,599,484 1,802,090 1,980,570 3,011,171
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
14 14 14 16 16 16 16 16
91,987 91,987 91,987 104,908 104,908 104,908 104,908 108,614
4th Year 5th Year 1st Year
- - - - - - - -
30 30 30 30 30 30 30 30
- - - - - - - -
- - - - - - - 1,000,000
- - - - - - - -
- - - - - - - -
722,181 722,181 722,181 1,739,771 1,739,771 1,739,771 1,739,771 (608,558)
16.0% 16.0% 16.0% 19.3% 19.3% 19.3% 19.3% 0%
- - - - - - - 608,558
722,181 722,181 722,181 1,739,771 1,739,771 1,739,771 1,739,771 -
(216,654) (216,654) (216,654) (521,931) (521,931) (521,931) (521,931) -
505,527 505,527 505,527 1,217,840 1,217,840 1,217,840 1,217,840 (608,558)
11.2% 11.2% 11.2% 13.5% 13.5% 13.5% 13.5% 0%
- - - - - - - -
- - - - - - - -
1,050,000 1,050,000 1,050,000 2,100,000 2,100,000 2,100,000 2,100,000 -
1,050,000 1,050,000 1,050,000 2,100,000 2,100,000 2,100,000 2,100,000 -
- - - - - - - -
1,050,000 1,050,000 1,050,000 2,100,000 2,100,000 2,100,000 2,100,000 -
Ok Ok Ok Ok Ok Ok Ok Ok
- - - - - - - 608,558
- - - - - - - (1,500)
- - - - - - - -
- - - - - - - -
- - - - - - - (1,500)
- - - - - - - -
- - - - - - - -
- - - - - - - 1,400,000
- - - - - - - -
- - - - - - - 1,400,000
3,011,171 3,516,773 4,022,375 4,527,977 6,795,891 8,013,806 9,231,721 -
505,602 505,602 505,602 2,267,915 1,217,915 1,217,915 1,217,915 790,117
3,516,773 4,022,375 4,527,977 6,795,891 8,013,806 9,231,721 10,449,636 790,117
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
16 16 16 17 17 17 17 4
108,614 108,614 108,614 119,568 119,568 119,568 119,568 39,125
2nd Year 3rd Year 4th Year 5th Year Checksum Checksum Checksum Checksum
Ok Ok Ok Ok
2020 2021 2022 2023 2019 2020 2021 2022
- - - - Ok Ok Ok Ok
30 30 30 30 Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
(121,145) 810,124 2,888,725 6,959,084 Ok Ok Ok Ok
(2.7%) 9.0% 16.0% 19.3%
121,145 (729,703) - - Ok Ok Ok Ok
- 80,421 2,888,725 6,959,084 Ok Ok Ok Ok
- (24,126) (866,617) (2,087,725) Ok Ok Ok Ok
(121,145) 785,998 2,022,107 4,871,359 Ok Ok Ok Ok
(2.7%) 8.7% 11.2% 13.5%
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
262,500 525,000 1,050,000 2,100,000 Ok Ok Ok Ok
262,500 525,000 1,050,000 2,100,000 Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
262,500 525,000 1,050,000 2,100,000 Ok Ok Ok Ok
Ok Ok Ok Ok
729,703 - - - Ok Ok Ok Ok
- - - -
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
790,117 931,772 1,980,570 4,527,977 Ok Ok Ok Ok
141,655 1,048,798 2,547,407 5,921,659 Ok Ok Ok Ok
931,772 1,980,570 4,527,977 10,449,636 Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
- - - - Ok Ok Ok Ok
14 16 16 17 Ok Ok Ok Ok
91,987 104,908 108,614 119,568 Ok Ok Ok Ok
Checksum
Ok
2023
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Ok
Payload Financial Model
(in whole USD; assumes no inflation)
Initial Funding
Existing Common Shares 10,000,000 - - -
Existing Preferred Shares - - - -
Existing Options Granted - - - -
Total Cumulative Shares 10,000,000 - - -
Round 1
Investment Dollar Amount 400,000 - - -
Additional Common Shares - - - -
Additional Preferred Shares - - - -
Additional Options Granted - - - -
Cumulative Common Shares 10,000,000 - - -
Cumulative Preferred Shares - - - -
Cumulative Options Granted - - - -
Total Cumulative Shares 10,000,000 - - -
Round 2
Investment Dollar Amount - - 1,000,000 -
Additional Common Shares - - - -
Additional Preferred Shares - - 336,000 -
Additional Options Granted - - 30,000 -
Cumulative Common Shares 10,000,000 - - -
Cumulative Preferred Shares - - 336,000 -
Cumulative Options Granted - - 30,000 -
Total Cumulative Shares 10,000,000 - 366,000 -
Options Price / Total Post-Money
Series B Series C Series D Total Shares Pre-Money Valuation
Available Share Investment Valuation
- - - 10,000,000
- - - -
- - - -
- - - 10,000,000
WACC (SECTION INDEPENDENT OF PRIMARY MODEL; YELLOW CELLS BELOW REQUIRE INDIVIDUAL INPUTS) (1)
(1) Choosing WACC for an early-stage startup is a highly arbitrary exercise. A good baseline is to reflect the average IRR of angel investors. According to three studies o
returns range from 18-37% to 27% to 30%.
(2) Initial placeholder based on the 10-Year Treasury Yield as of 9/9/2011.
(3) Initial placeholder based on the difference between the 1928-2010 arithmetic average return of stocks (Damodaran, January 2011) and the 10-Year Treasury Yield a
(4) Available on Yahoo! Finance under "Key Statistics" for publicly-traded companies .
Valuation
2019 2020
Operating Income (608,558) (121,145)
Tax Expense - -
Tax-Effected EBIT (Earnings Before Interest) (608,558) (121,145)
Plus: Depreciation Expense (175) (300)
Capital Expenditures (1,500) -
Changes in Working Capital - 262,500
Changes in Other Assets & Liabilities - -
Unlevered Free Cash Flow (610,233) 141,055
Present Value of Unlevered Free Cash Flow (584,615) 129,460
Terminal Value
Present Value of Terminal Value
78,119,053 441,278,788
68,687,785 356,109,825