| ← Back to Cover | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| BALANCE SHEET | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Simplified Monthly Balance Sheet - 60 Month Projection | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Year 1 (FY2026) | Year 2 (FY2027) | Year 3 (FY2028) | Year 4 (FY2029) | Year 5 (FY2030) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Account | Unit | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Jul-26 | Aug-26 | Sep-26 | Oct-26 | Nov-26 | Dec-26 | Jan-27 | Feb-27 | Mar-27 | Apr-27 | May-27 | Jun-27 | Jul-27 | Aug-27 | Sep-27 | Oct-27 | Nov-27 | Dec-27 | Jan-28 | Feb-28 | Mar-28 | Apr-28 | May-28 | Jun-28 | Jul-28 | Aug-28 | Sep-28 | Oct-28 | Nov-28 | Dec-28 | Jan-29 | Feb-29 | Mar-29 | Apr-29 | May-29 | Jun-29 | Jul-29 | Aug-29 | Sep-29 | Oct-29 | Nov-29 | Dec-29 | Jan-30 | Feb-30 | Mar-30 | Apr-30 | May-30 | Jun-30 | Jul-30 | Aug-30 | Sep-30 | Oct-30 | Nov-30 | Dec-30 | ||||
| ASSETS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cash & Cash Equivalents | $ | $1,809,002 | $1,668,746 | $1,543,154 | $1,424,475 | $1,283,486 | $1,142,036 | $1,016,775 | $841,000 | $664,632 | $499,938 | $297,865 | $5,095,107 | $4,925,187 | $4,658,031 | $4,390,617 | $4,143,194 | $3,834,556 | $3,525,604 | $3,250,995 | $2,872,048 | $2,492,768 | $2,138,567 | $1,707,609 | $16,276,253 | $15,903,321 | $15,360,065 | $14,816,781 | $14,307,808 | $13,695,718 | $13,083,561 | $12,515,317 | $11,815,188 | $11,115,032 | $10,449,188 | $9,680,202 | $8,911,151 | $8,230,448 | $7,292,605 | $6,354,853 | $5,458,480 | $4,438,287 | $38,418,170 | $37,468,146 | $36,308,195 | $35,148,348 | $34,043,643 | $32,773,809 | $31,504,074 | $30,340,738 | $28,861,969 | $27,383,294 | $25,956,236 | $24,374,798 | $22,793,494 | $21,279,909 | $19,563,557 | $17,847,284 | $16,191,161 | $14,355,076 | $12,519,121 | ||||
| Accounts Receivable | $ | $4,313 | $4,617 | $4,934 | $5,279 | $5,652 | $6,049 | $6,469 | $6,929 | $7,412 | $7,929 | $8,481 | $9,068 | $12,687 | $13,190 | $13,726 | $14,267 | $14,835 | $15,428 | $16,048 | $16,686 | $17,357 | $18,054 | $18,782 | $19,537 | $25,154 | $25,652 | $26,165 | $26,692 | $27,234 | $27,776 | $28,333 | $28,890 | $29,461 | $30,047 | $30,648 | $31,248 | $39,113 | $39,509 | $39,914 | $40,310 | $40,714 | $41,110 | $41,506 | $41,927 | $42,364 | $42,801 | $43,230 | $43,667 | $47,964 | $48,205 | $48,447 | $48,705 | $48,938 | $49,197 | $49,439 | $49,697 | $49,930 | $50,189 | $50,430 | $50,689 | ||||
| PP&E (Net of Depreciation) | $ | $252 | $521 | $809 | $1,117 | $1,446 | $1,799 | $2,177 | $2,581 | $3,013 | $3,476 | $3,970 | $4,499 | $5,239 | $6,009 | $6,809 | $7,642 | $8,507 | $9,407 | $10,343 | $11,317 | $12,329 | $13,382 | $14,478 | $15,617 | $17,085 | $18,581 | $20,107 | $21,664 | $23,253 | $24,873 | $26,526 | $28,211 | $29,930 | $31,683 | $33,471 | $35,293 | $37,575 | $39,880 | $42,208 | $44,559 | $46,934 | $49,332 | $51,754 | $54,199 | $56,671 | $59,167 | $61,689 | $64,236 | $67,034 | $69,846 | $72,672 | $75,513 | $78,368 | $81,238 | $84,122 | $87,021 | $89,933 | $92,861 | $95,803 | $98,760 | ||||
| TOTAL ASSETS | $ | $1,813,566 | $1,673,884 | $1,548,896 | $1,430,870 | $1,290,584 | $1,149,884 | $1,025,420 | $850,510 | $675,057 | $511,343 | $310,317 | $5,108,674 | $4,943,113 | $4,677,230 | $4,411,152 | $4,165,103 | $3,857,898 | $3,550,440 | $3,277,386 | $2,900,050 | $2,522,454 | $2,170,003 | $1,740,870 | $16,311,407 | $15,945,560 | $15,404,299 | $14,863,054 | $14,356,165 | $13,746,205 | $13,136,211 | $12,570,177 | $11,872,289 | $11,174,423 | $10,510,918 | $9,744,320 | $8,977,693 | $8,307,136 | $7,371,994 | $6,436,974 | $5,543,349 | $4,525,935 | $38,508,612 | $37,561,406 | $36,404,321 | $35,247,382 | $34,145,611 | $32,878,728 | $31,611,978 | $30,455,736 | $28,980,020 | $27,504,413 | $26,080,454 | $24,502,104 | $22,923,929 | $21,413,469 | $19,700,275 | $17,987,147 | $16,334,211 | $14,501,309 | $12,668,570 | ||||
| LIABILITIES | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Accounts Payable | $ | $148,908 | $134,847 | $135,866 | $151,580 | $152,788 | $154,057 | $188,756 | $190,264 | $191,799 | $217,974 | $219,763 | $221,644 | $292,242 | $293,506 | $294,873 | $336,850 | $338,290 | $339,789 | $410,680 | $412,282 | $413,986 | $466,667 | $468,504 | $470,399 | $592,523 | $593,531 | $594,592 | $664,383 | $665,501 | $666,593 | $755,619 | $756,739 | $757,913 | $827,842 | $829,072 | $830,277 | $1,014,095 | $1,014,781 | $1,015,481 | $1,098,774 | $1,099,474 | $1,100,160 | $1,240,868 | $1,241,596 | $1,242,373 | $1,353,271 | $1,354,012 | $1,354,768 | $1,572,046 | $1,572,420 | $1,572,774 | $1,676,146 | $1,676,487 | $1,676,887 | $1,812,506 | $1,812,905 | $1,813,247 | $1,933,679 | $1,934,033 | $1,934,432 | ||||
| Accrued Liabilities | $ | $54,948 | $54,948 | $54,948 | $62,240 | $62,240 | $62,240 | $78,906 | $78,906 | $78,906 | $91,146 | $91,146 | $91,146 | $121,875 | $121,875 | $121,875 | $142,188 | $142,188 | $142,188 | $176,854 | $176,854 | $176,854 | $202,313 | $202,313 | $202,313 | $256,598 | $256,598 | $256,598 | $290,962 | $290,962 | $290,962 | $334,902 | $334,902 | $334,902 | $369,265 | $369,265 | $369,265 | $450,824 | $450,824 | $450,824 | $492,128 | $492,128 | $492,128 | $562,139 | $562,139 | $562,139 | $617,211 | $617,211 | $617,211 | $719,890 | $719,890 | $719,890 | $771,375 | $771,375 | $771,375 | $839,008 | $839,008 | $839,008 | $899,024 | $899,024 | $899,024 | ||||
| TOTAL LIABILITIES | $ | $203,856 | $189,795 | $190,814 | $213,820 | $215,028 | $216,297 | $267,663 | $269,171 | $270,705 | $309,120 | $310,909 | $312,789 | $414,117 | $415,381 | $416,748 | $479,037 | $480,477 | $481,976 | $587,534 | $589,136 | $590,841 | $668,979 | $670,816 | $672,712 | $849,121 | $850,129 | $851,191 | $955,345 | $956,462 | $957,555 | $1,090,520 | $1,091,641 | $1,092,815 | $1,197,107 | $1,198,337 | $1,199,542 | $1,464,919 | $1,465,605 | $1,466,305 | $1,590,902 | $1,591,602 | $1,592,288 | $1,803,007 | $1,803,735 | $1,804,512 | $1,970,482 | $1,971,223 | $1,971,978 | $2,291,935 | $2,292,309 | $2,292,664 | $2,447,521 | $2,447,863 | $2,448,262 | $2,651,514 | $2,651,913 | $2,652,255 | $2,832,703 | $2,833,057 | $2,833,456 | ||||
| STOCKHOLDERS' EQUITY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Contributed Capital (Equity Raised) | $ | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $1,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $6,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $21,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | $56,750,000 | ||||
| Retained Earnings / (Accumulated Deficit) | $ | ($140,291) | ($265,911) | ($391,918) | ($532,950) | ($674,443) | ($816,413) | ($992,242) | ($1,168,661) | ($1,345,648) | ($1,547,777) | ($1,750,592) | ($1,954,115) | ($2,221,004) | ($2,488,151) | ($2,755,596) | ($3,063,934) | ($3,372,579) | ($3,681,537) | ($4,060,148) | ($4,439,085) | ($4,818,387) | ($5,248,976) | ($5,679,947) | ($6,111,304) | ($6,653,561) | ($7,195,831) | ($7,738,137) | ($8,349,180) | ($8,960,257) | ($9,571,344) | ($10,270,344) | ($10,969,352) | ($11,668,392) | ($12,436,189) | ($13,204,017) | ($13,971,849) | ($14,907,783) | ($15,843,611) | ($16,779,331) | ($17,797,553) | ($18,815,667) | ($19,833,676) | ($20,991,601) | ($22,149,414) | ($23,307,130) | ($24,574,870) | ($25,842,495) | ($27,110,001) | ($28,586,199) | ($30,062,289) | ($31,538,251) | ($33,117,067) | ($34,695,759) | ($36,274,333) | ($37,988,044) | ($39,701,638) | ($41,415,108) | ($43,248,492) | ($45,081,748) | ($46,914,887) | ||||
| TOTAL STOCKHOLDERS' EQUITY | $ | $1,609,709 | $1,484,089 | $1,358,082 | $1,217,050 | $1,075,557 | $933,587 | $757,758 | $581,339 | $404,352 | $202,223 | ($592) | $4,795,885 | $4,528,996 | $4,261,849 | $3,994,404 | $3,686,066 | $3,377,421 | $3,068,463 | $2,689,852 | $2,310,915 | $1,931,613 | $1,501,024 | $1,070,053 | $15,638,696 | $15,096,439 | $14,554,169 | $14,011,863 | $13,400,820 | $12,789,743 | $12,178,656 | $11,479,656 | $10,780,648 | $10,081,608 | $9,313,811 | $8,545,983 | $7,778,151 | $6,842,217 | $5,906,389 | $4,970,669 | $3,952,447 | $2,934,333 | $36,916,324 | $35,758,399 | $34,600,586 | $33,442,870 | $32,175,130 | $30,907,505 | $29,639,999 | $28,163,801 | $26,687,711 | $25,211,749 | $23,632,933 | $22,054,241 | $20,475,667 | $18,761,956 | $17,048,362 | $15,334,892 | $13,501,508 | $11,668,252 | $9,835,113 | ||||
| TOTAL LIABILITIES + EQUITY | $ | $1,813,566 | $1,673,884 | $1,548,896 | $1,430,870 | $1,290,584 | $1,149,884 | $1,025,420 | $850,510 | $675,057 | $511,343 | $310,317 | $5,108,674 | $4,943,113 | $4,677,230 | $4,411,152 | $4,165,103 | $3,857,898 | $3,550,440 | $3,277,386 | $2,900,050 | $2,522,454 | $2,170,003 | $1,740,870 | $16,311,407 | $15,945,560 | $15,404,299 | $14,863,054 | $14,356,165 | $13,746,205 | $13,136,211 | $12,570,177 | $11,872,289 | $11,174,423 | $10,510,918 | $9,744,320 | $8,977,693 | $8,307,136 | $7,371,994 | $6,436,974 | $5,543,349 | $4,525,935 | $38,508,612 | $37,561,406 | $36,404,321 | $35,247,382 | $34,145,611 | $32,878,728 | $31,611,978 | $30,455,736 | $28,980,020 | $27,504,413 | $26,080,454 | $24,502,104 | $22,923,929 | $21,413,469 | $19,700,275 | $17,987,147 | $16,334,211 | $14,501,309 | $12,668,570 | ||||
| Balance Check (Assets - L&E) | $ | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||
| NOTES | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| - Simplified balance sheet. A/R = Revenue * DSO/30. A/P = (COGS+OpEx) * DPO/30. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| - Balance check row should show 0 or near-0 if the model balances correctly. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||